JDBC连Oracle数据库

String driverName = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@172.28.139.78:1521:oracts";
String userName = "Scott";
String password = "tiger";
try {

Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(url,userName,password);

if(!conn.isClosed()){
System.out.println("ConnectOK");
}
else{
System.out.println("ConnectERROR");
}

//Statement stmt = conn.createStatement();
PreparedStatement stmt = conn.prepareStatement("select * from emp where EMPNO like ?");

//ResultSet rs = stmt.executeQuery("select * from emp ");
stmt.setString(1,"10%");
ResultSet rs = stmt.executeQuery();

while(rs.next()){

String empno=rs.getString("EMPNO");
String ename=rs.getString("ENAME");
String mgr=rs.getString("MGR");
System.out.println("EMPNO: " + empno + " ENAME: " + ename + " MGR: " + mgr);

}
conn.commit();
rs.close();
stmt.close();
conn.close();

} catch (Exception e) {
e.printStackTrace();
}

文章来自: 本站原创
标签: