java 代码
xml 代码
- <%@ page language="java" import="java.util.* ,java.sql.* " pageEncoding="UTF-8"%>
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
- <html>
- <head>
- </head>
- <body>
- <jsp:useBean id="db" class="com.student.util.page.DBcon" ></jsp:useBean>
- <jsp:setProperty property="con" name="db"/>
- <jsp:setProperty property="rs" name="db"/>
- <jsp:setProperty property="stmt" name="db"/>
- <%
- String sql="select * from teacher where username='李艳'";
- db.getCon().createStatement();
- ResultSet rs=db.getStmt().executeQuery(sql);
- while(rs.next()){
- out.println(rs.getString(1));
- out.println(rs.getString(2));
- }
- %>
- </body>
- </html>
- ================================
- package com.student.util.page;
- import java.sql.*;
- public class DBcon{
- private String url="jdbc:oracle:thin:@localhost:1521:oracle9";
- private String driver="oracle.jdbc.driver.OracleDriver";
- Connection con=null;
- PreparedStatement prp=null;
- Statement stmt=null;
- ResultSet rs=null;
- public DBcon () throws ClassNotFoundException, SQLException {
- Class.forName(driver);
- con=DriverManager.getConnection(url,"test","test");
- stmt=con.createStatement();
- }
- public Connection getCon() throws SQLException {
- return con;
- }
- public void setCon(Connection con) {
- this.con = con;
- }
- public PreparedStatement getPrp() {
- return prp;
- }
- public void setPrp(PreparedStatement prp) {
- this.prp = prp;
- }
- public Statement getStmt() {
- return stmt;
- }
- public void setStmt(Statement stmt) {
- this.stmt = stmt;
- }
- public ResultSet getRs() {
- return rs;
- }
- public void setRs(ResultSet rs) {
- this.rs = rs;
- }
- }
<jsp:usebean class="com.student.util.page.DBcon" id="db"></jsp:usebean>
<jsp:setproperty name="db" property="con"></jsp:setproperty>
<jsp:setproperty name="db" property="rs"></jsp:setproperty>
<jsp:setproperty name="db" property="stmt"></jsp:setproperty>