java-登录、注册
1.实体类
2.前端页面
3.后台Java代码实现
4.数据库设计
实体类
package com.web.model;
/**
* @author Administrator
* @date 2022年5月23日
*/
public class User {
private Integer id;
private String name;
private String pwd;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public User() {
super();
// TODO Auto-generated constructor stub
}
public User(Integer id, String name, String pwd, Integer age) {
super();
this.id = id;
this.name = name;
this.pwd = pwd;
this.age = age;
}
/*@Override
public String toString() {
return "User [id=" + id + ", name=" + name + ", pwd=" + pwd + ", age=" + age + "]";
}*/
}
数据库连接工具类
package com.web.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @author Administrator
* @date 2022年5月23日
*/
public class DBUtil {
static {
// 1:添加驱动程序
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConn() {
// 2:连接数据库
Connection conn = null;
try {
conn = DriverManager.getConnection("jdbc:sqlserver://192.20.128.9;databaseName=test", "sa", "sa@123456");
System.out.println("数据库连接成功!");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
// 7:关闭资源
try {
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (ps != null)
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
登录servlet
package com.web.servlet;
import com.web.util.DBUtil;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* @author Administrator
* @date 2022年5月23日
*/
//配置访问路径
@WebServlet(urlPatterns = "/LoginServlet")
public class LoginServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//1:设置编码问题
// 设置请求的编码问题
request.setCharacterEncoding("utf-8");
//设置响应编码问题
response.setCharacterEncoding("utf-8");
//设置响应的显示格式
response.setContentType("text/html");
//2:处理请求
String userName = request.getParameter("userName");
String pwd = request.getParameter("pwd");
// 验证登录是否成功
boolean isTrue = false;
// 登录业务 --->查询 ---> select * from school where userName=? and pwd=?
//jdbc
Connection conn = DBUtil.getConn();
// 3:添加sql语句
String sql = "select * from tab_user where name=? and pwd=?";
// 4:获取
PreparedStatement ps = null;
// 5:转换
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, userName);
ps.setString(2, pwd);
rs = ps.executeQuery();
if (rs.next()) {
isTrue = true;
}else{
isTrue = false;
}
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.close(conn, ps, rs);
// 处理响应
if (isTrue) {
response.sendRedirect("ListServlet");
}else{
response.sendRedirect("login.jsp");
}
}
}
注册servlet
package com.web.servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.web.util.DBUtil;
/**
* @author Administrator
* @date 2022年5月23日
*/
//配置访问路径
@WebServlet(urlPatterns = "/RegServlet")
public class RegServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 1:首先要把编码全部改为utf-8
// 将请求中的编码设置为utf-8
request.setCharacterEncoding("utf-8");
// 将响应中的编码设置为utf-8
response.setCharacterEncoding("utf-8");
// 设置响应的显示格式(类型)
response.setContentType("text/html");
//2:处理请求
String userName = request.getParameter("userName");
String pwd = request.getParameter("pwd");
//String name = request.getParameter("name");
String ageStr = request.getParameter("age");
Integer age = Integer.parseInt(ageStr);
// 我们未来将要添加的代码区域
// 注册---> 新增---> insert into book(title,author,classify,versions) values
// (?,?,?,?)
boolean isTrue = false; // 注册是否成功
// 3:添加sql语句
Connection conn = DBUtil.getConn();
String sql = "insert into tab_user(name,pwd,age) values (?,?,?)";
// 4:获取结果
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
ps.setString(1, userName);
ps.setString(2, pwd);
//ps.setString(3, name);
ps.setInt(3, age);
// 5:接收结果
int count = ps.executeUpdate();
// 6:输出结果
if (count > 0) {
// 注册成功!
isTrue = true;
}else{
// 注册失败!
isTrue = false;
}
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.close(conn, ps, null);
//3:处理响应
if (isTrue) {
PrintWriter out = response.getWriter();
response.setContentType("text/html");
out.println("<script type=\"text/javascript\">");
out.println("alert('注册成功!');");
out.println("</script>");
response.sendRedirect("login.jsp");//注册成功就返回登录页面
}else{
response.sendRedirect("reg.jsp");
}
}
}
列表展示servlet
package com.web.servlet;
import com.web.model.User;
import com.web.util.DBUtil;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* @author Administrator
* @date 2022年5月23日
*/
//配置访问路径
@WebServlet(urlPatterns = "/ListServlet")
public class ListServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 1:首先要把编码全部改为utf-8
// 将请求中的编码设置为utf-8
request.setCharacterEncoding("utf-8");
// 将响应中的编码设置为utf-8
response.setCharacterEncoding("utf-8");
// 设置响应的显示格式(类型)
response.setContentType("text/html");
// 我们未来将要添加的代码区域
// 列表---> 查询---> select * from students
// (?,?,?,?)
// jdbc
//1:添加驱动程序
//2:连接数据库
Connection conn = DBUtil.getConn();
// 3:添加sql语句
String sql = "select * from tab_user";
ArrayList<User> studentsList = new ArrayList<User>();
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 4:获取结果
ps = conn.prepareStatement(sql);
// 5:接收结果
rs = ps.executeQuery();
// 6:输出结果
while (rs.next()) {
User students = new User();
students.setId(rs.getInt("id"));
students.setName(rs.getString("name"));
students.setPwd(rs.getString("pwd"));
students.setAge(rs.getInt("age"));
studentsList.add(students);
}
//3:处理响应
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE>");
out.println("<style type=\"text/css\">"
+ ".left{width:100px;text-align: center;}"
+ ".right{width: 200px;}" + "table{margin: 0 auto;}"
+ "th{font-size: 30px;color: red;}" + "td{height: 50px;}"
+ "h1{text-align: center; color:red;font-size: 50px;}</style>");
out.println("</HEAD>");
out.println(" <BODY>");
out.println(" <h1>列表页面</h1>");
// 输出
out.println("<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">"
+ "<tr>"
+ " <td class=\"left\">编号</td>"
+ " <td class=\"left\">用户名</td>"
+ " <td class=\"left\">密码</td>"
+ " <td class=\"left\">姓名</td>"
+ " <td class=\"left\">年龄</td>"+ "</tr>");
for (User students : studentsList) {
out.println(students.toString());
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
} catch (SQLException e) {
e.printStackTrace();
}
// 7:关闭资源
DBUtil.close(conn, ps, rs);
}
}
登录页面
<%-- <%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%> --%>
<%@ 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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="LoginServlet" method="post">
<table border="1" cellspacing="0" cellpadding="1" align="center">
<h1 style="text-align: center; color: red;">登录页面</h1>
<tr>
<td><center>用户名:</center></td>
<td><input type="text" name="userName"></td>
</tr>
<tr>
<td><center>密码:</center></td>
<td><input type="password" name="pwd"></td>
</tr>
<tr>
<td align="center" colspan="2"><input type="submit" value="登录" />
<a href="reg.jsp"><input type="button" value="注册"></a> <input
type="reset" id="btn_reset" onclick="funreset" value="重置"></td>
</tr>
</table>
</form>
<script type="text/javascript">
function funreset() {
var text=document.getElementById("btn_reset");
text.value="";
}
</script>
</body>
</html>
注册页面
<%-- <%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%> --%>
<%@ 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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<style type="text/css">
.model {
text-align: center;
color: red;
font-size: 30px;
}
</style>
</head>
<body>
<div class="model">
<form action="RegServlet" method="post">
<table border="1" cellspacing="0" cellpadding="1" align="center">
注册页面
<tr>
<td><center>账号:</center></td>
<td><input type="text" name="userName" /></td>
</tr>
<tr>
<td><center>密码:</center></td>
<td><input type="password" name="pwd" /></td>
</tr>
<tr>
<td><center>年龄:</center></td>
<td><input type="text" name="age" /></td>
</tr>
<!-- <tr>
<td><center>确认密码:</center>
</td>
<td><input type="password" name="pwd" />
</td>
</tr> -->
<!-- <tr>
<td><center>姓名:</center></td>
<td><input type="text" name="name" /></td>
</tr> -->
<tr>
<td align="center" colspan="2"><input type="submit" value="注册">
<a href='login.jsp'><input type="button" value="登录"> </a></td>
</tr>
</table>
</form>
</div>
</body>
</html>
数据库设计字段以及数据
CREATE TABLE [dbo].[tab_user] (
[id] int identity(1,1) primary key NOT NULL,
[name] varchar(10) NOT NULL,
[pwd] varchar(10) NOT NULL,
[age] int(10) NOT NULL
)
jar包