//创建连接
Connection conn = null ;
//创建预编译对象
PreparedStatement st = null ;
//创建结果集
ResultSet rs = null;
//创建驱动初始化字符,如果是mysql则是 com.mysql.jdbc.driver
String cl_orcl = "oracle.jdbc.driver.OracleDriver";
//创建连接语句
String str="jdbc:oracle:thin:@localhost:1521:DATA01";
String username = "DONGJIAN";
String password = "itroot";
//创建sql语句
String strSql="select * from emp";
//加载驱动
Class.forName(cl_orcl);
//连接数据库
conn = DriverManager.getConnection(str,username,password);
//编译对象获取
st = conn.prepareStatement(strSql);
//搜索结果获取
rs = st.executeQuery();
while(rs.next()){
out.println(rs.getString(1)+"--"+rs.getString(2)+"--"+rs.getString(3)+"<br>");
//因为是在jsp上做的,所以使用out.println进行打印
}
rs.close();
conn.close();