各位高手能否给出一个完整的简单例子呢?谢谢

以前做过一个小例子，分享一下吧这是GetCon.javapackage test;import java.util.List;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.Connection;
import java.util.ArrayList;public class GetCon {  public List getCon(String argQuery) {    List list = new ArrayList();
    if (argQuery != null) {
//自己改一下---------------------------
      String url = "jdbc:oracle:thin:@192.168.0.053:1521:JIN";
      String id = "omesys";
      String pass = "omesys";
//-------------------------------------
      String query = argQuery.toLowerCase();
      String sql = "select * from system_users, state where " +
                   "(LOWER(first_name) LIKE '%" + query +
                   "%' or lower(last_name) like '%" + query +
                   "%') and system_users.state_init " +
                   " = state.state_init order by first_name";      System.out.println("sql = " + sql);
      Connection conn = null;
      Statement stmt = null;
      ResultSet rs = null;
      try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        conn = DriverManager.getConnection(url, id, pass);
        stmt = conn.createStatement();
        rs = stmt.executeQuery(sql);
        if (rs.next()) {
          do {
            ConForm form = new ConForm();
            form.setBuilding(rs.getString("building"));
            form.setEntry_date(rs.getString("entry_date"));
            form.setFirst_name(rs.getString("first_name"));
            form.setLast_name(rs.getString("last_name"));
            form.setPhone(rs.getString("phone"));
            form.setState_name(rs.getString("state_name"));
            form.setTitle(rs.getString("title"));
            list.add(form);
          }
          while (rs.next());
        }
      } catch (Exception ex) {
        ex.printStackTrace();
      } finally {
        try {
          if (stmt != null)stmt.close();
          if (conn != null)conn.close();
        } catch (Exception ex) {
          ex.printStackTrace();
        }
      }
    }
    return list;
  }
}
这是ConForm.java
package test;public class ConForm {
  private String first_name;  private String last_name;  private String title;  private String phone;  private String building;  private String state_name;  private String entry_date;  public void setEntry_date(String entry_date) {
    this.entry_date = entry_date;
  }  public void setState_name(String state_name) {
    this.state_name = state_name;
  }  public void setBuilding(String building) {
    this.building = building;
  }  public void setPhone(String phone) {
    this.phone = phone;
  }  public void setTitle(String title) {
    this.title = title;
  }  public void setLast_name(String last_name) {
    this.last_name = last_name;
  }  public void setFirst_name(String first_name) {
    this.first_name = first_name;
  }  public String getFirst_name() {
    return first_name;
  }  public String getLast_name() {
    return last_name;
  }  public String getTitle() {
    return title;
  }  public String getPhone() {
    return phone;
  }  public String getBuilding() {
    return building;
  }  public String getState_name() {
    return state_name;
  }  public String getEntry_date() {
    return entry_date;
  }
}这是我的测试sql
DROP TABLE system_users CASCADE CONSTRAINTS
/CREATE TABLE system_users (system_id VARCHAR2(6) NOT NULL,
first_name VARCHAR2(30),
last_name VARCHAR2(30),
title VARCHAR2(30),
phone VARCHAR2(10),
building VARCHAR2(3),
state_init VARCHAR2(2),
entry_date DATE,
CONSTRAINT PKsystem_users PRIMARY KEY (system_id))
/DROP TABLE state CASCADE CONSTRAINTS
/CREATE TABLE state (state_name VARCHAR2(30),
state_init VARCHAR2(2) NOT NULL,
CONSTRAINT PKstate PRIMARY KEY (state_init))
/INSERT INTO system_users VALUES (
'000121',
'Damon',
'Hougland',
'Mattress Tester',
'5557868945',
'745',
'TX',
sysdate)
/INSERT INTO system_users VALUES (
'000333',
'Aaron',
'Tavistock',
'Java Champion',
'5557861234',
'748',
'CA',
sysdate)
/INSERT INTO system_users VALUES (
'000345',
'Joseph',
'Blow',
'Mail Supervisor',
'5557864567',
'710',
'CA',
sysdate)
/INSERT INTO state VALUES ('ALABAMA', 'AL')
/
INSERT INTO state VALUES('ALASKA', 'AK')
/
INSERT INTO state VALUES('ARIZONA', 'AZ')
/
INSERT INTO state VALUES('ARKANSAS', 'AR')
/
INSERT INTO state VALUES('CALIFORNIA', 'CA')
/
INSERT INTO state VALUES('TEXAS', 'TX')
/
这是jsp
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Final//EN">
<%@ page import="java.util.*" %>
<%@ page import="test.ConForm" %>
<jsp:useBean id="connBean" scope="request" class="test.GetCon"/>
<html>
  <body>
    <form action="<%=request.getRequestURI() %>" method="post">
      <input type="text" name="query" size="15" maxlength="30" value="<% if (request.getParameter("query") != null)
        out.print(request.getParameter("query")); %>">
      <input type="submit" value="search">
    </form>
    <table border="1" cellpadding="3" cellspacing="0">
<%
  if (request.getParameter("query") != null) {    List list = connBean.getCon(request.getParameter("query"));String phNum = "";
%>
      <tr>
        <td><b>First Namesss</b></td>
        <td><b>Last Name</b></td>
        <td><b>Title</b></td>
        <td><b>Phone</b></td>
        <td><b>Building</b></td>
        <td><b>State</b></td>
        <td><b>Start Date</b></td>
      </tr>
<%
    for (int i = 0; i < list.size(); i++) {
    ConForm form = (ConForm)list.get(i);
      phNum = "(" + form.getPhone().substring(0,3) +
                   ")" + form.getPhone().substring(3,6) +
                   "-" + form.getPhone().substring(6,10);
%><tr>
  <td><%= form.getFirst_name() %></td>
  <td><%= form.getLast_name() %></td>
  <td><%= form.getTitle() %></td>
  <td><%= phNum %>
  <td><%= form.getBuilding() %></td>
  <td><%= form.getState_name() %></td>
  <td><%= form.getEntry_date() %></td>
  <%
    }
  }
%>
    </table>
  </body>
</html>这是运行结果：
First Namesss Last Name Title Phone Building State Start Date
Aaron Tavistock Java Champion (555)786-1234  748 CALIFORNIA 2005-05-12 10:41:09.0
Damon Hougland Mattress Tester (555)786-8945  745 TEXAS 2005-05-12 10:41:09.0

调试易

各位高手能否给出一个完整的简单例子呢?谢谢

解决方案 »