?? jspconnectionpool.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 + -