try {
res = dbUnit.queryAutoClose(sql,list); if(res!=null&&res.next()){
qjxxList = new ArrayList
QjxxBean qjxx = new QjxxBean(); String id = res.getString(\String sno = res.getString(\String sname = res.getString(\String kssj = res.getString(\String ksjc = res.getString(\String jssj = res.getString(\String jsjc = res.getString(\String content = res.getString(\int zt = res.getInt(\String sqsj = res.getString(\
Student student = new Student(); student.setSno(sno); student.setSname(sname); qjxx.setId(id);
qjxx.setBeginDate(kssj); qjxx.setBeginJC(ksjc); qjxx.setEndDate(jssj); qjxx.setEndJC(jsjc); qjxx.setContent(content); qjxx.setStatus(zt); qjxx.setSqsj(sqsj); qjxx.setStudent(student); qjxxList.add(qjxx); }
32
}
}
}
} catch (Exception e) {
// TODO Auto-generated catch block e.printStackTrace(); return qjxxList ;
}finally{
//========================请假申请========================//
public boolean qjAppl(String beginDate,String beginJC,String endDate,String
boolean res = false; String
sql
=
\
into VALUES
endJC,String content,String sno) {
qjmx(sno,begindate,beginjc,enddate,endjc,reason,statues,apptime) (?,?,?,?,?,?,0,?)\
DBUnit dbUnit = new DBUnit(SQL_CLASSNAME, SQL_URL, SQL_USERNAME,
ArrayList
dbUnit.updateAutoClose(sql, al); // res = true;
e.printStackTrace();
SQL_PASSWORD);
try {
} catch (Exception e) {
33
}
} finally { }
return res;
//========================请假审批========================//
public void updateQjxxsp(int status,String note,String qjid,String }
String sql = \DBUnit dbUnit = new DBUnit(SQL_CLASSNAME, SQL_URL, SQL_USERNAME,
SQL_PASSWORD);
ArrayList
dbUnit.updateAutoClose(sql, list); e.printStackTrace(); } catch (Exception e) {
tname){
= ? WHERE id = ?\
//========================考勤========================//
public boolean addKqxx(String sj,String jc,String zy,String bj,String
boolean iskq = isKCKq(sj,jc,zy,bj); if(iskq==false){ DBUnit
boolean result = true;
dbUnit
=
new
kc,Map
DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);
Set set =khxx.entrySet(); Iterator it=set.iterator();
34
ArrayList list = new ArrayList(); ArrayList list1 = new ArrayList();
list1.add(sj); list1.add(jc); list1.add(zy); list1.add(bj);
while(it.hasNext()){
ArrayList sub = new ArrayList();
Map.Entry
Connection conn = dbUnit.getConnetion(); try { result result
=
dbUnit.batchUpdateAutoClose(conn, =
\
into into
attendance(sno,cno,shijian,jieci,statues) values(?,?,?,?,?)\
dbUnit.updateAutoClose(\
CA_STATUS(shijian,jieci,zy,bj) values(?,?,?,?)\
} catch (Exception e) { }
return result; }else { } }
return false;
System.err.println(\插入考勤情况失败\e.printStackTrace();
35