dbconnection.java

jsp+javabean写的论坛

//类名:	DBConnection
//功能:	不使用DNS直接连接数据库，支持ACCESS、SQL Server
package com.alumni.bean;
import java.sql.*;

public class DBConnection
{
	private String driver="sun.jdbc.odbc.JdbcOdbcDriver";
	
	//access driver
	private StringBuffer accessURL=new StringBuffer("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=");
	private String accessFilePath="";
	private String accessFileName="";
	
	//sql server driver
	private StringBuffer SQLServerURL=new StringBuffer("jdbc:odbc:Driver={SQL Server};");
	
	private Connection conn;
	
	//Constructor
	public DBConnection()
	{
		conn=null;
	}
	
	//Method:connect to access file
	public Connection getConnectionToAccess(String fileURL) throws SQLException,ClassNotFoundException
	{
		accessURL.append(fileURL);
		Class.forName(driver);
		conn=DriverManager.getConnection(accessURL.toString());
		return conn;
	}
	
	//Method:connect to sql server
	public Connection getConnectionToSQLServer(String serverIP,String serverPort,String userName,String password,String databaseName) throws SQLException,ClassNotFoundException
	{
		SQLServerURL.append("server=");
		SQLServerURL.append(serverIP);
		SQLServerURL.append(":");
		SQLServerURL.append(serverPort);
		SQLServerURL.append(";");
		SQLServerURL.append("uid=");
		SQLServerURL.append(userName);
		SQLServerURL.append(";");
		SQLServerURL.append("pwd=");
		SQLServerURL.append(password);
		SQLServerURL.append(";");
		SQLServerURL.append("database=");
		SQLServerURL.append(databaseName);
		
		Class.forName(driver);
		conn=DriverManager.getConnection(SQLServerURL.toString());
		return conn;
	}
	
	//Method:close connection
	public void close()
	{
		try
		{
			this.conn.close();
		}
		catch(SQLException sqle)
		{
			sqle.printStackTrace();
		}
	}
}