📄 update_do.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -