javaÊý¾Ý¿â²Ù×÷

ÎÒÓõÄÊÇoracle 10g xeÊý¾Ý¿â
²éѯ·½·¨ÊÇÕâÑùдµÄ
Java code:

public ResultSet executeQuery(String sql){//Ö´Ðвéѯ
Statement stmte=null;
ResultSet rs = null;
try{
conn=connPool.getConnection();
stmte=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
stmte=conn.createStatement();
rs=stmte.executeQuery(sql);
}catch(SQLException ex){
System.out.println("²éѯ´íÎó!"+ex+"----on:"+sql);
connPool.returnConnection(conn);
conn=null;
return null;
}finally{
System.out.println("ok");
connPool.returnConnection(conn);
conn=null;
}
return rs;
}

ÔÚʹÓÃ
Java code:

String sql="select table_name from user_tables";
rs=cdb.executeQuery(sql);


¿ÉÒԲ鵽Êý¾Ý£¬Ò²¾ÍÊDZíÃû
µ«ÊÇÎÒ½«sql»»³É
Java code:

String sql="select ws_rep_table.rep_table_num,ws_rep_table.rep_table_name,"+
"ws_domain.domain_num,ws_datait