mybatis ---- 参数的一些简单使用

￡神魔★判官ぃ 2022-05-26 12:06 176阅读 0赞

由于mybatis会自动将date类型转换为unix long时间eg:1503912320000，而不是时间格式。 我们只需要在其对应的get方法上面添加 @JsonFormat(pattern=”yyyy-MM-dd HH:mm:ss”,timezone = “GMT+8”)  
然后就可以准换位正常的时间格式了

package com.test.entity;
    
    import com.fasterxml.jackson.annotation.JsonFormat;
    
    import java.util.Date;
    
    public class UserTable { 
        private Integer id;
    
        private String username;
    
        private String password;
    
        private String phone;
    
        private Date creationtime;
    
        public UserTable(Integer id, String username, String password, String phone, Date creationtime) {
            this.id = id;
            this.username = username;
            this.password = password;
            this.phone = phone;
            this.creationtime = creationtime;
        }
    
        public UserTable() {
            super();
        }
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username == null ? null : username.trim();
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password == null ? null : password.trim();
        }
    
        public String getPhone() {
            return phone;
        }
    
        public void setPhone(String phone) {
            this.phone = phone == null ? null : phone.trim();
        }
    
        @JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")
        public Date getCreationtime() {
            return creationtime;
        }
    
        public void setCreationtime(Date creationtime) {
            this.creationtime = creationtime;
        }
    
        @Override
        public String toString() {
            return "UserTable{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    ", phone='" + phone + '\'' +
                    ", creationtime=" + creationtime +
                    '}';
        }
    }

package com.test.dao;
    
    import com.test.entity.UserTable;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    public interface UserTableMapper { 
    
        // 查询所有
        List<UserTable> getAll();
    
        // 根据 id 查询
        UserTable get(Integer id);
    
        // 批量删除
        int batchDelete(Integer[] newsId);
    
        // 添加
        int save(UserTable serviceTable);
    
        // 添加2
        int save2(UserTable serviceTable);
    
        // 修改
        int update(UserTable serviceTable);
    
    
        // 分页
        // @Param：多个参数的话需要给参数进行命名,不然的话mybatis识别不出来你对应的是哪一个
        List<UserTable> getPager(@Param("page") Integer page, @Param("limit") Integer limit, @Param("username") String username);
    }

<?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="com.test.dao.UserTableMapper" >
    
      
      <sql id="Base_Column_List" >
        id, username, password, phone, creationTime
      </sql>
    
      
      <select id="get" resultType="UserTable" parameterType="java.lang.Integer" >
        select 
        <include refid="Base_Column_List" />
        from user_table
        where id = #{id}
      </select>
    
      
      <select id="getAll" resultType="UserTable">
        SELECT
        <include refid="Base_Column_List" />
        FROM user_table
      </select>
    
      
      <delete id="batchDelete">
        DELETE FROM user_table WHERE id in
        <foreach collection="array" item="item" separator="," open="(" close=")">
          #{item}
        </foreach>
      </delete>
    
      
      <insert id="save" parameterType="com.test.entity.UserTable" >
        insert into user_table (username, password, phone, creationTime)
        values (#{username}, #{password}, #{phone}, #{creationtime,jdbcType=DATE})
      </insert>
    
      
      <insert id="save2" parameterType="com.test.entity.UserTable" >
        insert into user_table
        <trim prefix="(" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            id,
          </if>
          <if test="username != null" >
            username,
          </if>
          <if test="password != null" >
            password,
          </if>
          <if test="phone != null" >
            phone,
          </if>
          <if test="creationtime != null" >
            creationTime,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            #{id},
          </if>
          <if test="username != null" >
            #{username},
          </if>
          <if test="password != null" >
            #{password},
          </if>
          <if test="phone != null" >
            #{phone},
          </if>
          <if test="creationtime != null" >
            #{creationtime,jdbcType=DATE},
          </if>
        </trim>
      </insert>
    
    
      <update id="update" parameterType="com.test.entity.UserTable" >
        update user_table
        <set >
          <if test="username != null" >
            username = #{username},
          </if>
          <if test="password != null" >
            password = #{password},
          </if>
          <if test="phone != null" >
            phone = #{phone},
          </if>
          <if test="creationtime != null" >
            creationTime = #{creationtime},
          </if>
        </set>
        where id = #{id}
      </update>
    
      
      <select id="getPager" resultType="UserTable">
        select
        <include refid="Base_Column_List" />
        from user_table
        <where>
          <if test="username!=null">username like "%"#{username}"%"</if>
        </where>
        ORDER BY creationTime DESC
        LIMIT #{page} ,#{limit}
      </select>
    
    </mapper>

上面所写的也就只是自己的一些见解，不一定全对，但是上面代码我都已经经过测试通过，可能有些细节方面的话大家还是要看具体的需求，使用前可以先做测试