📄 se.jsp

📁 机械工业出版社的《jsp2.0动态网站开发实例指南》的源代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="shop.logBean" %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%!
	public String codeString(String s){
		String str=s;
                try{
			byte b[]=str.getBytes("ISO-8859-1");
			str=new String (b);
			return str;
		}catch(Exception e){return str;}
	}
%>
<html>
<head>
<title>Shop</title>
</head>
<body bgcolor=#C0C0C0>
<%
	if(session.isNew()){
		response.sendRedirect("index.jsp");
	}
	%>
	<jsp:useBean id="log" class="shop.logBean" scope="session"/>
	<%
	String islog=log.getIslog();
	if(!islog.equals("true")){
		response.sendRedirect("index.jsp");
	}
	%>
	<center>
	<jsp:getProperty name="log" property="id"/>,查询商品
	<%
	if(log.getId().equals("admini")){
		%>
		<jsp:include page="adminihead.txt"/>
		<%
		}
	else{	
		%>
		<jsp:include page="head.txt"/>
		<%
	}
	String hidden=request.getParameter("hidden");
	if(hidden==null)hidden="";
	hidden=codeString(hidden);
	String text=request.getParameter("text");
	if(text==null)text="";
	text=codeString(text);
	if(text.equals("")||!(hidden.equals("name")||hidden.equals("type")||hidden.equals("product"))){
		%>
		<form method="post" action="se.jsp" name="name">
		按照商品名称查询<input type="text" name="text" size="20" maxlength="20">
		<input type="submit" name="name" value="查询">
		<input type="hidden" name="hidden" value="name">
		</form>
		<br>
		<form method="post" action="se.jsp" name="type">
		按照商品类型查询<input type="text" name="text" size="20" maxlength="20">
		<input type="submit" name="submit" value="查询">
		<input type="hidden" name="hidden" value="type">
		</form>
		<br>
		<form method="post" action="se.jsp" name="product">
		按照商品产地查询<input type="text" name="text" size="20" maxlength="20">
		<input type="submit" name="submit" value="查询">
		<input type="hidden" name="hidden" value="product">
		</form>
		<br>
		</center>
		</body>
		</html>
		<%
	}
	else{
	
		try{
     			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  			Connection con;
  			Statement sql;
  			ResultSet rs;
  			String id;
  			String type;
  			String name;
  			float price;
  			long amount;
  			String distr;
  			String product;
     			con=DriverManager.getConnection("jdbc:odbc:myshop","","");
     			sql=con.createStatement();
     			String condition;
     			condition="SELECT * FROM goods where " +hidden+ "='"+text+"'";
      			rs=sql.executeQuery(condition);
      			int rowcount=0;	
      			%>
      			<center>
      			<table width="800" bgcolor="#C0C0C0" >
      			<tr>
			<td ><table border="1" width="800" height="30">
			<td width="100" valign="middle" align="center">商品</td>
			<td width="100" valign="middle" align="center">类型</td>
			<td width="100" valign="middle" align="center">余量</td>
			<td width="100" valign="middle" align="center">价格</td>
			<td width="100" valign="middle" align="center">产地</td>
			<td width="100" valign="middle" align="center">介绍</td>
			<td width="100" valign="middle" align="center">数量</td>
			<td width="100" valign="middle" align="center">购入</td>
			</table></td>
			</tr>
      			<%
    			while(rs.next()){
       				rowcount++;
      				id=rs.getString("id");
      				type=rs.getString("type");
  				name=rs.getString("name");
  				price=rs.getFloat("price");
  				amount=rs.getLong("amount");
  				distr=rs.getString("distr");
  				if(distr==null)distr="";
  				if(distr.equals(""))distr="无信息";
  				product=rs.getString("product");
  				if(product==null)product="";
  				if(product.equals(""))product="无信息";
  				%>
  				<tr>
				<td><table  border="1" width="800" height="30">
				<form action="cart.jsp" method="post" name="form_<%=id%>">
				<td width="100" valign="middle" align="center"><a href="img/<%=id%>.jpg"><img src="img/<%=id%>.jpg" width="100" height="100"></a></td>
				
				<td width="100" valign="middle" align="center"><%=type%></td>
				<td width="100" valign="middle" align="center"><%=amount%></td>
				<td width="100" valign="middle" align="center"><%=price%></td>
				<td width="100" valign="middle" align="center"><%=product%></td>
				<td width="100" valign="middle" align="center"><%=distr%></td>
				<td width="100" valign="middle" align="center">
				<%
					if(!log.getId().equals("admini"))
					out.println("<input type=text maxlength=2 name=text size=4>");
				%>
				</td>
				<td width="100" valign="middle" align="center">
				<%
					if(!log.getId().equals("admini"))
					out.println("<input type=submit name=submit value=购入>");
				%>
				</td>
				<input type=hidden name="hidden" value="<%=name%>">
				</form>
				</table></td>
				</tr>
  				<%
      			}
      			%>
      			</table>
      			</center>
      			<%
      			con.close();
      		}catch(SQLException e){
      			response.sendRedirect("index.jsp");
      		}catch(ClassNotFoundException e){
  			response.sendRedirect("index.jsp");
  		}
	}	
%>
⌨️ 快捷键说明

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