public void testStatement(){
/* MYSQL 连接时的*/
//数据库用户名
String users = "root";
//数据库密码
String password = "11";
//数据库驱动
String classNames = "com.mysql.jdbc.Driver";
//数据库jdbc url
String urls = "jdbc:mysql://localhost:3306/shop";
/* oracle连接时 */
String url = "jdbc:oracl:thin:@127.0.0.1:1521:orcl";
String user = "scott";
String pwd = "tiger";
String className = "oracle.jdbc.driver.OracleDriver";
try {
Class.forName(className);
Connection conn = DriverManager.getConnection(url, user, pwd);
Statement st = conn.createStatement();
String sql = " select * from emp ";
ResultSet rs = st.executeQuery(sql);
while(rs.next()){
Integer empno = rs.getInt(1);
String ename = rs.getString("ename");
System.out.println(empno+":"+ename);
}
rs.close();
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
