jqGrid分页技术学习（三）spring jdbc 通用DAO——添加一条记录_jqgrid分页实现追加一条数据-优快云博客

本文介绍了一个基于Java的分页表单增删改查实现方案，包括了三个核心类：TablePagingController负责处理客户端请求，TablePagingDao进行数据库操作，InvHeader作为传输对象。

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

InvHeader是传输对象；

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

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

InvHeader类：

public class InvHeader implements 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 TablePagingController extends AbstractController { ...... String strOper = request.getParameter("oper"); if (strOper != null && strOper.length() > 0) { if (strOper.equals("add")) { // oper:add // id:_empty String 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:_empty data.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 TablePagingDao extends 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; } ......