dbconnect.java

来自「用JDK做的图书类型管理.通过jdk+Access实现」· Java 代码 · 共 53 行

import java.sql.*; 
public class DbConnect
{
	private String dbURL;
	private String user;
	private String password;
	public static void main(String args[])
	{
		try
		{
			DbConnect driver = new DbConnect();
			driver.setURL("jdbc:odbc:book");
			driver.setUser("");
			driver.setPassword("");
			Connection con = driver.getConnection();
			con.close();
		}
		catch (Exception e)
	    {
	        System.out.println(e.toString());
	    }
	}

	public Connection getConnection()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			return DriverManager.getConnection(dbURL,user,password);
		}		
		catch (Exception e)
		{
			System.out.println(e.toString());
		}
		return null;
	}

	public void setURL(String dbURL)
	{
		this.dbURL = dbURL;
	}

	public void setUser(String user)
	{
		this.user = user;
	}

	public void setPassword(String password)
	{
		this.password = password;
	}
}