database.java

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

package bookshop.util;
/**
 * <p>数据库连接专用包 </p>
 * <p>Copyright: wxy Copyright (c) 2004</p>
 * <p>Company:juanjuan book shop online </p>
 * @by :wxy
 * @version 1.0
 */
import java.sql.*;
public class DataBase {
  public Connection conn;//数据库连接对象
  public Statement stmt;//sql语句对象
  public ResultSet rs=null;//查询结果对象
  public String sqlStr="";

  public DataBase() {
	this.connect();
  }
 public boolean connect(){
	  try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载jdbc_odbc桥接器
		conn=DriverManager.getConnection("jdbc:odbc:bookshop","sa","");
		stmt = conn.createStatement ();
	   }catch(Exception ee){
		System.out.println("connect db error:"+ee.getMessage());
		return false;
	   }
	  return true;
	}
 
}