public void update(HttpServletRequest request, HttpServletResponse response) throws Exception {
   Province province = new Province(db);
   bindForm(province);
   province = province.update();
   if (province != null) {
     request.setAttribute("province", province);
     formHandler.setFormMessage("Update Completed");
   } else {
     formHandler.setFormMessage("Update Failed");
   }
   forward("?page=/web/provinceEdit.jsp");
 }
 public void create(HttpServletRequest request, HttpServletResponse response) throws Exception {
   Province province = new Province(db);
   bindForm(province);
   province = province.create();
   if (province != null)
     formHandler.setFormMessage(
         "Create Completed ,view <a href='process2?action=Province&cmd=view&id="
             + province.getId()
             + "' target='_blank'>new Record</a>");
   else formHandler.setFormMessage("Create Not Complete");
   redirect("process2?action=Province&cmd=add");
 }
 // update
 public void edit(HttpServletRequest request, HttpServletResponse response) throws Exception {
   String id = request.getParameter("id");
   if (id != null && !id.trim().equals("")) {
     Province province = new Province(db);
     province = province.findByPk(new Long(id));
     if (province != null) {
       request.setAttribute("province", province);
     } else {
       formHandler.setFormMessage("Error : Not Found with id " + id);
     }
   }
   forward("?page=/web/provinceEdit.jsp");
 }
 // delete
 public void delete(HttpServletRequest request, HttpServletResponse response) throws Exception {
   String[] ids = request.getParameterValues("id");
   if (ids != null && ids.length > 0) {
     Province province = new Province(db);
     List<Long> idList = new ArrayList<Long>();
     for (int i = 0; i < ids.length; i++) idList.add(new Long(ids[i]));
     int deleteRow = province.deleteByPks(idList);
     formHandler.setFormMessage(" Delete " + deleteRow + " Row Completed ");
   } else {
     formHandler.setFormMessage("Plese Select At Least One For Delete");
   }
   redirect("process2?action=Province&cmd=list");
 }
  // list
  public void list(HttpServletRequest request, HttpServletResponse response) throws Exception {
    Province province = new Province(db);
    // pageUtil.setPageSize(15);
    Integer totalRow = province.countAll();

    // set TotalRow
    pageUtil.setTotalRow(totalRow);
    List<Province> provinces = province.findAll(pageUtil);

    //	for data to display
    request.setAttribute("provinces", provinces);

    //	for screen to show
    forward("?page=/web/provinceList.jsp");
  }