📄 update1.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>
<%
  String tableName="product";  
  String pid=request.getParameter("id"); 
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(); 
  //发送执行SQL语句
  String sql=sql="SELECT * FROM "+tableName+" WHERE id="+pid;
  ResultSet rs =stmt.executeQuery(sql); 
  out.print("修改记录数据。<BR>");  
  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></TR>");
  rs.next();
     out.print("<TR>");
     out.print("<TD>"+rs.getInt(1)+"</TD>");
     //通过一个隐藏的表单，提交记录的id用于识别该记录
     out.print("<FORM action=update2.jsp method=post>"); 
     out.print("<TD><INPUT size=10 name='pdm' value='"+rs.getString("pdm")+"'></TD>");      
     out.print("<TD><INPUT name='pname' value='"+rs.getString("pname")+"'></TD>");      
     out.print("<TD><INPUT name='provider' value='"+rs.getString("provider")+"'></TD>");        
     out.print("<TD><INPUT name='info' value='"+rs.getString("info")+"'></TD>");    
     out.print("<TD><INPUT size=10 name='stock' value='"+rs.getString("stock")+"'></TD>");
     out.print("<TD><INPUT size=10 name='price' value='"+rs.getString("price")+"'></TD>");    
     out.print("<TD><INPUT type='hidden' name='id' value='"+pid+"'>");
     out.print("<INPUT type='submit' value='提交更改' name='submit'></TD>");
     out.print("</TR>");
  out.print("</TABLE>"); 
  rs.close();
  conn.close();   
 }
catch(SQLException e)
  {
   out.print(e.toString()); 
  }  
%>  
</HTML>
</BODY>
⌨️ 快捷键说明

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