database.java

图书管理系统,用JSP实现,图书的查询,添加等功能

package beans;
/**
 * 数据库连接
 */
import java.sql.*;
public class DataBase {
  public Connection conn;
  public Statement stmt;
  public ResultSet rs=null;
  
  public String sqlStr="";

  public DataBase() {
	this.connect();
  }
 public boolean connect(){
	  try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
		String url ="jdbc:odbc:bookshop";
		conn=DriverManager.getConnection(url);
		stmt = conn.createStatement ();
	   }catch(Exception ee){
		System.out.println("数据库连接出错："+ee.getMessage());
		return false;
	   }
	  return true;
	}
}