selectbook.java~2~

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.setBookNo(rs.getString(1));
                objBookInfo.setBookNo(rs.getString(1));
                objBookInfo.setBookNo(rs.getString(1));
                objBookInfo.setBookNo(rs.getString(1));
                objBookInfo.setBookNo(rs.getString(1));

            }
        }

    }
}