database_connection.java

JSP做的一个关于码头的网站

/*
 * database_connection.java
 * 连接数据库的公用javabean
 * Created on 2007年5月7日, 上午1:53
 * author: zhangzengming
 */

package common;
import java.sql.*;
import java.io.*;
import java.util.*;

public class database_connection {
    /***JDBC方式连接数据库****/
    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
    private String databaseName = "matou";
    private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName="+databaseName; 
    /***JDBC方式连接数据库****/
    /***JDBC-ODBC桥方式连接数据库****/
    //private String driverName = "sun.jdbc.odbc.JdbcOdbcDriver"; 
    //private String databaseName = "WebStore";
    //private String url = "jdbc:odbc:"+databaseName; 
    /***JDBC-ODBC桥方式连接数据库****/
    private String user = "sa";
    private String password = "";
    private String sql = "";
    private Connection con;
    private Statement stmt;
    
    public void setDriverName(String newDriverName) {
        driverName = newDriverName;
    }
    public String getDriverName() {
        return driverName;
    }
    public void setDatabaseName(String init){
        databaseName = init;
    }
    public String getDatabaseName(){
        return databaseName;
    }
    public void setUrl(String newUrl) {
        url = newUrl;
    }
    public String getUrl() {
        return url;
    }
    public void setUser(String newUser) {
        user = newUser;
    }
    public String getUser() {
        return user;
    }
    public void setPassword(String newPassword) {
        password = newPassword;
    }
    public String getPassword() {
        return password;
    }
    public void setSql(String init){
        sql = init;
    }
    public void setConnection() {
        try {
            Class.forName(driverName).newInstance();/***JDBC方式连接数据库****/
            //Class.forName(driverName);  /***JDBC-ODBC桥方式连接数据库****/
            con =  DriverManager.getConnection(url, user, password);
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }
    public void setStatement(){
         try {
            this.setConnection();
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
         }catch(Exception e) {
            e.printStackTrace();
        }
    }
    public ResultSet exeQuery(){
        try{
            this.setStatement();
            ResultSet rst = stmt.executeQuery(sql);
            return rst;
        }catch(Exception e) {
            e.printStackTrace();
            return null;
        }
    }
    public boolean exeUpdate(){
        try{
            this.setStatement();
            stmt.executeUpdate(sql);
            return true;
        }catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }
}