SQLServer jdbc 连接代码 单例

Constant 类

package utils;

public interface Constant{
    public abstract interface DB{
        public static final String Uri = "jdbc:sqlserver://";
        public static final String Host = "127.0.0.1:";     //主机
        public static final String Port = "1433;";          //端口
        public static final String DataBase = "DatabaseName=ASKManagerSystem;";//数据库
        public static final String DBAccount = "sa";        //账户
        public static final String DBPassWord = "root";     //密码
        public static final String ClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";//类的名称
    }
}

DB 类

package utils;

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

public class DB{

    private static Connection con = null;
    private static String URL = Constant.DB.Uri + Constant.DB.Host + Constant.DB.Port + Constant.DB.DataBase;
    static{
        try{
            Class.forName(Constant.DB.ClassName);
        } catch (ClassNotFoundException e){
            e.printStackTrace();
        }
    }

    private DB(){
        System.out.println("private DB()...");
    }

    public static Connection getConnection(){
        try{
            if (con == null){
                con = DriverManager.getConnection(URL, Constant.DB.DBAccount,Constant.DB.DBPassWord);
            }
            else{
                return con;
            }
        } catch (SQLException e){
            e.printStackTrace();
            return null;
        }
        return con;
    }
}

单例

package com.util;

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

public class DB {

    public static final String Uri = "jdbc:sqlserver://";
    public static final String Host = "127.0.0.1:";
    public static final String Port = "1433;";
    public static final String DataBase = "DatabaseName=ChapterThree;";
    public static final String DBAccount = "sa";
    public static final String DBPassWord = "guojia";
    public static final String ClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

    private static String URL = DB.Uri + DB.Host + DB.Port + DB.DataBase;

    private static Connection con = null;
    static {
        try {
            Class.forName(DB.ClassName);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    private DB() {
        System.out.println("private DB()...");
    }

    public static Connection getConnection() {
        try {
            if (con == null) {
                con = DriverManager.getConnection(URL, DB.DBAccount,
                        DB.DBPassWord);
            } else {
                return con;
            }
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
        return con;
    }

    public static void main(String[] args) {
        System.out.println(DB.getConnection());
    }

}