基于javaweb+mysql的ssm+maven教师师资管理系统(java+ssm+jsp+bootstrap+mysql)

基于javaweb+mysql的ssm+maven教师师资管理系统(java+ssm+jsp+bootstrap+mysql)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

基于javaweb+mysql的SSM+Maven教师师资管理系统(java+ssm+jsp+bootstrap+mysql)

项目介绍

本项目包含管理员与教师两种角色;

管理员角色包含以下功能: 管理员角色登录,教师管理,教师授课管理,审批教师的项目开题,项目详情审批,项目总结审批,公告管理等功能。

教师角色包含以下功能: 教师角色登录,修改个人信息,修改密码,公告列表管理,开题审批管理,项目排名,项目详情审批管理,项目总结管理等功能。

环境需要

1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7/8.0版本均可; 6.是否Maven项目:是;

技术栈

  1. 后端:Spring+SpringMVC+Mybatis 2. 前端:Jsp+CSS+JavaScript+jQuery+bootstrap

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
		//分页查询
		String sql = "SELECT * FROM xm WHERE 1=1 and status = 9 ";
        if(!isEmpty(xm.getName())){
        	sql += " and name like '%"+xm.getName()+"%'";
		}
        if(!isEmpty(xm.getTeacherId())){
        	sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
		}
        if(!isEmpty(xm.getContent())){
        	sql += " and content like '%"+xm.getContent()+"%'";
		}
        if(!isEmpty(xm.getStatus())){
        	sql += " and status like '%"+xm.getStatus()+"%'";
		}
        if(!isEmpty(xm.getScore())){
        	sql += " and score like '%"+xm.getScore()+"%'";
		}
       sql += " ORDER BY score DESC ";
		List<Xm> pagers = xmService.listBySqlReturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/xm4";
	}
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(xm.getName())){
        	params.put("name", xm.getName());
		}
        if(!isEmpty(xm.getTeacherId())){
        	params.put("teacherId", xm.getTeacherId());
		}

	/**
	 * ajax 删除
	 * @return
	 */
	@RequestMapping(value = "/delete.json", method = RequestMethod.POST)
	@ResponseBody
	public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		///1.通过主键删除
		manageService.deleteById(id);
		/*以下是多种删除方式*/
