用户表sys_user8:
CREATE TABLE `sys_user8` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_name` VARCHAR(50) DEFAULT NULL,
`birthday` DATE DEFAULT NULL,
`salary` DECIMAL(8,2) DEFAULT NULL,
`address` VARCHAR(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB CHARSET=utf8;
INSERT INTO `sys_user8` VALUES(1, '陈三', '1992-02-29', 123456.78, '深圳市南山区');
INSERT INTO `sys_user8` VALUES(2, '张三', '1990-03-05', 8500, '深圳市宝安区');
INSERT INTO `sys_user8` VALUES(3, '李三', '1991-05-23', 123326.1, '深圳市福田区');
INSERT INTO `sys_user8` VALUES(4, '赵四', '1988-09-15', 8000, '深圳市龙华新区');
实体类SysUser8
public class SysUser8 {
private int id;
private String userName;
private Date birthday;
private Double salary;
private String address;
//...省略setter、getter方法
public String toString(){
return "SysUser8 [id = " + id + ", userName = " + userName + ", birthday = " + birthday + ", salary = " + salary + ", address = " + address + "]";
}
}
接口SysUser8Dao
public interface SysUser8Dao {
public List<SysUser8> getUser1(String userName, Date birthday, Double salary);
public List<SysUser8> getUser2(Map paramMap);
public List<SysUser8> getUser3(@Param("userName")String userName, @Param("birthday")Date birthday, @Param("salary")Double salary);
public List<SysUser8> getUser4(@Param("userName")String userName, @Param("birthday")Date birthday, @Param("salary")Double salar