📄 checkregister.jsp

📁 网上书店的一个简单实例

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<%
int ID=0;
int i=1;
String logname=request.getParameter("username");

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

String repeatpassword=request.getParameter("repeatpassword");
       

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:game","","");
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String condition1="SELECT logname,ID,repeatpassword FROM user";
ResultSet rs=sql.executeQuery(condition1);
boolean flag=true;
while(rs.next()) 
{ 

if(logname.equals(rs.getString(1))){
    out.println("<br><br><center><B>请重新注册</B></center>");
out.println("<script>alert('对不起,用户名"+logname+"已存在');location.replace('register.jsp');</script>");
    flag=false; 
    break;
   }
   
if(!password.equals(repeatpassword)){
    out.println("<br><br><center><B>请重新注册</B></center>");
out.println("<script>alert('对不起,重复密码和注册密码不相符');location.replace('register.jsp');</script>");
    flag=false; 
   break;
   }  
   
   
}
if(flag){
rs.last();
ID=rs.getRow()+1;
String condition="INSERT INTO user VALUES"+"('"+ID+"','"+logname+"','"+password+"','"+repeatpassword+"','"+"null"+"','"+"null"+"','"+"null"+"')";

sql.executeUpdate(condition);

out.print("<script>alert('恭喜,注册成功,现在将转到首页.');location.replace('index2.jsp');</script>");
}
}
catch(Exception e)
{
out.println(e);
}

%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -