📄 carmessage_change.jsp

📁 物流信息网主要包括前台和后台两部分
💻 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="../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("请输入车辆类型！1");
form1.type.focus();
return false;
}
if(form1.carname.value=="")
{
alert("请输入车品名！！");
form1.carname.focus();
return false;
}
if(form1.loads.value=="")
{
alert("请输入车辆载重！！！");
form1.loads.focus();
return false;
}
if(form1.usetime.value=="")
{
alert("请输入车辆使用时间！！！");
form1.usetime.focus();
return false;
}
if(form1.transtyle.value=="")
{
alert("请输入运输类型！！！");
form1.style.focus();
return false;
}
if(form1.name.value=="")
{
alert("请输入驾驶员姓名！！1");
form1.name.focus();
return false;
}
if(form1.number.value=="")
{
alert("请输入驾证号码！！！");
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("请输入联系电话！！");
form1.phone.focus();
return false;
}
}
</Script>
<%!
ResultSet rs=null;
String sql;
String userName;
int code;
%>
<body bgcolor="#ffffff">
<form action="/logistics/Cars/CarMessage_change_config.jsp" name="form1">
<table border="1" width="786" align="center">
  <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"><font size="4">车牌号</font></td>
    <td width="32%" height="34" align="center"><input type="text" readonly="yes"  name="numbers" size="20"value="<%=rs.getString("TradeMark")%>"></td>
    <td width="19%" height="34"><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"><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"><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"><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"><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"><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"><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"><font size="4">驾驶证类型</font></td>
    <td width="31%" height="36" align="center"><input type="text" name="styles" size="20"value="<%=rs.getString("LicenceStyle")%>"></td>
   <td width="19%" height="37"><font size="4">运输类型</font></td>
     <td width="31%" height="37" align="center"><input type="text" name="transtyle" size="20"value="<%=rs.getString("TranspotStyle")%>"></td>
</tr>
  <tr>
    <td width="18%" height="42"><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"><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"><font size="4">备注</font></td>
    <td width="82%" height="65" colspan="3">
   <textarea rows="3" name="remark" cols="76">
  <%=rs.getString("Remark")%></textarea></td>
  </tr>
  <tr>
    <td width="18%" height="42">发布时间</td>
    <td width="32%" height="42">
      <p align="center"><input type="text" name="issuedate" size="20"value="<%=rs.getString("IssueDate")%>"></td>
    <td width="19%" height="42">ID:</td>
    <td width="31%" height="42"><input type="hidden" name="numb" value="<%=code%>">  </td>
  </tr>
<tr>
    <tr>
    <td width="18%" height="42">发布人</td>
    <td width="32%" height="42">
      <p align="center">
<input type="hidden" name="user" size="20"value="<%=rs.getString("UserName")%>"></td>
  </tr>
<tr>
 <td width="786" height="40" colspan="4">
    <p align="center">
 <input type="submit" name="show" value="修改" onClick="return check()">&nbsp;&nbsp;
  <input type="submit" name="reset" value="重写"> &nbsp;&nbsp; 
  <input type="button" name="back" value="" onClick="history.back()">
</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 + -