📄 jspconnectionpool.jsp

📁 SUN sl-314 source codes

💻 JSP

字号:

<%@ 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>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -