2019.10.21

先设置网页直接跳转，设置登录界面，验证输入，设置mysql表格，导入数据库

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;

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 util.DBUtil;

/**
* Servlet implementation class RegisterServlet
*/
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public RegisterServlet() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
*/

protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
request.setCharacterEncoding("UTF-8");
String sql = "insert into user (user, password, sex, name, num, email, scl, xi, class, year, province, phone) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
Connection connection = DBUtil.getConnection();
PreparedStatement ps = connection.prepareStatement(sql);
ps.setString(1,request.getParameter("user"));
ps.setString(2,request.getParameter("password"));
ps.setString(3,request.getParameter("sex"));
ps.setString(4,request.getParameter("name"));
ps.setString(5,request.getParameter("num"));
ps.setString(6,request.getParameter("email"));
ps.setString(7,request.getParameter("scl"));
ps.setString(8,request.getParameter("xi"));
ps.setString(9,request.getParameter("class"));
ps.setString(10,request.getParameter("year"));
ps.setString(11,request.getParameter("province"));
ps.setString(12,request.getParameter("phone"));
int updaterows = ps.executeUpdate(); //executeUpdate()返回的整型为受影响数据行数
DBUtil.close(ps, connection);
if(updaterows == 1)
response.sendRedirect("success.html");
else
response.sendRedirect("fail.html");
} catch (Exception e) {
e.printStackTrace();
}
}

}

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtil {
public static String DBDRIVER = "com.mysql.cj.jdbc.Driver";
public static String DBURL = "jdbc:mysql://localhost:3306/shop";
public static String DBUSER = "root";
public static String DBPASSWORD = "root";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void close(Statement state, Connection conn) {
try {
if(state!=null)
state.close();
if(conn!=null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close(ResultSet rs, Statement state, Connection conn) {
try {
if(rs!=null)
rs.close();
if(state!=null)
state.close();
if(conn!=null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>注册窗口</title>
</head>
<body>

</body>
<script type="text/javascript">
function check(form){
if(form.user.value.length<6 || form.user.value.length>12 || new RegExp("[^0-9a-zA-Z]").test(form.user.value)){
alert("用户名必须由6-12位英文字符或数字组成！");
form.user.focus();
return false;
}
if(new RegExp("[^a-zA-Z]").test(form.user.value.substring(0,1))){
alert("用户名必须以英文字母开头！");
form.user.focus();
return false;
}
//var ses=/^([2]{1}})([0]{1}})([1]{1}})([8]{1}})([0-9]{4})$/
if(form.num.value.length != 8/* || ses.test(form.num.value)*/){
alert("学号请输8位数字！");
form.phone.focus();
return false;
}
//以数字字母开头，中间可以是多个数字字母或下划线；然后是“@”；然后是数字字母；然后是“.”；最后是2-4个字母结尾
var regex = /^([a-zA-Z]|[0-9])(\w|\-)+@[a-zA-Z0-9]+\.([a-zA-Z]{2,4})$/;
if(!regex.test(form.email.value)){
alert("邮箱格式错误！");
form.email.focus();
return false;
}
return true;
}
</script>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>成功</title>
</head>
<body>

</body>
</html>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>失败</title>
</head>
<body>

</body>
</html>

posted on 2019-10-21 21:52 芥末果酱阅读(131) 评论(0) 收藏举报

刷新页面返回顶部

芥末果酱

导航

公告

2019.10.21