这是代码没有报错,但是没有打印出数据来packageconn;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.s...
这是代码没有报错,但是没有打印出数据来
package conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class OracleTest extends BaseDao{
public static void main(String[] args) {
Connection conn=null;
Statement pt=null;
ResultSet rs=null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","sa");
pt = conn.createStatement();
rs = pt.executeQuery("select * from USERS");
System.out.println("start.....");
while(rs.next()) {
System.out.println(rs.getString("UserName"));
}
}catch(Exception e){
e.getMessage();
}finally{
/*如果rs不空,关闭rs*/
if(rs!=null)
{
try{rs.close();}catch(SQLException ex){System.out.print("关闭执行对象异常"+ex);}
}
//如果pstmt不空,关闭pstmt
if(pt!=null)
{
try{pt.close();}catch(SQLException ex){System.out.print("关闭预处理对象异常"+ex);}
}
//如果conn不为空,关闭conn
if(conn!=null)
{
try{conn.close();}catch(SQLException ex){System.out.print("关闭数据库连接异常"+ex);}
}
}
}
}
展开