1.数据库连接类

package com.wangguan;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


/**
 * 主要功能是链接数据库，关闭数据库
 * @author Administrator
 *(第一部分数据库连接类)
 */
public class DataBaseConnection {
    private String url = "jdbc:sqlserver://127.0.1:1433;databaseName=userManager";
    private Connection conn = null;
    public DataBaseConnection() {
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            this.conn = DriverManager.getConnection(url, "sa", "wangguan");
        } catch (ClassNotFoundException e) {
            System.out.println("驱动器加载失败");
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    
    public Connection getConn() {
        return conn;
    }
    
    public void close() {
        try {
            conn.close();
        } catch (SQLException e) {
            System.out.println("数据库链接关闭失败");
            e.printStackTrace();
        }
    }
    
    
}