connectdatabaseclass.java

用java写的固定资产管理系统原代码 这可是自己小组做的哦

/*
 * connectdatabaseClass.java
 *
 * Created on 2007年4月28日, 下午1:51
 *
 *此功能是用来连接数据库
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.cn.szhaccp.set;

import java.sql.*;

/**
 *
 * @author Administrator
 */
public class connectdatabaseClass {
  private Connection con;
    
    /** Creates a new instance of connectdatabaseClass */
  public connectdatabaseClass() throws ClassNotFoundException, SQLException {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        con = DriverManager.getConnection("jdbc:microsoft:sqlserver://QX:1433;DatabaseName=AssetManageSystem","sa","");
  }
   
  /*
   *传出connection
   */
  public Connection transmitConnection() {
      return con;
  }
  
  /*
   *关闭connection
   */
  public void closeConnection() throws SQLException {
      if(con != null) {
        con.close();
      }
  }
    
}