java-toUpdate 或是 toAdd 到页面结合JS显示指定id的数据

jsp 在对页面某条数据进行更新时，首先要跳转到更新的页面，更新的页面会显示出这条数据的信息（一般是把该数据的ID传到后台方法中进行处理），对这些信息进行修改后点击更新按钮，成功的话则更新操作完成。

下面的代码涉及到更新操作和增加操作，框架是springmvc+jsp。其中也有通过js实现单选框和下拉式列表选中某项值的具体操作代码。

作为学习的一种参考！！

下拉式列表jsp页面：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

   .......

      <script>
      
      var ;
      //根据ID获得服务信息
      function getServerInfo()
      {
      	var para={};
      	para.id=id;
      	
      	$.ajax("operation/monitor/getjson?action=getinfo",{
      	async:true,
      	cache:false,
      	success : function(data, textStatus, jqXHR) {
if (textStatus == "success") {
try {
if (data.success) {
getinfores(data);
} else {
jAlert("getinfo.error1:" + data.message);
}
} catch (e) {
jAlert("getinfo.error2:" + e.message);
}
}
},
dataType : "json",
data : para,
type : "post",
processData : true
}).error(function() {
jAlert("getinfo.error3");
});	
    }
    //给页面的文本框赋值
    function getinfores(data)
    {
    	var rows = data.rows;
    	
    	if(rows.length >0)
    	{
    	
    	$("#server_name").val(rows[0].server_name);
    	$("#server_ip").val(rows[0].server_ip);
    	
    	var status =rows[0].server_role_name;
  	//下拉式列表选中指定项
            $("#role option").each(function () {
                if (this.value == status) {
                    this.selected = "selected";                
                }
            });
   
    	}
    } 
      //页面加载时调用函数        
      $(function()
      {
      	getServerInfo();
      });
      
     //更新服务器信息
    function updateinfo()
    {
    	$("#btnsubmit").attr('disabled',"true");
    	
    	setTimeout('$("#btnsubmit").removeAttr("disabled");', 5000);
    
    	var para = {};
    	para.id=id;
    	para.server_name = $("#server_name").val();
    	para.server_ip = $("#server_ip").val();
    	para.server_role = $("#role").val();
    
        $.ajax("operation/monitor/getjson?action=update", {
async : false,
cache : false,
success : function(data, textStatus, jqXHR) {
if (textStatus == "success") {
try {
if (data.success) {
jAlert("操作成功");
document.location='<%=basePath%>operation/monitor';
} else {
jAlert("updateinfo.error1:" + data.message);
}
} catch (e) {
jAlert("updateinfo.error2:" + e.message);
}
}
},
dataType : "json",
data : para,
type : "post",
processData : true
}).error(function() {
jAlert("update.error3");
});	
    }
   
    </script>  
</head>

<body>   
<!-- 菜单功能 -->
    <%@include file="../left.jsp"%>
    <div class="rightWapper">
    	 <!--顶部 -->
    <%@include file="../../../common/header.jsp"%>
        <div class="content-header">
        	<p>监控管理</p>
        </div>
        <div class="webAdd">
        	<h1>服务器编辑</h1>
            <ul>
            	<li><span>服务器名称：</span><input type="text" name="server_name"   /></li>
                <li><span>服务器IP：</span><input type="text" name="server_ip"   /></li>
                <li><span>服务器角色：</span>
                	<select name="role" >
<option value="采集服务器">采集服务器</option>
                <option value="任务调度服务器">任务调度服务器</option>
                <option value="负载均衡服务器">负载均衡服务器</option>
                <option value="Web应用服务器">Web应用服务器</option>
                <option value="分析服务器">分析服务器</option>
                <option value="数据库服务器">数据库服务器</option>
                <option value="缓存数据器">缓存数据器</option>
                <option value="其他服务器">其他服务器</option>
                	</select>
                </li>
             </ul>
            <div class="netBtnBox">
            	<input  />
                <input type="button" value="取消" class="btn-default" onclick="document.location='<%=basePath%>operation/monitor'"  />
            </div>
        </div>   
    </div>    
    <!--底部 -->
     <%@include file="../../../common/footer.jsp"%> 
