注册界面

String id4=request.getParameter("id3");
String name4=request.getParameter("name3");
String mima4=request.getParameter("mima3");//变量信息zhuanhuan

 

 

String sql2="select * from haas1 where id=?";
PreparedStatement pstmt2=conn.prepareStatement(sql2);
pstmt2.setString(1,id4);
ResultSet n2=pstmt2.executeQuery();

int k=0;
while (n2.next())
{%>
<a href="login.jsp">学号不能重复,请重新注册</a><%
k++;
}
if(k==0)
{
String sql="insert into haas1(id,name,password) values(?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,id4);
pstmt.setString(2,name4);
pstmt.setString(3,mima4);

int n=pstmt.executeUpdate();
if (n!=0)
{
%>
<a href="MyJsp.jsp">注册成功，返回登录界面</a>
<%
}
else
{%>
不成功
<%
}}
%>

</body>
</html>