jsp+Servlet+javaBean实现登录和注册

最新推荐文章于 2024-04-03 11:28:51 发布

LY_624

最新推荐文章于 2024-04-03 11:28:51 发布

阅读量7.5k

点赞数 2

分类专栏： Java Web 文章标签： java web

本文链接：https://blog.csdn.net/LY_624/article/details/53453268

版权

Java Web 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

数据库设计：

CREATE SCHEMA `student` ;
CREATE  TABLE `student`.`user` (
`id` INT NOT NULL AUTO_INCREMENT ,  
`user` VARCHAR(45) NOT NULL ,  
`pwd` VARCHAR(45) NOT NULL ,  
`name` VARCHAR(45) NOT NULL ,  
`xxx` VARCHAR(45) NOT NULL ,  
`age` INT NOT NULL ,  
PRIMARY KEY (`id`) );

数据库交互界面：

web.xml

<servlet>
		
		<servlet-name>loginServlet</servlet-name>
		<servlet-class>servlet.loginServlet</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>loginServlet</servlet-name>
		<url-pattern>/loginServlet</url-pattern>
	</servlet-mapping>
	<servlet>
		
		<servlet-name>addUserServlet</servlet-name>
		<servlet-class>servlet.addUserServlet</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>addUserServlet</servlet-name>
		<url-pattern>/addUserServlet</url-pattern>
	</servlet-mapping>

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>欢迎来到学生管理系统</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
	<div align="center">
		<font size=" 2" color="#FF6633">用户登录</font>
	</div>
	<form id="form1" name="form1" method="post" action="loginServlet">
		<table width="357" border="0" align="center">
			<tr>
				<td width="128">用户名：</td>
				<td width="219"><label> <input name="user" type="text"
						id="user" /> </label></td>
			</tr>
			<tr>
				<td>密 码：</td>
				<td><label> <input name="pwd" type="password" id="pwd" />
				</label></td>
			</tr>
			<tr>
				<td><label> <input type="submit" name="Submit"
						value="登录" /> </label></td>
				<td><label><a href="addUser.jsp">用户注册</a> </label></td>
			</tr>
		</table>
		<p> </p>
	</form>
</body>
</html>

界面：

addUser.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>用户注册</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head>

<body>
	<p align="center">
		<font size=" 3" color="#FF3300">用户注册</font>
	</p>
	<form id="form1" name="form1" method="post" action="addUserServlet">
		<table width="340" border="0" align="center">
			<tr>
				<td width="141">用户名：</td>
				<td width="189"><label> <input name="user" type="text"
						id="user" /> </label></td>
			</tr>
			<tr>
				<td>密码：</td>
				<td><label> <input name="pwd" type="password" id="pwd" />
				</label></td>
			</tr>
			<tr>
				<td>重输密码：</td>
				<td><label> <input name="pwd1" type="password"
						id="pwd1" /> </label></td>
			</tr>
			<tr>
				<td>姓名：</td>
				<td><label> <input name="name" type="text" id="name" />
				</label></td>
			</tr>
			<tr>
				<td>性别：</td>
				<td><label> <input name="xxx" type="radio" value="男"
						checked="checked" /> 男 <input type="radio" name="xxx" value="女" />
						女</label></td>
			</tr>
			<tr>
				<td>年龄：</td>
				<td><label> <input name="age" type="text" id="age" />
				</label></td>
			</tr>
			<tr>
				<td><label> <input type="submit" name="Submit"
						value="提交" /> </label></td>
				<td><label> <input type="reset" name="Submit2"
						value="重置" /> </label></td>
			</tr>
		</table>
	</form>
</body>
</html>

界面：

User.java

package bean;

public class User {
	private String user;
	private String pwd;
	private String name;
	private String xxx;
	private int age;

	public String getUser() {
		return user;
	}

	public void setUser(String user) {
		this.user = user;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getxxx() {
		return xxx;
	}

	public void setxxx(String xxx) {
		this.xxx = xxx;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}
}

DAO.java

package dao;

import getConnection.GetConnection;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mysql.jdbc.*;

import bean.User;

public class DAO {
	private Connection conn;
	private PreparedStatement pstat;
	String sql = "";

