JSP和JDBC的使用

最新推荐文章于 2021-10-20 11:12:30 发布

小满不吃香菜

最新推荐文章于 2021-10-20 11:12:30 发布

阅读量820

点赞数

分类专栏： javaweb

本文链接：https://blog.csdn.net/fjd7474/article/details/106389249

版权

javaweb 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

查询数据
在这里插入图片描述

<%@ page import="java.sql.*" %>


<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>

<!DOCTYPE html>
<html lang="en">


<head>

    <meta charset="UTF-8">
    <title>表格示例</title>
</head>

<body>

<%
    Connection connection = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    Class.forName("com.mysql.cj.jdbc.Driver");

    String url = "jdbc:mysql://localhost:3306/grade?user=root&password=18170021" +
            "&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC";

    connection = DriverManager.getConnection(url);

    String sql = "select * from stock";
    ps = connection.prepareStatement(sql);
    rs = ps.executeQuery();
%>

<h3>小型进销存系统</h3>
<table border="1">
    <tr>
        <th>订单号</th>
        <th>商品名</th>
        <th>进货日期</th>
        <th>供应商</th>
        <th>数量</th>
        <th>金额</th>
    </tr>

    <%
        while(rs.next()){  %>


    <tr>
        <td><%=rs.getInt("ordrId")%></td>
        <td><%=rs.getString("sName")%></td>
        <td><%=rs.getString("consignmentDate")%></td>
        <td><%=rs.getString("baleName")%></td>
        <td><%=rs.getInt("count")%></td>
        <td><%=rs.getDouble("money")%></td>
    </tr>
    <%}%>
</table>

</body>
</html>
</body>
</html>