📄 yanzheng10.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.text.SimpleDateFormat"%>
<html>
<head>
</head>
<body>
<% request.setCharacterEncoding("GBK");
int id=Integer.parseInt(request.getParameter("id"));
int id1=Integer.parseInt(request.getParameter("pd"));
int fenshu1=Integer.parseInt(request.getParameter("pds"));
int id2=Integer.parseInt(request.getParameter("xz"));
int fenshu2=Integer.parseInt(request.getParameter("xzs"));
int id3=Integer.parseInt(request.getParameter("tk"));
int fenshu3=Integer.parseInt(request.getParameter("tks"));
String sj=request.getParameter("ttime");
String C1=request.getParameter("C1");
String C2=request.getParameter("C2");
String C3=request.getParameter("C3");
%>
<%Calendar c = Calendar.getInstance();
c.add(Calendar.DATE,0);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String data = sdf.format(c.getTime()); %>
<% DBConn db=new DBConn();
String sql1="Update test set id1='"+id1+"',fenshu1='"+fenshu1+"',data='"+data+"' where id='"+id+"'";
String sql2="Update test set id1='"+id1+"',fenshu1='"+fenshu1+"',data='"+data+"' where id='"+id+"'";
String sql3="Update test set id1='"+id1+"',fenshu1='"+fenshu1+"',data='"+data+"' where id='"+id+"'";
if(C1!=null){
db.Update(sql1);
}
if(C2!=null){
db.Update(sql2);
}
if(C3!=null){
db.Update(sql3);
}
%>
<script language=javascript>
alert("添加成功！");
window.navigate("test.jsp");
</script>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -