public Connection getConn() throws SQLException {
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhwlcool:1521:fyt";
Connection conn = null;
String user="scott";
String pass="ch111111";
try {
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,user,pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public PreparedStatement getPreparedStatement(String sql)throws SQLException{
Connection conn=getConn();
PreparedStatement pst=conn.prepareStatement(sql);
return pst;
} public static void main(String [] args) throws SQLException{
TestConn tconn = new TestConn();
try{
PreparedStatement pst=tconn.getPreparedStatement("select * from gtestsomething");
if(pst!=null){
ResultSet rs=pst.executeQuery();
if(rs.next()){//此处为什么为false
System.out.println(rs.getString(2));
}
rs.close();
}
pst.close();
}catch(Exception e){
e.printStackTrace();
}
}用pl/sql执行“select * from gtestsomething”表gtestsomething中有两列数据,为什么rs.next()){一直为false呢
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhwlcool:1521:fyt";
Connection conn = null;
String user="scott";
String pass="ch111111";
try {
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,user,pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public PreparedStatement getPreparedStatement(String sql)throws SQLException{
Connection conn=getConn();
PreparedStatement pst=conn.prepareStatement(sql);
return pst;
} public static void main(String [] args) throws SQLException{
TestConn tconn = new TestConn();
try{
PreparedStatement pst=tconn.getPreparedStatement("select * from gtestsomething");
if(pst!=null){
ResultSet rs=pst.executeQuery();
if(rs.next()){//此处为什么为false
System.out.println(rs.getString(2));
}
rs.close();
}
pst.close();
}catch(Exception e){
e.printStackTrace();
}
}用pl/sql执行“select * from gtestsomething”表gtestsomething中有两列数据,为什么rs.next()){一直为false呢
解决方案 »
- 关于Log4net无法利用Oracle.DataAccess写日志到数据库的问题。
- rac增加新节点运行dbca 出现报错
- VS配置Oracle连接字符串的问题
- ora-04091 表t_mc_type发生了变化,触发器/函数不能读它
- oracle中表的问题
- imp导入.dmp文件出错
- 求一个SQL文!!!急在线等!!分不够揭帖后马上开贴加分!!!
- 一条SQL语句问题 帮忙一下 在线等
- 大家知不知道单CPU的企业版和标准版的Oracle 9i、DB2 v7.2和SQL 2000实际可以多少价钱买到??(正版)
- CLOB字段有多长?用Delphi如何存取?
- oracle text全文检索【急】
- 这个存储过程该怎么写?
insert into sgtestsomething(nid,nname) values(3,'婉思')插入