buyercar.java

网站的实例

package ebs;

import java.sql.*;
public class Buyercar{
          private String bookid=null; //图书编号
          private String bookname=null; //书名
          private String bookisbn=null; //图书出版号
          private String bookedit=null;//图书版本号
          private float bookprice=0; //价格
          private int booksum=0; //库存量
          private static String strDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
          private static String strDBUrl="jdbc:odbc:ebookstore";
          java.sql.Connection conn;
          java.sql.Statement stmt;
          java.sql.ResultSet Rst;
          
          public Buyercar(){
          	//加载驱动
          	try{
          	     Class.forName(strDBDriver);
          	   }
          	catch(java.lang.ClassNotFoundException e){
          		System.err.println("Buyercar():"+e.getMessage());
          	     }
          }
          //取当前数据库中全部图书信息
          public ResultSet getBookList(){
          	String strSql=null;
          	try{
          	     //建立与数据库的连接
          	     conn=DriverManager.getConnection(strDBUrl);
          	     stmt=conn.createStatement();
          	     strSql="select * from book_info";
          	     Rst=stmt.executeQuery(strSql);
          	    }
          	    //捕获异常
          	catch(SQLException e){
          		System.err.println("Buyercar.getBookList();"+e.getMessage());
          	      }
          	      return Rst;
              }
              //根据图书的编号给图书的其他信息赋值
              private void getBookInfo(String BID){
              	String strSql=null;
              	bookname=null;
              	bookedit=null;
                bookisbn=null; //图书出版号
                bookprice=0;
                booksum=0;
                try{
                    //建立和数据库的连接
                    conn=DriverManager.getConnection(strDBUrl);
                    stmt=conn.createStatement();
                    strSql="Select * from book_info where book_id="+BID;
                    Rst=stmt.executeQuery(strSql);
                    while(Rst.next()){
                    	bookname=Rst.getString("book_name");
                    	bookedit=Rst.getString("book_edit");
                    	bookisbn=Rst.getString("book_isbn");
                    	bookprice=Rst.getFloat("book_price");
                    	booksum=Rst.getInt("book_sum");
                       }
                  }
                  //捕获异常
                  catch(SQLException e){
                  	System.err.println("Buyercar.getBookInfo():"+e.getMessage());
                      }
                 }
                 //给图书的编号赋值，同时调用函数给图书的其他信息赋值
                 public void setBookid(String BID){
                 	this.bookid=BID;
                 	getBookInfo(bookid);
                       }
                 //取图书编号
                 public String getBookid(){
                 	return bookid;
                       }
                 public String getBookname(){
                 	return bookname;
                       }
                 public String getBookedit(){
                 	return bookedit;
                       }

                 public String getBookisbn(){
                 	return bookisbn;
                       }
                 public float getBookprice(){
                 	return bookprice;
                       }
                       
                 public int getBooksum(){
                 	return booksum;
                       }
                       
}