//		//2.通过实体条件删除
//		manageService.deleteByEntity(manage);
//		//3.通过参数删除
//        //通过map查询
//		Map<String,Object> params = new HashMap<String,Object>();
//		
//        if(!isEmpty(manage.getUserName())){
//        	params.put("userName", manage.getUserName());
//		}
//       
//        if(!isEmpty(manage.getPassWord())){
//        	params.put("passWord", manage.getPassWord());
//		}
//       
//        if(!isEmpty(manage.getRealName())){
//        	params.put("realName", manage.getRealName());
//		}
//       
//		manageService.deleteByMap(params);
//		//4.状态删除
//		Manage load = manageService.getById(manage.getId())
//		load.setIsDelete(1);
//		manageService.updateById(load);
		//5.状态删除
		//Manage load = manageService.load(id);
		//load.setIsDelete(1);
		//manageService.updateById(load);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("message", "删除成功");
		return jsonObject.toString();
	}
	/**
	 * 单文件上传
	 * @param file
	 * @param request
	 * @param model
	 * @return
	 */
    @RequestMapping(value = "/saveFile")  
    public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {  
  
        System.out.println("开始");  
	public String exUpdate(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
		//1.通过实体类修改,可以多传修改条件
		manageService.updateById(manage);
		//2.通过主键id修改
		//manageService.updateById(manage);
		return "redirect:/manage/findBySql.action";
	}
	
	/**
	 * 删除通过主键
	 * @return
	 */
	@RequestMapping(value = "/delete")
	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		///1.通过主键删除
		manageService.deleteById(id);
		/*以下是多种删除方式*/
//		//2.通过实体条件删除
//		manageService.deleteByEntity(manage);
//		//3.通过参数删除
//     //通过map查询
//		Map<String,Object> params = new HashMap<String,Object>();
//		
//        if(!isEmpty(manage.getUserName())){
//        	params.put("userName", manage.getUserName());
//		}
//       
//        if(!isEmpty(manage.getPassWord())){
//        	params.put("passWord", manage.getPassWord());
//		}
//       
//        if(!isEmpty(manage.getRealName())){
//        	params.put("realName", manage.getRealName());
//		}
//       
//		manageService.deleteByMap(params);
//		//4.状态删除
//		Manage load = manageService.getById(manage.getId())
//		load.setIsDelete(1);
//		manageService.update(load);
		//5.状态删除
		//Manage load = manageService.load(id);
		//load.setIsDelete(1);
		//manageService.update(load);
		return "redirect:/manage/findBySql.action";
	}
	
	// --------------------------------------- 华丽分割线 ------------------------------
	// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------

	/*********************************查询列表【不分页】***********************************************/
	
        	sql += " and isDelete like '%"+teacher.getIsDelete()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Teacher> pagers = teacherService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", teacher);
		return "teacher/teacher";
	}
	
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Teacher teacher, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(teacher.getUsername())){
        	params.put("username", teacher.getUsername());
		}
        if(!isEmpty(teacher.getSex())){
        	params.put("sex", teacher.getSex());
		}
        if(!isEmpty(teacher.getPassword())){
        	params.put("password", teacher.getPassword());
		}
        if(!isEmpty(teacher.getXw())){
        	params.put("xw", teacher.getXw());
		}
        if(!isEmpty(teacher.getPhone())){
        	params.put("phone", teacher.getPhone());
		}
        if(!isEmpty(teacher.getIsDelete())){
        	params.put("isDelete", teacher.getIsDelete());
		}
		//分页查询
		Pager<Teacher> pagers = teacherService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listAll")
	public String listAll(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
		List<Manage> listAll = manageService.listAll();
		model.addAttribute("list", listAll);
		return "manage/manage";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByEntity 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByEntity")
	public String listByEntity(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
		List<Manage> listAll = manageService.listAllByEntity(manage);
		model.addAttribute("list", listAll);
		return "manage/manage";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByMap 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByMap")
	public String listByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
	        if(!isEmpty(manage.getUserName())){
	        	params.put("userName", manage.getUserName());
			}
	        if(!isEmpty(manage.getPassWord())){
	        	params.put("passWord", manage.getPassWord());
			}
		
		
		return "login/mIndex";
	}
	
	/**
	 * 退出
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping("/tuichu")
	public String tuichu( HttpServletRequest request, HttpServletResponse response){
		HttpSession session = request.getSession();
		session.invalidate();
		return "login/login";
	}

	@RequestMapping("/head")
	private String head(){
		return "inc/head";
	}
	
	@RequestMapping("/left")
	private String left(){
		return "inc/left";
	}
	
	
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model,HttpServletRequest request) {
		
		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/mtuichu";	
		}
		
		Integer userId = Integer.valueOf(attribute.toString());
		Teacher byId = teacherService.getById(userId);
		model.addAttribute("obj",byId);
        	sql += " and content like '%"+xm.getContent()+"%'";
		}
        if(!isEmpty(xm.getStatus())){
        	sql += " and status like '%"+xm.getStatus()+"%'";
		}
        if(!isEmpty(xm.getScore())){
        	sql += " and score like '%"+xm.getScore()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/spxm3";
	}
	
	
	@RequestMapping(value = "/sp1")
	public String sp1(Xm xm,Integer isTy, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		if (isTy == 0){
			xm.setStatus(1);
		}else{
			xm.setStatus(2);
		}
		
		xmService.updateById(xm);
		return "redirect:/xm/spfindBySql1.action";
	}
	
	@RequestMapping(value = "/sp2")
	public String sp2(Xm xm,Integer isTy, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		if (isTy == 0){
			xm.setStatus(4);
		}else{
			xm.setStatus(5);
		}
		
		xmService.updateById(xm);
		return "redirect:/xm/spfindBySql2.action";
	}
	@RequestMapping(value = "/sp3")
	public String spfindBySql3(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		String sql = "SELECT * FROM xm WHERE status = 6 or status = 8 or status = 9";
        if(!isEmpty(xm.getName())){
        	sql += " and name like '%"+xm.getName()+"%'";
		}
        if(!isEmpty(xm.getTeacherId())){
        	sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
		}
        if(!isEmpty(xm.getContent())){
        	sql += " and content like '%"+xm.getContent()+"%'";
		}
        if(!isEmpty(xm.getStatus())){
        	sql += " and status like '%"+xm.getStatus()+"%'";
		}
        if(!isEmpty(xm.getScore())){
        	sql += " and score like '%"+xm.getScore()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/spxm3";
	}
	
	
	@RequestMapping(value = "/sp1")
	public String sp1(Xm xm,Integer isTy, Model model, HttpServletRequest request, HttpServletResponse response) {
		
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		if (isTy == 0){
			xm.setStatus(1);
		}else{
			xm.setStatus(2);
		}
		
		xmService.updateById(xm);
		return "redirect:/xm/spfindBySql1.action";
	}
	/**
	 * 添加执行
	 * @return
	 */
	@RequestMapping(value = "/exAdd")
	public String exAdd(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
		noticeService.insert(notice);
		return "redirect:/notice/findBySql.action";
	}
	
	
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Notice obj = noticeService.load(id);
		model.addAttribute("obj",obj);
		return "notice/update";
	}
	
	/**
	 * 添加修改
	 * @return
	 */
	@RequestMapping(value = "/exUpdate")
	public String exUpdate(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
		noticeService.updateById(notice);
		return "redirect:/notice/findBySql.action";
	}
	
	/**
	 * 删除通过主键
	 * @return
	 */
	@RequestMapping(value = "/delete")
	public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		noticeService.deleteById(id);
		return "redirect:/notice/findBySql.action";
	}
	
	
	
}

	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
	@ResponseBody
	public String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Pager<Manage> pagers = manageService.findByEntity(manage);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("pagers", pagers);
		jsonObject.put("obj", manage);
		return jsonObject.toString();
	}
	
	  
	/**
	 * 分页查询 返回list json(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMapJson",  method = RequestMethod.POST)
	@ResponseBody
	public String findByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(manage.getUserName())){
        	params.put("userName", manage.getUserName());
		}
        if(!isEmpty(manage.getPassWord())){
        	params.put("passWord", manage.getPassWord());
		}
        if(!isEmpty(manage.getRealName())){
        	params.put("realName", manage.getRealName());
		}
		//分页查询
		Pager<Manage> pagers = manageService.findByMap(params);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("pagers", pagers);
		jsonObject.put("obj", manage);
		return jsonObject.toString();
        if(!isEmpty(teacher.getIsDelete())){
        	sql += " and isDelete like '%"+teacher.getIsDelete()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Teacher> pagers = teacherService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", teacher);
		return "teacherclass/teacher";
	}
	
	/**
	 * 跳至添加页面
	 * @return
	 */
	@RequestMapping(value = "/add")
	public String add(Integer teacherId,Model model) {
		model.addAttribute("teacherId", teacherId);
		return "teacherclass/add";
	}

	/**
	 * 跳至详情页面
	 * @return
	 */
	@RequestMapping(value = "/view")
	public String view(Integer id,Model model) {
		Teacherclass obj = teacherclassService.load(id);
		model.addAttribute("obj",obj);
		return "teacherclass/view";
	}
	
	/**
	 * 添加执行
	 * @return
	 */
	@RequestMapping(value = "/exAdd")
	public String exAdd(Teacherclass teacherclass, Model model, HttpServletRequest request, HttpServletResponse response) {
		teacherclassService.insert(teacherclass);
		return "redirect:/teacherclass/findBySql.action?teacherId="+teacherclass.getTeacherId();
	}
	
	
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Teacherclass obj = teacherclassService.load(id);
		model.addAttribute("obj",obj);
		return "teacherclass/update";
		return "notice/notice";
	}
	
	@RequestMapping(value = "/findBySqlUser")
	public String findBySqlUser(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		String sql = "SELECT * FROM notice WHERE 1=1 ";
        if(!isEmpty(notice.getTitle())){
        	sql += " and title like '%"+notice.getTitle()+"%'";
		}
        if(!isEmpty(notice.getContent())){
        	sql += " and content like '%"+notice.getContent()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Notice> pagers = noticeService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", notice);
		return "notice/noticeUser";
	}
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Notice notice, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(notice.getTitle())){
        	params.put("title", notice.getTitle());
		}
        if(!isEmpty(notice.getContent())){
        	params.put("content", notice.getContent());
		}
		//分页查询
		Pager<Notice> pagers = noticeService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", notice);
		return "notice/notice";
	}
	
	/**********************************【增删改】******************************************************/
	
            e.printStackTrace();  
        }  
  
        return "";  
    }  
	
	
	/**
	 * springMvc多文件上传
	 * @param files
	 * @param id
	 * @return
	 */
    @RequestMapping(value = "/saveFiles")
    public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
		for(int i = 0;i<files.length;i++){
	      	System.out.println("fileName---------->" + files[i].getOriginalFilename());
		  if(!files[i].isEmpty()){
            int pre = (int) System.currentTimeMillis();
	     	try {
			//拿到输出流,同时重命名上传的文件
			 String filePath = request.getRealPath("/upload");
			 File f=new File(filePath);
			 if(!f.exists()){
				f.mkdirs();
			 }
		     String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
		     File file=new File(filePath+"/"+pre + files[i].getOriginalFilename());
			  if(!file.exists()){
				  file.createNewFile();
			 }
			  files[i].transferTo(file);
		     } catch (Exception e) {
				e.printStackTrace();
				System.out.println("上传出错");
			 }
		  }
		}
	  return "";
	}
 // --------------------------------------- 华丽分割线 ------------------------------
	

