从零学习springboot（四）--整合mybtais

原创

gosenkle 2021-12-29 09:48:39 博主文章分类：springboot ©著作权

文章标签 springboot spring mysql java 文章分类 代码人生

©著作权归作者所有：来自51CTO博客作者gosenkle的原创作品，请联系作者获取转载授权，否则将追究法律责任

1、集成mybatis starter

<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency>

2、加入数据库驱动（mysql）

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

3、在application.properties 中添加数据库以及实体对象包信息

## mybatis config info mybatis.type-aliases-package=com.linkus.uac.dao.po ## datasource config info spring.datasource.driverClassName = com.mysql.jdbc.Driver spring.datasource.url = jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8 spring.datasource.username = root spring.datasource.password = 123qwe!@#

4、配置mapper接口位置信息

@SpringBootApplication @MapperScan("club.isource.dao.mapper") public class App { public static void main( String[] args ) { SpringApplication.run(App.class, args); } }

5、测试

1）建立实体对象UserPo

private String userid; private String username; private String uuid; private String password; private Date lastedloginat; private String lastedloginip; private String isdeleted; private String isuse; private String idcard; private String xm; private String xb; private String email; private String telephone; private Date createtime; private String deptcode; private String gh; private String ereacode; private String parentcode; private String usertype; private String picid;

2）建立测试接口UserInf

public interface UserInf { UserPo selectUserByKey(String userid); }

3）建立xml映射文件UserInf

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" > <mapper namespace="club.isource.dao.mapper.UserInf" > <resultMap id="BaseResultMap" type="club.isource.dao.mapper.po.UserPo" > <id column="USERID" property="userid" jdbcType="VARCHAR" /> <result column="USERNAME" property="username" jdbcType="VARCHAR" /> <result column="UUID" property="uuid" jdbcType="VARCHAR" /> <result column="PASSWORD" property="password" jdbcType="VARCHAR" /> <result column="LASTEDLOGINAT" property="lastedloginat" jdbcType="DATE" /> <result column="LASTEDLOGINIP" property="lastedloginip" jdbcType="VARCHAR" /> <result column="ISDELETED" property="isdeleted" jdbcType="VARCHAR" /> <result column="isuse" property="isuse" jdbcType="VARCHAR" /> <result column="IDCARD" property="idcard" jdbcType="VARCHAR" /> <result column="xm" property="xm" jdbcType="VARCHAR" /> <result column="xb" property="xb" jdbcType="VARCHAR" /> <result column="EMAIL" property="email" jdbcType="VARCHAR" /> <result column="TELEPHONE" property="telephone" jdbcType="VARCHAR" /> <result column="CREATETIME" property="createtime" jdbcType="DATE" /> <result column="DEPTCODE" property="deptcode" jdbcType="VARCHAR" /> <result column="gh" property="gh" jdbcType="VARCHAR" /> <result column="ereacode" property="ereacode" jdbcType="VARCHAR" /> <result column="parentcode" property="parentcode" jdbcType="VARCHAR" /> <result column="usertype" property="usertype" jdbcType="VARCHAR" /> <result column="picid" property="picid" jdbcType="VARCHAR" /> </resultMap> <sql id="Base_Column_List" > USERID, USERNAME, UUID, PASSWORD, LASTEDLOGINAT, LASTEDLOGINIP, ISDELETED, isuse, IDCARD, xm, xb, EMAIL, TELEPHONE, CREATETIME, DEPTCODE, gh, ereacode, parentcode, usertype, picid </sql> <select id="selectUserByKey" resultMap="BaseResultMap" parameterType="java.lang.String"> select <include refid="Base_Column_List" /> from fw_user where USERID = #{userid,jdbcType=VARCHAR} </select> </select> </mapper>