conndatabase.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package libsystem;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
/**
 *  数据库连接类
 * @author admin
 */
public class ConnDataBase {
    private static Connection conn;
    //private Statement stmt;
    private ConnDataBase(){
    }
    private static void connect(){ 
            //String strurl ="jdbc:odbc:student";
            String strurl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=LibraryDataBase";
                    try{
                        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        }catch(ClassNotFoundException ex){
                            System.out.println("加载驱动失败");
                            ex.printStackTrace();
                        }
                        try{
      			conn = DriverManager.getConnection(strurl,"sa","");
                        }catch(SQLException ex){
                            System.out.println("连接失败");
                            JOptionPane.showMessageDialog(null,"连接失败,数据库可能未启动!");
                            return;
                        }
        }
    public static Connection getConnection(){
        if(conn==null) {connect();return conn;}
        else return conn;
    }
}