基于卡式的小区车辆管理系统的设计与实现

package com.bean; import java.sql.ResultSet; 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 CarBean { private List list; private ResultSet rs; private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); /////////////////////////////////////////////////////////////////////车位管理：对车位进行管理，包括车辆对应汽车的更新，修改等。 //增加 public int addPlace(String place,String remark){ String sql = "insert into place (place,remark,ifuse,addtime) values('"+place+"','"+remark+"','空闲状态','"+date+"')"; 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 int upPlace(String id,String place,String remark){ String sql = "update place set place='"+place+"',remark='"+remark+"' where id='"+id+"'"; 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 int delPlace(String id){ String sql = "delete from place where id='"+id+"'"; 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 getAllPlace(){ String sql = "select * from place 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(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list.add(list2); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } public List getAllNoPlace(){ String sql = "select * from place where ifuse='空闲状态' 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(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list.add(list2); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } // 一个 public List getPlace(String id){ String sql = "select * from place where id='"+id+"' "; DBO dbo=new DBO(); list = new ArrayList(); dbo.open(); try{ rs = dbo.executeQuery(sql); while(rs.next()){ list.add(rs.getString(1)); list.add(rs.getString(2)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } //////////////////////////////////////////////////////////////////车辆进出统计：对小区进出车辆进行统计，包括每一辆汽车进出的时间表。 //增加 type：进入 离开 public int addInto(String card,String cometime,String type){ String sql = "insert into carinto (card,cometime,cmil,gotime,gmil,type) values('"+card+"','"+cometime+"','"+System.currentTimeMillis()+"','未离开','0','"+type+"')"; 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 int upInto(String id,String gotime){ String sql = "update carinto set gotime='"+gotime+"',gmil='"+System.currentTimeMillis()+"' where id='"+id+"'"; 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 int delInto(String id){ String sql = "delete from carinto where id='"+id+"'"; 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 getAllInto(){ String sql = "select * from carinto 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(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list.add(list2); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } // 一个 public List getInto(String id){ String sql = "select * from carinto where id='"+id+"' "; DBO dbo=new DBO(); list = new ArrayList(); dbo.open(); try{ rs = dbo.executeQuery(sql); while(rs.next()){ list.add(rs.getString(1)); list.add(rs.getString(2)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } //////////按车牌查询 public List getSeqrchInto(String type){ String sql = "select * from carinto where type='"+type+"' 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(); list2.add(rs.getString(1)); list2.add(rs.getString(2)); list2.add(rs.getString(3)); list2.add(rs.getString(4)); list2.add(rs.getString(5)); list2.add(rs.getString(6)); list2.add(rs.getString(7)); list.add(list2); } return list; }catch(Exception e){ e.printStackTrace(); return null; }finally{ dbo.close(); } } /////////////////////////////////////////////////////////////////////注册信息管理：对新加入本系统管理的小区车辆各项信息进行登记， //////////////////////////////////////////////////////////////////////包括车主姓名，车牌号，联系电话，车位号，卡号 等。 //增加 public int addReg(String name,String num,String tel,String place,String card){ String sql = "insert into reg (name,num,tel,place,card,addtime) values('"+name+"','"+num+"','"+tel+"','"+place+"','"+card+"','"+date+"')"; DBO dbo = new DBO(); dbo.open(); try{ int i = dbo.executeUpdate(sql); dbo.executeUpdate("update place set ifuse='使用状态' where place='"+place+"'"); dbo.executeUpdate("update card set ifuse='使用状态' where card='"+card+"'"); if(i == 1) return Constant.SUCCESS; else return Constant.SYSTEM_ERROR; }catch(Exception e){ e.printStackTrace(); return Constant.SYSTEM_ERROR; }finally{ dbo.close(); } } // 修改 public int upReg(String id,String name,String num,Strin