Servlet修改

最新推荐文章于 2023-04-19 15:14:31 发布

天真.。

最新推荐文章于 2023-04-19 15:14:31 发布

阅读量1.4k

点赞数 3

分类专栏：数据库文章标签： Servlet

本文链接：https://blog.csdn.net/weixin_42509567/article/details/84798820

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

#Select 修改操作思路（通过ID查找到对应的信息，带参数回显到修改页面）

1.1通过ID查找到对应的信息
	@WebServlet("/toupd")
	public class toupd extends HttpServlet{
	@Override
	protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String id = request.getParameter("id");
		Connection conn=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d","root","root");
		PreparedStatement pr = conn.prepareStatement("select * from tb_car2 where id=?");	
		pr.setString(1, id);
		ResultSet re = pr.executeQuery();
		if (re.next()) {
			int id1 = re.getInt("id");
			String name = re.getString("name");
			String ys = re.getString("ys");
			String jg = re.getString("jg");
			String scd = re.getString("scd");
			String rq = re.getString("rq");
			Tb tb=new Tb(id1, name, ys, jg, scd, rq);
			System.out.println(tb);
			request.setAttribute("ulist", tb);
			request.getRequestDispatcher("upd.jsp").forward(request, response);
		}
		
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			if (conn!=null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}
	}
1.2带参数回显到修改页面
	<html>
	<head>
	<link href="<%=request.getContextPath()%>/css/css.css" rel="stylesheet">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<title>Insert title here</title>
	</head>
	<body>
	<form action="upd" method="post">
	序号<input  type="text" name="id" readonly="readonly" value="${ulist.id }"><br><br>
	品牌<input type="text" name="name" value="${ulist.name }"><br><br>
	颜色<input type="text" name="ys" value="${ulist.ys }"><br><br>
	价格<input type="text" name="jg" value="${ulist.jg }"><br><br>
	生产地<input type="text" name="scd" value="${ulist.scd }"><br><br>
	生产日期<input type="date" name="rq" value="${ulist.rq }"><br><br>
	<input type="submit" value="提交">
	<!-- 	<td>${u.id }</td>
			<td>${u.name }</td>
			<td>${u.ys }</td>
			<td>${u. jg}</td>
			<td>${u. scd}</td>
			<td>${u.rq }</td> -->
	</form>
	</body>
	</html>
1.3修改信息，将所有信息提交到upd，成功并重定向到列表页面
			@WebServlet("/upd")
	public class upd extends HttpServlet {
		@Override
		protected void service(HttpServletRequest request, HttpServletResponse response)
				throws ServletException, IOException {
			String id = request.getParameter("id");
			String name = request.getParameter("name");
			String ys = request.getParameter("ys");
			String jg = request.getParameter("jg");
			String scd = request.getParameter("scd");
			String rq = request.getParameter("rq");
			System.out.println(id);
			System.out.println(name);
			System.out.println(ys);
			System.out.println(jg);
			System.out.println(scd);
			System.out.println(rq);
			Connection conn = null;
			try {
				Class.forName("com.mysql.jdbc.Driver");
				conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/1701d", "root", "root");
				PreparedStatement pr = conn.prepareStatement("update tb_car2 set name=?,ys=?,jg=?,scd=?,rq=? where id=?");
				pr.setString(1, name);
				pr.setString(2, ys);
				pr.setString(3, jg);
				pr.setString(4, scd);
				pr.setString(5, rq);
				pr.setString(6, id);
	
				int insert = pr.executeUpdate();
				if (insert > 0) {
					System.out.println("修改成功");
					response.sendRedirect("list");
				} else {
					System.out.println("修改失败");
				}
	
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} finally {
				if (conn != null) {
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
			/*
			 * <!-- <td>${u.id }</td> <td>${u.name }</td> <td>${u.ys }</td> <td>${u.
			 * jg}</td> <td>${u. scd}</td> <td>${u.rq }</td> -->
			 */
	
		}
	}

天真.。

关注

3
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
Servlet修改

#Select 修改操作思路（通过ID查找到对应的信息，带参数回显到修改页面）1.1通过ID查找到对应的信息 @WebServlet(&quot;/toupd&quot;) public class toupd extends HttpServlet{ @Override protected void service(HttpServletRequest request, HttpServletRespon...
复制链接

扫一扫

专栏目录