tomcat数据源配置+测试
<%@?page?import="java.sql.*"%>
<%@?page?import="javax.naming.*"%>
<%@?page?import="javax.sql.*"%>
<!DOCTYPE?HTML?PUBLIC?"-//W3C//DTD?HTML?4.01?Transitional//EN">
<html>
<head>
<title>tomcat datasource test</title>
</head>
<body>
<%
Context?initContext?=?new?InitialContext();
//法一：java:/comp/env这个玩意是固定的
//Context?envContext?=?(Context)?initContext.lookup("java:/comp/env");
//DataSource?db?=?(DataSource)envContext.lookup("jdbc/test");
//法二：
DataSource?db?=?(DataSource)initContext.lookup("java:/comp/env/jdbc/test");
Connection?conn?=?db.getConnection();?
Statement?stmt?=?conn.createStatement();
ResultSet?rs?=?stmt.executeQuery("SELECT?*?FROM emp");
while(rs.next()){
?????? out.print(rs.getString("ename")+"__?");
}
rs.close();
stmt.close();
conn.close();
%>?
</body>
</html>
