该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
pageEncoding="UTF-8"%>
Inserttitlehererequest.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Strings1[]={"北京市","天津市","上海市","重庆市","河北省","河南省","湖北省","湖南省","江苏省",
"江西省","辽宁省","吉林省","黑龙江省","陕西省","山西省","山东省","四川省","青海省",
"安徽省","海南省","广东省","贵州省","浙江省","福建省","台湾省","甘肃省","云南省","西藏自治区",
"宁夏回族自治区","广西壮族自治区","新疆维吾尔自治区","内蒙古自治区","香港特别行政区","澳门特别行政区"};
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exceptione){
}
try{
Stringuri="jdbc:mysql://127.0.0.1:3306/classmgr?characterEncoding=UTF-8";
Stringuser="root";
Stringpassword="1234";
Connectionconn=DriverManager.getConnection(uri,user,password);
Statementstmt=conn.createStatement();
Stringa=request.getParameter("id");
Stringsql2="selectcount(*)asctfromsinformationwherestu_num=?";
PreparedStatementps=conn.prepareStatement(sql2);
ps.setString(1,a);
ResultSetJudge=ps.executeQuery();
Judge.next();
intct=Judge.getInt("ct");
System.out.println(ct);
if(ct!=0){
%>
alert("该账号已被注册");
windows.document.location.href="login.jsp";
}else
{
Stringsql="insertintosinformation(`stu_name`,`stu_num`,`pwd`,`gender`,`birthday`,`birthplace`,`address`,`email`,`stat`)values(?,?,?,?,?,?,?,?,?)";
stmt.executeUpdate(sql);
PreparedStatementstmp=conn.prepareStatement(sql);
Stringname=request.getParameter("name");
Stringid=request.getParameter("id");
Stringsex=request.getParameter("sex");
Stringpassword1=request.getParameter("password1");
Stringbirthday=request.getParameter("birthday");
StringNative_place=s1[Integer.parseInt(request.getParameter("Nativeplace"))];
S