数据库CRUD操作----查询

最新推荐文章于 2021-12-08 00:36:45 发布

奥申

最新推荐文章于 2021-12-08 00:36:45 发布

阅读量175

点赞数

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

本文链接：https://blog.csdn.net/qq_44890539/article/details/102864604

版权

JavaWeb 专栏收录该内容

13 篇文章 1 订阅

订阅专栏

数据库CRUD操作----查询

在这里插入图片描述
JSP页面

<%@ page import="com.hnpi.domain.Tianjia" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %><%--
  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2019/10/31
  Time: 21:16
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>展示页面</title>
    <script src="js/jquery-3.1.1.min.js"></script>
</head>
<body>
<center>
<table>
    <tr>
        <td>ID</td>
        <td>number</td>
        <td>pwd</td>
        <td>bumen</td>
        <td>juse</td>
    </tr>

    <%
        List<Tianjia> list = (ArrayList)session.getAttribute("list");
        for(Tianjia tianjia : list){
            %>
    <tr>
        <td><%=tianjia.getId()%></td>
        <td><%=tianjia.getNumber()%></td>
        <td><%=tianjia.getPwd()%></td>
        <td><%=tianjia.getBumen()%></td>
        <td><%=tianjia.getJuse()%></td>
    </tr>
    <%
        }
    %>

</table>
</center>
</body>
</html>

Servlet页面

package com.hnpi.servlet;

import com.hnpi.domain.Tianjia;
import com.hnpi.util.DBUtil;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

@WebServlet(value = "/ListServlet")
public class ListServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        HttpSession session = request.getSession();

        Connection conn = DBUtil.getConn();
        PreparedStatement ps  = null;
        ResultSet rs = null;
        String sql = "select * from Tianjia";
        List<Tianjia> tianjiaList = new ArrayList<Tianjia>();
        try {
            ps = conn.prepareStatement(sql);
            rs = ps.executeQuery();
            while(rs.next()){
                Tianjia tianjia = new Tianjia(rs.getInt(1),rs.getInt(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6));
                tianjiaList.add(tianjia);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.close(conn,ps,rs);
        }
        session.setAttribute("list",tianjiaList);
        request.getRequestDispatcher("list.jsp").forward(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request,response);
    }
}

好，这个查询页面就这么多代码，是不是很简单

奥申

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
数据库CRUD操作----查询

数据库CRUD操作----查询JSP页面<%@ page import="com.hnpi.domain.Tianjia" %><%@ page import="java.util.List" %><%@ page import="java.util.ArrayList" %><%-- Created by IntelliJ IDEA. ...
复制链接

扫一扫