jdbcTemplate.update("insert into useinfo(cardNo, boxNo) values(?, ?)", "1541819172", ""+ 6);
注意,必须是update方法。字符串填充也是很常规的。
查询
jdbcTemplate.query("select * from useinfo where cardNo=?", new Object[] {req.getCardNo()},
new RowCallbackHandler() {
@OverridepublicvoidprocessRow(ResultSet res) throws SQLException {
System.out.println(res.getString("cardNo"));
}
});