目录
1.整体框架
2.对应代码展示
2.1 引入所需依赖
2.2 连接数据库
2.2.1 配置conf.xml
2.2.2 配置mapper下的内容
2.2.3 entity类下的内容
2.2.4 dao包下的内容
2.3.5 测试方法是否正确
3.SpringMvc下编写方法
3.1 controller层下的配置
3.2 公共类下的内容
3.3 springmvc的配置内容
4.elementui界面显示
4.1 登录界面代码展示
4.2 登录成功界面代码
5.拦截器拦截未登录者查看信息
1.整体框架
2.对应代码展示
2.1 引入所需依赖
mysql
mysql-connector-java
8.0.28
junit
junit
4.13.2
org.projectlombok
lombok
1.18.24
org.springframework
spring-webmvc
5.2.15.RELEASE
javax.servlet
javax.servlet-api
4.0.1
com.fasterxml.jackson.core
jackson-databind
2.13.2.2
org.mybatis
mybatis
3.5.9
log4j
log4j
1.2.17
2.2 连接数据库
2.2.1 配置conf.xml
mysql mysql-connector-java8.0.28 junit junit4.13.2 org.projectlombok lombok1.18.24 org.springframework spring-webmvc5.2.15.RELEASE javax.servlet javax.servlet-api4.0.1 com.fasterxml.jackson.core jackson-databind2.13.2.2 org.mybatis mybatis3.5.9 log4j log4j1.2.17
2.2 连接数据库
2.2.1 配置conf.xml
db.properties内容
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/mydb?serverTimezone=Asia/Shanghai username=root password=123456
2.2.2 配置mapper下的内容
userMapper.xml:
因为所作登录界面简单,只考虑输入账号和密码对应问题
select * from tb_user where uername=#{name} and password=#{pass}
StudentMapper.xml:
因为所作学生界面简单,只考虑查询所有问题
2.2.3 entity类下的内容
user:
注意此处命名与数据库相对应,若命名不一致则需要进行之后的重新映射,参见之前的mybatis的博客。
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private int id;
private String uername;
private String password;
public User(String uername, String password) {
this.uername = uername;
this.password = password;
}
}
Student:
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
private int id;
private String name;
private int age;
private String address;
private int sex;
public Student(String name, int age, String address, int sex) {
this.name = name;
this.age = age;
this.address = address;
this.sex = sex;
}
}
2.2.4 dao包下的内容
UserDao注意两者都为接口类型:
public interface UserDao {
//多参传入方法,相当于给传参的数据进行重命名,@Param("name")内是新替换的名称
public User getNameAndPass(@Param("name")String uername,@Param("pass") String password);
}
StudentDao:
public interface StudentDao {
//注意此处查询结果返回的是List型
public List findAll();
}
2.3.5 测试方法是否正确
public class Test01 {
SqlSession sqlSession;
UserDao mapper;
StudentDao mapper1;
{
try{
Reader reader= Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader);
sqlSession= sqlSessionFactory.openSession();
mapper = sqlSession.getMapper(UserDao.class);
mapper1 = sqlSession.getMapper(StudentDao.class);
}catch (Exception e){
e.printStackTrace();
}
}
@Test
public void testGetName(){
User nameAndPass = mapper.getNameAndPass("admin", "123456");
System.out.println(nameAndPass);
}
@Test
public void testFindAll(){
List all = mapper1.findAll();
for (Student stu:all
) {
System.out.println(stu.getId()+"t"+stu.getName()+"t"
+stu.getAge()+"t"+stu.getAddress()+"t"+stu.getSex());
}
}
}
3.SpringMvc下编写方法
3.1 controller层下的配置
3.1 controller层下的配置
UserController:
@Controller
public class UserController {
SqlSession sqlSession;
UserDao mapper;
{
try{
Reader reader= Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader);
sqlSession=sqlSessionFactory.openSession();
mapper = sqlSession.getMapper(UserDao.class);
}catch (Exception e){
e.printStackTrace();
}
}
@RequestMapping("/loginPage")
@ResponseBody
//username与之前的表单名字一致
public CommonResult getName(String username, String password, HttpSession httpSession){
User nameAndPass = mapper.getNameAndPass(username, password);
if(nameAndPass!=null){
System.out.println(nameAndPass);
httpSession.setAttribute("user",nameAndPass);
return CommonResult.success(200);
}else{
return CommonResult.notFount();
}
}
}
StudentController:
@Controller
public class StudentController {
SqlSession sqlSession;
StudentDao mapper;
{
try{
Reader reader= Resources.getResourceAsReader("conf.xml");
SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader);
sqlSession= sqlSessionFactory.openSession();
mapper = sqlSession.getMapper(StudentDao.class);
}catch (Exception e){
e.printStackTrace();
}
}
@RequestMapping("/student")
@ResponseBody//返回的json类型的数据
public CommonResult getFind(){
List all = mapper.findAll();
if(all!=null){
return CommonResult.success(all);
}else{
return CommonResult.notFount();
}
}
}
3.2 公共类下的内容
commonResult:
@Data
@AllArgsConstructor
@NoArgsConstructor
public class CommonResult {
private final static int success=200;
private final static int error=500;
private final static int not_fount=404;
private int code;
private String msg;
//注意此处的date,后续要是不能打印注意看此处
private Object date;
public static CommonResult success(Object date){
return new CommonResult(CommonResult.success,"success",date);
}
public static CommonResult error(Object date){
return new CommonResult(CommonResult.error,"未知错误,请联系管理员",date);
}
public static CommonResult notFount(){
return new CommonResult(CommonResult.not_fount,"资源不存在",null);
}
}
3.3 springmvc的配置内容
4.elementui界面显示
4.1 登录界面代码展示
4.1 登录界面代码展示
login.jsp:
注意要引入样式,不然不能正常显示。
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
登录页面
提交
4.2 登录成功界面代码
success.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
成功界面
{{scope.row.sex==1?'男':'女'}}
5.拦截器拦截未登录者查看信息
interceptor包下的LoginInterceptor:
注意不要忘了在springmvc.xml中配置所要释放信息。
public class LoginInterceptor implements HandlerInterceptor {
public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
HttpSession session = request.getSession();
Object user = session.getAttribute("user");
if(user!=null){
return true;
}
PrintWriter writer = response.getWriter();
response.setCharacterEncoding("utf-8");
response.setContentType("application/json;charset=utf-8");
writer.write(new ObjectMapper().writeValueAsString(CommonResult.error("未知异常")));
writer.flush();
writer.close();
return false;
}
}



