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();
}
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();
}