📄 yanzheng.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<html>
<head>
<title>在线考试</title>
</head>
<body>
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
int ret;
String sname=request.getParameter("student");
String ssex=request.getParameter("sex");
String spassword=request.getParameter("pwd");
String sclass=request.getParameter("classes");
String sno=request.getParameter("number");
DBConn db=new DBConn();
String sql="select * from student where no='"+sno+"'";
String sql2="insert into student(name,sex,password,class,no) values ('"+sname+"','"+ssex+"','"+spassword+"','"+sclass+"','"+sno+"')";
ResultSet rs=db.Query(sql);
%>
<% if(rs.next()){%>
<script language=javascript>
alert("已有此学员，请重新录入！");
window.navigate("register.jsp");
</script>
<%}else{
ret=db.Update(sql2);
%>
<script language=javascript>
alert("注册成功！");
window.navigate("index.jsp");
<%}%>
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -