게시판 검색해서 뿌려주는 부분인데 보통 title=? 이런건 자주쓰는데 ?=? (where rnum >=? and rnum <=? and ? like ?";)
이렇게도 사용이 가능하냐능? 3,4번이  유동적으로 변해서 아니면 걍 title=? , name=? 이렇게 나뉘는 쿼리소스를 if로 분기줘서 여러번써줘야되려나
근데 이렇게 사용하는거 옛날에 쓰던방식임? 요샌 이렇게 안하냐능?;;;;


public static ArrayList getFindList(int start, int end, String select, String text){
  Connection con=null;
  PreparedStatement ps=null;
  ResultSet rs=null;
  
  ArrayList ar=new ArrayList();   
  
  try {
   con=getConnection();
   String sql="select * from"+
    "(   select ROWNUM rnum,num,name,email,title,content,regdate "+
       " from "+
      "  ("+
      "  select num,name,email,title,content,regdate from guest "+
       " order by num desc "+
        " ) "+
     " ) "+
     " where rnum >=? and rnum <=? and ? like ?";
   ps=con.prepareStatement(sql);
   ps.setInt(1, start);
   ps.setInt(2, end);
   ps.setString(3, select);
   ps.setString(4, "%"+text+"%");
   rs=ps.executeQuery();
   
   int contentLen = 5;
   
   while(rs.next()){
    Guest guest=new Guest();  
    guest.setNum(rs.getInt("num"));
    guest.setName(rs.getString("name"));
    guest.setEmail(rs.getString("email"));
    guest.setTitle(rs.getString("title"));
    StringBuffer buf = new StringBuffer(rs.getString("content"));
    if(buf.length()>contentLen){
     buf.setLength(contentLen);
     guest.setContent(buf + "...");
    }else{
     guest.setContent(rs.getString("content")); 
    }
    guest.setRegdate(rs.getTimestamp("regdate"));
    ar.add(guest);   
   }
  } catch (Exception e) {
   System.out.println("getList 예외 발생");
   e.printStackTrace();
  }finally{
   if(rs!=null)try{rs.close();}catch(Exception e){}
   if(ps!=null)try{ps.close();}catch(Exception e){}
   if(con!=null)try{con.close();}catch(Exception e){}
  }//finally
  
  return ar;