数据库页面

项目构成

register.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>








注册操作






用户注册


姓        名：



用  户  名：



密        码：



确认密码：

注册页面

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.*" %>







<%
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){
%>

<%
}else{
%>

<%
}
%>

register_success.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>








注册成功
3秒后将返回登录页面，你也可以点击这里跳转
<%
response.setHeader("refresh", "3;URL=login.jsp");
%>

注册失败页面

register_failure.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>








注册失败
3秒后将返回注册页面，你也可以点击这里跳转
<%
response.setHeader("refresh", "3;URL=register.jsp");
%>

注册成功页面