比较完整的jsp开发小项目

package com.wy.bean ; import java.sql.*; import java.util.* ; public class WelcomeBean { private int nowPage = 1 ; private int pageSize = 10 ; public void setNowPage(int value) { this.nowPage = value ; } public int getNowPage(){ return nowPage ; } public void setPageSize(int value) { this.pageSize = value ; } public int getPageSize(){ return pageSize ; } private int getRowCount() { int count = 0 ; try { Connection cn = com.wy.data.DataBase.getConnection() ; Statement st = cn.createStatement() ; ResultSet rs = st.executeQuery("select count(*) from goods") ; rs.next() ; count = rs.getInt(1) ; rs.close() ; st.close() ; cn.close() ; } catch (Exception ex) { } return count ; } public int getPageCount(){ int rowCount = this.getRowCount() ; int pageCount = 0 ; if(rowCount%pageSize==0){ pageCount = rowCount/pageSize ; }else { pageCount = rowCount/pageSize + 1 ; } return pageCount ; } public ArrayList getData() { ArrayList al = new ArrayList() ; try { Connection cn = com.wy.data.DataBase.getConnection() ; Statement st = cn.createStatement() ; ResultSet rs = st.executeQuery("select go_id , ppai ,type ,gname , cost , price , remark from goods") ; //跳过该跳过的数据 for (int i = 0; i<(nowPage-1)*pageSize; i++){ rs.next() ; } for (int i = 0; i<pageSize; i++){ if(rs.next()){ GoodsBean gb = new GoodsBean() ; gb.setId(rs.getString(1)) ; gb.setPpai(rs.getString(2)) ; gb.setType(rs.getString(3)) ; gb.setGname(rs.getString(4)) ; float cost = rs.getFloat(5) ; gb.setCost(cost) ; gb.setOff(cost/rs.getFloat(6)) ; gb.setRemark(rs.getString(7)) ; al.add(gb) ; } } rs.close() ; st.close() ; cn.close() ; } catch (Exception ex) { } return al ; } }