dbconnector.java

来自「银行系统中储蓄模块的实现」· Java 代码 · 共 59 行

package Database;
import java.sql.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DbConnector {
        public static DbConnector uniqueInstance = new DbConnector();
        private Connection con;

        private DbConnector() {

            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=储蓄";// DB name
            String user = "sa";// USER
            String password = "";// PASSWORD

            try {
                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                con = DriverManager.getConnection(url, user, password);
                System.out.println("\nSucceed to connect!!");
            }
            catch (Exception err) {
                System.out.println("\nFail to connect!"+err);
            }
        }

        public static DbConnector getInstance(){
            if(uniqueInstance == null){
                uniqueInstance = new DbConnector();
        }
        else
            System.out.println("Only one instance available!");
        return uniqueInstance;
        }

        public void stopConnection()
        {
            try {
                con.close();
                System.out.println("\n断开链接");
            }
            catch (SQLException e) {
                e.printStackTrace();
            }
        }

        public Connection getConnection(){
            return con;
        }
}