springboot mybatis 创建、更新时间戳

---

mybatis 创建、更新时间戳

 

 

*********************

示例

 

*****************

pojo 层

 

Book

@Table(name = "book")
public class Book implements Serializable {
    @Id
    @GeneratedValue(generator = "JDBC")
    private Integer id;

    private String name;

    @Column(name = "create_time")
    private Timestamp createTime;

    @Column(name = "update_time")
    private Timestamp updateTime;

    。。。。

}

 

*****************

dao 层

 

BookMapper

public interface BookMapper extends Mapper<Book> {

    void save(@Param("book") Book book);
}

 

*****************

mapper 文件

 

BookMapper.xml

  <insert id="save" parameterType="book">
    insert into book(id,name) values(#{book.id},#{book.name});
  </insert>

 

*****************

controller 层

 

BookController

@RestController
public class BookController {

    @Autowired
    private BookMapper bookMapper;

    @RequestMapping("/save")
    public String save(){
        Book book=new Book();
        book.setId(1);
        book.setName("瓜田李下");

        bookMapper.save(book);

        return "success";
    }

    @RequestMapping("/update")
    public Book update(){
        Book book=bookMapper.selectByPrimaryKey(1);
        book.setName("海贼王");
        book.setUpdateTime(null);

        bookMapper.updateByPrimaryKeySelective(book);

        return bookMapper.selectByPrimaryKey(book.getId());
    }
}

 

 

*********************

插入更新测试