1.1 项目目录
1.2 代码示例
客户实体类
package cn.guardwhy.domain;
/**
* 客户实体类
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Customer {
// 成员变量
private Long custId;
private String custName;
private String custSource;
private String custIndustry;
private String custLevel;
private String custAddress;
private String custPhone;
}
结果集映射
package cn.guardwhy.resources;
import cn.guardwhy.domain.Customer;
import org.springframework.jdbc.core.RowMapper;
import java.sql.ResultSet;
import java.sql.SQLException;
public class CustomerRowMapper implements RowMapper<Customer> {
/**
* 结果集映射的方法:
* 结果集中的每一行记录,都会调用一次该方法
*/
public Customer mapRow(ResultSet rs, int index) throws SQLException{
// 创建客户对象
Customer customer = new Customer();
customer.setCustId(rs.getLong("cust_id"));
customer.setCustName(rs.getString("cust_name"));
customer.setCustSource(rs.getString("cust_source"));
customer.setCustIndustry(rs.getString("cust_industry"));
customer.setCustLevel(rs.getString("cust_level")