src/com/fhd/conn/DBConnection.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.fhd.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection {
	   private static Connection conn = null;

    /**
     * 返回数据库连接
     * @return Connection
     * @throws SQLException
     * @throws ClassNotFoundException 
     */
    public static Connection getConnection(){
    	if(conn == null){
    		try {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			String connStr = "jdbc:sqlserver://localhost:1433;DatabaseName=family";
			String userName = "sa";
			String userPass = "sa";
    		try {
				conn =  DriverManager.getConnection(connStr,userName,userPass);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
    	}
    	return conn;
    }
    
    public static void closeConnection(Connection conn){
		if(conn!=null){
			try {
				conn.close();				
			} catch (SQLException e) {
			}
			
		}
		//System.out.println("关闭了数据库连接！");
	}
	
	public static void closeStatement(Statement state){
		if(state!=null){
			try {
				state.close();				
			} catch (SQLException e) {
			}
			
		}
		//System.out.println("关闭了数据操作对象Statement！");
	}
	
	public static void closeResultSet(ResultSet rs){
		if(rs!=null){