jspconnectionpool.jsp

来自「SUN sl-314 source codes」· JSP 代码 · 共 55 行

<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page contentType="text/html;charset=GBK" %>

<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>Use ConnectionPool</title>
</head>
<body bgcolor="#FFFFFF">

<%! private DataSource orasrc; %>
<%  try {
	      Context initcontext = new InitialContext();
	      Context context = (Context)initcontext.lookup("java:comp/env");
	      orasrc = (DataSource)context.lookup("jdbc/OracleDB");
	}
	catch(NamingException ne) {
		  ne.printStackTrace();
	}
	try {
		  Connection con = orasrc.getConnection();
		  Statement stmt = con.createStatement();
		  String SQL_stmt = "select empno, ename, job, mgr, hiredate, sal, deptno from emp";
	      ResultSet rs = stmt.executeQuery(SQL_stmt);
	        
	      out.print("<TABLE BORDER='1' CELLSPACING='0' CELLPADDING='5'>");
	      out.print("<TR bgcolor=cyan><TH>雇员编号</TH><TH>雇员姓名</TH><TH>职位</TH><TH>所属经理</TH><TH>雇佣日期</TH><TH>月薪</TH><TH>所在部门</TH></TR>");
	  	      	   
	  	  int empno; String ename; String job; int mgr; 
	  	  Date hiredate; double sal; int deptno;
	  	  
	  	  while(rs.next()) {        	     
	  	      empno = rs.getInt("empno");
	  	      ename = rs.getString("ename");
	          job = rs.getString("job");
	          mgr = rs.getInt("mgr");
	          hiredate = rs.getDate("hiredate");
	          sal = rs.getDouble("sal");
	          deptno = rs.getInt("deptno");

	  	      out.println("<TR><TD>" + empno + "</TD><TD>" + ename + "</TD><TD>" + job + "</TD><TD>"
	  	      + mgr + "</TD><TD>" + hiredate + "</TD><TD>" + sal + "</TD><TD>" + deptno + "</TD></TR>"); }
	  		  
	  		  out.println("</TABLE>");
	  		  con.close(); 
	      }
	  catch(SQLException e) {
	    e.printStackTrace();
	  }
%>
</body>
</html>