selectbook.java

JSP制作的一个在线书店 拥有简单的功能 请看看吧 初学者

package bookadmin;

import java.sql.*;
import ConnBean.ConnBean;
import common.BookInfoBean;
import java.util.*;

public class selectBook {
    ConnBean objCon=new ConnBean() ;
    Statement stmt = null;
    ResultSet rs=null;
    public selectBook() {
        this.stmt =objCon.getStmt() ;
    }

    public Vector SelectBook(){
        try{
            Vector v=new Vector() ;
            common.BookInfoBean objBookInfo=null;
            String strsql="select * from Bookinformation";
            while(rs.next() ){
                objBookInfo=new BookInfoBean() ;
                objBookInfo.setBookNo(rs.getString(1));
                objBookInfo.setBookType(rs.getInt(2));
                objBookInfo.setBookName(rs.getString(3));
                objBookInfo.setPrice(Float.parseFloat(rs.getString(4)));
                objBookInfo.setBookCount(Integer.parseInt(rs.getString(5)));
                objBookInfo.setBook_concern(rs.getString(6));
                objBookInfo.setAuthor(rs.getString(7));
                objBookInfo.setImage(rs.getString(8));
                objBookInfo.setIntroduc(rs.getString(9));
                v.add(objBookInfo);
            }
            return v;
        } catch(Exception ex){
            ex.printStackTrace();
            return null;
        }

    }
}