dataaccess.java

一个完整的网上书店

package com.ascenttech.ebookstore.util;
import java.sql.*;
import java.util.Properties;

import javax.sql.*;
import javax.naming.*;
public class DataAccess {
  private static String driver;
  private static String url;
  private static String user;
  private static String pwd;
  static{
	  
	  DatabaseConfigParser databaseConfig=new DatabaseConfigParser();
		try {
			databaseConfig.parse("database.conf.xml");
			Properties dbProps=databaseConfig.getProps();
			driver=dbProps.getProperty("driver");
			url=dbProps.getProperty("url");
			user=dbProps.getProperty("user");
			pwd=dbProps.getProperty("password");
		} catch (Exception e) {
			e.printStackTrace();
		}
  }
  
  public DataAccess() throws Exception {
     
  }

  public static Connection getConnection(){
     Connection con=null;
     try {
      Class.forName(driver);
      con = DriverManager.getConnection(url, user, pwd);
     }
     catch (Exception ex) {
    	 ex.printStackTrace();
     }
     return con;
  }
  
  public static Connection getConnectionByDS(){
	  Connection con = null;  
	  try{
	    Context ctx = new InitialContext();
	    DataSource ds = (DataSource)ctx.lookup("ebsDS");
	    con = ds.getConnection();
	  }catch(Exception e){e.printStackTrace();}
	  
	  return con;
  }

}