上次写了登录 就是select语句去数据库查询 这次写了注册,实际上就是insert语句
但是没有做重复用户的逻辑。
新建一个注册页面的jsp
代码如下
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>注册界面</title>
</head>
<body>
<form action="register" method="post">
<table>
<tr>
<td>用户名:</td>
<td><input type="text" name="username" id="username"></td>
</tr>
<tr>
<td>密码:</td>
<td><input type="password" name="password" id="password"></td>
</tr>
<tr>
<td><input type="submit" value=注册></td>
</tr>
</table>
</form>
</body>
</html>
再创建一个servlet文件
代码如下
package cn.com.test;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.com.db.DBUtil;
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public RegisterServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username=request.getParameter("username"); //获取前台注册的用户名和密码
String password=request.getParameter("password");
Connection conn=DBUtil.getMySqlConn();//连接数据库 代码在登录帖过
String sql="insert into user(username,password)"+"values(?,?)"; //向数据库中插入记录
try {
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
int count=ps.executeUpdate();
if(count>0) {
response.sendRedirect("registersuccess.jsp"); //插入成功后跳转
}else {
response.sendRedirect("register.jsp"); //重新注册
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
注册成功页面
代码如下
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>注册首页</title>
</head>
<body>
<h1>注册成功</h1>
<input type="button" value="点击登录" onclick="window.location.href='login.jsp'"> <!--这边写了个登录按钮跳转到登录页面 -->
</body>
</html>
简单的注册页面,就做好了,后续要改进的还很多,大神勿喷,有不对的地方欢迎指出。