?? mcarmessage_change.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="condata" scope="page" class="wuliu.conndata"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="/logistics/CSS/style.css">
<title>
CarMessage_change page
</title>
</head>
<Script language="javascript">
function check()
{
if(form1.numbers.value=="")
{
alert("請填寫車牌號碼！！");
form1.numbers.focus();
return false;
}
if(form1.type.value=="")
{
alert("請填寫車輛類型！！！");
form1.type.focus();
return false;
}
if(form1.carname.value=="")
{
alert("請填寫車輛品牌?。?！");
form1.carname.focus();
return false;
}
if(form1.loads.value=="")
{
alert("請填寫車輛限重?。。?quot;);
form1.loads.focus();
return false;
}
if(form1.usetime.value=="")
{
alert("請填寫使用年限！??！");
form1.usetime.focus();
return false;
}
if(form1.transtyle.value=="")
{
alert("請填寫運輸類型?。?！");
form1.transtyle.focus();
return false;
}
if(form1.name.value=="")
{
alert("請填寫駕駛員姓名?。。?quot;);
form1.name.focus();
return false;
}
if(form1.number.value=="")
{
alert("請填寫駕駛證號碼?。。?quot;);
form1.number.focus();
return false;
}
if(form1.styles.value=="")
{
alert("請填寫駕駛證類型?。?！");
form1.styles.focus();
return false;
}
if(form1.time.value=="")
{
alert("請填寫駕駛員駕齡?。?！");
form1.time.focus();
return false;
}
if(form1.linkman.value=="")
{alert("請填寫聯系人?。?！");
form1.linkman.focus();
return false;
}
if(form1.phone.value=="")
{
alert("請填寫聯系電話?。。?quot;);
form1.phone.focus();
return false;
}
}
</Script>
<%!
ResultSet rs=null;
String sql;
String userName;
int num,code;
%>
<jsp:include page="/Manager/mtop.jsp"/>
<body bgcolor="#ffffff">
<form action="/logistics/Manager/Cars/mCarMessage_change_config.jsp" method="post"name="form1">
<table width="785" border="1" align="center" cellpadding="0" cellspacing="0"bordercolor="#FFFFFF" bordercolordark="#333333" bordercolorlight="#FFFFFF">
<tr>
<td width="100%" height="62" colspan="4">
<p align="center"><font size="7" face="隸書">車輛信息修改</font></td>
</tr>
<%
sql="select * from db_CarMessage where Code="+request.getParameter("id");
try
{
rs=condata.executeQuery(sql);
if(rs.next())
{
code=rs.getInt("Code");
%>
<tr>
<td width="18%" height="34" align="center"><font size="4">車牌號碼：</font></td>
<td width="32%" height="34" align="center"><input type="text" name="numbers" size="20"value="<%=rs.getString("TradeMark")%>"></td>
<td width="19%" height="34" align="center"><font size="4">車輛品名：</font></td>
<td width="31%" height="34" align="center"><input type="text" name="carname" size="20"value="<%=rs.getString("Brand")%>"></td>
</tr>
<tr>
<td width="18%" height="36" align="center"><font size="4">車輛類型：</font></td>
<td width="32%" height="36" align="center"><input type="text" name="type" size="20"value="<%=rs.getString("Style")%>"></td>
<td width="19%" height="36" align="center"><font size="4">車輛限量：</font></td>
<td width="31%" height="36" align="center"><input type="text" name="loads" size="20"value="<%=rs.getString("CarLoad")%>">噸</td>
</tr>
<tr>
<td width="18%" height="37" align="center"><font size="4">已使用：</font></td>
<td width="32%" height="37" align="center"><input type="text" name="usetime" size="20"value="<%=rs.getString("UsedTime")%>">年</td>
<td width="18%" height="37" align="center"><font size="4">駕駛員名稱：</font></td>
<td width="32%" height="37" align="center"><input type="text" name="name" size="20"value="<%=rs.getString("DriverName")%>"></td>
</tr>
<tr>
<td width="19%" height="37" align="center"><font size="4">駕駛員駕齡：</font></td>
<td width="31%" height="37" align="center"><input type="text" name="time" size="20"value="<%=rs.getString("DriverTime")%>">年</td>
<td width="18%" height="36" align="center"><font size="4">駕駛證號碼：</font></td>
<td width="32%" height="36" align="center"><input type="text" name="number" size="20"value="<%=rs.getString("LicenceNumber")%>"></td>
</tr>
<tr>
<td width="19%" height="36" align="center"><font size="4">駕駛證類型：</font></td>
<td width="31%" height="36" align="center">
<%
String styles=rs.getString("LicenceStyle");
%>
<select size="1" name="styles">
<option value="<%=styles%>" selected><%=styles%></option>
<option value="A類">A類</option>
<option value="B類">B類</option>
<option value="C類">C類</option>
</select>
</td>
<td width="19%" height="37" align="center"><font size="4">運輸類型：</font></td>
<td width="31%" height="37" align="center">
<%
String trans=rs.getString("TranspotStyle");
%>
<select size="1" name="transtyle">
<option value="<%=trans%>" selected><%=trans%></option>
<option value="短途">短途</option>
<option value="長途">長途</option>
</select>
</td>
</tr>
<tr>
<td width="18%" height="42" align="center"><font size="4">聯系人：</font></td>
<td width="32%" height="42" align="center"><input type="text" name="linkman" size="20"value="<%=rs.getString("LinkMan")%>"></td>
<td width="19%" height="42" align="center"><font size="4">聯系電話：</font></td>
<td width="31%" height="42" align="center"><input type="text" name="phone" size="20"value="<%=rs.getString("LinkPhone")%>"></td>
</tr>
<tr>
<td width="18%" height="65" align="center"><font size="4">備注：</font></td>
<td width="82%" height="65" colspan="3">
<textarea rows="3" name="meg" cols="76">
<%=rs.getString("Remark")%></textarea></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">ID:</td>
<td width="31%" height="42"><%=code%><input type="hidden" name="code" value="<%=code%>"> </td>
</tr>
<tr>
<td width="18%" height="42" align="center">發布人：</td>
<td width="32%" height="42" colspan="3">
<input type="text" name="username" size="20"value="<%=rs.getString("UserName")%>"></td>
</tr>
<tr>
<td width="104%" height="40" colspan="4">
<p align="center">
<input type="submit" name="show" value="修改" onClick="return check()">
<input type="submit" name="reset" value="重置"> </td>
</tr>
<%
}
rs.close();
condata.closeStatement();
condata.closeConn();
}catch(SQLException e)
{
System.out.print("查詢異常??！");
}
%>
</table>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -