📄 car_index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"language="java" import="java.sql.*,java.io.*" %>
<%request.setCharacterEncoding("gb2312");%>
<%! String getCol(ResultSet rst,int type,int column)throws Exception
{ String str;
switch(type)
{case (1):
str=rst.getString(column);
break;
case(4):
str=String.valueOf(rst.getInt(column));
break;
case(5):
str=String.valueOf(rst.getInt(column));
break;
case(6):
str=String.valueOf(rst.getFloat(column));
break;
case(8):
str=String.valueOf(rst.getDouble(column));
break;
case(12):
str=String.valueOf(rst.getString(column));
break;
case(93):
str=String.valueOf(rst.getDate(column));
break;
default:
str="not have";
break;
}
return trans(str);
}
%>
<%!
String trans(String str)
{String str2=null;
byte[] by;
try
{by=str.getBytes();
str2=new String(by);
}
catch (Exception e)
{
}
return str2;
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>办公自动化系统_车辆管理！</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
}
.style10 {color: #669999}
.style11 {color: #C60001}
.style12 {
font-size: 10pt;
font-weight: bold;
}
-->
</style></head>
<body>
<table width="557" height="90" border="0" cellpadding="-2" cellspacing="-2" background="images/asset/asset.gif">
<tr valign="top">
<td width="800" height="89"> </td>
</tr>
</table>
<table width="557" height="40" border="0" cellpadding="-2" cellspacing="-2" background="images/asset/car_01.gif">
<tr>
<td width="7%" height="24" align="center" valign="middle"> <img src="images/icon_smile.GIF" width="15" height="15"></td>
<td width="18%" height="24" align="center"><div align="left"><span class="style10"> 您好！ </span></div></td>
<td width="6%" align="center"><span class="style10"><img src="images/asset/car.gif" width="34" height="20"></span></td>
<td width="13%" align="center" class="style10"><div align="left">车辆管理
</div></td>
<td width="9%" height="24"><div align="center" class="style10"></div></td>
<td width="30%" height="24">
<div align="left" class="style10"> </div></td>
<td width="17%" height="24"><div align="center"></div></td>
</tr>
<tr>
<td height="16" colspan="8"></td>
</tr>
</table>
<table width="556" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td><form method="post" name="form1" action="car_index.jsp?string=sunmit">
<table width="100%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td width="3%"> </td>
<td width="24%"> <span class="style11">请输入车辆相关信息：</span></td>
<td width="15%"><select name="select" class="Style_button">
<option value="number" selected>车牌号</option>
<option value="model">车型</option>
<option value="changshang">厂商</option>
<option value="driver">驾驶员</option>
</select> </td>
<td width="27%"><input name="value" type="text" class="Sytle_text" id="branch2"></td>
<td width="10%"><input name="Submit" type="submit" class="Style_button" value="搜索"></td>
<td width="21%"><div align="left">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
<table width="556" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td>
<table width="97%" height="27" border="1" align="right" cellpadding="-2" cellspacing="-2" bordercolor="#FFFFFF" bordercolorlight="#FFCCCC" bordercolordark="#FFFFFF">
<tr>
<td width="15%"><div align="center" class="style11">牌号</div></td>
<td width="20%"><div align="center" class="style11">型号</div></td>
<td width="15%"><div align="center" class="style11">购买日期</div></td>
<td width="15%"><div align="center" class="style11">生产厂家</div></td>
<td width="19%"><div align="center" class="style11">司机姓名</div>
<div align="center" class="style11"></div></td>
<td width="8%"><div align="center"><span class="style11">状态</span></div></td>
</tr>
<%
Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:prodb");
Statement st=con.createStatement();
String check=request.getParameter("string");
if(check!=null)
{
String name=request.getParameter("select");
String value=request.getParameter("value");
boolean num=st.execute("select * from tab_car where "+name+" like '%"+value+"%'");
if(num)
{
ResultSet result=st.executeQuery("select * from tab_car where "+name+" like '%"+value+"%'");
ResultSetMetaData meta=result.getMetaData();
int col=meta.getColumnCount();
//获得记录中的子段的总数；
while (result.next())
{ out.print("<tr>");
for(int j=1;j<col+1;j++)
{out.print("<td><div align=center class=style11>");
out.print(getCol(result,meta.getColumnType(j),j));
out.print("</div></td>");
}
out.print("</tr>");
}
result.close();
out.flush();
}
else
{
out.print("<tr><td colspan='6' align='center' class='style11'>暂时没有您要搜索的纪录</td></tr>");
}
}
else
{
ResultSet result=st.executeQuery("select * from tab_car");
ResultSetMetaData meta=result.getMetaData();
int col=meta.getColumnCount();
while (result.next())
{ out.print("<tr>");
for(int j=1;j<col+1;j++)
{out.print("<td><div align=center class=style11>");
out.print(getCol(result,meta.getColumnType(j),j));
out.print("</div></td>");
}
out.print("</tr>");
}
result.close();
out.flush();
}
%> </tr>
</table> </td>
</tr>
</table>
<table width="556" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -