Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@172.16.2.229:1521:DBSERVER";
String UserName="root";
String PassWord ="root";
conn = DriverManager.getConnection(url,UserName,PassWord);Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from insurance_accounts where name='胡军");
while(rs.next()){
rs.getString(0);
}
rs.close();
conn.close();
问题: rs.next 为false..是什么原因呢,有什么解决办法?
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@172.16.2.229:1521:DBSERVER";
String UserName="root";
String PassWord ="root";
conn = DriverManager.getConnection(url,UserName,PassWord);Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from insurance_accounts where name='胡军");
while(rs.next()){
rs.getString(0);
}
rs.close();
conn.close();
问题: rs.next 为false..是什么原因呢,有什么解决办法?
你把rs.getString(0);
改成
System.out.println(rs.getString(0));
然后不要断点直接执行,
应该能打印出东西来。原因就在你不该看的时候看了rs.next()的值。
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@172.16.2.229:1521:DBSERVER";
String UserName="root";
String PassWord ="root";
conn = DriverManager.getConnection(url,UserName,PassWord);Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from insurance_accounts where name='胡军'");
while(rs.next()){
System.out.print(rs.getString(0));
}
rs.close();
conn.close();这样打印么,什么都没有的
while(rs.next()){
System.out.println(rs.getString(0));
}有东西输出么?
ResultSet rs = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@172.16.2.229:1521:DBSERVER";
String UserName="root";
String PassWord ="root";
conn = DriverManager.getConnection(url,UserName,PassWord);Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from insurance_accounts where name='胡军");
while(rs.next()){
rs.getString(0);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
rs.close();
conn.close();
}catch(SQLExcetptin e){
e.printStackTrace()
}
}
}
没打印异常情况debug提示the source attachment does not contain the source for the file OracleResultSetImpl.class
ResultSet rs = stmt.executeQuery("select * from insurance_accounts where name like '胡军%'");
while (rs.next()) {
System.out.println(rs.getString(0));
System.out.println(rs.getString(1));
}
出现错误。
原来你没有搞清楚该怎么写sql select * 改成 select name 就可以了。
你直接从1开始拿应该不会有问题的