<%@page import="java.sql.SQLException"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="common.JDBConnect"%> <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> 상품재고조회

상품재고조회

<% ResultSet rs = null; JDBConnect jdbc = new JDBConnect(); try{ String sql = "select * from products"; jdbc.stmt = jdbc.con.createStatement(); rs = jdbc.stmt.executeQuery(sql); while (rs.next()){ %> <% } }catch (SQLException e) { out.println(" 데이터 베이스 접속 에러"); } finally { if (rs != null) rs.close(); if (jdbc.con != null) jdbc.con.close(); } %>
Product_id Product_name Category Price Description Stock_quantity
<%= rs.getString("product_id") %> <%= rs.getString("product_name") %> <%= rs.getString("category") %> <%= rs.getString("price") %> <%= rs.getString("description") %> <%= rs.getString("stock_quantity") %>