</body>
</html>



单选框的选中某项处理：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

.......  
    
      <script>
      var id = "${id}";
    function getinfo()
    {
        var para = {};
        
        para.id = id;
        
        $.ajax("operation/antiMonitor/getjson?action=getinfo", {
async : true,
cache : false,
success : function(data, textStatus, jqXHR) {
if (textStatus == "success") {
try {
if (data.success) {
getinfores(data);
} else {
jAlert("getinfo.error1:" + data.message);
}
} catch (e) {
jAlert("getinfo.error2:" + e.message);
}
}
},
dataType : "json",
data : para,
type : "post",
processData : true
}).error(function() {
jAlert("getinfo.error3");
});    
    }
    
    function getinfores(data)
    {
        var rows = data.rows;
        
        if(rows.length >0)
        {
        
        $("#ip").val(rows[0].ip);
        $("#type").val(rows[0].type);
        
     //处理单选框
        var status = data.rows[0].status;
            $("[name='status']").each(function () {
                if (this.value == status) {
                    this.checked = true;
                }
            });
        }
    }
    function saveinfo()
    {
        $("#btnsubmit").attr('disabled',"true");
        
        setTimeout('$("#btnsubmit").removeAttr("disabled");', 5000);
    
        var para = {};
        para.id = "${id}";
        para.ip = $("#ip").val();
        para.type = $("#type").val();
        
        para.status = "";
        $("input:checked[name='status']").each(function () {
            para.status = this.value;
        });
        
        
        $.ajax("operation/antiMonitor/getjson?action=update", {
　　　　 async : false,
　　　　 cache : false,
　　　　 success : function(data, textStatus, jqXHR) {
   if (textStatus == "success") {
     try {
if (data.success) {
jAlert("操作成功");
document.location='<%=basePath%>operation/antiMonitor';
} else {
jAlert("saveinfo.error1:" + data.message);
}
} catch (e) {
jAlert("saveinfo.error2:" + e.message);
}
}
},
dataType : "json",
data : para,
type : "post",
processData : true
}).error(function() {
jAlert("saveinfo.error3");
});    
    }
    
    $(function() {
        getinfo();

     });
    </script>  
    
</head>

<body>   

    <!-- 菜单功能 -->
    <%@include file="../left.jsp"%>
    <div class="rightWapper">
         <!--顶部 -->
    <%@include file="../../../common/header.jsp"%>
    <div class="content-header">
            <p>反监控管理</p>
        </div>
        <div class="webAdd">
            <h1>修改代理IP</h1>
            <ul>
                <li><span>代理IP：</span><input  /></li>
                <li><span>状态：</span><input type="radio" name="status" value="1" />启用<input type="radio" name="status" value="0" />未启用</li>
                <li><span>类型：</span>
                    <select >
                    <option value="1">国内</option>
                    <option value="2">国外</option>
                    </select>
                </li>
            </ul>
            <div class="netBtnBox">
                <input  />
                <input type="button" value="取消" class="btn-default" onclick="document.location='<%=basePath%>operation/antiMonitor'"  />
            </div>
        </div>   
    </div>    
    <!--底部 -->
     <%@include file="../../../common/footer.jsp"%> 
</body>
</html>
 
 
 
