一、项目运行
环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
JSP +SpringBoot + MyBatis + html+ css + JavaScript + JQuery + Ajax + maven等等。
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
课程管理Controller控制层:
@Controller
@RequestMapping("/subject")
public class SubjectController {
@Autowired
private SubjectDaoImpl subjectDaoImpl;
@Autowired
private SubjectDao subjectDao;
@Autowired
private PrivateCoachInfoDao privateCoachInfoDao;
/**
* @Description: 课程管理-进入课程信息界面
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/jin7")
public String jin7(){
return "WEB-INF/jsp/subject";
}
/**
* @Description: 课程管理-根据课程名称分页查询
* xiaoc
@RequestMapping("/qc")
public class EquipmentController {
@Autowired
private EquipmentDaoImpl equipmentDao;
/**
* @Description: 器材管理-进入器材信息界面
* xiaoc
* @Date: 2020/4/12
*/
@RequestMapping("/yemian")
public String yemian(){
return "WEB-INF/jsp/CEquipment";
}
/**
* @Description: 器材管理-根据器材名称分页查询
* xiaoc
* @Date: 2020/4/12
*/
@RequestMapping("/query")
@ResponseBody
public Map<String,Object> query(String hyname, int pageSize, int pageNumber){
Map<String,Object> map1=new HashMap<String,Object>();
map1.put("hyname",hyname);
map1.put("qi",(pageNumber-1)*pageSize);
map1.put("shi",pageSize);
map1.put("subname",subname);
map1.put("qi",(pageNumber-1)*pageSize);
map1.put("shi",pageSize);
return subjectDaoImpl.query(map1);
}
/**
* @Description: 课程管理-添加课程
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/add")
@ResponseBody
public void save(Subject subject){
subjectDao.save(subject);
}
/**
* @Description: 课程管理-根据课程id查询课程信息
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/cha")
@ResponseBody
public Optional<Subject> one(long subId){
public Map<String,Object> query(String subname, int pageSize, int pageNumber){
Map<String,Object> map1=new HashMap<String,Object>();
map1.put("subname",subname);
map1.put("qi",(pageNumber-1)*pageSize);
map1.put("shi",pageSize);
return subjectDaoImpl.query(map1);
}
/**
* @Description: 课程管理-根据课程id删除课程
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/del")
@ResponseBody
public Map<String,Object> del(long subId,String subname, int pageSize, int pageNumber){
//先根据教练id在私教信息表里查询是否有其信息
List<PrivateCoachInfo> privateCoachInfoList = privateCoachInfoDao.queryBySubjectIdNative(subId);
if(privateCoachInfoList !=null && privateCoachInfoList.size() > 0){
//如果有,先循环删除
for(PrivateCoachInfo privateCoachInfo : privateCoachInfoList){
if(subId == privateCoachInfo.getSubject().getSubId()){
privateCoachInfoDao.delete(privateCoachInfo);
}
}
}
subjectDao.deleteById(subId);
Map<String,Object> map1=new HashMap<String,Object>();
* @Description: 课程管理-进入课程信息界面
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/jin7")
public String jin7(){
return "WEB-INF/jsp/subject";
}
/**
* @Description: 课程管理-根据课程名称分页查询
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/query")
@ResponseBody
public Map<String,Object> query(String hyname, int pageSize, int pageNumber){
Map<String,Object> map1=new HashMap<String,Object>();
map1.put("hyname",hyname);
map1.put("qi",(pageNumber-1)*pageSize);
map1.put("shi",pageSize);
return equipmentDao.query(map1);
}
/**
* @Description: 器材管理-添加器材
* xiaoc
* @Date: 2020/4/12
*/
@RequestMapping("/insert")
*/
@RequestMapping("/dl/yz")
public String login(String username, String password,HttpSession httpSession,Model model){
Subject subject= SecurityUtils.getSubject();
UsernamePasswordToken userToken=new UsernamePasswordToken(username,DigestUtils.md5Hex(password));
try{
subject.login(userToken);
Adminuser a= adminuserDao.findByAdminNameAndAdminPassword(username,DigestUtils.md5Hex(password));
httpSession.setAttribute("user",a);
return "WEB-INF/jsp/index";
}catch (UnknownAccountException e){
model.addAttribute("msg","用户名或密码错误,请重新输入");
return "login";
}
/*Adminuser a= adminuserDao.findByAdminNameAndAdminmima(username,password);
if(a!=null){
httpSession.setAttribute("user",a);
return "WEB-INF/jsp/index" ;
* @Date: 2020/4/8
*/
@RequestMapping("/add")
@ResponseBody
public void save(Subject subject){
subjectDao.save(subject);
}
/**
* @Description: 课程管理-根据课程id查询课程信息
* xiaoc
* @Date: 2020/4/8
*/
@RequestMapping("/cha")
@ResponseBody
public Optional<Subject> one(long subId){
return subjectDao.findById(subId);
}
/**
* @Description: 课程管理-修改课程信息
@RequestMapping("/qc")
public class EquipmentController {
@Autowired
private EquipmentDaoImpl equipmentDao;
/**
* @Description: 器材管理-进入器材信息界面
* xiaoc
* @Date: 2020/4/12
*/
@RequestMapping("/yemian")
public String yemian(){
return "WEB-INF/jsp/CEquipment";
}
/**
* @Description: 器材管理-根据器材名称分页查询
* xiaoc
* @Date: 2020/4/12
*/
@RequestMapping("/query")
@ResponseBody
}
管理员登录Controller控制层:
@Controller
@RequestMapping("/")
public class AdminuserConntroller {
@Autowired
private AdminuserDao adminuserDao;
/**
* @Description: 输入端口号直接跳转登录界面
* xiaoc
* @Date: 2020/4/29
*/
@RequestMapping("/")
public String beforeLogin(){
return "login";
}
/**
* @Description: 管理员登录验证方法
* xiaoc
* @Date: 2020/4/4
*/
@RequestMapping("/dl/yz")
public String login(String username, String password,HttpSession httpSession,Model model){
Subject subject= SecurityUtils.getSubject();
UsernamePasswordToken userToken=new UsernamePasswordToken(username,DigestUtils.md5Hex(password));