javaweb连接MySql数据库实现注册和登录功能

1.登录页面（login.jsp)

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








用户名：

密码：

2.登录检查页面（连接数据库部分）(login_check.jsp)

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







<%
String name=request.getParameter("vname");
String pwd=request.getParameter("vpwd");

%>
<%!
public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/user";//最后一个是数据库名
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);
	conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);
	String sql="select * from user11 where name=? and password=?";
	pstmt=conn.prepareStatement(sql);
	pstmt.setString(1,name);
	pstmt.setString(2,pwd);
	rs=pstmt.executeQuery();
	if(rs.next())
	{
		flag=true;
	}
}catch(Exception e)
{
	System.out.println("数据库操作异常了！");
	}finally{
		try{
			rs.close();
			pstmt.close();
			conn.close();
		}catch(Exception e)
		{
			System.out.println("数据库关闭异常");
		}
	}

%>
<%
if(flag)
{
%>



<%
}else{
%>

<%
}
%>

3.登录成功页面（success.jsp)

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







欢迎<%=request.getParameter("vname") %>登录

4.登录失败页面（failure.jsp）

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







登录失败了,重新返回登录页面

5.注册页面（register.jsp）

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










用户名：


密码：

 6.注册检查页面（register_check.jsp）

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







<%
String name=request.getParameter("yhm");
String pwd=request.getParameter("mm");

%>
<%System.out.println(name+pwd); %>
<%!
public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/user";//最后一个是数据库名
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{
	
	String sql="insert into user11(name,password) values(?,?)";
	Class.forName(DBDRIVER);
	conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);
	pstmt=conn.prepareStatement(sql);
	pstmt.setString(1,name);
	pstmt.setString(2,pwd);
	int row=pstmt.executeUpdate();
	if(row>=1)
	{
		flag=true;
	}
}catch(Exception e)
{
	System.out.println("数据库操作异常了！");
	}finally{
		try{
			pstmt.close();
			conn.close();
		}catch(Exception e)
		{
			System.out.println("数据库关闭异常");
		}
	}
%>
<%
if(flag){
%>

<% 
}else{
%>

<%
}
%>

 7.注册成功页面（register_success.jsp）

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

8.注册失败页面（register_failure.jsp）

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