基于java学生考勤管理系统(7)

附 录

附录1

程序源代码

//========================登录============================//

/**

* 是否登录成功,并返回用户类型 *

* @param uid * 用户名 * @param password * 密码 * @return

* @throws Exception */

public User isLoginSuccess(String uid,String password) throws Exception{

User user = null;

if(uid==null||password==null){

; }else{

DBUnit dbUnit = new

ArrayList list = new ArrayList(); list.add(uid); list.add(password);

ResultSet res = dbUnit.queryAutoClose(\

if(res.next()){

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

ACCOUNT = ? and password = ?\

user = new User();

int type = res.getInt(\String name = res.getString(%user.setUid(uid); user.setType(type); user.setUsername(name);

27

} }

}

return user;

//=======================人员信息列表=========================//

public List getStudent(){

List list = null ;

String sql = \

\

\

\and class.zyid = STUDENT.professional and class.id =

dbUnit

=

new

student.sclass\

DBUnit try {

ResultSet rs = dbUnit.queryAutoClose(sql); if(rs!=null){

list = new ArrayList(); while(rs.next()){

String sno = rs.getString(\String sname = rs.getString(\String sex = rs.getString(\String jg = rs.getString(\int zyid = rs.getInt(\String zy = rs.getString(10); String tel = rs.getString(\String email = rs.getString(\String note = rs.getString(\String sclass = rs.getString(\Student student = new Student(); student.setBirthplace(jg); student.setEmail(email); student.setNote(note); student.setSclass(sclass);

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

28

student.setSex(sex); student.setTel(tel); student.setSname(sname); student.setSno(sno);

Specialty s = new Specialty(); s.setId(zyid); s.setName(zy);

student.setProfessional(s); list.add(student);

}

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{ return list ; }

}

//========================增加用户========================//

public boolean addStudentDao(Student student) throws Exception{ String sql = \ boolean suc = false; DBUnit dbUnit

=

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

ArrayList list = new ArrayList(); list.add(student.getSno()); list.add(student.getSname()); list.add(student.getSclass()); list.add(student.getSex()); list.add(student.getBirthplace()); list.add(student.getTel());

list.add(student.getProfessional().getId()); list.add(student.getEmail());

list.add(student.getNote());

29

new

}

if(dbUnit.updateAutoClose(sql,list)){

suc=true;

sql = \INTO LOGINUSER(ACCOUNT,PASSWORD,NAME,TYPE) ArrayList list1 = new ArrayList(); list1.add(student.getSno()); list1.add(student.getSno()); list1.add(student.getSname()); list1.add(5);

dbUnit.updateAutoClose(sql,list1);

VALUES(?,?,?,?)\

}

return suc;

//=======================用户修改========================// public boolean updateStudentDao(Student student) throws Exception{

ArrayList list = new ArrayList(); list.add(student.getSname()); list.add(student.getSclass()); list.add(student.getSex()); list.add(student.getBirthplace()); list.add(student.getTel());

list.add(student.getProfessional().getId()); list.add(student.getEmail()); list.add(student.getNote());

System.out.println(\list.add(student.getSno());

if(dbUnit.updateAutoClose(sql,list))

String sql = \student set sname= ?, sclass = ?, sex = ?, birthplace boolean suc = false; DBUnit dbUnit = new

= ?, tel = ?, professional = ?, email = ?, note = ? where sno = ?\

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

30

}

suc=true;

return suc;

//========================用户删除========================//

//========================请假列表========================//

public List getQjxxByTeacher(String tno){

List qjxxList = null ; ArrayList list = new ArrayList(); boolean result = false ; list.add(tno); String

sql

=

\

public boolean deleteStudentDao(String sno) throws Exception{ }

String sql = \boolean suc = false; DBUnit

dbUnit

=

new

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

ArrayList list = new ArrayList(); list.add(sno);

if(dbUnit.updateAutoClose(sql,list)){

suc=true;

}

System.out.println(suc+\return suc;

b.id,A.SNO,A.SNAME,B.BEGINDATE,B.BEGINJC,B.ENDDATE,B.ENDJC,B.REASON,B.STATUES,B.APPTIME\

\

\\

DBUnit

ResultSet res;

dbUnit

=

new

DBUnit(SQL_CLASSNAME,SQL_URL,SQL_USERNAME,SQL_PASSWORD);

31

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库基于java学生考勤管理系统(7)在线全文阅读。