dbconnect.java

一个用JSP写的基于了B/S的图书馆管理系统

package lms;
import java.sql.*;

public class DBConnect
{
  private String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
  private String url ="jdbc:odbc:LMS";
  private String user = "sa";
  private String password = "";
  public DBConnect()
  {

  }
  public String getDriverName()
  {
    return this.driverName;
  }
  public void setDriverName(String newdrivername)
  {
    this.driverName = newdrivername;
  }

  public String getUrl()
  {
    return this.url;
  }
  public void setUrl(String newurl)
  {
    this.url = newurl;
  }

  public String getUser()
  {
    return this.user;
  }
  public void setUser(String newuser)
  {
    this.user = newuser;
  }

  public String getPassword()
  {
    return this.password;
  }
  public void setPassword(String newpassword)
  {
    this.password = newpassword;
  }

  public Connection getConnection()
  {
    try
    {
      Class.forName(driverName).newInstance();
      //System.out.println(driverName);
      //System.out.println("a");
      DriverManager.getConnection(url,user,password);
      //System.out.println("B");
      return DriverManager.getConnection(url,user,password);

    }
    catch(Exception ex)
    {
      ex.printStackTrace();
      return null;
    }
  }
  /*
  public static void main(String args[]){
   DBConnection db = new DBConnection();
   String sql = "select * from User";
   try{
     Statement stm = db.getConnection().createStatement();
     ResultSet rs = stm.executeQuery(sql);
     while (rs.next()) {
       System.out.println(rs.getString(1));
       System.out.println(rs.getString(2));
       System.out.println(rs.getString(3));
     }
   }catch(Exception ex){
     ex.printStackTrace();
  }
}
  */
}