dbaccess.java

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

package org.xjtu.bank.sysdb;

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 void closeConn(Connection conn)
	{
		if(conn!=null)
		{
			try 
			{
				conn.close();
			} catch (SQLException e) 
			{
				e.printStackTrace();
			}
		}
	}
	public static void main(String args[])
	{
		DBAccess dbaccess =new DBAccess();
		dbaccess.getConn();
	}

}