databaseconnection.java

来自「用java写的固定资产管理系统原代码 这可是自己小组做的哦」· Java 代码 · 共 47 行

package com.cn.szhaccp.sill;

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
 * @(#)DatabaseConnection.java
 *
 *
 * @author 
 * @version 1.00 2007/4/27
 */


public class DatabaseConnection {

    public DatabaseConnection() {
    	try {
    		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    		conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://QX:1433;databaseName=AssetManageSystem;","sa","");
    	} catch(ClassNotFoundException e) {
    		e.printStackTrace();
    	} catch(SQLException e) {
    		e.printStackTrace();
    	}
    }
    
    public Connection getConn() throws SQLException {
    	return conn;
    }
    
    public void connClose() throws SQLException {
    	conn.close();
    }
    
    public ResultSet getRs() throws SQLException {
    	stmt = conn.createStatement();
    	rs = stmt.executeQuery("SELECT Code 编号,Name 资产名称,Sort 资产类别,Model 资产型号,Merit 资产价值,BuyDate 购买日期,State 当前状态,UserName 借用者,Remark 备注 FROM AssetInfo");
    	return rs;
    }
    
    private Connection conn;
    private Statement stmt;
    ResultSet rs;
}