databaseconnection.java

长沙公交查询管理系统,主要实现对人员资料的管理以及车辆的分配路线。

package pro;

import java.io.*;
import java.sql.*;

public class DatabaseConnection//此类提供连接和关连接的方法!
{
	private static Connection mCon;
	
	private DatabaseConnection(){}//
	
	public static Connection getConnection()
	{
		if (mCon == null)
		{
			try
			{
				File file = new File("config.ini");
				FileReader fr = new FileReader(file);
				BufferedReader br = new BufferedReader(fr);
				String strDriver = br.readLine();
				String strUrl = br.readLine();
				String strUser = br.readLine();
				String strPwd = br.readLine();
				br.close();
				fr.close();
				
				Class.forName(strDriver);
				mCon = DriverManager.getConnection(strUrl, strUser, strPwd);
				System.out.println("OK");
			}
			catch (ClassNotFoundException cnfe)
			{
				cnfe.printStackTrace();
			}
			catch (IOException ioe)
			{
				ioe.printStackTrace();
			}
			catch (SQLException sqle)
			{
				sqle.printStackTrace();
			}
		}
		return (mCon);
	}
	
	public static void closeConnection()
	{
		try
		{
			if (mCon != null)
			{
				mCon.close();
				System.out.println("close");
			}
		}
		catch (SQLException sqle)
		{
			sqle.printStackTrace();
		}
	}
}