@Mapper
public interface UserDao extends BaseDao<UserDao> {
  /** 分頁查詢 */
  @Select("select * from t_user limit #{page.currentPage}, #{page.pageSize}")
  List<UserPO> listByPage(@Param("page") Page page);
  /** 根據(jù)id查詢 */
  @Select("select * from t_user where id = #{id}")
  Optional<UserPO> getById(Serializable id);
  /** 單個插入 */
  @Insert("insert into t_user(id, name, gender, birthday, address, create_time, update_time) values(#{id}, #{name}, #{gender}, #{birthday}, #{address}, #{createTime}, #{updateTime})")
  void save(UserPO po);
  /** 批量插入 */
  @Insert("<script>insert into t_user(id, name, gender, birthday, address, create_time, update_time) values "
    + "<foreach collection='list' index='index' item='n' separator=','> "
    + "(#{n.id}, #{n.name}, #{n.gender}, #{n.birthday}, #{n.address}, #{n.createTime}, #{n.updateTime})"
    + "</foreach></script>")
  void saveBatch(@Param("list") List<UserPO> list);
  /** 更新 */
  @Update("update t_user set id = #{id}, name = #{name}, gender = #{gender}, birthday = #{birthday}, address = #{address}, create_time = #{createTime}, update_time = #{updateTime} where id = #{id}")
  void update(UserPO po);
  /** 單個刪除 */
  @Delete("delete from t_user where id = #{id}")
  void remove(Serializable id);
  /** 批量刪除 */
  @Delete("<script>delete from t_user where id in "
    + "<foreach collection='ids' index='index' item='id' open='(' separator=',' close=')'>"
    + "#{id}"
    + "</foreach></script>")
  void removeByIds(@Param("ids") Set<Serializable> ids);
  /** 統(tǒng)計 */
  @Select("select count(*) from t_user")
  int count();
}

# MySQL 連接配置
mysql.datasource.driver-class-name=com.mysql.jdbc.Driver
mysql.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&useSSL=false
mysql.datasource.username=root
mysql.datasource.password=
# 表前綴，生成類時會去掉這個前綴
mysql.datasource.table.prefix=t_
# 是否要生成 PO
java.model.enable=true
# PO 包路徑
java.model.package=com.xxx.po
# PO 類文件生成路徑，"/"結(jié)尾
java.model.src.folder=E:/CODE/github/po/
# PO 類文件前綴
java.model.prefix=
# PO 類文件后綴
java.model.suffix=PO
# 是否要生成 DAO
java.dao.enable=true
# DAO 包路徑
java.dao.package=com.xxx.dao
# DAO 類文件生成路徑，"/"結(jié)尾
java.dao.src.folder=E:/CODE/github/dao/
# DAO 類文件前綴
java.dao.prefix=
# DAO 類文件后綴
java.dao.suffix=Dao

├─dao
│   BaseDao.java
│   StudentDao.java
│   UserDao.java
│
└─po
    Page.java
    StudentPO.java
    UserPO.java