eclipse编写简单注册页面(JSP+MySQL)

eclipse编写简单注册页面(JSP+MySQL)

数据库页面
数据库页面
项目构成
项目构成

register.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>
<center>
<h1>注册操作</h1>
<hr>
<form action="register_check.jsp" method="post">
<table border="1">
<tr>
<br>
<td colspan="2" align="center"><font size="4"><b>用户注册</b></font></td>
</tr>
<tr>
<td align="right">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;名:</td>
<td><input type="text" name="name1" size="20"></td>
</tr>
<tr>
<td align="right">&nbsp;&nbsp;&nbsp;&nbsp;名:</td>
<td><input type="text" name="username1" size="20" maxlength="11"></td>
</tr>
<tr>
<td align="right">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码:</td>
<td><input type="password" name="passwd1" size="21"></td>
</tr>
<tr>
<td align="right">确认密码:</td>
<td><input type="password" name="passwd2" size="21"></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="reset" value="重置">
<input type="submit" value="注册">
</table>
</form>
</center>
</body>
</html>

注册页面
注册页面

register_check.jsp

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="javax.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>注册验证</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
%>
<%!
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/mldn";
public static final String DBUSER="root";
public static final String DBPASS="123456";
%>
<%
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
boolean flag=false;
%>
<%
try{
	
	Class.forName(DBDRIVER);
	String username=request.getParameter("username1");
	String passwd=request.getParameter("passwd1");
	String passwd1=request.getParameter("passwd2");
	String name=request.getParameter("name1");
	if(username==null || username=="" || passwd==null || passwd=="" || name==null || name==""){
		flag=false;
	}
	else if(passwd.equals(passwd1)){
		conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
		String sql="insert into user01(userid,password,name) values (?,?,?)";
		pstmt=conn.prepareStatement(sql);
		pstmt.setString(1,username);
		pstmt.setString(2,passwd);
		pstmt.setString(3, name);
		int rtn=pstmt.executeUpdate();
		flag=true;
	}
	else{
		flag=false;
	}
}catch(Exception e){
	System.out.println(e);
}
finally{
	try{
		rs.close();
		pstmt.close();
		conn.close();
	}catch(Exception e){}
}
%>
<%
if(flag){
%>
<jsp:forward page="register_success.jsp"/>
<%
}else{
%>
<jsp:forward page="register_failure.jsp"/>
<%
}
%>
</body>
</html>

register_success.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>
<center>
<h1>注册成功</h1>
<h2>3秒后将返回登录页面,你也可以点击<a href="register.jsp">这里</a>跳转</h2>
<%
response.setHeader("refresh", "3;URL=login.jsp");
%>
</center>
</body>
</html>

注册失败页面
注册失败页面

register_failure.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>
<center>
<h1>注册失败</h1>
<h2>3秒后将返回注册页面,你也可以点击<a href="register.jsp">这里</a>跳转</h2>
<%
response.setHeader("refresh", "3;URL=register.jsp");
%>
</center>
</body>
</html>

注册成功页面
注册成功页面

  • 7
    点赞
  • 154
    收藏
    觉得还不错? 一键收藏
  • 6
    评论
评论 6
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值