spring jdbctemplate

String sql="insert into th_balance_sheet (id,name)  values(?,?) ";

jdbcTemplate.update(sql,1,"123");

这种方式很简单，但是不易封装。

jdbcTemplate.update(sql, args, argTypes)

String sql

Object[] args 参数

int[] argTypes 类型

//查询对象

final String sql = "select * from th_risk_proportion r left join th_customer t on r.riskId=t.testRisk where t.customerid=? ";
RowMapper<RiskProportionPO> mapper=new BeanPropertyRowMapper<RiskProportionPO>(RiskProportionPO.class);
RiskProportionPO proportionPO = new RiskProportionPO();
proportionPO=jdbcTemplate.queryForObject(sql, mapper,customerid);

//查询少量数据

final String sql = "select * from th_risk_proportion r left join th_customer t on r.riskId=t.testRisk where t.customerid=? ";
final RiskProportionPO proportionPO = new RiskProportionPO();


jdbcTemplate.query(sql, new Object[] { customerid },
new RowCallbackHandler() {
public void processRow(ResultSet rs) throws SQLException {
proportionPO.setRiskId(rs.getString("riskId"));
proportionPO.setRiskName(rs.getString("riskName"));
proportionPO.setLowRisk(rs.getString("lowRisk"));
proportionPO.setlMediumRisk(rs.getString("lMediumRisk"));
proportionPO.setMediumRisk(rs.getString("mediumRisk"));
proportionPO.setmHighRisk(rs.getString("mHighRisk"));
proportionPO.setHighRisk(rs.getString("highRisk"));
}
});