07-pringboot整合Mybatis

Springboot整合Mybatis

1、导包

• jdbc sql
• jdbc drvier

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
 <dependency>
     <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <scope>runtime</scope>
</dependency>
 <!-- mybatisr -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
</dependency>

2、配置

• 配置数据源
• 配置Mybatis

# 数据源的设置
spring.datasource.username=root
spring.datasource.password=245631
spring.datasource.url=jdbc:mysql://localhost:3306/xd_ssm1?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# 整合Mybatis
mybatis.type-aliases-package=com.xd.pojo
#设置mapper路径
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
#设置字段驼峰命名
mybatis.configuration.map-underscore-to-camel-case=true

3、编写接口函数

@Mapper
@Repository   
public interface UserMapper {

    List<User> findAll();

    User findUserById(Integer id);

    void addUser(User user);

    void updateUser(User user);

    void deleteUser(Integer id);
}

4、写mapper

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xd.mapper.UserMapper">
    <select id="findAll" resultType="User">
        select * from `user`
    </select>
    <select id="findUserById" resultType="User" parameterType="int">
        select * from `user` where user_id=#{id}
    </select>
    <insert id="addUser" parameterType="User">
        insert into `user`(user_id,user_name,user_sex,user_phone,user_email,user_address,
        user_join_time,user_update_time,user_status,delete_status) values
        (#{userId},#{userName},#{userSex},#{userPhone},#{userEmail},#{userAddress},
        #{userJoinTime},#{userUpdateTime},#{userStatus},#{daleteStatus})
    </insert>
    <update id="updateUser" parameterType="User">
        update `user`
        <set>
            <if test="userName !=null">user_Name=#{userName},</if>
            <if test="userSex !=null">user_Sex=#{userSex},</if>
            <if test="userPhone !=null">user_Phone=#{userPhone},</if>
            <if test="userEmail !=null">user_Email=#{userEmail},</if>
            <if test="userAddress !=null">user_Address=#{userAddress},</if>
            <if test="userJoinTime !=null">user_Join_Time=#{userJoinTime},</if>
            <if test="userUpdateTime !=null">user_Update_Time=#{userUpdateTime},</if>
            <if test="userStatus !=null">user_Status=#{userStatus},</if>
            <if test="deleteStatus !=null">delete_Status=#{deleteStatus},</if>
        </set>
        where  user_id = #{userId}
    </update>
    <delete id="deleteUser" parameterType="int">
        delete from `user` where user_id = #{id}
    </delete>
</mapper>