dbconnection.java

留言管理系统,用JAVA JSP + MVC + DAO完成

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.shx.note.DBConn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Administrator
 */
// 主要功能就是连接数据库、关闭数据库
public class DBConnection {

    //设置连接数据库的参数
    String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NoteDemo";
    String DBUSER = "shx";
    String DBPASSWORD = "19861019";
    //数据库连接对象
    Connection conn = null;

    //构造函数
    public DBConnection() throws Exception {
        try {
            Class.forName(DBDRIVER);
            this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
        } catch (Exception e) {
            throw new Exception("操作中出现错误！！！") ;
        }
    }

    //获得数据库连接对象
    public Connection getConnection(){
        return this.conn;
    }

    //关闭数据库连接
    public void close(){
        try {
            this.conn.close();
        } catch (SQLException ex) {
            Logger.getLogger(DBConnection.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}