dbget.java~1~

java+sql2000企业人力管理系统

package manpowermanager;

import java.sql.*;

/**
 * <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) {
      ex.printStackTrace();
    }
    return con;
  }

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

  private void jbInit() throws Exception {
  }
}