public Int find(){
Connection conn = null;
int a = 0;
try{
try {
//1 注册驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//2 连接数据库
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","tiger");
}catch(Exception e) {
System.out.println("没有得到数据库连接");
e.printStackTrace();
}
return conn;
sql="select host_client from emp where deptno='40' ;";
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
a = rs.getInt("host_client");
}
}catch(Exception e){
e.printStackTrace();
}finally{
closeRs(rs);
closePs(ps);
closeConn(conn);
}
return a;
}
这就能取到了 但是 你问这么。。。个问题 感觉你这些代码也看不懂???是不是
追问ps rs 是 什么类型啊
追答。。。。。我的错
PreparedStatement ps=null;
ResultSet rs=null;
String sql=null;
本回答被提问者采纳