/**
 * @ClassName:  
 * @Description: 
 */

@Controller
@RequestMapping("/teacher")
public class TeacherController extends BaseController {
	
	
	/**
	 * 依赖注入 start dao/service/===
	 */
	@Autowired
	private TeacherService teacherService;
	
	// --------------------------------------- 华丽分割线 ------------------------------
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(Teacher teacher, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		String sql = "SELECT * FROM teacher WHERE isDelete = 0 ";
        if(!isEmpty(teacher.getUsername())){
        	sql += " and username like '%"+teacher.getUsername()+"%'";
	
	@RequestMapping(value = "/findBySql3")
	public String findBySql3(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		

		Object attribute = request.getSession().getAttribute("userId");
		
		if (attribute == null){
			return "redirect:/login/mtuichu";	
		}
		
		Integer userId = Integer.valueOf(attribute.toString());
		
		/* -1 新建
		 * 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		//分页查询
		String sql = "SELECT * FROM xm WHERE 1=1 and (status = 5 or status =6 or status = 7 or status = 9 or status = 8) and teacherId =  "+ userId;
        if(!isEmpty(xm.getName())){
        	sql += " and name like '%"+xm.getName()+"%'";
		}
        if(!isEmpty(xm.getTeacherId())){
        	sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
		}
        if(!isEmpty(xm.getContent())){
        	sql += " and content like '%"+xm.getContent()+"%'";
		}
        if(!isEmpty(xm.getStatus())){
        	sql += " and status like '%"+xm.getStatus()+"%'";
		}
        if(!isEmpty(xm.getScore())){
        	sql += " and score like '%"+xm.getScore()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/xm3";
	}
	
	@RequestMapping(value = "/findBySql4")
	public String findBySql4(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		

		Object attribute = request.getSession().getAttribute("userId");
		
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/xm";
	}
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/spfindBySql1")
	public String findBySql(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		String sql = "SELECT * FROM xm WHERE status = 0";
        if(!isEmpty(xm.getName())){
        	sql += " and name like '%"+xm.getName()+"%'";
		}
        if(!isEmpty(xm.getTeacherId())){
        	sql += " and teacherId like '%"+xm.getTeacherId()+"%'";
		}
        if(!isEmpty(xm.getContent())){
        	sql += " and content like '%"+xm.getContent()+"%'";
		}
        if(!isEmpty(xm.getStatus())){
        	sql += " and status like '%"+xm.getStatus()+"%'";
		}
        if(!isEmpty(xm.getScore())){
        	sql += " and score like '%"+xm.getScore()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Xm> pagers = xmService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", xm);
		return "xm/spxm1";
	}
	
	@RequestMapping(value = "/spfindBySql2")
	public String spfindBySql2(Xm xm, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		/* 0 一待审 1 一审不通 2 一审通过
		 3 二待审 4 二审不通 5 二审通过
	     6 三待审 7 三审不通 8 三审通过
		 9 积分设置完成结束*/
		
		String sql = "SELECT * FROM xm WHERE status = 3";
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
	        if(!isEmpty(manage.getUserName())){
	        	params.put("userName", manage.getUserName());
			}
	        if(!isEmpty(manage.getPassWord())){
	        	params.put("passWord", manage.getPassWord());
			}
	        if(!isEmpty(manage.getRealName())){
	        	params.put("realName", manage.getRealName());
			}
	    List<Manage> listAll = manageService.listByMap(params);
	    JSONObject jsonObject = new JSONObject();
		jsonObject.put("list", listAll);
		jsonObject.put("obj", manage);
		return jsonObject.toString();
	}
	
	
	/**
	 * 分页查询 返回list json(通过对象)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
	@ResponseBody
	public String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Pager<Manage> pagers = manageService.findByEntity(manage);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("pagers", pagers);
		jsonObject.put("obj", manage);
		return jsonObject.toString();
	}
	
	  
	/**
	 * 分页查询 返回list json(通过Map)

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值