本文共 2897 字，大约阅读时间需要 9 分钟。

springboot入门(1)—整合MyBatis

1、快速创建springboot项目

       
    
     org.mybatis.spring.boot
        
    
     mybatis-spring-boot-starter
        
    
     1.1.1
    
   

2.2、添加mysql驱动：

       
    
     mysql
        
    
     mysql-connector-java
    
   

2.3添加数据库连接信息

mybatis.type-aliases-package=com.zdww.domainspring.datasource.driverClassName=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql://localhost:3306/bk?serverTimezone=UTCspring.datasource.username=rootspring.datasource.password=1405284875

3、代码的编写

package com.zdww.domain;/** * @ClassName:User * @Auther: crazy * @Date: 2020/8/1 14:29 * @Description: TODO * @Version：1.0 */public class User {       private String uname;    private String  mail;    private String account;    private String role;    public String getUname() {           return uname;    }    public void setUname(String uname) {           this.uname = uname;    }    public String getmail() {           return mail;    }    public void setmail(String mail) {           this.mail = mail;    }    public String getAccount() {           return account;    }    public void setAccount(String account) {           this.account = account;    }    public String getRole() {           return role;    }    public void setRole(String role) {           this.role = role;    }    @Override    public String toString() {           return "User{" +                "uname='" + uname + '\'' +                ", mail='" + mail + '\'' +                ", account='" + account + '\'' +                ", role='" + role + '\'' +                '}';    }}

3.2、mapper层

package com.zdww.mapper;import com.zdww.domain.User;import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Select;import java.util.List;/** * @ClassName:UserMapper * @Auther: crazy * @Date: 2020/8/1 14:31 * @Description: TODO * @Version：1.0 */@Mapperpublic interface UserMapper {       @Select("select * from tuser")    public List
   
     queryUserList();}
   

3.3、ctroller层

package com.zdww.ctroller;import com.zdww.domain.User;import com.zdww.mapper.UserMapper;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.CrossOrigin;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.ResponseBody;import java.util.List;/** * @ClassName:MapperController * @Auther: crazy * @Date: 2020/8/1 14:35 * @Description: TODO * @Version：1.0 */@CrossOrigin@Controllerpublic class MapperController {       @Autowired    private## UserMapper userMapper;    @RequestMapping("/queryUser")    @ResponseBody    public List
   
     queryUser() {           List
    
      users = userMapper.queryUserList();        return users;    }}
    
   

4、调试运行