1.登陆页面login.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="login.jsp" method="post">
用户:<input type="text" name="name" />
<br>密码:<input type="password" name="pwd"/>
<input type="submit" value="登录">
</form>
<a href="register.html">
<button >注册</button></a>
<a href="delete.html">
<button >删除</button></a>
<a href="queny.html">
<button >查询</button></a>
</body>
</html>
2.实现登录功能login.jsp
<%@ page language="java" import="java.util.*,java.sql.*,java.net.*" pageEncoding="utf-8"%>
<html>
<head>
</head>
<body>
<% //接收用户名和密码
String user = new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String pwd = request.getParameter("pwd");
String driverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/login";
String username = "root";
String password = "root";
try {
Class.forName(driverClass);//加载驱动
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection(url,username,password);//得到连接
PreparedStatement pStmt = conn.prepareStatement("select * from log where name = '" + user + "' and pwd = '" + pwd + "'");
ResultSet rs = pStmt.executeQuery();
if(rs.next()){
response.getWriter().print("登录成功");
}else{
response.getWriter().print("登录失败");
}
try {
rs.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
pStmt.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
%>
</body>
</html>
3.注册页面register.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action = "registercheck.jsp" method = "post">
<table >
<tr>
<th>用户名:</th>
<td><input type="text" name="name"></td>
</tr>
<tr>
<th>输入密码:</th>
<td><input type="text" name="pwd" ></td>
</tr>
<tr>
<td colspan = "2" align = "center">
<input type="submit" value="注 册">
</td>
</tr>
</table>
</form>
</body>
</html>
4.实现注册功能registercheck.jsp
<%@ page language="java" import="java.util.*,java.sql.*,java.net.*" pageEncoding="utf-8"%>
<html>
<head>
</head>
<body>
<%
String user = new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String pwd = request.getParameter("pwd");
String driverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/login";
String username = "root";
String password = "root";
try {
Class.forName(driverClass);//加载驱动
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection(url,username,password);//得到连接
PreparedStatement pStmt = conn.prepareStatement("select * from log where name= '" + user + "'");
ResultSet rs = pStmt.executeQuery();
if(rs.next()){
response.sendRedirect("have.jsp");
}else{
PreparedStatement tmt = conn.prepareStatement("insert into log(name,pwd)value (?,?)");
tmt.setString(1, user);
tmt.setString(2, pwd);
int rst = tmt.executeUpdate();
if (rst != 0){
response.getWriter().print("注册成功");
}else{
response.getWriter().print("注册失败");
}
tmt.close();
}
rs.close();
conn.close();
%>
</body>
</html>
5.查询页面queny.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="Query.jsp" method="post">
查询:<input type="text" name="name" />
<input type="submit" value="查询">
</form>
</body>
</html>
6.查询功能实现Quency.jsp
<%@ page language="java" import="java.util.*,java.sql.*,java.net.*" pageEncoding="utf-8"%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
String user = new String(request.getParameter("name").getBytes("ISO-8859-1"),"UTF-8");
String driverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/login";
String username = "root";
String password = "root";
try {
Class.forName(driverClass);//加载驱动
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection(url,username,password);//得到连接
PreparedStatement pr = conn.prepareStatement("select * from log where name = ?");
pr.setObject(1,user);
ResultSet rs = pr.executeQuery();
if(rs.next()){
String name=rs.getString(1);
String id=rs.getString(2);
response.getWriter().println("用户名:"+name);
response.getWriter().print("密码:"+id);
}else{
response.getWriter().print("该用户不存在");
}
try {
rs.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
pr.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
%>
</body>
</html>
7.删除页面delete.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="delete.jsp" method="post">
删除:<input type="text" name="dename" />
<input type="submit" value="删除">
</form>
</body>
</html>
8.删除功能实现delete.jsp
<%@ page language="java" import="java.util.*,java.sql.*,java.net.*" pageEncoding="utf-8"%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
String user = new String(request.getParameter("dename").getBytes("ISO-8859-1"),"UTF-8");
String driverClass = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/login";
String username = "root";
String password = "root";
try {
Class.forName(driverClass);//加载驱动
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection conn = DriverManager.getConnection(url,username,password);//得到连接
PreparedStatement pr = conn.prepareStatement("delete from log where name ='"+user+"'");
int a=pr.executeUpdate();
if (a != 0){
response.getWriter().print("删除成功");
}else{
response.getWriter().print("删除失败");
}
try {
pr.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
%>
</body>
</html>
数据库内容