登录界面的JSP代码通常涉及HTML表单和JSP标签来处理用户输入。以下是一个简单的示例,展示了如何创建一个基本的登录界面:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Login Page</title>
</head>
<body>
<h2>Login</h2>
<form action="loginProcess.jsp" method="post">
Username: <input type="text" name="username"><br><br>
Password: <input type="password" name="password"><br><br>
<input type="submit" value="Login">
</form>
</body>
</html>
<%@ page import="java.sql.*" %>
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
// 假设数据库连接信息
String url = "jdbc:mysql://localhost:3306/mydatabase";
String dbUsername = "root";
String dbPassword = "password";
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, dbUsername, dbPassword);
String sql = "SELECT * FROM users WHERE username=? AND password=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
ResultSet rs = pstmt.executeQuery();
if (rs.next()) {
out.println("Login successful!");
} else {
out.println("Invalid username or password.");
}
rs.close();
pstmt.close();
conn.close();
} catch (Exception e) {
out.println("Error: " + e.getMessage());
}
%>
PreparedStatement
)来防止SQL注入攻击。通过以上代码和解释,你应该能够理解如何创建一个基本的登录界面,并了解相关的概念和最佳实践。
领取专属 10元无门槛券
手把手带您无忧上云