	/**
	 * 
	 * 用户登录
	 */
	public boolean logoin(User user) throws SQLException {
		conn = GetConnection.getConnection();
		boolean i = false;
		sql = "select * from user where user=? and pwd=?";

		pstat = conn.prepareStatement(sql);

		pstat.setString(1, user.getUser());
		pstat.setString(2, user.getPwd());

		ResultSet rs1 = (ResultSet) pstat.executeQuery();
		if (rs1.next()) {
			i = true;
			rs1.close();
			pstat.close();
		} else {
			i = false;
			rs1.close();
			pstat.close();
		}
		conn.close();
		return i;
	}

	/**
	 * 用户注册
	 */
	public void addUser(User user) {
		conn = GetConnection.getConnection();
		sql = "insert into user values(?,?,?,?,?,?)";
		try {
			pstat = conn.prepareStatement(sql);
			pstat.setString(1, null);
			pstat.setString(2, user.getUser());
			pstat.setString(3, user.getPwd());
			pstat.setString(4, user.getName());
			pstat.setString(5, user.getxxx());
			pstat.setInt(6, user.getAge());
			pstat.executeUpdate();
			pstat.close();
			conn.close();

		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
}

GetConnection.java

package getConnection;

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

/**
 * 
 * 用JDBC的方法获得数据库的连接
 * 
 */
public class GetConnection {
	// 通过静态方法注册驱动，获得连接

	public static Connection getConnection() {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost/student";
		Connection con = null;
		try {
			Class.forName(driver);
			try {
				con = DriverManager.getConnection(url, "root", "root");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		System.out.println("已获得数据库的连接");
		return con;
	}
	/*
	 * public static void main(String args[]){ getConnection(); }
	 */
}

loginServlet.java

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.DAO;

import bean.User;

public class loginServlet extends HttpServlet {
	public void destory() {
		super.destroy();
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		String name = new String(request.getParameter("user").getBytes(
				"ISO8859_1"), "GBK");
		String pwd = new String(request.getParameter("pwd").getBytes(
				"ISO8859_1"), "utf-8");
		User user = new User();
		user.setUser(name);
		user.setPwd(pwd);
		DAO dao = new DAO();
		boolean isLogin;
		try {
			isLogin = dao.logoin(user);
			if (isLogin) {
				response.sendRedirect("MYJSP.jsp");
			} else {
				response.sendRedirect("index.jsp");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}

	public void init() throws ServletException {

	}
}

addUserServlet.java

package servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import dao.DAO;

import bean.User;

public class addUserServlet extends HttpServlet {

	/**
	 * Destruction of the servlet.
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log

		// Put your code here

	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		response.setCharacterEncoding("utf-8");
		String user1 = request.getParameter("user");
		String pwd = request.getParameter("pwd");
		String name = new String(request.getParameter("name").getBytes(
				"ISO8859_1"), "utf-8");
		String xxx = new String(request.getParameter("xxx").getBytes(
				"ISO8859_1"), "utf-8");
		String age1 = request.getParameter("age");
		User user = new User();
		user.setUser(user1);
		user.setPwd(pwd);
		user.setName(name);
		user.setxxx(xxx);
		int age;
		if (age1 != null) {
			age = Integer.parseInt(age1);
			user.setAge(age);
		}
		DAO dao = new DAO();
		dao.addUser(user);

		request.setAttribute("info", new String(" 添加成功！恭喜！！" + " "));
		request.setAttribute("id", new String("a"));
		request.setAttribute("denglu", new String(" 登陆"));

		request.getRequestDispatcher("info.jsp").forward(request, response);
	}

	public void init() throws ServletException {
		// Put your code here
	}

}

LY_624

关注

2
点赞
踩
53

收藏

觉得还不错? 一键收藏
5
评论
jsp+Servlet+javaBean实现登录和注册

数据库设计：CREATE SCHEMA `student` ;CREATE TABLE `student`.`user` (`id` INT NOT NULL AUTO_INCREMENT , `user` VARCHAR(45) NOT NULL , `pwd` VARCHAR(45) NOT NULL , `name` VARCHAR(45) NOT NULL , `
复制链接

扫一扫