from t_admin
and id = #{id}
and username = #{username}
and password = #{password}
and name = #{name}
and sex = #{sex}
limit #{pageable.offset}, #{pageable.pageSize}
select count(1)
from t_admin
and id = #{id}
and username = #{username}
and password = #{password}
and name = #{name}
and sex = #{sex}
insert into t_admin(username, password, name, sex)
values (#{username}, #{password}, #{name}, #{sex})
insert into t_admin(username, password, name, sex)
values
(#{entity.username}, #{entity.password}, #{entity.name}, #{entity.sex})
insert into t_admin(username, password, name, sex)
values
(#{entity.username}, #{entity.password}, #{entity.name}, #{entity.sex})
on duplicate key update
username = values(username),
password = values(password),
name = values(name),
sex = values(sex)
update t_admin
username = #{username},
password = #{password},
name = #{name},
sex = #{sex},
where id = #{id}
delete from t_admin where id = #{id}
5、自动生成的dao层
**
-
(TAdmin)表数据库访问层
-
@author 程序员小王
-
@since 2021-12-26 21:07:15
*/
public interface TAdminDao {
/**
-
通过ID查询单条数据
-
@param id 主键
-
@return 实例对象
*/
TAdmin queryById(Integer id);
/**
-
统计总行数
-
@param tAdmin 查询条件
-
@return 总行数
*/
long count(TAdmin tAdmin);
/**
-
新增数据
-
@param tAdmin 实例对象
-
@return 影响行数
*/
int insert(TAdmin tAdmin);
/**
-
批量新增数据(MyBatis原生foreach方法)
-
@param entities List 实例对象列表
-
@return 影响行数
*/
int insertBatch(@Param(“entities”) List entities);
/**
-
批量新增或按主键更新数据(MyBatis原生foreach方法)
-
@param entities List 实例对象列表
-
@return 影响行数
-
@throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常,请自行校验入参
*/
int insertOrUpdateBatch(@Param(“entities”) List entities);
/**
-
修改数据
-
@param tAdmin 实例对象
-
@return 影响行数
*/
int update(TAdmi