package DB;

import java.sql.Connection;

import java.sql.DriverManager;

public class Conn {

	// 定义一个变量

	private static String message = "恭喜你，数据库链接成功！";

	// 连接（加载）方法

	public static Connection getConnection() {

		try {

			// 加载驱动

			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

			// 实行连接参数 库名 用户名 和密码

			return DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=ConstructionDB","sa","123456");

		} catch (Exception e) {

			// 打印异常

			e.printStackTrace();

			message = "数据库链接失败！";

			return null;

		}

	}

	// main方法

	public static void main(String[] args) {

		// 调用连接

		getConnection();

		// 测试情况

		System.out.println(message);

	}

}

package dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class BaseDao {

	/**

	 * @param args

	 */

	public static void main(String[] args) {

		// TODO Auto-generated method stub

		getConn();

	}

	public static  Connection getConn() {

		// TODO Auto-generated method stub

		//加载驱动

		Connection conn=null;

		try {

			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

			//连接数据库

			conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=ConstructionDB","sa","123456");

			System.out.println("连接成功");

		} catch (ClassNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

		return conn;

	}

	public void closeConn(Connection conn,PreparedStatement pstmt,ResultSet rs) {

		// TODO Auto-generated method stub

			try {

				if(rs!=null)

					rs.close();

				if(pstmt!=null)

					pstmt.close();

				if(conn!=null)

					conn.close();

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

	}

}