dbget.java~6~

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","");
//    }
//    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 {
    }
}