基于jsp的公司访客登记系统

package com.zqh.dbs; import java.sql.*; import java.util.ArrayList; import com.zqh.valuebean.*; public class Visit { private Connection conn=null; private Statement stmt=null; private ResultSet rs=null; private int pagesize=5;//每页显示5行 private int pagecount=0;//一共有多少页 private int row=0;//从数据库得到行数 public boolean check(String userName,String userPass) { boolean ck=false; try { conn=new LogonDB().getConn(); String sql="select * from tb_master where master_name='"+userName+"'and master_password='"+userPass+"'"; stmt=conn.createStatement(); rs=stmt.executeQuery(sql); if(rs.next()) { ck=true; } else { ck=false; } } catch(Exception e) { e.printStackTrace(); } finally { this.closeDB();//关闭数据库 } return ck; } public boolean update(String id,String name,String sex,String date){//修改 boolean a=false; try{ conn=new LogonDB().getConn(); stmt=conn.createStatement(); int b=stmt.executeUpdate("update tb_client set client_id='"+id+"'client_name='"+name+"',client_sex='"+sex+"',client_date='"+date+"' where client_id='"+id+"'"); if(b==1){ a=true; } }catch(Exception e){ e.printStackTrace(); }finally{ this.closeDB(); } return a; } public boolean delete(String id){//删除 boolean a=false; try{ conn=new LogonDB().getConn(); stmt=conn.createStatement(); int b=stmt.executeUpdate("delete from tb_client where client_id='"+id+"'"); if(b==1){ a=true; } }catch(Exception e){ e.printStackTrace(); }finally{ this.closeDB(); } return a; } public boolean insert(String name,String sex,String date){//添加 boolean a=false; try{ conn=new LogonDB().getConn(); stmt=conn.createStatement(); int b=stmt.executeUpdate("insert into tb_client (client_name,client_sex,client_date) values('"+name+"','"+sex+"','"+date+"')"); if(b==1){//成功插入一条 a=true; } }catch(Exception e){ e.printStackTrace(); }finally{ this.closeDB(); } return a; } public int getPage(){// 得到分页 try{ conn=new LogonDB().getConn(); stmt=conn.createStatement(); rs=stmt.executeQuery("select count(*) from tb_client"); if(rs.next()){ row=rs.getInt(1); } //计算pagecount if(row%pagesize==0){//首页 pagecount=row/pagesize; }else{ pagecount=row/pagesize+1; } }catch(Exception e){ e.printStackTrace(); }finally{ this.closeDB(); } return pagecount; } public ArrayList getPageResult(int pageindex){//得到查询结果 ArrayList array=new ArrayList();//用ArrayList封装rs以便关闭数据库 try{ conn=new LogonDB().getConn(); stmt=conn.createStatement(); rs=stmt.executeQuery("select * from tb_client limit "+(pageindex-1)*pagesize+","+pagesize); if(rs==null){ array.add("没有访客记录！"); }else{ while(rs.next()){ Customer ctm=new Customer(); ctm.setCustomerid(rs.getInt(1)); ctm.setCustomername(rs.getString(2)); ctm.setCustomersex(rs.getString(3)); ctm.setVisitdate(rs.getString(4)); array.add(ctm); } return array; } }catch(Exception e){ e.printStackTrace(); }finally{ this.closeDB();//关闭数据库 } return array; } public void closeDB(){ try{ if(rs!=null){ rs.close(); rs=null; } if(stmt!=null){ stmt.close(); stmt=null; } if(conn!=null){ conn.close(); conn=null; } }catch(Exception e){ e.printStackTrace(); } } }