database.java

JSP+SQL 网上图书销售系统源码+开题报告+毕业论文+答辩PPT

package bookshop.util;
/**
 * <p>��ݿ�l��ר�ð� </p>
 * <p>Copyright: wxy Copyright (c) 2007</p>
 * <p>Company:Ling Du book shop online </p>
 * @by :wxy
 * @version 1.0
 */
import java.sql.*;
public class DataBase {
  public Connection conn;
  public Statement stmt;
  public ResultSet rs=null;
  public String sqlStr="";

  /*public DataBase() {
    this.connect();
  }*/
 public Connection connect(){
      try{
    	 
    	  String path = this.getClass().getClassLoader().getResource("").getPath()+"bookshop.mdb";
    	 path =  path.substring(1);
  //  	  System.out.println(path);
    	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	  conn = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+path);
  //      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
  //      String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookshop";
  //      conn=DriverManager.getConnection(url,"sa","");
   //     stmt = conn.createStatement ();
       }catch(Exception ee){
        System.out.println("connect db error:"+ee.getMessage());
       }
      return conn;
    }
 /*public static void main(String[] args) {
     try{
            DataBase db = new DataBase();
            db.connect();
          }catch(Exception e){
            e.printStackTrace();
          }
        }*/
}