📄 car_xiangxi.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="connection" scope="page" class="com.wy.JDBConnection"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../CSS/style.css">
<title>
Manager CarMessageshow page
</title>
</head>
<%!
ResultSet rs=null;
String sql;
String userName;
int num,code;
%>
<body bgcolor="#ffffff"><jsp:include page="mtop.jsp"/>
<table width="785" border="1" align="center" cellpadding="0" cellspacing="0"bordercolor="#FFFFFF" bordercolordark="#333333" bordercolorlight="#FFFFFF">
<tr>
<td width="786" height="62" colspan="4">
<p align="center">车辆信息展示</td>
</tr>
<%
sql="select * from tb_CarMessage where Code="+request.getParameter("id");
try
{
rs=connection.executeQuery(sql);
if(rs.next())
{
code=rs.getInt("Code");
%>
<tr>
<td width="18%" height="34" align="center">车牌号码：</td>
<td width="32%" height="34" align="center"><%=rs.getString("TradeMark")%></td>
<td width="19%" height="34" align="center">车辆品名：</td>
<td width="31%" height="34" align="center"><%=rs.getString("Brand")%></td>
</tr>
<tr>
<td width="18%" height="36" align="center">车辆类型：</td>
<td width="32%" height="36" align="center"><%=rs.getString("Style")%></td>
<td width="19%" height="36" align="center">车辆限量：</td>
<td width="31%" height="36" align="center"><%=rs.getString("CarLoad")%>吨</td>
</tr>
<tr>
<td width="18%" height="37" align="center">已使用：</td>
<td width="32%" height="37" align="center"><%=rs.getString("UsedTime")%>年</td>
<td width="18%" height="37" align="center">驾驶员名称：</td>
<td width="32%" height="37" align="center"><%=rs.getString("DriverName")%></td>
</tr>
<tr>
<td width="19%" height="37" align="center">驾驶证驾龄：</td>
<td width="31%" height="37" align="center"><%=rs.getString("DriverTime")%></td>
<td width="18%" height="36" align="center">驾驶证号码：</td>
<td width="32%" height="36" align="center"><%=rs.getString("LicenceNumber")%></td>
</tr>
<tr>
<td width="19%" height="36" align="center">驾驶员类型：</td>
<td width="31%" height="36" align="center"><%=rs.getString("LicenceStyle")%></td>
<td width="19%" height="37" align="center">运输类型：</td>
<td width="31%" height="37" align="center"><%=rs.getString("TranspotStyle")%></td>
</tr>
<tr>
<td width="18%" height="42" align="center">联系人：</td>
<td width="32%" height="42" align="center"><%=rs.getString("LinkMan")%></td>
<td width="19%" height="42" align="center">联系电话：</td>
<td width="31%" height="42" align="center"><%=rs.getString("LinkPhone")%></td>
</tr>
<tr>
<td width="18%" height="65" align="center">备注：</td>
<td width="82%" height="65" colspan="3">
<%=rs.getString("Remark")%></td>
</tr>
<tr>
<td width="18%" height="42" align="center">发布时间：</td>
<td width="32%" height="42">
<p align="center"><%=rs.getString("IssueDate")%></td>
<td width="19%" height="42" align="center">发布人：</td>
<td width="31%" height="42" align="center"><%=rs.getString("UserName")%></td>
</tr>
<tr>
<td width="100%" height="33" colspan="4" align="center">
<a href="car_change.jsp?id=<%=code%>">修改</a>
<a href="car_delete.jsp?id=<%=code%>">删除</a></td>
</tr>
<%
}
}catch(SQLException e)
{
System.out.print("查询异常！！");
}
%>
</table><jsp:include page="down.jsp"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -