📄 searchpro.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"; 
  String pname="";  
  String sql="";
  if(request.getParameter("pname")!=null)
   {
    pname=request.getParameter("pname");
    pname=new String(pname.getBytes("ISO-8859-1"));
    sql="SELECT * FROM "+tableName+" WHERE pname REGEXP '"+pname+"'";
   }
  if(pname.equals(""))
  {
    sql="SELECT * FROM "+tableName+" WHERE pname REGEXP '_*'";
  }  
  if(request.getParameter("stock")!=null) 
  {
    String ss=request.getParameter("stock");
    sql="SELECT * FROM "+tableName+" WHERE stock<="+ss;
  } 
 out.print(sql+"<BR>");
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(); 
  ResultSet rs = stmt.executeQuery(sql); 
%>
 搜索结果如下：<BR> 
 <TABLE BORDER=1 bordercolorlight=#000000 >
  <TR><TD width=40>序号</TD>
  <TD width=60>代码</TD>
  <TD width=80>商品名称</TD>
  <TD width=60>品牌</TD>
  <TD width=150>产品简介</TD><TD width=80>存货数量</TD>
  <TD width=80>价格/元</TD>
  <TD width=60>更改</TD>
  <TD width=60>删除</TD></TR>
<% 
  while(rs.next())
    {
     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 + -