批量修改(前提要改都改)

批量修改(前提要改都改) 

<form action="/pams/updateAction.shtml?ation=update" method="post" οnsubmit="return check()">
<table>
 <tr>
   <td>选择</td>
   <td>是/否</td>
 </tr>
 <tr>
   <logic:notEmpty name="ipList">
       <logic:iterate id="itm" name="ipList">
        <tr align="center" height="25">
        
         <td class="tab1" valign="bottom">
         
          <logic:equal name="itm" property="UNDEBIT_FLG" value="1">
           <input type="checkbox" name="ar_id" value="<bean:write name="itm" property="ar_id"/>" checked="true">
          </logic:equal>
          
          <logic:equal name="itm" property="UNDEBIT_FLG" value="0">
           <input type="checkbox" name="ar_id" value="<bean:write name="itm" property="ar_id"/>">
          </logic:equal>
          
          //有隐藏的形式（所有ARID的集合）
          <input name="allarid" type="hidden" class="btn_2" value="<bean:write name="itm" property="ar_id"/>"> 
         </td>
         
         <td class="tab1" valign="bottom">
          <logic:equal name="itm" property="NOENT_FLG" value="1">是</logic:equal>
          <logic:equal name="itm" property="NOENT_FLG" value="0">否</logic:equal>
         </td>
         
        </tr>
       </logic:iterate>
    </logic:notEmpty>    
 </tr>
 
 <tr>
   <td align="left" valign="middle" height="28">
    <input name="button3" type="button" class="btn_2" value="全选" οnclick=selectAll()>
    <input name="submit" type="submit" class="btn_2" value="修改无贷款户标志">
   </td>
 </tr>
</table>
</form>

<script language="javascript">

function selectAll(){
 var ChkEls=document.getElementsByName("ar_id");
 if(ChkEls.length!=0){
  var count = 0;
  for(var i=0;i< ChkEls.length;i++){
   var oEl = ChkEls.item(i);
    if (oEl.status==true){
     count ++ ;
    }
  }
  if(count==ChkEls.length){
    for(var i=0;i< ChkEls.length;i++){
   var oEl = ChkEls.item(i);
   oEl.status=false;
   }
  }else {
    for(var i=0;i< ChkEls.length;i++){
   var oEl = ChkEls.item(i);
   oEl.status=true;
   }
  }
 }
}

function check(){
 var ChkEls=document.getElementsByName("ar_id");
 if(ChkEls.length==0){
  alert("需要选择修改的记录!");
  return false;
 }
 return true;
}
function back_qer(){
location.href = '<%=request.getAttribute("return")%>';
}
</script>
  
  
=========================================Action=============================================
public ActionForward update(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

        // 机构号
  String contain = request.getParameter("contain");
  //单个部门号
  String instno_Id[] = request.getParameterValues("instno_Id");
  String id = "";
  
  //机构----部门的所有号
  String instnoId[] = request.getParameterValues("instnoId"); // 隐藏
  String all_id = "";
  String sql = null;

  if (instno_Id != null && instno_Id.length > 0) {
   for (int i = 0; i < instno_Id.length; i++) {
    id = id + instno_Id[i];
    if (i != instno_Id.length - 1) {

     id = id + "','";
    }
   }
   // 将对认定标志修改为1
   sql = "update PAMS.ORG_MERCANT set MERCANT = '1' where instno in ('"
     + id + "')";
   if (dao.update(sql) == 0) {
    request.setAttribute("info", "对部门认定修改失败,请重新操作!");
   }
  }
  // 格式化返回页所有的instnoId
  for (int i = 0; i < instnoId.length; i++) {
   all_id = all_id + instnoId[i];
   if (i != instnoId.length - 1) {
    all_id = all_id + "','";
   }
  }
  
  // 将部门认定标志修改为0
  String sql2 = "update PAMS.ORG_MERCANT set MERCANT = '0' where instno in ('"
    + all_id + "')";
  
  if (instno_Id != null && instno_Id.length > 0) {
   sql2 = sql2 + "and instno not in ('" + id + "')";
  }
  if (dao.update(sql2) == 0) {
   request.setAttribute("info", "对部门认定修改失败,请重新操作!");
  }
  request.setAttribute("info", "对部门认定修改标志修改成功!");
  //跳转到上面的那个方法来显示
  request.setAttribute("result", "/pams/OrgMercant.shtml?action=OrgMercantlist&asptorgidt=" + contain);
  return mapping.findForward("result");
  
  
==============================DAO============================
public int update(String sql){
     
     Connection con = null;
     ResultSet rs = null;
     Statement stmt = null;
  Session session = getSession();
  int totalrows = 0;
  try {
   
   con=session.connection();
   stmt=con.createStatement();
   stmt.executeUpdate(sql);
   stmt.close();
   con.close();
  } catch (Exception re) {
   log.error("UNDEBIT_FLG_UPDATE failed", re);
   return (int) 0;
  }finally{
   session.close();
  }
  return 1;//返回正常
    }    
   
   
 ========================================参考资料语句Action==========================
 public ActionForward update(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

  String newvalue = request.getParameter("newvalue");
  String id = request.getParameter("id");
  String opid = UserSession.getCurrentUserID(request.getSession());
  String pageno = request.getParameter("ctlPageNo");
  String urlParam = "&pageNo=" + CFormat.forbidNull(pageno);
  try {
   Double value = null;
   if(!CFormat.isEmpty(newvalue))
    value=Double.valueOf(newvalue.trim());

   if (!CFormat.isEmpty(id)) {
    ParamAgreedep p = (ParamAgreedep) this.dao
      .findById(ParamAgreedep.class, id);
    
    p.setFactrate(value);
    p.setInputdate(DateTimeUtil.getDateString(DateTimeUtil
      .getSqlDate(new java.util.Date()), "yyyyMMdd"));
    p.setUserid(opid);

    this.dao.attachDirty(p);
    request.setAttribute("info", "修改参数成功！");
   }
  } catch (NumberFormatException nfe) {
   request.setAttribute("info", "您输入了不合法的新参数值！");
   request.setAttribute("historyBack", "true");
  } catch (Exception ex) {
   request.setAttribute("info", "修改参数失败，请重试！");
   request.setAttribute("historyBack", "true");
  }
  request.setAttribute("result",
    "/pams/xycksjll.shtml?action=list"+urlParam);
  return mapping.findForward("result");
 }
 
 
============================DAO==============

public Object findById(Class clazz, String key) {
      log.debug("getting Object instance with id: " + key);
     
      Object instance = null;
      try {                
       instance = getHibernateTemplate().get(clazz,key); 

          return instance;
      } catch (RuntimeException re) {
          log.error("get failed", re);
          throw re;
      }
}

public boolean attachDirty(Object instance) {
        log.debug("attaching dirty Object instance");
        boolean ok= false;      
        try {       
            getHibernateTemplate().update(instance);
            ok=true;
            log.debug("attach successful");
        } catch (RuntimeException re) {
            log.error("attach failed", re);
            throw re;
        }
        return ok;
    }