本文共 1040 字，大约阅读时间需要 3 分钟。

查询数据

<%@ page import="java.sql.*" %><%@ page contentType="text/html;charset=UTF-8" language="java" %>        
       <%    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();%>
小型进销存系统
   
    <%        while(rs.next()){     %>    
    <%}%>
        
     
              
订单号
              
商品名
              
进货日期
              
供应商
              
数量
              
金额
         
     
              
<%=rs.getInt("ordrId")%>
              
<%=rs.getString("sName")%>
              
<%=rs.getString("consignmentDate")%>
              
<%=rs.getString("baleName")%>
              
<%=rs.getInt("count")%>
              
<%=rs.getDouble("money")%>