JSP表单开发

杰.

已于 2024-06-23 16:03:09 修改

阅读量115

点赞数 3

文章标签： java 开发语言

于 2024-06-23 15:58:26 首次发布

本文链接：https://blog.csdn.net/2203_75655824/article/details/139901521

版权

index.jsp

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>查询数据</title>
</head>
<body>
	<h2>显示所有用户信息</h2>
	<table>
		<tr>
			<td>用户名</td>
			<td>密码</td>
		</tr>

		<%
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/lab2";
		Class.forName(driver);
			Connection conn = DriverManager.getConnection(url, "root", "123456");
			Statement stmt = conn.createStatement();
			String sql = "select * from user";
			ResultSet rs = stmt.executeQuery(sql);
			while (rs.next()) {
		%>
		<tr>
			<td><%=rs.getString("username")%></td>
			<td><%=rs.getString("password")%></td>
		</tr>
		<%
			}
			rs.close();
			stmt.close();
			conn.close();
		%>


	</table>

</body>
</html>

login_result.jsp

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
		request.setCharacterEncoding("UTF-8");
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/lab2";
		Class.forName(driver);
		Connection conn = DriverManager.getConnection(url, "root", "123456");
		
	//	String sql = "SELECT * FROM user WHERE username='" + username + "' and password='"+ password + "'";
	//	Statement stmt = conn.createStatement();
	//	ResultSet rs = stmt.executeQuery(sql);
	
		String sql = "SELECT * FROM user WHERE username=? and password=?";
		PreparedStatement pstat = conn.prepareStatement(sql);
		pstat.setString(1,username); //替换第一个问号的值
		pstat.setString(2,password); //替换第二个问号的值
		ResultSet rs = pstat.executeQuery();
		
		if(rs.next()){
			out.println("登陆成功");}
		else {
			out.println("登陆失败");
			}
			
			rs.close();
			pstat.close();
			conn.close();
		%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

</head>
<body>
	<h2>登录系统</h2>
	<form action="login_result.jsp" method="post" name="loginForm">
		<input type="text" name="username" placeholder="请输入用户名"><br>
		<br> <input type="text" name="password" placeholder="请输入密码"><br>
		<br> <input type="submit" value="登录">
	</form>
</body>
</html>

register_result.jsp

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>插入信息提示</title>
</head>
<body>
	<%
		request.setCharacterEncoding("UTF-8");
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/lab2";
		Class.forName(driver);
		Connection conn = DriverManager.getConnection(url, "root", "123456");

		String sql = "insert into user values(?,?)";
		PreparedStatement psmt = conn.prepareStatement(sql);
		psmt.setString(1, username);
		psmt.setString(2, password);
		
		String sqll = "SELECT * FROM user WHERE username=? and password=?";
		PreparedStatement pstat = conn.prepareStatement(sqll);
		pstat.setString(1,username);
		pstat.setString(2,password); 
		ResultSet rs = pstat.executeQuery();
		
		if(rs.next()){
			out.println("注册失败");}
		else {
			int n = psmt.executeUpdate();
			out.println("注册成功");
			}
		
		rs.close();
		psmt.close();
		conn.close();
	%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript">
function check() {
	if(registerForm.username.value == "") {
		alert("用户名不能为空");
		return false;
	}
	else if(registerForm.password.value == "") {
		alert("密码不能为空");
		return false;
	}
	return true;
}
</script>

</head>
<body>
	<h2>注册界面</h2>
	<form action="register_result.jsp" method="post" name="registerForm" onsubmit="return check()">
		<input type="text" name="username" placeholder="请输入用户名"><br>
		<br> <input type="text" name="password" placeholder="请输入密码"><br>
		<br> <input type="submit" value="保存">
	</form>
</body>
</html>