userhandledb.jsp

精通tomcat书籍原代码,希望大家共同学习

<%@ page language="java"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%  
String jndi_name="java:comp/env/jdbc/TestDB";//JDBC资源名
String select_user_sql="select userid,name,birthday, email from emp";//SQL语句
String colnames[][]={{"User ID","Name","Birth day","EMail"},
	{"userid","name","birthday","email"}};//定义列名
Vector userSet=new Vector();
Vector columnSet=new Vector();
for(int i=0;i<colnames[0].length;i++){
	columnSet.add(colnames[0][i]);
}
userSet.add(columnSet);
//查找JDBC资源，取得数据库连接
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("No Context");
DataSource ds = (DataSource)ctx.lookup(jndi_name);
Connection conn = ds.getConnection();
//查找数据库数据
try {
	PreparedStatement psPreparedStatement=conn.prepareStatement(select_user_sql);
	ResultSet resultSet = psPreparedStatement.executeQuery();
	while(resultSet.next()){
		columnSet=new Vector();
		for(int i=0;i<colnames[1].length;i++){
			columnSet.add(resultSet.getString(colnames[1][i]));
		}
		userSet.add(columnSet);
	}
}catch(SQLException e) {
}finally {
conn.close();
}%>