request.getParameter是从上一个表单页面提交过来的，我这个不知道为什么就是插入不进sql的表
```
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<%@page import="javax.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String s1 [] = {"北京市","天津市","上海市","重庆市","河北省 ", "河南省 ","湖北省 ","湖南省 ","江苏省 ",
"江西省 ","辽宁省 ","吉林省 ","黑龙江省 ","陕西省 ","山西省 ","山东省 ","四川省 ","青海省 ",
"安徽省 ","海南省 ","广东省 ","贵州省 ","浙江省 ","福建省 ","台湾省 ","甘肃省 ","云南省 ","西藏自治区 ",
"宁夏回族自治区 ","广西壮族自治区 ","新疆维吾尔自治区 ","内蒙古自治区 ","香港特别行政区 ","澳门特别行政区 "};
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){
}
try{
String uri = "jdbc:mysql://127.0.0.1:3306/classmgr?characterEncoding=UTF-8";
String user="root";
String password="1234";
Connection conn=DriverManager.getConnection(uri,user,password);
Statement stmt = conn.createStatement();
String a = request.getParameter("id");
String sql2="select count(*) as ct from sinformation where stu_num=?";
PreparedStatement ps = conn.prepareStatement(sql2);
ps.setString(1,a);
ResultSet Judge = ps.executeQuery();
Judge.next();
int ct = Judge.getInt("ct");
System.out.println(ct);
if(ct!=0){
%>
<script type="text/javascript" language="javascript">
alert("该账号已被注册");
windows.document.location.href = "login.jsp";
</script>
<%
}else
{
String sql = "insert into sinformation(`stu_name`,`stu_num`,`pwd`,`gender`,`birthday`,`birthplace`,`address`,`email`,`stat`) values(?,?,?,?,?,?,?,?,?)";
stmt.executeUpdate(sql);
PreparedStatement stmp=conn.prepareStatement(sql);
String name=request.getParameter("name");
String id=request.getParameter("id");
String sex=request.getParameter("sex");
String password1=request.getParameter("password1");
String birthday=request.getParameter("birthday");
String Native_place = s1[Integer.parseInt(request.getParameter("Native place"))];
String situation=request.getParameter("situation");
String email=request.getParameter("email");
String stat= "0";
stmp.setString(1,name);
stmp.setString(2,id);
stmp.setString(3,sex);
stmp.setString(4,password);
stmp.setString(5,birthday);
stmp.setString(6,Native_place);
stmp.setString(7,situation);
stmp.setString(8,email);
stmp.setString(9,stat);
conn.close();
}
}catch(SQLException sqle){
System.out.print(sqle);
}
%>
注册成功，请等待管理员验证！
<a href="login.jsp">点此返回</a>
</body>
</html>
```
```
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*" %>
<%@page import="javax.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
String s1 [] = {"北京市","天津市","上海市","重庆市","河北省 ", "河南省 ","湖北省 ","湖南省 ","江苏省 ",
"江西省 ","辽宁省 ","吉林省 ","黑龙江省 ","陕西省 ","山西省 ","山东省 ","四川省 ","青海省 ",
"安徽省 ","海南省 ","广东省 ","贵州省 ","浙江省 ","福建省 ","台湾省 ","甘肃省 ","云南省 ","西藏自治区 ",
"宁夏回族自治区 ","广西壮族自治区 ","新疆维吾尔自治区 ","内蒙古自治区 ","香港特别行政区 ","澳门特别行政区 "};
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){
}
try{
String uri = "jdbc:mysql://127.0.0.1:3306/classmgr?characterEncoding=UTF-8";
String user="root";
String password="1234";
Connection conn=DriverManager.getConnection(uri,user,password);
Statement stmt = conn.createStatement();
String a = request.getParameter("id");
String sql2="select count(*) as ct from sinformation where stu_num=?";
PreparedStatement ps = conn.prepareStatement(sql2);
ps.setString(1,a);
ResultSet Judge = ps.executeQuery();
Judge.next();
int ct = Judge.getInt("ct");
System.out.println(ct);
if(ct!=0){
%>
<script type="text/javascript" language="javascript">
alert("该账号已被注册");
windows.document.location.href = "login.jsp";
</script>
<%
}else
{
String sql = "insert into sinformation(`stu_name`,`stu_num`,`pwd`,`gender`,`birthday`,`birthplace`,`address`,`email`,`stat`) values(?,?,?,?,?,?,?,?,?)";
stmt.executeUpdate(sql);
PreparedStatement stmp=conn.prepareStatement(sql);
String name=request.getParameter("name");
String id=request.getParameter("id");
String sex=request.getParameter("sex");
String password1=request.getParameter("password1");
String birthday=request.getParameter("birthday");
String Native_place = s1[Integer.parseInt(request.getParameter("Native place"))];
String situation=request.getParameter("situation");
String email=request.getParameter("email");
String stat= "0";
stmp.setString(1,name);
stmp.setString(2,id);
stmp.setString(3,sex);
stmp.setString(4,password);
stmp.setString(5,birthday);
stmp.setString(6,Native_place);
stmp.setString(7,situation);
stmp.setString(8,email);
stmp.setString(9,stat);
conn.close();
}
}catch(SQLException sqle){
System.out.print(sqle);
}
%>
注册成功，请等待管理员验证！
<a href="login.jsp">点此返回</a>
</body>
</html>
```
