connectdb.java

swing+jdbc+sqlserver2000的小型网吧系统

package org.itstar.netbar.utils;

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

public class ConnectDB 
{
	private static Connection con=null;
	
	static
	{//加载类
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=NetBar";
		String dbUsername="sa";
		String dbPassword="sa";
		try {//建立与数据源的连接
			con=DriverManager.getConnection(url,dbUsername,dbPassword);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getConn()
	{//此方法得到一个连接
		return con;
	}
	
	public static void closeConn()
	{//此方法关闭一个连接
		try {
			con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}