daobase.java

一个连接tomcat数据池的源码

package com.chjchina.dao;

import java.sql.*;
import javax.sql.*;
import javax.naming.*;

public abstract class DAOBase {
	public Connection getConnection() throws NamingException, SQLException{
/*        Context initContext = new InitialContext();
        Context envContext = (Context)initContext.lookup("java:/comp/env");
        DataSource ds = (DataSource)envContext.lookup("jdbc/CollegeDataSource");
        Connection conn = ds.getConnection();
		return conn;*/
		String username="admin";
		String password="123456";
		String url="jdbc:mysql://localhost:3306/college";
		
		try{
			Class.forName("com.mysql.jdbc.Driver");
		}catch(ClassNotFoundException e){
			throw new RuntimeException(e);
		}
		Connection conn=DriverManager.getConnection(url,username,password);
		
		return conn;
	}
	
	public Connection getSimpleConnection()
	  throws SQLException,ClassNotFoundException{
		String username="admin";
		String password="123456";
		String url="jdbc:mysql://192.168.4.92:3306/college";
		
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn=DriverManager.getConnection(url,username,password);
		
		return conn;
	}
	
	
}