【正文】 Student()。while(()){String sno = (SNO) 。String sname = (SNAME)。String sex = (SEX)。String jg = (birthplace)。int zyid = (professional)。String zy = (10)。String tel = (TEL)。String = (EMAIL)。String note = (NOTE)。String sclass = (classname)。Student student = new Student()。(jg)。()。(note)。30 / 41(sclass)。(sex)。(tel)。(sname)。(sno)。Specialty s = new Specialty()。(zyid)。(zy)。(s)。(student)。}}} catch (Exception e) {// TODO Autogenerated catch block()。}finally{return list 。}}//========================增加用戶========================//public boolean addStudentDao(Student student) throws Exception{String sql = insert into student values(?,?,?,?,?,?,?,?,?) 。boolean suc = false。 DBUnit dbUnit = new DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD)。ArrayList list = new ArrayList()。(())。(())。(())。(())。(())。(())。(().getId())。(())。31 / 41(())。if((sql,list)){suc=true。sql = INSERT INTO LOGINUSER(ACCOUNT,PASSWORD,NAME,TYPE) VALUES(?,?,?,?) 。ArrayList list1 = new ArrayList()。(())。(())。(())。(5)。(sql,list1)。}return suc。}//=======================用戶修改========================//public boolean updateStudentDao(Student student) throws Exception{String sql = update student set sname= ?, sclass = ?, sex = ?, birthplace = ?, tel = ?, professional = ?, = ?, note = ? where sno = ? 。boolean suc = false。 DBUnit dbUnit = new DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD)。ArrayList list = new ArrayList()。(())。(())。(())。(())。(())。(().getId())。(())。(())。(+())。(())。32 / 41if((sql,list))suc=true。return suc。}//========================用戶刪除========================//public boolean deleteStudentDao(String sno) throws Exception{String sql = delete from student where sno = ? 。boolean suc = false。 DBUnit dbUnit = new DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD)。ArrayList list = new ArrayList()。(sno)。if((sql,list)){suc=true。}(suc+222)。return suc。}//========================請(qǐng)假列表========================//public ListQjxxBean getQjxxByTeacher(String tno){ListQjxxBean qjxxList = null 。ArrayList list = new ArrayList()。boolean result = false 。(tno)。String sql = SELECT ,,,B.APPTIME+ FROM STUDENT A,QJMX B,TEACHER C+ WHERE = AND = + AND = AND = ?。DBUnit dbUnit = new DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD)。33 / 41ResultSet res。try {res = (sql,list)。if(res!=nullamp。amp。()){qjxxList = new ArrayListQjxxBean()。()。while(()){QjxxBean qjxx = new QjxxBean()。String id = (id)。String sno = (sno)。String sname = (sname)。String kssj = (BEGINDATE)。String ksjc = (BEGINJC)。String jssj = (ENDDATE)。String jsjc = (ENDJC)。String content = (REASON)。int zt = (STATUES)。String sqsj = (APPTIME)。Student student = new Student()。(sno)。(sname)。(id)。(kssj)。(ksjc)。(jssj)。(jsjc)。(content)。(zt)。(sqsj)。(student)。(qjxx)。34 / 41}}} catch (Exception e) {// TODO Autogenerated catch block()。}finally{return qjxxList 。}}//========================請(qǐng)假申請(qǐng)========================//public boolean qjAppl(String beginDate,String beginJC,String endDate,String endJC,String content,String sno) {boolean res = false。String sql = insert into qjmx(sno,begindate,beginjc,enddate,endjc,reason,statues,apptime) VALUES (?,?,?,?,?,?,0,?)。DBUnit dbUnit = new DBUnit(SQL_CLASSNAME, SQL_URL, SQL_USERNAME,SQL_PASSWORD)。try {ArrayListObject al = new ArrayListObject()。(sno)。(beginDate)。(beginJC)。(endDate)。(endJC)。(content)。(new Date())。(sql, al)。 // res = true。} catch (Exception e) {()。35 / 41} finally {return res。}}//========================請(qǐng)假審批========================//public void updateQjxxsp(int status,String note,String qjid,String tname){String sql = UPDATE qjmx SET statues = ? ,note = ? ,sptime = ?,spz = ? WHERE id = ?。DBUnit dbUnit = new DBUnit(SQL_CLASSNAME, SQL_URL, SQL_USERNAME,SQL_PASSWORD)。ArrayListObject list = new ArrayListObject()。(status)。(note)。(new Date())。(tname)。(qjid)。try {(sql, list)。 } catch (Exception e) {()。}}//========================考勤========================//public boolean addKqxx(String sj,String jc,String zy,String bj,String kc,MapString,String khxx) throws Exception{boolean iskq = isKCKq(sj,jc,zy,bj)。if(iskq==false){DBUnit dbUnit = new DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD)。boolean result = true。 Set set =()。 36 / 41 Iterator it=()。 ArrayList list = new ArrayList()。 ArrayList list1 = new ArrayList()。 (sj)。 (jc)。 (zy)。 (bj)。 while(()){ ArrayList sub = new ArrayList()。 String, String entry= (EntryString, String) ()。 String sno = () 。 String sta = ()。 (sno)。 (kc)。 (sj)。 (jc)。 (sta)。 (sub)。 } Connection conn = ()。 try { result = (conn, insert into attendance(sno,o,shijian,jieci,statues) values(?,?,?,?,?), list)。 result = (insert into CA_STATUS(shijian,jieci,zy,bj) values(?,?,?,?), list1)。} catch (Exception e) {(插入考勤情況失敗)。()。}return result。}else {return false。37 / 41}