dbconnection.java

三层架构实现左侧菜单

package database;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class DBConnection {

	private Connection conn = null;
//连接ACCESS
	public Connection getConn(String path) {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
			String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+path;
			this.conn = DriverManager.getConnection(url,"","");
		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
		return this.conn;
	}
	
	public Connection getConn() {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@192.168.1.101:1521:cambrian";
			this.conn = DriverManager.getConnection(url, "xz", "xz");

		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
		return this.conn;
	}

	public Connection getConnFromProperties() {
		try {
			InputStream in=getClass().getResourceAsStream("jdbc.properties");
			Properties properties=new Properties();
			properties.load(in);
			String driver=properties.getProperty("jdbc.driverClassName");
			String url=properties.getProperty("jdbc.url");
			String user=properties.getProperty("jdbc.username");
			String password=properties.getProperty("jdbc.password");
			Class.forName(driver);
			this.conn = DriverManager.getConnection(url, user, password);

		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
		} catch (SQLException ex) {
			ex.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return this.conn;
	}
	
	public Connection getConn(String url, String user, String pwd) {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			this.conn = DriverManager.getConnection(url, user, pwd);

		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
		return this.conn;
	}

	/**
	 * 从数据连接池中获取数据库的连接
	 * 
	 * @param fsName 
	 * @throws NamingException
	 * @throws SQLException
	 * @return Connection
	 */
	public static Connection getConnectionFromPooledDataSource(String fsName)
			throws javax.naming.NamingException, SQLException {

		Context initContext;
		Connection con = null;
		try {
			initContext = new InitialContext();
			Context envContext = (Context) initContext.lookup("java:/comp/env");
			DataSource ds = (DataSource) envContext.lookup(fsName);
			con = ds.getConnection();
		} catch (NamingException e) {
			e.printStackTrace();
		}

		return con;
	}

	public static void main(String[] args){
		DBConnection dbconn=new DBConnection();
		System.out.println(dbconn.getConn("C:\\Program Files\\Apache Software Foundation\\Tomcat 5.0\\webapps\\tree\\db\\tree.mdb"));
	}
}