📄 f0f96fa6041d00171005f7af098808c8
字号:
<!--首先导入一些必要的packages-->
<!--告诉编译器使用SQL包-->
<%@ page import="java.sql.*"%>
<%@ page import="com.xxgl.data.DBconnection"%>
<!--设置中文输出-->
<%@ page contentType="text/html; charset=GB2312" %>
<html>
<head>
<title>DbJsp.jsp</title>
</head>
<body>
<%
int count=0;
//以try开始
try
{ //以try开始
String s_id =request.getParameter("sid");
s_id=new String (s_id.getBytes("ISO-8859-1"),"GBK");
String yesorno =request.getParameter("yesorno");
yesorno=new String (yesorno.getBytes("ISO-8859-1"),"GBK");
String ydrq =request.getParameter("ydrq");
ydrq=new String (ydrq.getBytes("ISO-8859-1"),"GBK");
String ydlb =request.getParameter("ydlb");
ydlb=new String (ydlb.getBytes("ISO-8859-1"),"GBK");
String ydyy =request.getParameter("ydyy");
ydyy=new String (ydyy.getBytes("ISO-8859-1"),"GBK");
String ydqx =request.getParameter("ydqx");
ydqx =new String (ydqx .getBytes("ISO-8859-1"),"GBK");
//建一个数据库连接
Connection con = DBconnection.getConnection();
Statement stmt;
stmt = con.createStatement();
//修改记录
String sql="update xjbdqk set m_time='"+ydrq+"',m_type='"+ydlb+"',m_reson='"+ydyy+"'m_jg='"+ ydqx+"' WHERE s_tid='"+s_id+"'";
count=stmt.executeUpdate(sql);
String tempStr="'"+s_id+"','"+ydrq+"','"+ydlb+"','"+ydyy+"','"+ydqx+"'";
String sql="INSERT INTO newstudent (s_id,m_time,m_type,m_reson,m_jg) VALUES ("+tempStr+")";
count=stmt.executeUpdate(sql);
//关闭数据库连结
stmt.close();
con.close();
}
//捕获错误信息
catch (Exception e) {out.println(e.getMessage());}
%>
<script language="javascript">
if (<%=count%> == 1)
alert("异动信息提交成功！");
else
alert("异动信息提交失败！");
window.location.href("inputydinfo.html");
</script>
</body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -