pageEncoding="utf-8"%>

登记验证

/*浏览器提交的数据在提交给服务器之前设置编码方式为UTF-8*/

request.setCharacterEncoding("UTF-8");

out.println("用户名："+request.getParameter("User")+"
");

out.println("密码："+request.getParameter("pwd")+"
");

out.println("性别："+request.getParameter("sexy")+"
");

out.println("密保问题："+request.getParameter("secret")+"
");

out.println("密保问题答案："+request.getParameter("pwd2")+"
");

%>

request.setCharacterEncoding("UTF-8");

String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=Users";//此处为你的库名

//Connection conn=null;

Connection conn=null;

String userName="sa";

String pwd="xxxx";//xxxx是你的数据库登录密码

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn = DriverManager.getConnection(dbURL,userName,pwd);

String sql="insert into Users2(username,password,question,answer,gender)values(?,?,?,?,?)";//此处username等是指数据库里的属性名

PreparedStatement stmp=conn.prepareStatement(sql);

String username=request.getParameter("User");

String password=request.getParameter("pwd");

String question=request.getParameter("secret");

String answer=request.getParameter("pwd2");

//int gender=Integer.parseInt(request.getParameter("sexy"));

String gender=request.getParameter("sexy");

//    另外，setString中的数字顺序对应sql语句参数顺序！

stmp.setString(1,username);

stmp.setString(2,password);

stmp.setString(3,question);

stmp.setString(4,answer);

stmp.setString(5,gender);

int n=stmp.executeUpdate();

if(n==1){%>数据插入成功！

else{%>数据插入失败！

%>