jsp:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>無標題文檔</title>
<jsp:useBean id="con" scope="page" class="sist.DB" />
bean:
package sist;
import java.sql.*;
import java.io.*;
//import java.util.*;
public class DB {
private Connection conn = null;
private Statement drpStmt = null;
private ResultSet drpRst = null;
private int countInt = 0;
private String strDBError="";
boolean autoCommit;
public DB() {//構造函數開始
try{
//jdbc-odbc
Class.forName("org.gjt.mm.mysql.Driver");
//設置連接數據庫信息
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/gordon?useUnicode=true&characterEncoding=gbk");
drpStmt = conn.createStatement();
}
catch(SQLException sqle){
countInt=-1;
strDBError=sqle.getMessage();
}
catch(java.lang.Exception e){
countInt=-2;
strDBError=e.getMessage();
}
}
//構造函數的結束
//構造函數的作用，當創建該類的對象時，將自動調用構造函數，并運行其中的方法，對于本程序來說，當創建本類的對象時，將自動連接數據庫
//-------------------------------------------------------------------
public int getErrorCode(){
return countInt;
}
//-------------------------------------------------------------------
//-------------------------------------------------------------------
public String getErrorInfo(){
return strDBError;
}
//-------------------------------------------------------------------
//-------------------------------------------------------------------
//Q方法開始
//這個方法的返回值類型為結果集，主要完成數據庫的查詢操作，在使用的時候要向該方法傳遞SQL字符串
public ResultSet q(String queryString){
countInt=0;
strDBError="";
try{
drpRst = drpStmt.executeQuery(queryString);
countInt=1;
}catch(SQLException sqly){
countInt=-1;
strDBError+="Error occur while useing dataConn.exeQuery(queryString)!<p>The queryString is <p>" + queryString + "<p>The Error Information from DBMS錕斤拷<p>"+sqly.getMessage();
}catch(java.lang.Exception y){
countInt=-2;
strDBError+="<p>java.lang.Exception:"+y.getMessage();
}
return drpRst;
}
//-------------------------------------------------------------------
//-------------------------------------------------------------------
public int u(String updateString){
countInt=0;
strDBError="";
try{
countInt = drpStmt.executeUpdate(updateString);
}catch(SQLException sqlz){
countInt=-1;
strDBError="Error occur while using dataConn.exeUpdate()!The SQL is:<p>" + updateString + "<p>執行失敗:<P>" + sqlz.getMessage();
}
return countInt;
}
//--------------------------------------------------------------------
public int getRowCount(String queryString){
countInt=0;
strDBError="";
ResultSet rs;
int nRowCount=0;
try{
rs=drpStmt.executeQuery("select count(*) from (" + queryString + ") as viewTempQueryString" );
while(rs.next()) nRowCount=rs.getInt(1);
}
catch(SQLException errGetRowCount){
countInt=-1;
strDBError+="Error occur while useing dataConn.getRowCount("+queryString+")! " + errGetRowCount.getMessage();
}catch(java.lang.Exception errOther){
countInt=-2;
strDBError+="" + errOther.getMessage();
}
return nRowCount;
}
//-----------------------------------------------------------
}//end of all
bean位置在C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ROOT\jc\WEB-INF\classes\sist里面
謝謝~~！