dbget.java

java+sql2000企业人力管理系统

package managersystem;

import java.sql.*;
import javax.swing.JOptionPane;

/**
 * <p>Title: 企业人力资源管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DBGet {
    public DBGet() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public Connection getConnection() {
        Connection con = null;
    try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=HrSys","sa","sa");
    }
    catch (Exception ex) {
       JOptionPane.showMessageDialog(null,"数据库未连接");
       System.exit(1);
    }
//        try {
//            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//            con = DriverManager.getConnection("jdbc:odbc:test");
//        } catch (Exception ex) {
//            JOptionPane.showMessageDialog(null, "数据库未连接");
//            System.exit(1);
//        }
        return con;
    }

    public void clossConnection(Connection con) {
        try {
            if (con != null) {
                con.close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
    }
}