📄 carsearch.jsp

📁 汽车展销的网站开发
💻 JSP
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312" import="java.sql.*"%>
<jsp:useBean id="check" class="Bean.DbConn" scope="page"/>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<%
	ResultSet rs=null;
	int count=0;
	check.open();
	String path="C:\\Program Files\\Tomcat 5.5\\webapps\\ROOT\\car\\images\\";
	String sql="select car_id,bname,type,price,prodtime,browse_num,cover,manufacturer from category,car where category.brand_id=car.brand_id";
	String str="select count(*) as countNum from category,car where category.brand_id=car.brand_id";
	rs=check.executeQuery(str);
	if(rs.next())
		count=rs.getInt("countNum");
	rs=check.executeQuery(sql);
	
%>
<center><font size="+1">共有</font><font size="+2" color="#FF0000"><%=count%></font><font size="+1">条搜索结果</font></center><p>
<%
	while(rs.next())
	{
		int car_id=rs.getInt("car_id");
		String bname=rs.getString("bname");
		String type=rs.getString("type");
		String price=rs.getString("price");
		String p=rs.getString("prodtime");
		String prodtime=p.substring(0,10);
		String browse_num=rs.getString("browse_num");
		String cover="<img src='C:\\Program Files\\Tomcat 5.5\\webapps\\ROOT\\car\\images\\"+rs.getString("cover")+"'>";
		String manufacturer=rs.getString("manufacturer");
		out.println("<table border='1' align='center' bordercolor='#cccccc' width='600' height='100'>");
		out.print("<tr><td rowspan='4' width='130' height='100'><a href='..\\CarInfo.jsp?car_id="+car_id+"'>"+cover+"</a></td>");
		out.print("<td>汽车名称："+bname+type+"</td></tr>");
		out.print("<tr><td>生产厂家："+manufacturer+"</td></tr>");
		out.print("<tr><td>上市时间："+prodtime+"&nbsp;&nbsp;&nbsp;浏览次数："+browse_num+"</td></tr>");
		out.print("<tr><td>价格："+price+"元&nbsp;&nbsp;&nbsp;<a href='..\\CarInfo.jsp?car_id="+car_id+"'><font color='red'>查看更多>></font></a>&nbsp;&nbsp;&nbsp;<a href='carModify.jsp?car_id="+car_id+"'>【修改】</a><a href='carDelete.jsp?car_id="+car_id+"'>【删除】</a></td></tr>");
		out.print("</table>");
	 }
		
%>	

<%
	check.close();
	
%>
</body>
</html>
⌨️ 快捷键说明

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