你要有一个jsp页面,你可以查下jsp怎么连接对应数据库
编写连接数据库的程序,以下是jsp连接oracle程序
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
request.setCharacterEncoding("GBK");
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException ce){
out.println(ce.getMessage());
}
try{
String url="jdbc:oracle:thin:@localhost:1521:orcl";
conn=DriverManager.getConnection(url,"scott","tiger");
stmt=conn.prepareStatement("select * from emp");
rs=stmt.executeQuery();
out.print("
out.print("
"+"Empno"+"");
out.print("
"+"Ename"+"");
out.print("
"+"Job"+"");
out.print("
"+"Mgr"+"");
out.print("
"+"hiredate"+"");
out.print("
"+"Sal"+"");
out.print("
"+"Comm"+"");
out.print("
"+"Deptno"+"");
while(rs.next()){
out.print("
"+rs.getString(1)+"");
out.print("
"+rs.getString(2)+"");
out.print("
"+rs.getString(3)+"");
out.print("
"+rs.getString(4)+"");
out.print("
"+rs.getString(5)+"");
out.print("
"+rs.getString(6)+"");
out.print("
"+rs.getString(7)+"");
out.print("
"+rs.getString(8)+"");
}
out.print("
");
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
%>