jqGrid分页技术学习（三）spring jdbc 通用DAO——添加一条记录

编写了三个主要的类：TablePagingController，TablePagingDao，InvHeader

InvHeader是传输对象；

TablePagingDao是数据库操作的Data Access Object，是数据处理层；

TablePagingController是负责解析客户端调用Servlet的解析、处理类，是业务逻辑层。

 

InvHeader类：

public class InvHeaderimplements Serializable{private int id; private String invdate;private int client_id;private float amount;private float tax;private float total;private String closed;private String ship_via;private String note;}

 

TablePagingController解析增加一条记录的操作：

public class TablePagingControllerextends AbstractController{......String strOper = request.getParameter("oper");if (strOper != null && strOper.length() > 0) {if (strOper.equals("add")) { // oper:add// id:_emptyString strClientId = request.getParameter("client_id");int clientId = Integer.parseInt(strClientId);logger.info("Res-Host request client_id=[" + clientId + "]");String invdate = request.getParameter("invdate");logger.info("Res-Host request invdate=[" + invdate + "]");String closed = request.getParameter("closed");logger.info("Res-Host request closed=[" + closed + "]");String ship_via = request.getParameter("ship_via");logger.info("Res-Host request ship_via=[" + ship_via + "]");String note = request.getParameter("note");logger.info("Res-Host request note=[" + note + "]");String strAmount = request.getParameter("amount");float amount = Float.parseFloat(strAmount);logger.info("Res-Host request amount=[" + amount + "]");String strTax = request.getParameter("tax");float tax = Float.parseFloat(strTax);logger.info("Res-Host request tax=[" + tax + "]");String strTotal = request.getParameter("total");float total = Float.parseFloat(strTotal);logger.info("Res-Host request total=[" + total + "]");InvHeader data = new InvHeader();data.setId(0); // id:_emptydata.setInvdate(invdate);data.setClient_id(clientId);data.setAmount(amount);data.setTax(tax);data.setTotal(total);data.setClosed(closed);data.setShip_via(ship_via);data.setNote(note);final boolean b = this.getDao().add(data);model.put("JSON_OBJECT", b);......

 

TablePagingDao的增加一条记录的操作：

public class TablePagingDaoextends JdbcDaoSupport{....../** * 添加一个对象. * * @param data * :InvHeader * @return true/false */public boolean add(final InvHeader data){JdbcTemplate jdbcTemplate = this.getJdbcTemplate();String sql = "INSERT INTO invheader (invdate, client_id, amount, tax, total, closed, ship_via, note)"+ " VALUES (?, ?, ?, ?, ?, ?, ?, ?)";jdbcTemplate.update(sql, new PreparedStatementSetter(){public void setValues(PreparedStatement ps)throws SQLException{ps.setString(1, data.getInvdate());ps.setInt(2, data.getClient_id());ps.setFloat(3, data.getAmount());ps.setFloat(4, data.getTax());ps.setFloat(5, data.getTotal());ps.setString(6, data.getClosed());ps.setString(7, data.getShip_via());ps.setString(8, data.getNote());}});return true;}......