private int id; private String name; private int age; private String sex; public Person() { } public Person(int id, String name, int age, String sex) { this.id = id; = name; this.age = age; this.sex = sex; } @S
public String getResult(ResultSet rs, String columnName) throws SQLException { String result = rs.getString(columnName); ("读取string参数1[" + result + "]"); return result; } @Override public String getResult(ResultSet rs, int columnIndex) throws SQLException { String result = rs.getStrin...
(name, age) values (#{name}, #{age})") int insert(User user); @Update("update user set name = #{name} where id = #{id}") int updateNameById(@Param("id") Long id, @Param("name") String name); @Delete("delete from user where id = #{id}") int deleteById(@Param("id"...
ASSIGN_ID) private String id; private String name; private Integer price; private Integer num; private String image; private String images; private Date createTime; private Date updateTime; private String spuId; private Integer categoryId; private String categoryName; private Integer brandId; ...
public interface TypeHandler<T> {/*** 入库前的类型转换*/void setParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException;/*** 得到结果。* 查询后的数据处理*/T getResult(ResultSet rs, String columnName) throws SQLException;T getResult(ResultSet rs...
@Data public class User { private Long id; private String name; private Integer age; private String email; } 查看编译结果 Lombok使用参考: https://blog.csdn.net/motui/article/details/79012846 3、mapper 创建包 mapper 编写Mapper 接口: UserMapper.java public interface UserMapper extends BaseMapper<...
@Param("cm")Map<String,Object>var1);intdelete(@Param("ew")Wrapper<T>var1);intdeleteBatchIds...
int deleteById(Serializable var1); int deleteByMap(@Param("cm") Map<String, Object> var1); int delete(@Param("ew") Wrapper<T> var1); int deleteBatchIds(@Param("coll") Collection<? extends Serializable> var1); int updateById(@Param("et") T var1); ...
(); HashMap<String, TableNameHandler> map = new HashMap<>(); // 对于user2表,进行动态表名设置 map.put("user2", (sql, tableName) -> { String _ = "_"; int random = new Random().nextInt(2) + 1; return tableName + _ + random; // 若返回null, 则不会进行动态表名替换, ...
privateString name; /** * 备注。 */ privateString note; publicvoidsetId(Integer id) { this.id = id; } publicInteger getId() { returnid; } publicvoidsetName(String name) { this.name = name; } publicString getName() { returnname; ...