dbaccess.java

程序为银行管理系统,分为四个子模块,分别为人事管理系统,计算机管理系统,机构管理系统和bbs论坛

package org.xjtu.bank.compdb;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBAccess {
	String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=bankdb";
	String username = "sa";
	String password = "198701";
	
	public Connection conn = null;
	public void getConn()
	{
		try {
			DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			conn = DriverManager.getConnection(url, username, password);
			System.out.println("数据库连接成功！");
		} catch (SQLException e) {
			System.out.println("数据库连接失败！");
			e.printStackTrace();
		}
	}
	
	public Connection connDB()
	{
		if(this.conn != null)		
			return conn;
		else	
			return null;
	}
	public static void main(String args[])
	{
		DBAccess dbaccess = new DBAccess();
		dbaccess.getConn();
	}
}