【JSP+JDBC编程】实现简单的数据库增删改查

作者：AllinToyou | 2024-05-15 23:02:50

踩

数据库编程利用jdbc实现数据库连接和增删改查操作,并在jsp页面中进行显示。

为什么80%的码农都做不了架构师？>>>

JSP+JDBC技术完成用户管理功能#

【1】主界面模块##

1）index.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
 
<html>
<head>
 
<title>My JSP 'index.jsp' starting page</title>
 
</head>
 
<body>
	<%
		String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串
		Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序
		Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接
		String sql = "select * from users";
		PreparedStatement pStmt = conn.prepareStatement(sql);
		ResultSet rs = pStmt.executeQuery();
	%>
	<table border="1" width="500">
		<tr>
			<th>编号</th>
			<th>姓名</th>
			<th>密码</th>
			<th colspan="2">操作</th>
		</tr>
		<%
			while (rs.next()) {
		%>
 
		<tr>
			<td>
				<%
					out.print(rs.getString("id"));
				%>
			</td>
			<td>
				<%
					out.print(rs.getString("username"));
				%>
			</td>
			<td>
				<%
					out.print(rs.getString("password"));
				%>
			</td>
			<td><a href="delete.jsp?id=<%=rs.getString("id")%>"  onclick="return confirm('确定删除该条记录?')">删除</a></td>
			<td><a href="edit.jsp?id=<%=rs.getString("id")%>">编辑</a></td>
		</tr>
		<%
			}
		%>
 
	</table>
	</br>
	<a href="register.jsp">添加新记录</a>
 
	<%
		//关闭
		rs.close();
		pStmt.close();
		conn.close();
	%>
 
</body>
</html>

新建模块##

1）register.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
 
<html>
<head>
 
<title>My JSP 'register.jsp' starting page</title>
 
</head>
 
<body>
 
	<form action="add.jsp">
		姓名：<input type="text" name="username"/><br>
		密码：<input type="text" name="password"/><br><br>
		<input type="submit" value="添加" />
	</form>
 
</body>
</html>

2）add.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
 
<html>
<head>
 
<title>My JSP 'add.jsp' starting page</title>
 
</head>
 
<body>
 
	<%
		String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串
		Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序
		Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接
		
		String sql = "insert into users values(null,?,?)";
		PreparedStatement pStmt = conn.prepareStatement(sql);
		
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		pStmt.setString(1, username);
		pStmt.setString(2, password);
 
		int cnt = pStmt.executeUpdate();
		if (cnt > 0) {
			response.sendRedirect("index.jsp");
		} else {
			out.print("用户已存在，<a href='register.jsp'>重新注册</a>");
		}
 
		//关闭
		pStmt.close();
		conn.close();
	%>
	
</body>
</html>

编辑模块##

1）edit.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
 
 
<html>
<head>
 
<title>My JSP 'edit.jsp' starting page</title>
 
</head>
 
<body>
 
	<%
		String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串
		Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序
		Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接
 
		String id = request.getParameter("id");
		String username = "";
		String password = "";
 
		String sql = "select * from users where id=?";
		PreparedStatement pStmt = conn.prepareStatement(sql);
		pStmt.setString(1, id);
		ResultSet rs = pStmt.executeQuery();
		while (rs.next()) {
			username = rs.getString("username");
			password = rs.getString("password");
		}
	%>
	
	<form action="modify.jsp">
		编号：<input type="text" name="id" readonly="readonly" value="<%=id %>" /><br>
		 姓名：<input type="text" name="username" value="<%=username %>"  /><br>
		  密码：<input type="text" name="password"  value="<%=password %>"/><br><br> 
		 <input type="submit" value="修改" />
	</form>
	
	<%
		//关闭
		pStmt.close();
		conn.close();
 
	%>
 
</body>
</html>

2）modify.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
 
<html>
<head>
 
<title>My JSP 'modify.jsp' starting page</title>
 
</head>
 
<body>
	<%
		String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串
		Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序
		Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接
 
		String sql = "update users set username=?,password=? where id=?";
		PreparedStatement pStmt = conn.prepareStatement(sql);
 
		String id = request.getParameter("id");
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		
		pStmt.setString(1, username);
		pStmt.setString(2, password);
		pStmt.setString(3, id);
		
		pStmt.executeUpdate();
 
		//关闭
		pStmt.close();
		conn.close();
		
		response.sendRedirect("index.jsp");
	%>
 
</body>
</html>

删除模块##

1）delete.jsp###


<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
 
<html>
<head>
 
<title>My JSP 'delete.jsp' starting page</title>
 
</head>
 
<body>
	<%
		String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串
		Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序
		Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接
 
		String sql = "delete from users where id=?";
		PreparedStatement pStmt = conn.prepareStatement(sql);
 
		String id = request.getParameter("id");
 
		pStmt.setString(1, id);
		pStmt.executeUpdate();
		
		//关闭
		pStmt.close();
		conn.close();
		
		response.sendRedirect("index.jsp");
	%>
</body>
</html>

转载于:https://my.oschina.net/sugary/blog/673822

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/AllinToyou/article/detail/575396