코딩에 대한 설명은 생략하겠습니다..

import java.util.HashMap;
import java.util.Vector;

public class k2BoxVector extends HashMap {
public k2BoxVector(){
super();
}

public void k2setVector(String key, Vector value){
super.put(key, value);
}

public Vector k2getVector(String key){

  Vector vector = new Vector();
  try{
   vector = (Vector)super.get(key);
  }catch(Exception e){
   vector = null;
  }
  return vector;
}
}

import java.io.Reader;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;

import wizard.com.k2Box;
import wizard.com.k2BoxVector;
import wizard.util.SqlCon;
import wizard.util.k2UtilBean;
import wizard.xml.ReadXmlConf;

public class k2TableSql {

private int getTotalPage = 0;
private int row = 0;
private int page = 0;

public k2TableSql(){
}

public k2TableSql(int page, int row){
  this.page = page;
  this.row = row;
}

public int getTotalNum(){
  return this.getTotalPage;
}

/**
* Execute Query 관련 Select
* @param con
* @param sql
* @param objData
* @return
*/
public k2BoxVector tableViewPage(SqlCon conn, String sql,Object[] objData, String exception){
  int rows = 0;
  PreparedStatement pstmt = null;
  ResultSet rs = null;
  ResultSetMetaData meta = null;
  int vFirstPage = (this.page - 1) * this.row;

  //System.out.println(vFirstPage+":"+this.page +":"+this.row);
  int vLastPage = this.page * this.row;
  k2BoxVector b = new k2BoxVector();

  try{

   String maxSql = "SELECT COUNT(*) AS TOTAL " + sql.substring(sql.indexOf("FROM"), sql.length());
   k2Box max = this.GetBox(conn, maxSql, objData, this.getClass().getName()+"[tableViewPage]");
   getTotalPage = Integer.parseInt(max.k2get("TOTAL"));

   String query = " SELECT * FROM " +
            "             (SELECT ROW_.*, ROWNUM AS RNUM from ("+sql+") ROW_ )" +
            " where RNUM > "+vFirstPage+" AND ROWNUM <= "+this.row;

   pstmt = conn.prepareStatement(query);
   if(objData != null && objData.length > 0) {
    for(int i =0;i<objData.length;i++ ) {
     pstmt.setObject(i+1, objData[i].toString());
    }
   }
   rs = pstmt.executeQuery();
   meta = rs.getMetaData();

   int vectorSize = meta.getColumnCount();
   Vector data[] = new Vector[vectorSize];

   for(int i = 0; i < vectorSize; i++){
    data[i] = new Vector();
   }


   while(rs.next()) {
    for(int j = 0; j < vectorSize; j++){
     if(meta.getColumnTypeName(j + 1).equals("CLOB")){
      try{
       Reader instream = rs.getCharacterStream(meta.getColumnLabel(j + 1));
          // create temporary buffer for read
          char[] buffer = new char[1024];
          // length of characters read
          int length = 0;
          StringBuffer sb = new StringBuffer();
          // fetch data
          while ((length = instream.read(buffer)) != -1) {
              for (int i = 0; i < length; i++){
                  sb.append(buffer[i]);
              }
          }
          // Close input stream
          instream.close();

       data[j].add(sb.toString());
      }catch(Exception e){
       e.printStackTrace();
      }
     }else{
      data[j].add(k2UtilBean.replaceNull(rs.getString(j + 1)));
     }
    }
     }

   for(int i = 0; i < vectorSize; i++){
    String str = meta.getColumnLabel(i + 1);
    b.k2setVector(str, data[i]);
   }
  }
    catch(SQLException se){
   System.err.println("tableViewPage ["+exception+"] :" + se.getMessage());
    }
  finally{
   try{
    rs.close();
    pstmt.close();
   }catch(Exception e){}
    }
    return b;
}

}

사용예

JSP 던 SERVLET 이던

String sql = "SELECT AAB, AAC FROM TABLE1 WHERE A = ? AND B= ?";

Object[] object = {"인자1", "인자2"};

k2BoxVector box = new k2TableSql.tableViewPage(con, sql, object};

System.out.println(box.k2getVector("AAB").get(i).toString());

System.out.println(box.k2getVector("AAC ").get(i).toString());

끝.

더 자세한 사항및 필요한 사항이 있으시면

hochuel@naver.com 연락주세요.. 성심성의껏 답변해드리겠습니다..

그리고 더 좋은 아이디어및 수정된 코드가 있다면 메일주세요...

읽어주셔서 감사합니다.

테이블 쿼리 시 유용한 유틸이라 생각들어 올립니다. 많은 의견 부탁드리겠습니다.