package dao;
import java.sql.Date;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import domain.ChuChai;
import domain.Department;
import domain.QingJia;
import domain.QianDao;
import domain.User;
import domain.GongGao;
import domain.KaoQin;
import util.C3P0Util;
import util.DateUtil;
public class UserDao {
// 登陆
public User login(String uname, String upwd) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("select * from user where uname = ? && upwd = ?", new BeanHandler<User>(User.class), uname,
upwd);
}
// 查
public List<User> userAdvancedsearch(String uid, String uname, String udepartname) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
String sql = "select * from user where 1 = 1";
List list = new ArrayList();
if(!"".equals(uid)){
sql+=" and uid = ?"; // 不能在这写% %'1002'%
list.add(uid);// '%1002%'
}
if(!"".equals(uname)){
sql+=" and uname=?";
list.add(uname);
}
if(!"".equals(udepartname)){
sql+=" and udepartname = ?";
list.add(udepartname);
}
System.out.println(sql + " " +list.toArray());
return qr.query(sql, new BeanListHandler<User>(User.class),list.toArray());
}
//get all user
public List<User> getAllUser() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM user ", new BeanListHandler<User>(User.class));
}
// 改
public void updatauser(User user) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
qr.update(
"update user set uname=?,usex=?,udepartid=?,udepartname=?,utel=?,uaddr=?,umail=?,uboss=?,uentrytime=?,ubirth=? ,uwork = ? where uid=?",
user.getUname(), user.getUsex(), user.getUdepartid(), user.getUdepartname(),
user.getUtel(), user.getUaddr(), user.getUmail(), user.getUboss(), user.getUentrytime(),
user.getUbirth(), user.getUwork(),user.getUid());
}
// 签到 state 似乎没意义了
public void qiandao(String uid, String addr) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
String description = "正常";
java.sql.Timestamp date = DateUtil.getDateTime();
int hour = date.getHours();
// if((hour<=10&&hour>0)){
qr.update("insert into qiandao(uid,starttime,addr,state,description) values(?,?,?,?,?)",uid , DateUtil.getDateTime(), addr,
1,description);
// }
// else if((hour<=15&&hour>12)){
qr.update("UPDATE qiandao SET starttime1 = NOW(),state=2 WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",uid);
// }
// else if((hour>19&&hour<=0)){
description = "加班";
qr.update("UPDATE qiandao SET starttime2 = ?,description= '加班' WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",DateUtil.getDateTime(),uid);
// }
// else{
qr.update("UPDATE qiandao SET description= '迟到' WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",uid);
// }
}
// 签退
public void qiantui(String uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
java.sql.Timestamp date = DateUtil.getDateTime();
int hour = date.getHours();
// if((hour<=10&&hour>0)){
qr.update("UPDATE qiandao SET endtime =NOW() WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",uid);
// }
// else if((hour<=15&&hour>12)){
qr.update("UPDATE qiandao SET endtime1 = NOW() WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",uid);
// }
// else if((hour>19&&hour<=0)){
qr.update("UPDATE qiandao SET endtime2 =NOW() WHERE uid = ? AND TO_DAYS(starttime)= TO_DAYS(NOW());",uid);
// }
}
public QianDao getQiandao(String uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qiandao WHERE uid = ? and TO_DAYS(starttime)= TO_DAYS(NOW());",
new BeanHandler<QianDao>(QianDao.class), uid);
}
public List<QianDao> getSigns(int uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qiandao WHERE uid = ?", new BeanListHandler<QianDao>(QianDao.class), uid);
}
public void qingjia(QingJia dayoff) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
qr.update("insert into qingjia(uid,starttime,endtime,reason,uname,udepartname) values(?,?,?,?,?,?)", dayoff.getUid(),
dayoff.getStarttime(), dayoff.getEndtime(), dayoff.getReason(),dayoff.getUname(),dayoff.getUdepartname());
}
public List<QingJia> getDayOff(int uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qingjia WHERE uid = ?", new BeanListHandler<QingJia>(QingJia.class), uid);
}
public List<QingJia> getAllDayOff() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qingjia ", new BeanListHandler<QingJia>(QingJia.class));
}
public List<QingJia> getAllNotAgreeDayOff() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qingjia where state = 0", new BeanListHandler<QingJia>(QingJia.class));
}
public Department getDepartment(String udepartid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM department WHERE udepartid = ? ", new BeanHandler<Department>(Department.class),
udepartid);
}
public Department departSearch(String udepartname) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM department WHERE udepartname= ? ", new BeanHandler<Department>(Department.class),
udepartname);
}
public List<GongGao> getAllGongGao() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM gonggao ", new BeanListHandler<GongGao>(GongGao.class));
}
public void creatChuChai(ChuChai cc) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
qr.update("insert into chuchai(uid,addr,starttime,endtime,reason,uname,udepartname) values(?,?,?,?,?,?,?)", cc.getUid(), cc.getAddr(),
cc.getStarttime(), cc.getEndtime(), cc.getReason(),cc.getUname(),cc.getUdepartname());
}
public List<ChuChai> getChuChai(int uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM chuchai WHERE uid = ?", new BeanListHandler<ChuChai>(ChuChai.class), uid);
}
public List<ChuChai> getAllChuChai() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM chuchai", new BeanListHandler<ChuChai>(ChuChai.class));
}
public void creatGongGao(GongGao gg) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
qr.update("insert into gonggao(name,time,text) values(?,?,?)", gg.getName(), gg.getTime(), gg.getText());
}
public int deleteGongGao(String name) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.update("delete FROM gonggao WHERE name = ?", name);
}
public List<QianDao> getQianDao(int uid) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qiandao WHERE uid = ? and description = ?", new BeanListHandler<QianDao>(QianDao.class), uid,"加班");
}
public List<QianDao> getAllQianDao() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
return qr.query("SELECT * FROM qiandao where description = '加班'", new BeanListHandler<QianDao>(QianDao.class));
}
public void agreeDayOff(String uid, String starttime) throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getDs());
qr.update("UPDATE qingjia SET agreetime = NOW() , state = 1 where uid = ? and starttime = ?",uid,starttime);
}
public List<Department> getAllDepart() throws
没有合适的资源?快使用搜索试试~ 我知道了~
基于jsp+Servlet+jstl写的考勤系统.zip
共197个文件
java:55个
jsp:52个
png:42个
需积分: 5 0 下载量 177 浏览量
2023-07-30
23:35:29
上传
评论
收藏 636KB ZIP 举报
温馨提示
基于java、jsp、servlet、mysql、springboot等技术构建的系统,适合毕设项目、课设作业。资源中的源码都是经过本地编译过可运行的,下载后按照文档配置好环境就可以运行。资源项目的难度比较适中,内容都是经过助教老师审定过的,应该能够满足学习、使用需求,如果有需要的话可以放心下载使用。
资源推荐
资源详情
资源评论
收起资源包目录
基于jsp+Servlet+jstl写的考勤系统.zip (197个子文件)
.classpath 824B
org.eclipse.wst.common.component 480B
org.eclipse.wst.jsdt.ui.superType.container 49B
main.css 4KB
main.css 4KB
style1.css 1KB
style1.css 1KB
main1.css 844B
main1.css 844B
left.css 216B
left.css 216B
bg.gif 63B
bg.gif 63B
1.gif 54B
1.gif 54B
2-2.gif 52B
2-2.gif 52B
.gitattributes 378B
.gitignore 878B
NewFile.html 5KB
welcome.html 4KB
UserDao.java 12KB
ExcelUtil.java 5KB
User.java 5KB
UserService.java 4KB
GetChuQin.java 3KB
EncodingFilter.java 3KB
NewServlet.java 3KB
UserLogin.java 3KB
QianDao.java 2KB
AdvancedSearch.java 2KB
UpdateServlet.java 2KB
QingJia.java 2KB
UserAdvancedSearch.java 1KB
UserSearch.java 1KB
GetAllGongGao.java 1KB
SignIn.java 1KB
UpdateDepartServlet.java 1KB
DeleteUser.java 1KB
CreatKaoQinRule.java 1KB
CreatGongGao.java 1KB
CreatDayOff.java 1KB
GetDayOffServlet.java 1KB
AddUser.java 1KB
UpdatePwd.java 1KB
CreatChuChai.java 1KB
DafOffJudge.java 1KB
ChuQin.java 1KB
GetSignServlet.java 1KB
GetAllDayOffServlet.java 1KB
CreateDepartServlet.java 1KB
DepartSearch.java 1KB
GetChuChaiServlet.java 1KB
GetJiaBanServlet.java 1KB
ChuChai.java 1KB
GetAllJiaBanServlet.java 1KB
GetAllDepartServlet.java 1KB
GetAllChuChaiServlet.java 1KB
GetAllUser.java 1KB
C3P0Util.java 1009B
ChangeRole.java 1001B
AgreeDayOff.java 1000B
GetKaoQinServlet.java 941B
GetGongGao.java 934B
XiaoJia.java 894B
ChuQinSearch.java 892B
Department.java 890B
DeleteDepart.java 868B
DeleteGongGao.java 841B
UserException.java 714B
DateUtil.java 545B
ListUtil.java 524B
GongGao.java 413B
KaoQin.java 412B
Test.java 359B
JiaBan.java 42B
bg1.jpg 188KB
bg1.jpg 188KB
top_100.jpg 48KB
top_100.jpg 48KB
top_01.jpg 23KB
top_01.jpg 23KB
mis_01.jpg 404B
mis_01.jpg 404B
bt_02.jpg 394B
bt_02.jpg 394B
mis_05c.jpg 356B
mis_05c.jpg 356B
mis_05a.jpg 352B
mis_05a.jpg 352B
mis_05b.jpg 328B
mis_05b.jpg 328B
jquery.min.js 91KB
.jsdtscope 555B
left.jsp 5KB
left.jsp 5KB
xinxixiugai.jsp 4KB
xinxixiugai.jsp 3KB
top.jsp 3KB
top.jsp 3KB
共 197 条
- 1
- 2
资源评论
独处东汉
- 粉丝: 342
- 资源: 821
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功