基于javaweb+mysql的ssm学生请假考勤管理系统(java+ssm+mysql+jsp)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的SSM学生请假考勤管理系统(java+ssm+mysql+jsp)
管理员：
super-admin 123456
admin 123456
学生：
001 123456
002 123456
任课老师：
001 123456
002 123456
班主任：
001 123456
002 123456
辅导员：
001 123456
002 123456
学生请假为分课堂请假和其它请假
课堂请假由任课老师审核
其它请假由班主任审核
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshigonghao==null||jiaoshigonghao.equals("")){pmap.put("jiaoshigonghao", null);}else{pmap.put("jiaoshigonghao", jiaoshigonghao);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
if(beizhu==null||beizhu.equals("")){pmap.put("beizhu", null);}else{pmap.put("beizhu", beizhu);}
int total=xueshengxuankeService.getCount(pmap);
pageBean.setTotal(total);
List<Xueshengxuanke> list=xueshengxuankeService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "xueshengxuanke_yanben5";
}
@RequestMapping("xueshengxuankeList2.do")
public String xueshengxuankeList2(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Xueshengxuanke xueshengxuanke, String kechengbianhao, String kechengmingcheng, String jiaoshigonghao, String jiaoshixingming, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String beizhu,HttpServletRequest request){
/*if(session.getAttribute("user")==null){
return "login";
}*/
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
pmap.put("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
@RequestMapping("kqtbList.do")
public String kqtbList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Kaoqintongbao kaoqintongbao, String biaoti, String neirong, String xiangguanfujian, String faburen){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(biaoti==null||biaoti.equals("")){pmap.put("biaoti", null);}else{pmap.put("biaoti", biaoti);}
if(neirong==null||neirong.equals("")){pmap.put("neirong", null);}else{pmap.put("neirong", neirong);}
if(xiangguanfujian==null||xiangguanfujian.equals("")){pmap.put("xiangguanfujian", null);}else{pmap.put("xiangguanfujian", xiangguanfujian);}
if(faburen==null||faburen.equals("")){pmap.put("faburen", null);}else{pmap.put("faburen", faburen);}
int total=kaoqintongbaoService.getCount(pmap);
pageBean.setTotal(total);
List<Kaoqintongbao> list=kaoqintongbaoService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "kaoqintongbaolist";
}
@RequestMapping("kqtbListtp.do")
public String kqtbListtp(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Kaoqintongbao kaoqintongbao, String biaoti, String neirong, String xiangguanfujian, String faburen){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(biaoti==null||biaoti.equals("")){pmap.put("biaoti", null);}else{pmap.put("biaoti", biaoti);}
if(neirong==null||neirong.equals("")){pmap.put("neirong", null);}else{pmap.put("neirong", neirong);}
if(xiangguanfujian==null||xiangguanfujian.equals("")){pmap.put("xiangguanfujian", null);}else{pmap.put("xiangguanfujian", xiangguanfujian);}
if(faburen==null||faburen.equals("")){pmap.put("faburen", null);}else{pmap.put("faburen", faburen);}
int total=kaoqintongbaoService.getCount(pmap);
pageBean.setTotal(total);
List<Kaoqintongbao> list=kaoqintongbaoService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "kaoqintongbaolisttp";
}
@RequestMapping("deleteKaoqintongbao.do")
pmap.put("banjihao", null);
} else {
pmap.put("banjihao", banjihao);
}
if (fudaoyuangonghao == null || fudaoyuangonghao.equals("")) {
pmap.put("fudaoyuangonghao", null);
} else {
pmap.put("fudaoyuangonghao", fudaoyuangonghao);
}
if (kaoqinzhuangtai == null || kaoqinzhuangtai.equals("")) {
pmap.put("kaoqinzhuangtai", null);
} else {
pmap.put("kaoqinzhuangtai", kaoqinzhuangtai);
}
if (beizhu == null || beizhu.equals("")) {
pmap.put("beizhu", null);
} else {
pmap.put("beizhu", beizhu);
}
int total = ketangkaoqinService.getCount(pmap);
pageBean.setTotal(total);
List<Ketangkaoqin> list = ketangkaoqinService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "ketangkaoqin_yanben4";
}
@RequestMapping("ketangkaoqin_yanben5.do")
public String ketangkaoqin_yanben5(@RequestParam(value = "page", required = false) String page,
ModelMap map, HttpSession session, Ketangkaoqin ketangkaoqin, String kechengbianhao, String kechengmingcheng, String jiaoshigonghao, String jiaoshixingming, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String kaoqinzhuangtai, String beizhu) {
if (page == null || page.equals("")) {
page = "1";
}
PageBean pageBean = new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap = new HashMap<String, Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if (kechengbianhao == null || kechengbianhao.equals("")) {
pmap.put("kechengbianhao", null);
} else {
pmap.put("kechengbianhao", kechengbianhao);
if(youxiang==null||youxiang.equals("")){pmap.put("youxiang", null);}else{pmap.put("youxiang", youxiang);}
if(shouji==null||shouji.equals("")){pmap.put("shouji", null);}else{pmap.put("shouji", shouji);}
if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);}
if(touxiang==null||touxiang.equals("")){pmap.put("touxiang", null);}else{pmap.put("touxiang", touxiang);}
if(dizhi==null||dizhi.equals("")){pmap.put("dizhi", null);}else{pmap.put("dizhi", dizhi);}
if(beizhu==null||beizhu.equals("")){pmap.put("beizhu", null);}else{pmap.put("beizhu", beizhu);}
int total=yonghuzhuceService.getCount(pmap);
pageBean.setTotal(total);
List<Yonghuzhuce> list=yonghuzhuceService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "yonghuzhucelist";
}
@RequestMapping("deleteYonghuzhuce.do")
public String deleteYonghuzhuce(int id,HttpServletRequest request){
yonghuzhuceService.delete(id);
String url = request.getHeader("Referer");
return "redirect:"+url;
//return "redirect:yonghuzhuceList.do";
}
@RequestMapping("quchongYonghuzhuce.do")
public void quchongYonghuzhuce(Yonghuzhuce yonghuzhuce,HttpServletResponse response){
Map<String,Object> map=new HashMap<String,Object>();
map.put("yonghuming", yonghuzhuce.getYonghuming());
System.out.println("yonghuming==="+yonghuzhuce.getYonghuming());
System.out.println("yonghuming222==="+yonghuzhuceService.quchongYonghuzhuce(map));
JSONObject obj=new JSONObject();
if(yonghuzhuceService.quchongYonghuzhuce(map)!=null){
obj.put("info", "ng");
}else{
obj.put("info", "用户名可以用！");
}
response.setContentType("text/html;charset=utf-8");
PrintWriter out=null;
try {
out=response.getWriter();
out.print(obj);
out.flush();
} catch (IOException e) {
e.printStackTrace();
}finally{
out.close();
}
}
}
public static String getDateStr(){
String dateString="";
try{//yyyyMMddHHmmss
java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date currentTime_1=new java.util.Date();
dateString=formatter.format(currentTime_1);
}catch(Exception e){
}
return dateString;
}
public static String getUTFStr(String str) {
if(str==null){
return "";
}
try {
str = new String(str.getBytes("ISO-8859-1"),"utf-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return str;
}
public static String getGBKStr(String str) throws UnsupportedEncodingException{
if(str==null){
return "";
}
return new String(str.getBytes("ISO-8859-1"),"GBK");
}
public static String getGB2312Str(String str) throws UnsupportedEncodingException{
if(str==null){
return "";
}
return new String(str.getBytes("ISO-8859-1"),"gb2312");
}
} catch (IOException e) {
e.printStackTrace();
}finally{
out.close();
}
}
}
@Controller
public class BanzhurenController {
@Resource
private BanzhurenServer banzhurenService;
@RequestMapping("addBanzhuren.do")
public String addBanzhuren(HttpServletRequest request,Banzhuren banzhuren,HttpSession session) throws SQLException{
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
if(qingjiatianshu1==null||qingjiatianshu1.equals("")){pmap.put("qingjiatianshu1", null);}else{pmap.put("qingjiatianshu1", qingjiatianshu1);}
if(qingjiatianshu2==null||qingjiatianshu2.equals("")){pmap.put("qingjiatianshu2", null);}else{pmap.put("qingjiatianshu2", qingjiatianshu2);}
if(qingjiayuanyin==null||qingjiayuanyin.equals("")){pmap.put("qingjiayuanyin", null);}else{pmap.put("qingjiayuanyin", qingjiayuanyin);}
if(kaishiriqi1==null||kaishiriqi1.equals("")){pmap.put("kaishiriqi1", null);}else{pmap.put("kaishiriqi1", kaishiriqi1);}
if(kaishiriqi2==null||kaishiriqi2.equals("")){pmap.put("kaishiriqi2", null);}else{pmap.put("kaishiriqi2", kaishiriqi2);}
if(jieshuriqi1==null||jieshuriqi1.equals("")){pmap.put("jieshuriqi1", null);}else{pmap.put("jieshuriqi1", jieshuriqi1);}
if(jieshuriqi2==null||jieshuriqi2.equals("")){pmap.put("jieshuriqi2", null);}else{pmap.put("jieshuriqi2", jieshuriqi2);}
if(xiangguanpingzheng==null||xiangguanpingzheng.equals("")){pmap.put("xiangguanpingzheng", null);}else{pmap.put("xiangguanpingzheng", xiangguanpingzheng);}
if(banzhurenshenhe==null||banzhurenshenhe.equals("")){pmap.put("banzhurenshenhe", null);}else{pmap.put("banzhurenshenhe", banzhurenshenhe);}
if(shenhehuifu==null||shenhehuifu.equals("")){pmap.put("shenhehuifu", null);}else{pmap.put("shenhehuifu", shenhehuifu);}
int total=qitaqingjiaService.getCount(pmap);
pageBean.setTotal(total);
List<Qitaqingjia> list=qitaqingjiaService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "qitaqingjia_list";
}
@RequestMapping("qitaqingjia_yanben1.do")
public String qitaqingjia_yanben1(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Qitaqingjia qitaqingjia, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String qingjiatianshu1,String qingjiatianshu2, String qingjiayuanyin, String kaishiriqi1,String kaishiriqi2, String jieshuriqi1,String jieshuriqi2, String xiangguanpingzheng, String banzhurenshenhe, String shenhehuifu){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 8);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 8);
if(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
if(qingjiatianshu1==null||qingjiatianshu1.equals("")){pmap.put("qingjiatianshu1", null);}else{pmap.put("qingjiatianshu1", qingjiatianshu1);}
if(qingjiatianshu2==null||qingjiatianshu2.equals("")){pmap.put("qingjiatianshu2", null);}else{pmap.put("qingjiatianshu2", qingjiatianshu2);}
if(qingjiayuanyin==null||qingjiayuanyin.equals("")){pmap.put("qingjiayuanyin", null);}else{pmap.put("qingjiayuanyin", qingjiayuanyin);}
if(kaishiriqi1==null||kaishiriqi1.equals("")){pmap.put("kaishiriqi1", null);}else{pmap.put("kaishiriqi1", kaishiriqi1);}
if(kaishiriqi2==null||kaishiriqi2.equals("")){pmap.put("kaishiriqi2", null);}else{pmap.put("kaishiriqi2", kaishiriqi2);}
if(jieshuriqi1==null||jieshuriqi1.equals("")){pmap.put("jieshuriqi1", null);}else{pmap.put("jieshuriqi1", jieshuriqi1);}
}
if (kaoqinzhuangtai == null || kaoqinzhuangtai.equals("")) {
pmap.put("kaoqinzhuangtai", null);
} else {
pmap.put("kaoqinzhuangtai", kaoqinzhuangtai);
}
if (beizhu == null || beizhu.equals("")) {
pmap.put("beizhu", null);
} else {
pmap.put("beizhu", beizhu);
}
int total = ketangkaoqinService.getCount(pmap);
pageBean.setTotal(total);
List<Ketangkaoqin> list = ketangkaoqinService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "ketangkaoqin_yanben5";
}
@RequestMapping("ketangkaoqinList2.do")
public String ketangkaoqinList2(@RequestParam(value = "page", required = false) String page,
ModelMap map, HttpSession session, Ketangkaoqin ketangkaoqin, String kechengbianhao, String kechengmingcheng, String jiaoshigonghao, String jiaoshixingming, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String kaoqinzhuangtai, String beizhu, HttpServletRequest request) {
/*if(session.getAttribute("user")==null){
return "login";
}*/
if (page == null || page.equals("")) {
page = "1";
}
PageBean pageBean = new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap = new HashMap<String, Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
pmap.put("jiaoshigonghao", (String) request.getSession().getAttribute("username"));
if (kechengbianhao == null || kechengbianhao.equals("")) {
pmap.put("kechengbianhao", null);
} else {
pmap.put("kechengbianhao", kechengbianhao);
}
if (kechengmingcheng == null || kechengmingcheng.equals("")) {
pmap.put("kechengmingcheng", null);
} else {
pmap.put("kechengmingcheng", kechengmingcheng);
}
if (jiaoshixingming == null || jiaoshixingming.equals("")) {
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(xueshi==null||xueshi.equals("")){pmap.put("xueshi", null);}else{pmap.put("xueshi", xueshi);}
if(xuefen==null||xuefen.equals("")){pmap.put("xuefen", null);}else{pmap.put("xuefen", xuefen);}
if(beizhu==null||beizhu.equals("")){pmap.put("beizhu", null);}else{pmap.put("beizhu", beizhu);}
int total=kechengxinxiService.getCount(pmap);
pageBean.setTotal(total);
List<Kechengxinxi> list=kechengxinxiService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "kechengxinxi_yanben2";
}
@RequestMapping("kechengxinxi_yanben3.do")
public String kechengxinxi_yanben3(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Kechengxinxi kechengxinxi, String kechengbianhao, String kechengmingcheng, String xueshi, String xuefen, String beizhu){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(xueshi==null||xueshi.equals("")){pmap.put("xueshi", null);}else{pmap.put("xueshi", xueshi);}
if(xuefen==null||xuefen.equals("")){pmap.put("xuefen", null);}else{pmap.put("xuefen", xuefen);}
if(beizhu==null||beizhu.equals("")){pmap.put("beizhu", null);}else{pmap.put("beizhu", beizhu);}
int total=kechengxinxiService.getCount(pmap);
pageBean.setTotal(total);
List<Kechengxinxi> list=kechengxinxiService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "kechengxinxi_yanben3";
}
@RequestMapping("kechengxinxi_yanben4.do")
public String kechengxinxi_yanben4(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Kechengxinxi kechengxinxi, String kechengbianhao, String kechengmingcheng, String xueshi, String xuefen, String beizhu){
pmap.put("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(qingjiayuanyin==null||qingjiayuanyin.equals("")){pmap.put("qingjiayuanyin", null);}else{pmap.put("qingjiayuanyin", qingjiayuanyin);}
if(xiangguanpingzheng==null||xiangguanpingzheng.equals("")){pmap.put("xiangguanpingzheng", null);}else{pmap.put("xiangguanpingzheng", xiangguanpingzheng);}
if(qingjiashijian1==null||qingjiashijian1.equals("")){pmap.put("qingjiashijian1", null);}else{pmap.put("qingjiashijian1", qingjiashijian1);}
if(qingjiashijian2==null||qingjiashijian2.equals("")){pmap.put("qingjiashijian2", null);}else{pmap.put("qingjiashijian2", qingjiashijian2);}
if(renkelaoshishenhe==null||renkelaoshishenhe.equals("")){pmap.put("renkelaoshishenhe", null);}else{pmap.put("renkelaoshishenhe", renkelaoshishenhe);}
if(shenhehuifu==null||shenhehuifu.equals("")){pmap.put("shenhehuifu", null);}else{pmap.put("shenhehuifu", shenhehuifu);}
int total=ketangqingjiaService.getCount(pmap);
pageBean.setTotal(total);
List<Ketangqingjia> list=ketangqingjiaService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "ketangqingjia_list2";
}
@RequestMapping("ketangqingjiaList3.do")
public String ketangqingjiaList3(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Ketangqingjia ketangqingjia, String kechengbianhao, String kechengmingcheng, String jiaoshigonghao, String jiaoshixingming, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String qingjiayuanyin, String xiangguanpingzheng, String qingjiashijian1,String qingjiashijian2, String renkelaoshishenhe, String shenhehuifu,HttpServletRequest request){
/*if(session.getAttribute("user")==null){
return "login";
}*/
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
pmap.put("xuehao", (String)request.getSession().getAttribute("username"));
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(qingjiayuanyin==null||qingjiayuanyin.equals("")){pmap.put("qingjiayuanyin", null);}else{pmap.put("qingjiayuanyin", qingjiayuanyin);}
if(xiangguanpingzheng==null||xiangguanpingzheng.equals("")){pmap.put("xiangguanpingzheng", null);}else{pmap.put("xiangguanpingzheng", xiangguanpingzheng);}
if(qingjiashijian1==null||qingjiashijian1.equals("")){pmap.put("qingjiashijian1", null);}else{pmap.put("qingjiashijian1", qingjiashijian1);}
if(qingjiashijian2==null||qingjiashijian2.equals("")){pmap.put("qingjiashijian2", null);}else{pmap.put("qingjiashijian2", qingjiashijian2);}
if(renkelaoshishenhe==null||renkelaoshishenhe.equals("")){pmap.put("renkelaoshishenhe", null);}else{pmap.put("renkelaoshishenhe", renkelaoshishenhe);}
if(shenhehuifu==null||shenhehuifu.equals("")){pmap.put("shenhehuifu", null);}else{pmap.put("shenhehuifu", shenhehuifu);}
@Controller
public class KetangdakaController {
@Resource
private KetangdakaServer ketangdakaService;
@RequestMapping("addKetangdaka.do")
public String addKetangdaka(HttpServletRequest request,Ketangdaka ketangdaka,HttpSession session) throws SQLException{
Timestamp time=new Timestamp(System.currentTimeMillis());
ketangdaka.setAddtime(time.toString().substring(0, 19));
ketangdakaService.add(ketangdaka);
session.setAttribute("backxx", "添加成功");
session.setAttribute("backurl", request.getHeader("Referer"));
//session.setAttribute("backurl", "ketangdakaList.do");
return "redirect:postback.jsp";
//return "redirect:ketangdakaList.do";
}
// 处理编辑
@RequestMapping("doUpdateKetangdaka.do")
public String doUpdateKetangdaka(int id,ModelMap map,Ketangdaka ketangdaka){
ketangdaka=ketangdakaService.getById(id);
map.put("ketangdaka", ketangdaka);
return "ketangdaka_updt";
}
// 后台详细
@RequestMapping("ketangdakaDetail.do")
public String ketangdakaDetail(int id,ModelMap map,Ketangdaka ketangdaka){
ketangdaka=ketangdakaService.getById(id);
map.put("ketangdaka", ketangdaka);
return "ketangdaka_detail";
}
// 前台详细
@RequestMapping("ktdkDetail.do")
public String ktdkDetail(int id,ModelMap map,Ketangdaka ketangdaka){
ketangdaka=ketangdakaService.getById(id);
map.put("ketangdaka", ketangdaka);
return "ketangdakadetail";
map.put("dakatixing", dakatixing);
return "dakatixing_updt";
}
// 后台详细
@RequestMapping("dakatixingDetail.do")
public String dakatixingDetail(int id,ModelMap map,Dakatixing dakatixing){
dakatixing=dakatixingService.getById(id);
map.put("dakatixing", dakatixing);
return "dakatixing_detail";
}
// 前台详细
@RequestMapping("dktxDetail.do")
public String dktxDetail(int id,ModelMap map,Dakatixing dakatixing){
dakatixing=dakatixingService.getById(id);
map.put("dakatixing", dakatixing);
return "dakatixingdetail";
}
//
@RequestMapping("updateDakatixing.do")
public String updateDakatixing(int id,ModelMap map,Dakatixing dakatixing,HttpServletRequest request,HttpSession session){
dakatixingService.update(dakatixing);
session.setAttribute("backxx", "修改成功");
session.setAttribute("backurl", request.getHeader("Referer"));
return "redirect:postback.jsp";
//String url = request.getHeader("Referer");
//return "redirect:"+url;
//return "redirect:dakatixingList.do";
}
// 分页查询
@RequestMapping("dakatixingList.do")
public String dakatixingList(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Dakatixing dakatixing, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String tixingneirong){
if(page==null||page.equals("")){
page="1";
}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
if(tixingneirong==null||tixingneirong.equals("")){pmap.put("tixingneirong", null);}else{pmap.put("tixingneirong", tixingneirong);}
int total=dakatixingService.getCount(pmap);
pageBean.setTotal(total);
List<Dakatixing> list=dakatixingService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "dakatixing_list";
}
@RequestMapping("dakatixing_yanben1.do")
public String dakatixing_yanben1(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Dakatixing dakatixing, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String tixingneirong){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
if(tixingneirong==null||tixingneirong.equals("")){pmap.put("tixingneirong", null);}else{pmap.put("tixingneirong", tixingneirong);}
int total=dakatixingService.getCount(pmap);
pageBean.setTotal(total);
List<Dakatixing> list=dakatixingService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "dakatixing_yanben1";
}
@RequestMapping("dakatixing_yanben2.do")
public String dakatixing_yanben2(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Dakatixing dakatixing, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao, String tixingneirong){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshigonghao==null||jiaoshigonghao.equals("")){pmap.put("jiaoshigonghao", null);}else{pmap.put("jiaoshigonghao", jiaoshigonghao);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
int total=ketangdakaService.getCount(pmap);
pageBean.setTotal(total);
List<Ketangdaka> list=ketangdakaService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "ketangdakalist";
}
@RequestMapping("ktdkListtp.do")
public String ktdkListtp(@RequestParam(value="page",required=false)String page,
ModelMap map,HttpSession session,Ketangdaka ketangdaka, String kechengbianhao, String kechengmingcheng, String jiaoshigonghao, String jiaoshixingming, String xuehao, String xueshengxingming, String banjihao, String fudaoyuangonghao){
if(page==null||page.equals("")){
page="1";
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshigonghao==null||jiaoshigonghao.equals("")){pmap.put("jiaoshigonghao", null);}else{pmap.put("jiaoshigonghao", jiaoshigonghao);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);}
if(xueshengxingming==null||xueshengxingming.equals("")){pmap.put("xueshengxingming", null);}else{pmap.put("xueshengxingming", xueshengxingming);}
if(banjihao==null||banjihao.equals("")){pmap.put("banjihao", null);}else{pmap.put("banjihao", banjihao);}
if(fudaoyuangonghao==null||fudaoyuangonghao.equals("")){pmap.put("fudaoyuangonghao", null);}else{pmap.put("fudaoyuangonghao", fudaoyuangonghao);}
int total=ketangdakaService.getCount(pmap);
pageBean.setTotal(total);
List<Ketangdaka> list=ketangdakaService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "ketangdakalisttp";
}
@RequestMapping("deleteKetangdaka.do")
public String deleteKetangdaka(int id,HttpServletRequest request){
ketangdakaService.delete(id);
} else {
pmap.put("kechengbianhao", kechengbianhao);
}
if (kechengmingcheng == null || kechengmingcheng.equals("")) {
pmap.put("kechengmingcheng", null);
} else {
pmap.put("kechengmingcheng", kechengmingcheng);
}
if (jiaoshigonghao == null || jiaoshigonghao.equals("")) {
pmap.put("jiaoshigonghao", null);
} else {
pmap.put("jiaoshigonghao", jiaoshigonghao);
}
if (jiaoshixingming == null || jiaoshixingming.equals("")) {
pmap.put("jiaoshixingming", null);
} else {
pmap.put("jiaoshixingming", jiaoshixingming);
}
if (xuehao == null || xuehao.equals("")) {
pmap.put("xuehao", null);
} else {
pmap.put("xuehao", xuehao);
}
if (xueshengxingming == null || xueshengxingming.equals("")) {
pmap.put("xueshengxingming", null);
} else {
pmap.put("xueshengxingming", xueshengxingming);
}
if (banjihao == null || banjihao.equals("")) {
pmap.put("banjihao", null);
} else {
pmap.put("banjihao", banjihao);
}
if (fudaoyuangonghao == null || fudaoyuangonghao.equals("")) {
pmap.put("fudaoyuangonghao", null);
} else {
pmap.put("fudaoyuangonghao", fudaoyuangonghao);
}
if (kaoqinzhuangtai == null || kaoqinzhuangtai.equals("")) {
pmap.put("kaoqinzhuangtai", null);
} else {
}
PageBean pageBean=new PageBean(Integer.parseInt(page), 15);
Map<String, Object> pmap=new HashMap<String,Object>();
pmap.put("pageno", pageBean.getStart());
pmap.put("pageSize", 15);
if(kechengbianhao==null||kechengbianhao.equals("")){pmap.put("kechengbianhao", null);}else{pmap.put("kechengbianhao", kechengbianhao);}
if(kechengmingcheng==null||kechengmingcheng.equals("")){pmap.put("kechengmingcheng", null);}else{pmap.put("kechengmingcheng", kechengmingcheng);}
if(jiaoshigonghao==null||jiaoshigonghao.equals("")){pmap.put("jiaoshigonghao", null);}else{pmap.put("jiaoshigonghao", jiaoshigonghao);}
if(jiaoshixingming==null||jiaoshixingming.equals("")){pmap.put("jiaoshixingming", null);}else{pmap.put("jiaoshixingming", jiaoshixingming);}
if(shangkeshijian==null||shangkeshijian.equals("")){pmap.put("shangkeshijian", null);}else{pmap.put("shangkeshijian", shangkeshijian);}
if(shangkedidian==null||shangkedidian.equals("")){pmap.put("shangkedidian", null);}else{pmap.put("shangkedidian", shangkedidian);}
if(kechengjieshao==null||kechengjieshao.equals("")){pmap.put("kechengjieshao", null);}else{pmap.put("kechengjieshao", kechengjieshao);}
int total=kechenganpaiService.getCount(pmap);
pageBean.setTotal(total);
List<Kechenganpai> list=kechenganpaiService.getByPage(pmap);
map.put("page", pageBean);
map.put("list", list);
session.setAttribute("p", 1);
return "kechenganpailisttp";
}
@RequestMapping("deleteKechenganpai.do")
public String deleteKechenganpai(int id,HttpServletRequest request){
kechenganpaiService.delete(id);
String url = request.getHeader("Referer");
return "redirect:"+url;
//return "redirect:kechenganpaiList.do";
}
}
{
DATE2 = d2[0]+"-0"+d2[1];
}else{
DATE2 = d2[0]+"-"+d2[1];
}
if(d2[2].length()==1)
{
DATE2 = DATE2+"-0"+d2[2];
}else{
DATE2 = DATE2+"-"+d2[2];
}
for(int j=0;j<10000;j++)
{
i=j;
String gday = Info.getDay(DATE1, j);
if(gday.equals(DATE2))
{
break;
}
}
return i;
}
/**
* 比较时间大小
*
*/
public static String compare_datezq(String DATE1, String DATE2) {
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
try {
Date dt1 = df.parse(DATE1);
Date dt2 = df.parse(DATE2);
if (dt1.getTime() > dt2.getTime()) {
session.setAttribute("p", 1);
return "ketangkaoqinlisttp";
}
@RequestMapping("deleteKetangkaoqin.do")
public String deleteKetangkaoqin(int id, HttpServletRequest request) {
ketangkaoqinService.delete(id);
String url = request.getHeader("Referer");
return "redirect:" + url;
//return "redirect:ketangkaoqinList.do";
}
}
@Controller
181
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
