在基于springboot构建的maven工程中使用mybatis框架

来源：互联网发布：知乎评价章泽天长相编辑：程序博客网时间：2024/06/08 12:25

1.在pom.xml文件下引用相关依赖包

        <!-- 数据源-->        <dependency>            <groupId>com.zaxxer</groupId>            <artifactId>HikariCP</artifactId>        </dependency>        <!-- mysql-->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.38</version>        </dependency>        <!-- mybatis-spring -->        <dependency>            <groupId>org.mybatis.spring.boot</groupId>            <artifactId>mybatis-spring-boot-starter</artifactId>            <version>1.1.1</version>        </dependency>

2.在application.properties文件中配置数据库和mybatis的连接
在本实例中使用的是mysql数据库，需要配置数据库名称、地址等相关信息。

#配置数据源spring.datasource.name=shoesshoppingspring.datasource.url=jdbc:mysql://localhost:3306/shoesshoppingspring.datasource.username=rootspring.datasource.password=123456spring.datasource.type=com.zaxxer.hikari.HikariDataSourcespring.datasource.driver-class-name=com.mysql.jdbc.Driver#mybatismybatis.type-aliases-package=com.lzr.model

3.创建实体，编写mybatis的mapper映射

在创建好数据模型对应的实体类(如下面代码里的Member类)后，使用注解配置SQL语句。

package com.lzr.dao.mapper;import com.lzr.model.Member;import org.apache.ibatis.annotations.*;import java.util.List;@Mapperpublic interface MemberMapper {    @Insert("INSERT INTO member (name, pwd, userType) VALUES (#{name}, #{pwd}, '1')")    int save(Member member);    @Select("SELECT * FROM member WHERE userId = #{userId}")    Member selectById(int id);    @Select("SELECT * FROM member WHERE name = #{name}")    Member selectByName(String name);    @Update("UPDATE member SET pwd = #{pwd} WHERE userId = #{userId}")    int updateById(Member member);    @Delete("DELETE FROM member WHERE userId = #{userId}")    int deleteById(Member member);    @Select("SELECT * FROM member")    List<Member> queryAll();}

4.在controller层或service层编写逻辑，调用mapper

    @Autowired    MemberMapper mapper;    @Override    public String login(String name) {        if(StringUtils.isEmpty(mapper.selectByName(name))){            return "index";        }else {            return "success";        }    }

运行程序，就可以成功连接数据库，对数据进行操作。

0 0