dbconnection.java

项目名称eShop

/*
 * 创建日期：2006-7-16 14:36:33
 *
 * 代码作者：万星
 * 
 * 项目名称：eShop
 * 
 * Copyright 2005 北京交通大学信息管理与信息系统系. All right reserved.
 */
package eshop.common;
import java.sql.*;

/**
 * <h5>功能说明:提供连接数据库联接的方法</h5>
 *
 * <h5>对应需求:封装连接数据库连接的方法</h5>
 * 
 *
 * @version 1.0
 * @author 万星
 */
public class DBConnection
{

    public static void main(String[] args)throws Exception
    {
        String strSQL="select * from T_USER where F_USERCODE='SS'";
        Connection conn=null;
        Statement stmt=null;
        ResultSet rs=null;
        try
        {
           conn=DBConnection.getConnection();
           stmt=conn.createStatement();
           rs=stmt.executeQuery(strSQL);
           
           
           while (rs.next())
           {
               String strUserCode=rs.getString(1);
               System.out.print(strUserCode);
           }
        }
        catch(Exception e)
        {
          e.printStackTrace();  
          throw e;
        }
        finally
        {
               rs.close();
               stmt.close();
               conn.close();
        }
    }
    
    public static Connection getConnection() 
    {
        Connection conn=null;
       try 
        { 
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
        } 
       catch(ClassNotFoundException e1)
        {
           e1.printStackTrace();
        } 
       
       try
        {
          //String strURL ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data\\eShopDB.mdb";   
          //String strURL ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=admin//App_Data\\eShopDB.mdb";
          // String strURL ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C://eclipse//workspace//eShop//admin//App_Data\\eShopDB.mdb"; 
          String strURL ="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C://Program Files//Apache Software Foundation//Tomcat 5.5//webapps//eShop//admin//App_Data\\eShopDB.mdb"; 
          conn=DriverManager.getConnection(strURL);
        }
       catch(Exception e)
        {
          e.printStackTrace();   
        }
       
       return conn;
    }
}