dbconnect.java

来自「java开发的大整数计算器,实现基本的运算,还有sin,cos,tan,cot.」· Java 代码 · 共 51 行

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

import javax.swing.JOptionPane;

public class DBConnect
{
	private Connection con;
	
	private String driverUrl;
	
	public Connection getConnection(String dbPath)
	{
		
		File f = new File(dbPath);
		if(f.exists())
		{
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				
				driverUrl = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath;
				
				con = DriverManager.getConnection(driverUrl,"管理员","123456");
				
				if(!con.isClosed())
					System.out.println("DataBase connected!");
			}
			catch (ClassNotFoundException e)
			{
				System.out.println(e.getMessage());
			}
			catch (SQLException e)
			{
				System.out.println(e.getMessage());
			}
			return con;
		}
		else
		{
			JOptionPane.showMessageDialog(null,"config.bin文件缺失");
			
			System.exit(0);
			return null;
		}
		
	}
}