select * from test where id='00000000000000000087';
如果在工具中查询,有一条记录。
但是在java中
String gg = "select * from test where id='00000000000000000087'";
PreparedStatement stmt = conn.prepareStatement(gg);
ResultSet rs = stmt.executeQuery();rs无值,id的类型为 VARCHAR2(20)多谢!OracleJava
如果在工具中查询,有一条记录。
但是在java中
String gg = "select * from test where id='00000000000000000087'";
PreparedStatement stmt = conn.prepareStatement(gg);
ResultSet rs = stmt.executeQuery();rs无值,id的类型为 VARCHAR2(20)多谢!OracleJava
string fname = rs.getstring("emp_id");
system.out.println("the fname is " + fname);
}
如果不是这个,可能是数据库连接没有关闭,
rs.close();
pstmt.close();
conn.close();