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

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>

4）

 

★ The server time zone value '?й???????' is unrecognized or represents more than one time zone.

使用新版本的mysql驱动发生错误

解决方法：在jdbc url上加入serverTimezone=UTC