栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

SpringMVC整合mybatis框架

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

SpringMVC整合mybatis框架

目录

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




    
    
    
        
    
    
        
    
    
        
            
            
                
                
                
                
            
        
    

    
        
        
    

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层下的配置

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 登录界面代码展示

login.jsp:

        注意要引入样式,不然不能正常显示。

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    登录页面
    
    
    
    
    
    



    
        
            
                
                    
                
                
                    
                
                
                    提交
                
            
        
    



4.2 登录成功界面代码

success.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    成功界面
    
    
    
    
    



    
        
        
        
        
        
        
        
        

        
            
        

    



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;
    }
}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/961523.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号