connbean.java

JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者

package ConnBean;

import java.sql.*;
import java.lang.*;

public class ConnBean {
    Connection conn = null;
    Statement stmt = null;

    String database = null;
    String server = null;

    public ConnBean() {
        this.database ="BookDB";
        this.server=".";
    }

    public ConnBean(String database, String server) {
        this.database = database;
        this.server = server;
    }

    public Statement getStmt() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection(
                   "jdbc:odbc:driver={SQL server};database=" + this.database +
                   ";server=" + this.server + "","sa","");
            this.stmt = conn.createStatement();
            System.out.println("数据库连接成功");
            return stmt;
             } catch (Exception e) {
                 e.printStackTrace();
                 return null;
             }
    }
    public String getTypeName(int booktype) {
        try {
            String strSql =
                    "select bookTypeName from bookType where [bookType]=" +
                    booktype;
            Statement stmt = this.getStmt();
            ResultSet rs = stmt.executeQuery(strSql);
            if (rs.next())
                return (rs.getString(1));
            else
                return (null);
        } catch (Exception ex) {
            ex.printStackTrace();
            return (null);
        }
    }

    public void disConnect() {
        try {
            if (stmt != null)
                stmt.close() ;
            if (conn != null)
                conn.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}