基于OCR系統(tǒng)的高校檔案管理系統(tǒng)的數(shù)據(jù)庫管理員功能附錄

1、附錄系統(tǒng)管理模塊分機(jī)構(gòu)部門維護(hù)、機(jī)構(gòu)信息查詢、部門信息查詢、人員維護(hù)、角色維護(hù)、模塊管理六個功能模塊。這里對六個模塊的實(shí)現(xiàn)代碼一一講解。機(jī)構(gòu)部門維護(hù)Spring頁碼配置Spring頁碼配置action-servlet.xml主要代碼實(shí)現(xiàn)為smOrganControllerbean id=smOrganParamMultiControllerbean id=smOrganController控制層代碼實(shí)現(xiàn)SmOrganController.java為機(jī)構(gòu)部門維護(hù)控制層代碼實(shí)現(xiàn)，其主要方法為handleRequest，其代碼如下。public ModelAndView handleRequest(

2、HttpServletRequest request,HttpServletResponse response) throws Exception if (log.isDebugEnabled() log.debug(entering handleRequest method.);/ 得到機(jī)構(gòu)頁面控制類型，1為查詢頁面 2為維護(hù)頁面String organviewType = FormUtil.getString(request, organviewType, );request.setAttribute(organviewType, organviewType);SmOrgan smOrga

3、n = new SmOrgan();/ 機(jī)構(gòu)編碼String organId = FormUtil.getString(request, queryOrganId, );String organName1 = FormUtil.getString(request, queryOrganName1, );/ 機(jī)構(gòu)名稱String organName = FormUtil.getString(request, queryOrganName, );String organId1 = FormUtil.getString(request, queryOrganId1, );/ 上級機(jī)構(gòu)編碼String

4、 preOrganId = FormUtil.getString(request, queryPreOrganId, );/ 法人名稱String corporationName = FormUtil.getString(request,queryCorporationName, );int status = FormUtil.getInt(request, status, 1);request.setAttribute(queryOrganId, organId);request.setAttribute(queryOrganName1, organName1);request.setAtt

5、ribute(queryOrganName, organName);request.setAttribute(queryOrganId1, organId1);request.setAttribute(queryPreOrganId, preOrganId);request.setAttribute(queryCorporationName, corporationName);request.setAttribute(status, status);smOrgan.setOrganId(organId);smOrgan.setOrganName(organName);smOrgan.setPr

6、eOrganId(preOrganId);smOrgan.setCorporationName(corporationName);smOrgan.setStatus(status);request.setAttribute(flaglist, ConstantsWhy.FLAGLIST);/ populate object with request parametersBeanUtils.populate(smOrgan, request.getParameterMap();/ 根據(jù)條件得到機(jī)構(gòu)信息列表List smOrgans = smOrganManager.getSmOrgans(smO

7、rgan);return new ModelAndView(sm/smOrganList, Constants.SMORGAN_LIST,smOrgans);DAO層代碼實(shí)現(xiàn)機(jī)構(gòu)部門維護(hù)數(shù)據(jù)訪問層(DAO)為SmOrganDaoHibernate其主要實(shí)現(xiàn)方法為getSmOrgans.java代碼實(shí)現(xiàn)如下。public List getSmOrgans(final SmOrgan smOrgan) String querySQL = from SmOrgan where 1=1 ;/ return getHibernateTemplate().find(from SmOrgan where 1

8、=1 );if (smOrgan != null) / 機(jī)構(gòu)編碼if (!smOrgan.getOrganId().trim().equals() querySQL += and organId = + smOrgan.getOrganId().trim()+ ;/ 機(jī)構(gòu)名稱if (!smOrgan.getOrganName().trim().equals() querySQL += and organName = + smOrgan.getOrganName().trim() + ;/ 上級機(jī)構(gòu)編碼if (!smOrgan.getPreOrganId().trim().equals() qu

9、erySQL += and preOrganId = + smOrgan.getPreOrganId().trim() + ;/ 法人名稱if (!smOrgan.getCorporationName().trim().equals() querySQL += and corporationName like %+ smOrgan.getCorporationName().trim() + %;if (smOrgan.getStatus() != 0) querySQL += and status = + smOrgan.getStatus();querySQL += ORDER BY ins

10、ort asc ;return getHibernateTemplate().find(querySQL);視圖層代碼實(shí)現(xiàn)視圖層為smOrganList.jsp其代碼實(shí)現(xiàn)為。input type=button class=btn_a name=selectqueryOrganId, queryOrganName1, 2, 2);value= /input type=button class=btn_a name=selectqueryOrganId1, queryOrganName, 2, 2);value= /%- input type=button class=btn_gjsearch o

11、nclick=value= /-%input type=button class=btn_searchonclick=javascript:formSubmit();value= /input type=reset class=btn_re name=resetvalue= /input type=button class=btn_searchonclick=javascript:formSubmit();value= /input type=reset class=btn_re name=resetvalue= / input type=button class=btn_add style=

12、margin-right: 5pxonclick=location.href=value= / Form.focusFirstElement($(smOrganForm); function formSubmit() if (!Validator.isEmpty($F(queryOrganId) &!Validator.isW_($F(queryOrganId) win.alertMsg(,methodHander,queryOrganId); return; if (!Validator.isEmpty($F(queryOrganName) &!Validator.isChineseOrW_

13、($F(queryOrganName) win.alertMsg(,methodHander,queryOrganName); return; if (!Validator.isEmpty($F(queryPreOrganId) &!Validator.isW_($F(queryPreOrganId) win.alertMsg(,methodHander,queryPreOrganId); return; if (!Validator.isEmpty($F(queryCorporationName) &!Validator.isChineseOrW_($F(queryCorporationNa

14、me) win.alertMsg(,methodHander,queryCorporationName); return;$(smOrganForm).submit(); function showOrganList(parent_window, split, organRootId, organId, organName, selectType, isSign) var url = $absPath/$SYSTEM_PROJECTNAME/smOrganMultiAction.why?method=getOrganList + &split= + split + &organId= + or

15、ganRootId + &selectId= + organId + &selectName= + organName +&selectType= + selectType + &isSign= + isSign + ; 機(jī)構(gòu)部門查詢界面與機(jī)構(gòu)部門維護(hù)界面用相同的代碼實(shí)現(xiàn)。當(dāng)organviewType=1時，實(shí)現(xiàn)機(jī)構(gòu)部門查詢；當(dāng)organviewType=2時，實(shí)現(xiàn)機(jī)構(gòu)部門維護(hù)。部門信息維護(hù)Spring頁碼配置Spring頁碼配置action-servlet.xml主要代碼實(shí)現(xiàn)為。smDepartmentController控制層代碼實(shí)現(xiàn)部門信息維護(hù)界面的控制層代碼為SmDepartmentP

16、ublicController.java，其主要實(shí)現(xiàn)代碼為。public ModelAndView handleRequest(HttpServletRequest request,HttpServletResponse response) throws Exception if (log.isDebugEnabled() log.debug(entering handleRequest method.);/ String selectId = FormUtil.getString(request, selectId, );/ request.setAttribute(selectId, se

17、lectId);/ String selectName = FormUtil.getString(request, selectName, );/ request.setAttribute(selectName, selectName);String idStr = FormUtil.getString(request, idStr, );String nameStr = FormUtil.getString(request, nameStr, );/ 存放機(jī)構(gòu)IDrequest.setAttribute(param_selectId, idStr);/ 存放機(jī)構(gòu)名稱request.setAt

18、tribute(param_selectName, nameStr);SmDepartment smDepartment = new SmDepartment();String departmentId = FormUtil.getString(request, querydepartmentId,);String departmentName = FormUtil.getString(request,querydepartmentName, );String organId = FormUtil.getString(request, queryorganId, );String depart

19、mentType = FormUtil.getString(request,querydepartmentType, );String preDepartmentId = FormUtil.getString(request,querypreDepartmentId, );smDepartment.setDepartmentId(departmentId);smDepartment.setDepartmentName(departmentName);smDepartment.setOrganId(organId);smDepartment.setDepartmentType(departmen

20、tType);smDepartment.setPreDepartmentId(preDepartmentId);/ populate object with request parametersBeanUtils.populate(smDepartment, request.getParameterMap();List smDepartments = smDepartmentManager.getSmDepartments(smDepartment);return new ModelAndView(sm/smDepartmentList,Constants.SMDEPARTMENT_LIST,

21、 smDepartments);DAO層代碼實(shí)現(xiàn)數(shù)據(jù)訪問層頁面SmDepartmentDaoHibernate.java代碼實(shí)現(xiàn)如下。public List getSmDepartments(final SmDepartment smDepartment) String querySQL = from SmDepartment where 1=1 ;/ return getHibernateTemplate().find(from SmOrgan where 1=1 );if (smDepartment != null) / 部門編碼if (!smDepartment.getDepartmen

22、tId().trim().equals() querySQL += and departmentId = + smDepartment.getDepartmentId().trim() + ;/ 部門名稱if (!smDepartment.getDepartmentName().trim().equals() querySQL += and departmentName = + smDepartment.getDepartmentName().trim() + ;/ 機(jī)構(gòu)編碼if (!smDepartment.getOrganId().trim().equals() querySQL += a

23、nd organId = + smDepartment.getOrganId().trim() + ;/ 部門類型if (!smDepartment.getDepartmentType().trim().equals() querySQL += and departmentType = + smDepartment.getDepartmentType().trim() + ;/ 上級部門編碼if (!smDepartment.getPreDepartmentId().trim().equals() querySQL += and preDepartmentId = + smDepartment.getPreDepartm