jsp实现简单注册
1.实现工具:j2EE、mysql、Navicat for mysql
2.导入mysql-connector-java-x.x.xx-bin.jar包
1.在数据库中新建一张表
表格数据的属性设置如下
2.登陆注册主界面
源代码:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>User Login Page</title>
</head>
<body>
<hr><br>Welcome to this <font color="green">Login Page</font>!<br>
<form action="do_login.jsp" method="post">
<br>
<h1>Please input your message:</h1><br>
用户名:<input type="text" name="name"><br>
<br>
密码: <input type="password" name="password"><br>
<br><br><br>
<input type="submit" value="登陆"> <input type="reset"><br>
Click me to <font color="green"><a href="register.jsp">Register</a>!</font><br>
</form>
</body>
</html>
运行结果:
3.注册界面
源代码:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here!</title>
</head>
<body>
<hr><br>Welcome to this <font color="green">Enroll(Register) Page</font>!<br>
<form action="do_register.jsp" method="post">
<br>
<h1>Please input your message:</h1><br>
用户名:<input type="text" name="register_name"><br>
密码:<input type="password" name="register_password"><br>
<br><br><br>
<input type="submit" value="注册"> <input type="reset"><br>
</form>
</body>
</html>
运行结果:
4.注册处理
源代码:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %><!--导入sql包 -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Server to do the register page!</title>
</head>
<body>
<%
String Register_name=request.getParameter("register_name");//获取register_name的参数值
String Register_password=request.getParameter("register_password");//获取register_password的参数值
if(Register_name==null||"".equals(Register_name.trim())||Register_password==null||"".equals(Register_password.trim())){//判断用户名和密码是否为空
//out.write("用户名或密码不能为空!");
System.out.println("用户名或密码不能为空!");//输出提示
response.sendRedirect("register.jsp");//页面跳转
return;
//request.getRequestDispatcher("login.jsp").forward(request, response);
}
%>
<%
try{
Class.forName("com.mysql.jdbc.Driver");//加载mysql驱动
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test1?useSSL=false", "root", "3701211994812sls");//连接数据库
Statement stmt=conn.createStatement();//实例化Statement对象
String InsertSQL="INSERT INTO p_user(username,password) values('"+Register_name+"','"+Register_password+"')";//sql语句
System.out.println(Register_name+"\t"+Register_password);//输出注册信息
int FLAG=stmt.executeUpdate(InsertSQL);//执行sql语句
if(FLAG!=0){//判断查询结果
out.println("<script>alert('注册成功!');history.go(-1);</script>"); //弹出注册信息history.go(-1)表示返回当前页面的上一页
}else{
out.println("<script>alert('注册失败!');history.go(-1);</script>");
}
//关闭资源
stmt.close();
conn.close();
}catch(SQLException e){//捕获异常
e.printStackTrace();
}
%>
</body>
</html>
注册运行过程: