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.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());
}
}