简单的JavaWeb注册登录案例

最新推荐文章于 2024-08-05 16:03:37 发布

clamtian

最新推荐文章于 2024-08-05 16:03:37 发布

阅读量6.9k

点赞数 10

分类专栏： Java学习文章标签： servlet javaweb

本文链接：https://blog.csdn.net/luckytsw/article/details/84930070

版权

Java学习专栏收录该内容

4 篇文章 0 订阅

订阅专栏

简单的JavaWeb注册登录案例

1.注册页面register.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>register</title>
</head>
<body>
	<form action="http://localhost:8080/register&enter/register"
		method="get">
		姓名：<input type="text" name="username"></br>
		电话：<input name="telephone"></br>
		邮箱：<input name="email"></br>
		qq：<input name="qq"></br>
		<input type="submit" value="提交" >
	</form>
</body>
</html>

在这里插入图片描述

2.注册案例实现程序register.java

/**
 * 注册案例实现程序
 * @author lucky
 *
 */
public class register extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response) {
				//获取表单提交过来的信息
				String username = request.getParameter("username");
				String telephone = request.getParameter("telephone");
				String email = request.getParameter("email");
				String qq = request.getParameter("qq");
				
				//调用database中的insert方法，将新用户添加到数据库中
				database db = new database();
				try {
					db.insert(username, telephone, email, qq);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
	}

3.登录页面enter.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="http://localhost:8080/register&enter/enter" method="get">
	用户：<input name="username">
	密码：<input name="qq">
	<input type="submit" value="登录">
</form>
</body>
</html>

在这里插入图片描述

4.登录案例实现程序enter.java

/**
 * 登录案例实现代码
 * @author lucky
 *
 */
public class enter extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response) {
		//获取表单提交的信息
		String username = request.getParameter("username");
		String qq = request.getParameter("qq");
		
		//标记，i=2:出现错误 i=1:登录成功 i=0:登录失败
		int i = 2;
		
		//调用database方法read查询数据库
		//用户名密码（qq）匹配则i=1 不匹配则i=0
		database db = new database();
		try {
			i = db.read(username, qq);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println(i);
	}
}

5.数据库操作相关程序database.java

/*
 * 数据库操作相关程序
 */
public class database {
	/*
	 * 用户注册，像数据库中添加信息
	 */
	public void insert(String username,String telephone,String email,String qq) throws Exception {
		//连接池
		ComboPooledDataSource cp = new ComboPooledDataSource();
		Connection conn = cp.getConnection();
		String sql = "insert into user(username,telephone,email,qq) values(?,?,?,?);";
		
		//语句预编译执行者
		PreparedStatement pt = conn.prepareStatement(sql);
		
		//插入参数
		pt.setString(1, username);
		pt.setString(2, telephone);
		pt.setString(3, email);
		pt.setString(4, qq);
		
		//执行sql语句，输出结果
		int i = pt.executeUpdate();
		System.out.println(i);
	}
	/*
	 * 用户登录  向数据库查询用户输入信息是否正确
	 */
	public int read(String username,String qq) throws Exception {
		ComboPooledDataSource cp = new ComboPooledDataSource();
		Connection conn = cp.getConnection();
		
		//通过提交的用户名对比查询相应的qq 结果一致则输入正确 不一致则输入错误
		String sql = "select qq from user where username = ?;";
		
		//用pwd接受数据库中查询出来的qq信息
		String pwd = null;
		PreparedStatement pt = conn.prepareStatement(sql);
		pt.setString(1, username);
		
		//re接收结果集
		ResultSet rs = pt.executeQuery();
		
		//对比qq信息是否一致
		while(rs.next()){
			pwd = rs.getString("qq");
			System.out.println("qq"+pwd);
		}
		
		//输出结果
		if(pwd.equals(qq)) return 1;
		else	return 0;
	}
}

6.web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>registerenter</display-name>
  <servlet>
  	<servlet-name>register</servlet-name>
  	<servlet-class>web.register</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>register</servlet-name>
  	<url-pattern>/register</url-pattern>
  </servlet-mapping>
  <servlet>
  	<servlet-name>enter</servlet-name>
  	<servlet-class>web.enter</servlet-class>
  
  </servlet>
  <servlet-mapping>
  	<servlet-name>enter</servlet-name>
  	<url-pattern>/enter</url-pattern>
  </servlet-mapping>
</web-app>

新人学习记录，有问题可以一起探讨。