登录和注册的jsp页面+servlet+javaBean+mysql
时间: 2023-07-29 09:13:50 浏览: 49
好的,我可以为您提供一个包含登录和注册功能的 JSP 页面、Servlet、JavaBean 和 MySQL 数据库连接的示例。
1. 登录页面 login.jsp
```
<html>
<head>
<title>登录页面</title>
</head>
<body>
<h3>用户登录</h3>
<form action="loginServlet" method="post">
用户名:<input type="text" name="username"><br>
密 码:<input type="password" name="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
```
2. 注册页面 register.jsp
```
<html>
<head>
<title>注册页面</title>
</head>
<body>
<h3>用户注册</h3>
<form action="registerServlet" method="post">
用户名:<input type="text" name="username"><br>
密 码:<input type="password" name="password"><br>
确认密码:<input type="password" name="confirm_password"><br>
<input type="submit" value="注册">
</form>
</body>
</html>
```
3. 用户 JavaBean User.java
```
public class User {
private String username;
private String password;
public User() {
}
public User(String username, String password) {
this.username = username;
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
```
4. 数据库连接工具类 DbUtil.java
```
import java.sql.*;
public class DbUtil {
private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/test";
private static String user = "root";
private static String password = "123456";
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn, Statement stmt, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
```
5. 登录 Servlet loginServlet.java
```
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class loginServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String username = request.getParameter("username");
String password = request.getParameter("password");
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
conn = DbUtil.getConnection();
String sql = "SELECT * FROM user WHERE username=? AND password=?";
stmt = conn.prepareStatement(sql);
stmt.setString(1, username);
stmt.setString(2, password);
rs = stmt.executeQuery();
if (rs.next()) {
out.println("<html>");
out.println("<head><title>登录结果</title></head>");
out.println("<body>");
out.println("<h3>登录结果</h3>");
out.println("欢迎您," + username);
out.println("</body>");
out.println("</html>");
} else {
out.println("<html>");
out.println("<head><title>登录结果</title></head>");
out.println("<body>");
out.println("<h3>登录结果</h3>");
out.println("用户名或密码错误,请重新输入!");
out.println("</body>");
out.println("</html>");
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DbUtil.close(conn, stmt, rs);
}
out.close();
}
}
```
6. 注册 Servlet registerServlet.java
```
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class registerServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String username = request.getParameter("username");
String password = request.getParameter("password");
String confirm_password = request.getParameter("confirm_password");
if (!password.equals(confirm_password)) {
out.println("<html>");
out.println("<head><title>注册结果</title></head>");
out.println("<body>");
out.println("<h3>注册结果</h3>");
out.println("两次密码输入不一致,请重新输入!");
out.println("</body>");
out.println("</html>");
out.close();
return;
}
Connection conn = null;
PreparedStatement stmt = null;
try {
conn = DbUtil.getConnection();
String sql = "INSERT INTO user(username, password) VALUES (?, ?)";
stmt = conn.prepareStatement(sql);
stmt.setString(1, username);
stmt.setString(2, password);
stmt.executeUpdate();
out.println("<html>");
out.println("<head><title>注册结果</title></head>");
out.println("<body>");
out.println("<h3>注册结果</h3>");
out.println("恭喜您,注册成功!");
out.println("</body>");
out.println("</html>");
} catch (Exception e) {
e.printStackTrace();
} finally {
DbUtil.close(conn, stmt, null);
}
out.close();
}
}
```
以上就是一个包含登录和注册功能的 JSP 页面、Servlet、JavaBean 和 MySQL 数据库连接的示例。如果您有更多的需求,可以根据自己的业务需求进行修改和扩展。