停車場管理系統(tǒng)論文

附錄登錄主要代碼位置：TestPark/src/DAL/login.java。主要封裝了對登錄數據的操，該類中有三個方法分別用于檢查用戶登錄信息是否合法，根據用戶編號和角色編號獲取用戶名和角色信息。publicclassLogin{ publicbooleancheckLogin(Stringuser_id,Stringuser_pwd) { StringsqlCmd="selectcount(*)fromuserwhereuser_id=?anduser_pwd=?"; Object[]objList=newObject[2]; objList[0]=user_id; objList[1]=user_pwd; Stringresult=SQLUtil.excuteScalar(sqlCmd,objList).toString(); if(result.equals("1")) { returntrue; } else{ returnfalse; } } publicStringgetName(Stringuser_id) { StringsqlCmd="selectuser_namefromuserwhereuser_id='"+user_id+"'"; Stringresult=SQLUtil.excuteScalar(sqlCmd,null).toString(); returnresult; } publicStringgetSysLevel(Stringuser_id) { StringsqlCmd="selectrole_idfromuserwhereuser_id='"+user_id+"'"; Stringresult=SQLUtil.excuteScalar(sqlCmd,null).toString(); returnresult; }}對車位數據的操作封裝在：seat.java類中。該類中主要封裝了分頁和對車位信息的增、刪、改、查等方法。首先獲取車位信息列表，然后獲取未分配的車位列表，根據查詢條件獲取獲取分頁后的信息列表，數據的更新、插入、刪除，獲取分頁總數，根據查詢條件獲取分頁總數。publicclassSeat{ publicList<Object>getEntity() { StringsqlCmd="select*fromSeat"; returnDBUtil.SQLUtil.executeQuery(sqlCmd,null); } publicList<Object>getNoUseSeat() { StringsqlCmd="SELECT*FROMSeatWHEREseat_idNOTIN(SELECTseat_idFROMcard)"; returnDBUtil.SQLUtil.executeQuery(sqlCmd,null); } publicList<Object>getEntity(intpage) { intsize=(1)*15; StringsqlCmd="select*fromSeatlimit"+size+",15"; returnDBUtil.SQLUtil.executeQuery(sqlCmd,null); } publicList<Object>getEntityByWhere(StringsqlWhere,intpage) { intsize=(1)*15; StringsqlCmd="select*fromSeatwhere"+sqlWhere+"limit"+size+",15"; returnDBUtil.SQLUtil.executeQuery(sqlCmd,null);}publicintdeleteEntity(Stringseat_id){StringsqlCmd="deletefromSeatwhereseat_id='"+seat_id+"'";returnDBUtil.SQLUtil.executeNonQuery(sqlCmd,null);}publicList<Object>getEntityById(Stringseat_id){StringsqlCmd="select*FromSeatwhereseat_id='"+seat_id+"'";returnDBUtil.SQLUtil.executeQuery(sqlCmd,null);}publicintupdateEntity(Stringseat_id,Stringseat_num,Stringseat_section,Stringseat_state,Stringseat_tag){StringsqlCmd="UpdateSeatsetseat_num='"+seat_num+"',seat_section='"+seat_section+"',seat_state='"+seat_state+"',seat_tag='"+seat_tag+"'whereseat_id='"+seat_id+"'";returnSQLUtil.executeNonQuery(sqlCmd,null);}publicintinsertEntity(Stringseat_id,Stringseat_num,Stringseat_section,Stringseat_state,Stringseat_tag){StringsqlCmd="InsertintoSeatvalues('"+seat_id+"','"+seat_num+"','"+seat_section+"','"+seat_state+"','"+seat_tag+"')";returnSQLUtil.executeNonQuery(sqlCmd,null);}publicbooleancheckExist(Stringseat_id){StringsqlCmd="selectcount(*)fromSeatwhereseat_id='"+seat_id+"'";if(1==Integer.parseInt(SQLUtil.excuteScalar(sqlCmd,null).toString())){returntrue;}returnfalse;} publicObjectgetPageCount() { StringsqlCmd="SELECTCEIL(COUNT(*)/15.0)FROMSeat"; returnSQLUtil.excuteScalar(sqlCmd,null); } publicObjectge