SpringBoot整合mybatis

最新推荐文章于 2024-10-07 11:50:46 发布

Mr..w..

最新推荐文章于 2024-10-07 11:50:46 发布

阅读量119

点赞数 1

文章标签： mybatis spring boot java

本文链接：https://blog.csdn.net/electric_pig/article/details/127626576

版权

1、首先导入导入maven依赖

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2、配置springboot的配置文件

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/wjx?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8&useSSL=false

mybatis:
  mapper-locations: classpath:**/mapper/*.xml

3、创建数据对应的实体类

public class User {
    private int id;
    private String name;
    private String password;
    private Date birthday;

//此处省略get和set方法
}

4、创建mapper接口，在resource资源目录下创建Mapper的xml文件，在xml文件中写好sql语句。

@Mapper
public interface UserMapper {
    @Select("select * from user")
    List<User> selectAllUser();

//    User addUser(User user);
//
//    @Select("select * from user where id = #{id}")
//    User findUserById(int id);
}

<mapper namespace="com.wx.wjx.demo3.mapper.UserMapper">
    <!--没有使用type-aliases-package时的配置项-->
    <select id="selectAllUser" resultType="com.wx.wjx.demo3.entity.User">
        select * from user;
    </select>

<!--    <insert id="addUser" parameterType="com.wx.wjx.demo3.entity.User" keyProperty="id" useGeneratedKeys="true">-->
<!--        insert into user(name,password,birthday) value (#{name},#{password},#{birthday});-->
<!--    </insert>-->

<!--    <select id="findUserById" resultType="com.wx.wjx.demo3.entity.User">-->
<!--        select * form user where id=#{id};-->
<!--    </select>-->

</mapper>

5、ctrl+shift+T创建一个Test类，进行单元测试。

@SpringBootTest
@Slf4j
//@MapperScan("com.wx.wjx.demo3.mapper")
class SpringBootDay1ApplicationTests {
    @Autowired
    UserMapper userMapper;

    @Test
    void contextLoads() {
        List<User> userList=userMapper.selectAllUser();
//        System.out.println(userList);
//        User user=new User();
//        user.setName("wanghao");
//        user.setPassword("qwer");
//        user.setBirthday(new Date());
//        userMapper.addUser(user);
//        int id =user.getId();
//        User user1=userMapper.findUserById(id);
//        log.info(user1.toString());
        System.out.println(userList);


    }
}