update_do.jsp

来自「短信平台退费系统(jsp+mysql)」· JSP 代码 · 共 49 行

JSP
49
字号
<%@ page import="java.lang.Float" %>
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*,java.text.*"%>
<%@ include file = "../conn.jsp" %>
<jsp:include page="../islogin.jsp"/>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {color: #FF0000}
.style2 {color: #0000FF}
-->
</style>
<body>
<%!String Id,Tuifei_Yuanyin,Tuifei_Howmuch,Tuifei_Chennuo_Date,Tuifei_Yitui_Date,User_Message,Kefu_Gonghao,sql;%>
<%
  Id=request.getParameter("Id");
  Tuifei_Yuanyin=request.getParameter("Tuifei_Yuanyin");
  Tuifei_Howmuch=request.getParameter("Tuifei_Howmuch");
  Tuifei_Chennuo_Date=request.getParameter("Tuifei_Chennuo_Date");
  Tuifei_Yitui_Date=request.getParameter("Tuifei_Yitui_Date");
  User_Message=request.getParameter("User_Message");
  Kefu_Gonghao=request.getParameter("Kefu_Gonghao");
	 sql="UPDATE app_kefu_tuifeixitong SET Tuifei_Yuanyin='"+Tuifei_Yuanyin+"',Tuifei_Howmuch='"+Tuifei_Howmuch+"',Tuifei_Chennuo_Date='"+Tuifei_Chennuo_Date+"',Tuifei_Yitui_Date='"+Tuifei_Yitui_Date+"',User_Message='"+User_Message+"',Kefu_Gonghao='"+Kefu_Gonghao+"' WHERE Id='"+Id+"'";
     //out.println(sql);
	 Statement sqlbean = null ;
try{
	 sqlbean = conn.createStatement();
	 sqlbean.executeUpdate(sql); 
   %>
<center>
操作成功!
</center>
<%
}
catch (SQLException e) {}
finally {
    try {
      if (sqlbean!=null) {
        sqlbean.close();
      }
    }
    catch (SQLException e) {}

}	
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?