JAVA JSP水产品配送管理系统 源代码 论文

package com.bean; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.List; import com.util.Constant; import com.util.DBO; public class ComBean { private List list; private ResultSet rs = null; private int EVERYPAGENUM = 2; private int count = -1; private int qq = 0; //声明时间变量 String date1=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime()); String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); //分页查询所有个人会员 public void setEVERYPAGENUM(int EVERYPAGENUM){ this.EVERYPAGENUM=EVERYPAGENUM; } public int getMessageCount(String sql) { //得到信息总数 DBO dbo=new DBO(); dbo.open(); try { rs = dbo.executeQuery(sql); rs.next(); count = rs.getInt(1); return count; } catch (SQLException ex) { ex.printStackTrace(); return -1; } finally { dbo.close(); } } public int getPageCount() { //得到共多少页（根据每页要显示几条信息） if (count % EVERYPAGENUM == 0) { return count / EVERYPAGENUM; } else { return count / EVERYPAGENUM + 1; } } public List getMessage(int page,String sql2,int rr) { //得到每页要显示的信息 DBO dbo=new DBO(); dbo.open(); List list = new ArrayList(); try { rs = dbo.executeQuery(sql2); for (int i = 0; i < (page - 1) * EVERYPAGENUM; i++) { rs.next(); } for (int t = 0; t < EVERYPAGENUM; t++) { if (rs.next()) { qq++; List list2=new ArrayList(); for(int cc=1;cc<=rr;cc++){ list2.add(rs.getString(cc)); } list.add(list2); } else { break; //减少空循环的时间 } } return list; } catch (SQLException ex) { ex.printStackTrace(); return null; } finally { dbo.close(); } } public int comUp(String sql){ DBO dbo = new DBO(); dbo.open(); try{ int i = dbo.executeUpdate(sql); if(i == 1){ return Constant.SUCCESS; } else{ return Constant.SYSTEM_ERROR; } }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } public List getCom(String sql,int row){ //String sql = "select * from bank where uid='"+uid+"' order by id desc "; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try{ rs = dbo.executeQuery(sql); while(rs.next()){ List list2 = new ArrayList(); for(int i=1;i<=row;i++){ list2.add(rs.getString(i)); } list.add(list2); } return list; }catch(Exception e){ e.printStackTrace(); return list; }finally{ dbo.close(); } } public List get1Com(String sql,int row){ //String sql = "select * from bank where uid='"+uid+"' order by id desc "; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try{ rs = dbo.executeQuery(sql); rs.next(); for(int i=1;i<=row;i++){ list.add(rs.getString(i)); } return list; }catch(Exception e){ e.printStackTrace(); return list; }finally{ dbo.close(); } } public String getString(String sql){ //String sql = "select * from bank where uid='"+uid+"' order by id desc "; DBO dbo = new DBO(); list = new ArrayList(); dbo.open(); try{ rs = dbo.executeQuery(sql); if(rs.next()) return rs.getString(1); else return null; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } public int getCount(String sql){ DBO dbo = new DBO(); dbo.open(); try{ rs = dbo.executeQuery(sql); rs.next(); return rs.getInt(1); }catch(Exception e){ e.printStackTrace(); return 1; }finally{ dbo.close(); } } }