WebRoot/pingjiajilu_updt_post.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java"  pageEncoding="gb2312" import="java.sql.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("gb2312"); 
response.setCharacterEncoding("gb2312"); 
%>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'adminyanzheng.jsp' starting page</title>
  </head>
  <body>
  <%
String shitangbianhao=request.getParameter("shitangbianhao");
String shitangmingcheng=request.getParameter("shitangmingcheng");
String jiageheli=request.getParameter("jiageheli");
String kouweiheshi=request.getParameter("kouweiheshi");
String caipinfengfu=request.getParameter("caipinfengfu");
String huanjingweisheng=request.getParameter("huanjingweisheng");
String fuwuzhiliang=request.getParameter("fuwuzhiliang");
String qitapingyu=request.getParameter("qitapingyu");
String pingjiaren=request.getParameter("pingjiaren");

String id=request.getParameter("id");
String sql="update pingjiajilu set shitangbianhao='"+shitangbianhao+"',shitangmingcheng='"+shitangmingcheng+"',jiageheli='"+jiageheli+"',kouweiheshi='"+kouweiheshi+"',caipinfengfu='"+caipinfengfu+"',huanjingweisheng='"+huanjingweisheng+"',fuwuzhiliang='"+fuwuzhiliang+"',qitapingyu='"+qitapingyu+"',pingjiaren='"+pingjiaren+"' where id= "+id;
connDbBean.executeUpdate(sql);
out.print("<script>alert('修改成功!!');location.href='pingjiajilu_updt.jsp?id="+id+"';</script>");
%>
  </body>
</html>