connectdb.java

对各种数据库连接

/*
* 编写:Java一族
* qq群号 6608058
* QQ:308212012
* Created on 2003年11月19日
*/

package com.jgt.util; //你编译时候可以修改package
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;

public class ConnectDB{
//数据库配置参数
private String driverClass;
private String dbUrl;
private String dbUser;
private String dbPwd;
private String yn;
private Connection con;
private String ny;
private String lookup;

public ConnectDB(){
try{
Properties props = new Properties();
props.load(new FileInputStream("db.properties"));
dbUrl = props.getProperty("dbUrl");
dbUser = props.getProperty("dbUser");
dbPwd = props.getProperty("dbPwd");
yn=props.getProperty("yn");
ny=props.getProperty("ny");
lookup=props.getProperty("lookup");
}catch(Exception e){e.printStackTrace();}
}
public Connection connection(){ //得到Conncetion对象
try{
if(ny.equals("n")){
Class.forName(driverClass);
if(yn.equals("y"))
con=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
else
con=DriverManager.getConnection(dbUrl);
}else{
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup(lookup);
con = ds.getConnection();
}
}catch(Exception ex){ex.printStackTrace();}
return con;
} 
}