controller 类：
 
 /**
  * 查询json数据
  * @param map
  * @param request
  * @return
  */
 @RequestMapping("/getjson")
 public String getjson(ModelMap map, HttpServletRequest request)
 {
  try
  {
   String straction = request.getParameter("action").toLowerCase();
 
   HashMap<String, Object> res;
   if("add".toLowerCase().equals(straction))
   {
    //添加
    service.add(request);
   
    res = new HashMap<String, Object>();
    res.put("success", true);
    res.put("message", "ok");
   }else if("update".toLowerCase().equals(straction))
   {
    //保存
    service.update(request);
   
    res = new HashMap<String, Object>();
    res.put("success", true);
    res.put("message", "ok");
   }else if("del".toLowerCase().equals(straction))
   {
    //删除
    service.del(request);
   
    res = new HashMap<String, Object>();
    res.put("success", true);
    res.put("message", "ok");
   }else if("getinfo".toLowerCase().equals(straction))
   {
    //查询详细信息
    res = new HashMap<String, Object>();
    res.put("success", true);
    res.put("message", "ok");
   
    res.put("rows", service.getinfo(request));
   }
   else
   {
    throw new Exception("getjson.error:没有找到指定的action");
   }
   
   //返回结果
   
   
   map.put("jsondata", JSON.toJSONString(res));
  }catch(Exception e)
  {
   //错误记日志
   LogRecord.error("getjson.error:(" + e.getMessage() + ")" + e.getStackTrace());
   
   //输出错误信息
   HashMap<String, Object> res = new HashMap<String, Object>();
   
   res.put("success", false);
   res.put("message", "getjson.error:" + e.getMessage());
   
   map.put("jsondata", JSON.toJSONString(res));
  }
 
  return "common/json";
 }
 
 
service类：
/**
  * 修改 服务器信息
  * @return
  * @throws Exception
  */
 public boolean update(HttpServletRequest request) throws Exception
 {
  Map<String,String> filterMap = new HashMap<String, String>();
 
  String id = CommonUtil.getNoNullPara(request, "id");
  String server_name =CommonUtil.getNoNullPara(request, "server_name");
  String server_ip =CommonUtil.getNoNullPara(request, "server_ip");
  String server_role =CommonUtil.getNoNullPara(request, "server_role");
 
  if(StringUtils.isNotEmpty(id))
  {
   filterMap.put("id", id);
  }
 
  if(StringUtils.isNotEmpty(server_name))
  {
   filterMap.put("server_name", server_name);
  }
 
  if(StringUtils.isNotEmpty(server_ip))
  {
   filterMap.put("server_ip", server_ip);
  }
 
  if(StringUtils.isNotEmpty(server_role))
  {
   filterMap.put("server_role_name", server_role);
  }
 
 
  if(operationManDaoImpl.updateServerInfo(filterMap))
  {
   return true;
  }else
  {
   throw new Exception("server.update.error:" + String.valueOf("operationManDaoImpl.updateServerInfo(filterMap)"));
  }
 
 }
 
daoImpl 方法：
 
/**
  * @param filterMap
  * @return
  * 更新服务器信息
  */
 public boolean updateServerInfo(Map<String,String> filterMap)
 {
  StringBuffer sql = new StringBuffer("update servers set ");
 
  if(filterMap.size()>0)
  {
   
   if(null!=filterMap.get("server_name"))
   {
    sql.append(" server_name='"+filterMap.get("server_name")+"',");
   }
   
   if(null!=filterMap.get("server_ip"))
   {
    sql.append("server_ip='"+filterMap.get("server_ip")+"',");
   }
   
   if(filterMap.get("server_role_name")!=null)
   {
   //根据服务器角色名称获得服务器角色id
   String roleSql="select server_role_id from server_role WHERE server_role_name='"+filterMap.get("server_role_name")+"'";
   int server_role =Integer.valueOf(this.jdbcTemplate.queryForList(roleSql).get(0).get("server_role_id").toString());
   
   sql.append("server_role="+server_role);
   
   }
   
   if(null!=filterMap.get("id"))
   {
    sql.append(" where >).toString()));
   }
  }
 
  return this.jdbcTemplate.update(sql.toString())>0;
 
 }

java-toUpdate 或是 toAdd 到页面结合JS显示指定id的数据

相关推荐