connectionfactory.java

达内JAVA培训-WEB课程部分项目源代码

package cn.com.tarena.web.servlet.day3.util;

import java.sql.Connection;
import java.sql.DriverManager;

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

public class ConnectionFactory {
	private static final String DB_DRIVER = "com.pointbase.jdbc.jdbcUniversalDriver";

	private static final String DB_URL = "jdbc:pointbase:server://localhost/test";

	private static final String DB_USER = "test";

	private static final String DB_PASSWORD = "test";


	public static Connection getConnByJDBC() throws Exception {
		Class.forName(DB_DRIVER);

		return DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
	}
	
	public static Connection getConnByJNDI() throws Exception {
		Context context = new InitialContext();
		
		DataSource dataSource = (DataSource)context.lookup("java:comp/env/jdbc/pointbase");

		return dataSource.getConnection();
	}
	
	
	
	
	
	
	
}