📄 insert_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}
-->
</style>
<body>
<%!String Create_Manager,Dest_terminal_Id,Tuifei_Yuanyin,Tuifei_Howmuch,Tuifei_Chennuo_Date,Tuifei_Yitui_Date,User_Message,Kefu_Gonghao,sql;%>
<%!
public String Now()
{
SimpleDateFormat simpledateformat = new SimpleDateFormat("yyyyMMddHHmmss");
return simpledateformat.format(new java.util.Date());
}
%>
<%
Dest_terminal_Id=request.getParameter("Dest_terminal_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");
Create_Manager=(String)session.getValue("manager");
String Create_Time=Now();
//out.print(Create_Time);
sql="insert into app_kefu_tuifeixitong(Dest_terminal_Id,Tuifei_Yuanyin,Tuifei_Howmuch,Tuifei_Chennuo_Date,Tuifei_Yitui_Date,User_Message,Kefu_Gonghao,Create_Manager,Create_Time) values('"+Dest_terminal_Id+"','"+Tuifei_Yuanyin+"','"+Tuifei_Howmuch+"','"+Tuifei_Chennuo_Date+"','"+Tuifei_Yitui_Date+"','"+User_Message+"','"+Kefu_Gonghao+"','"+Create_Manager+"','"+Create_Time+"')";
//out.print(sql);
Statement sqlbean = null ;
try{
sqlbean = conn.createStatement();
sqlbean.executeUpdate(sql);
%>
<br>
<br>
<center>
<font color="red">
<b>
<br><br>
添加成功！
</b>
<br><br>
<form name="form3" type="post" action="insert.html">
<input name="submit" type="submit" value="继续添加">
</form>
</font>
</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 + -