📄 listpro.jsp

📁 一本jsp自学教材
💻 JSP
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@ page import= "javax.naming.* "%> 
<%@ page import= "javax.sql.DataSource "%> 
<%@ page import="java.sql.*" %>
<HTML>
<head>
<title>查看和管理商品</title>
</head>
<BODY>
<%@include file="includeTop.jsp"%>
<%  
   //表名  
  String tableName="product";    
try{
  Context initCtx = new InitialContext(); 
  Context ctx = (Context) initCtx.lookup("java:comp/env"); 
  //获取连接池对象 
  DataSource ds =(DataSource)ctx.lookup("jdbc/rot"); 
  //创建连接
  Connection conn = ds.getConnection(); 
  Statement stmt = conn.createStatement(); 
  String sql=sql="SELECT * FROM "+tableName;
  ResultSet rs = stmt.executeQuery(sql);  
  out.print("<TABLE BORDER=1 bordercolorlight=#000000 >");
  out.print("<TR><TD width=40>序号</TD>");
  out.print("<TD width=60>代码</TD><TD width=80>商品名称</TD>");
  out.print("<TD width=60>品牌</TD>");
  out.print("<TD width=150>产品简介</TD><TD width=80>存货数量</TD>");
  out.print("<TD width=80>价格/元</TD>");
  out.print("<TD width=60>更改</TD>");
  out.print("<TD width=60>删除</TD></TR>");
  rs.afterLast();
  while(rs.previous())
    {
     out.print("<TR>");
     out.print("<TD>"+rs.getInt(1)+"</TD>");
     out.print("<TD>"+rs.getString("pdm")+"</TD>");
     out.print("<TD>"+rs.getString("pname")+"</TD>");     
     out.print("<TD>"+rs.getString("provider")+"</TD>");
     out.print("<TD>"+rs.getString("info")+"</TD>");
     out.print("<TD>"+rs.getString("stock")+"</TD>");
     out.print("<TD>"+rs.getString("price")+"</TD>");
     out.print("<FORM action=update1.jsp method=post>");
     //通过一个隐藏的表单，提交记录的id用于识别该记录
     out.print("<TD><INPUT type='hidden' name='id' value='"+rs.getInt(1)+"'>");
     out.print("<INPUT type='submit' value='更改' name='submit'></TD>");
     out.print("</FORM>");
     out.print("<FORM action=delPro.jsp method=post>");
     //通过一个隐藏的表单，提交记录的id用于识别该记录
     out.print("<TD><INPUT type='hidden' name='id' value='"+rs.getInt(1)+"'>");
     out.print("<INPUT type='submit' value='删除' name='submit'></TD>");
     out.print("</FORM>");
     out.print("</TR>");
   }
  out.print("</TABLE>");

  rs.close(); 

  stmt.close();   
 
  conn.close();

catch(SQLException e)
  {
   out.print(e.toString()); 
  }  
%>  
</HTML>
</BODY>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -