com.lqh下的每个包
controller
StudentController
package com.lqh.controller;
import com.lqh.entity.Student;
import com.lqh.service.IStudent;
import com.lqh.utils.CommentResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.util.List;
@RestController(value = "sc")
public class StudentController {
@Autowired
private IStudent istu;
@RequestMapping("findAll")
public CommentResult testFindAll(){
List list = istu.findAll();
if(list!=null){
return new CommentResult(2000,"查询成功",list);
}else
return new CommentResult(5000,"查询失败",null);
}
@RequestMapping(value = "/insert")
public CommentResult testInsert(Student stu){
istu.addStudent(stu);
return new CommentResult(2000,"添加成功",null);
}
@RequestMapping(value = "/delete")
public CommentResult testDelete(Integer stuId){
istu.delete(stuId);
return new CommentResult(2000,"删除成功",null);
}
@RequestMapping(value = "/exit")
public CommentResult testExit(HttpServletRequest req){
HttpSession session = req.getSession();
session.removeAttribute("user");
return new CommentResult(2000,"退出成功",null);
}
@RequestMapping(value = "update")
public CommentResult testUpdate(Student stu){
istu.update(stu.getStuId(),stu.getStuName(),stu.getStuSex(),stu.getStuAge(),stu.getStuAddress());
return new CommentResult(2000,"修改成功",null);
}
}
UserController
package com.lqh.controller;
import com.lqh.entity.User;
import com.lqh.service.IService;
import com.lqh.utils.CommentResult;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
@RestController(value = "uc")
public class UserController {
@Autowired
private IService is;
@RequestMapping(value = "/findOne")
public CommentResult testFindOne(String username, String pwd,HttpSession session){
User user = is.findOne(username, pwd);
session.setAttribute("user",user);
if(user!=null){
CommentResult result=new CommentResult(2000,"登录成功",user);
return result;
}else{
CommentResult result=new CommentResult(5000,"登录失败",null);
return result;
}
}
@RequestMapping(value = "/insertUser")
public CommentResult testInsertUser(User user){
is.insertUser(user);
return new CommentResult(2000,"注册成功",null);
}
}
dao
StudentMapper
package com.lqh.dao;
import com.lqh.entity.Student;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface StudentMapper {
int deleteByPrimaryKey(Integer stuId);
int insert(Student record);
int insertSelective(Student record);
Student selectByPrimaryKey(Integer stuId);
int updateByPrimaryKeySelective(Student record);
int updateByPrimaryKey(Student record);
List findAll();
void addStudent(Student stu);
void delete(@Param("id")Integer id);
void update(@Param("stuId")Integer stuId,@Param("stuName")String stuName,@Param("stuSex")Integer stuSex,@Param("stuAge")Integer stuAge,@Param("stuAddress")String stuAddress);
//void update(Student stu);
}
UserMapper
package com.lqh.dao;
import com.lqh.entity.User;
import org.apache.ibatis.annotations.Param;
public interface UserMapper {
int insert(User record);
int insertSelective(User record);
User findOne(@Param("username")String username,@Param("pwd")String pwd);
void insertUser(User user);
}
entity
Student
package com.lqh.entity;
import java.io.Serializable;
public class Student implements Serializable{
private Integer stuId;
private String stuName;
private Integer stuAge;
private Integer stuSex;
private String stuAddress;
public Student() {
}
public Integer getStuId() {
return stuId;
}
public void setStuId(Integer stuId) {
this.stuId = stuId;
}
public String getStuName() {
return stuName;
}
public void setStuName(String stuName) {
this.stuName = stuName == null ? null : stuName.trim();
}
public Integer getStuAge() {
return stuAge;
}
public void setStuAge(Integer stuAge) {
this.stuAge = stuAge;
}
public Integer getStuSex() {
return stuSex;
}
public void setStuSex(Integer stuSex) {
this.stuSex = stuSex;
}
public String getStuAddress() {
return stuAddress;
}
public Student(String stuName, Integer stuAge, Integer stuSex, String stuAddress) {
this.stuName = stuName;
this.stuAge = stuAge;
this.stuSex = stuSex;
this.stuAddress = stuAddress;
}
public void setStuAddress(String stuAddress) {
this.stuAddress = stuAddress == null ? null : stuAddress.trim();
}
}
User
package com.lqh.entity;
import java.io.Serializable;
public class User implements Serializable {
private Integer id;
private String username;
private String pwd;
private String realname;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username == null ? null : username.trim();
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd == null ? null : pwd.trim();
}
public String getRealname() {
return realname;
}
public User(String username, String pwd, String realname) {
this.username = username;
this.pwd = pwd;
this.realname = realname;
}
public void setRealname(String realname) {
this.realname = realname == null ? null : realname.trim();
}
}
interceptor
LogInInterceptor
package com.lqh.interceptor;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.lqh.utils.CommentResult;
import org.springframework.web.servlet.HandlerInterceptor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.PrintWriter;
public class LogInInterceptor implements HandlerInterceptor {
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
response.setContentType("application/json;charset=utf-8");
HttpSession session = request.getSession();
Object user = session.getAttribute("user");
if(user!=null){
return true;
}
CommentResult result=new CommentResult(5001,"没有登录",null);
PrintWriter out = response.getWriter();
ObjectMapper objectMapper=new ObjectMapper();
String jsons = objectMapper.writeValueAsString(result);
System.out.println(jsons);
out.print(jsons);
out.flush();
out.close();
return false;
}
}
service
impl
StudentServiceImpl
package com.lqh.service.Impl;
import com.lqh.dao.StudentMapper;
import com.lqh.entity.Student;
import com.lqh.service.IStudent;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service(value = "ss")
public class StudentServiceImpl implements IStudent {
@Autowired
private StudentMapper sm;
public List findAll() {
List list = sm.findAll();
return list;
}
public void addStudent(Student stu){
sm.addStudent(stu);
}
public void delete(Integer id){
sm.delete(id);
}
public void update(Integer stuId,String stuName,Integer stuSex, Integer stuAge, String stuAddress) {
sm.update(stuId, stuName,stuSex, stuAge, stuAddress);
}
}
UserServiceImpl
package com.lqh.service.Impl;
import com.lqh.dao.UserMapper;
import com.lqh.entity.User;
import com.lqh.service.IService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service(value = "us")
public class UserServiceImpl implements IService {
@Autowired
private UserMapper um;
public User findOne(String username, String pwd) {
User user = um.findOne(username, pwd);
return user;
}
public void insertUser(User user) {
um.insertUser(user);
}
}
IUser
package com.lqh.service;
import com.lqh.entity.User;
public interface IService {
User findOne(String username,String pwd);
void insertUser(User user);
}
IStudent
package com.lqh.service;
import com.lqh.entity.Student;
import java.util.List;
public interface IStudent {
List findAll();
void addStudent(Student stu);
void delete(Integer id);
void update(Integer stuId,String stuName,Integer stuSex,Integer stuAge,String stuAddress);
}
Test
TestGenerator
package com.lqh.Test;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;
import java.io.File;
import java.util.ArrayList;
import java.util.List;
public class TestGenerator {
public static void main(String[] args) throws Exception{
List warnings = new ArrayList();
boolean overwrite = true;
//new file中的名字必须和generator生成器的名字一致
File configFile = new File("generator.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
}
utils
COmmentResult
package com.lqh.utils;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class CommentResult {
private Integer code;
private String msg;
private Object data;
}
===============
resources下的配置文件和mapper包
mapper
StudentMapper.xml
stu_id, stu_name, stu_age, stu_sex, stu_address
UserMapper.xml
insert into user (id, username, pwd, realname) values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{pwd,jdbcType=VARCHAR}, #{realname,jdbcType=VARCHAR}) insert into user id, username, pwd, realname, #{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{pwd,jdbcType=VARCHAR}, #{realname,jdbcType=VARCHAR}, select * from user where username=#{username} and pwd=#{pwd} insert into user values (null,#{username},#{pwd},#{realname})
spring.xml、log4j.properties配置文件参考上一篇文档内容
==========
web下的css,js,jsp页面
login.jsp
<%--
Created by IntelliJ IDEA.
User: 李青华
Date: 2022/6/14
Time: 18:47
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
登录
>
>
>
>
取 消
保 存
登录
注册
main.jsp
<%--
Created by IntelliJ IDEA.
User: 李青华
Date: 2022/6/14
Time: 19:02
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
学生信息
欢迎${sessionScope.user.realname}进入学生管理系统
添加学生
退出登录
>
>
男
女
>
>
取 消
确 定
{{scope.row.stuSex==0?"男":"女"}}
编辑
删除
>
>
男
女
>
>
取 消
保 存
>
>
男
女
>
>
取 消
保 存



