📄 yanzheng8.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<html>
<head>
<%
int id2; %>
</head>
<body>
<% request.setCharacterEncoding("GBK");
int id1=Integer.parseInt(request.getParameter("id"));
String tgan=request.getParameter("t1");
String dan=request.getParameter("cate");
String A1=request.getParameter("txt1");
String A2=request.getParameter("txt2");
String A3=request.getParameter("txt3");
String A4=request.getParameter("txt4");%>
<% DBConn db=new DBConn();
String sql="select * from xzt where tgan='"+tgan+"'";
String sql2="Update xzt set tgan='"+tgan+"',dan='"+dan+"',A='"+A1+"',B='"+A2+"',C='"+A3+"',D='"+A4+"' where id='"+id1+"'";
ResultSet rs=db.Query(sql);%>
<%if(rs.next()){
id2=rs.getInt("id");
}else{
id2=id1;
}
%>
<%if(id1!=id2){%>
<script language=javascript>
alert("此试题一存在！修改失败！");
history.back();
</script>
<%}else{ DBConn db1=new DBConn();
db1.Update(sql2);
%>
<script language=javascript>
alert("修改成功！");
window.navigate("type_2.jsp");
</script>
<%} %>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -