📄 carmanagemodify.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<%@ page import="com.logistic.business.CarManager" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.logistic.model.CarInfo"%>
<%@ page import="java.lang.NumberFormatException" %>
<%request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv='Expires' content='-10'>
<meta http-equiv='Pragma' content='No-cache'>
<meta http-equiv='Cache-Control', 'private'>
<title>车辆信息修改窗口</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
<link href="<%=request.getContextPath()%>/cssjs/comcss.css" rel="stylesheet" type="text/css">
<script language="javascript" src="<%=request.getContextPath()%>/cssjs/comjs.js"></script>
</head>
<body>
<%
String success=(String)session.getAttribute("success");
if(success!=null){
%>
<script language="javascript">
alert("车辆信息修改成功！");
location.href="<%=request.getContextPath()%>/viewpage/showpage/admincarinfo.jsp";
</script>
<%
session.removeAttribute("success");
}
%>
<%
String id=(String)request.getParameter("id");
CarInfo ci=null;
if(id!=null){
CarManager cm=new CarManager();
try{
ci=cm.CarSearchById(Integer.valueOf(id));
System.out.print("ci="+ci);
}catch(NumberFormatException ex){ex.printStackTrace();}
if(ci==null){
session.setAttribute("errors","车辆信息获取失败!");
response.sendRedirect("../../errors/errorpage.jsp");
}
}else{
session.setAttribute("errors","对不起编号不能为空!");
response.sendRedirect("../../errors/errorpage.jsp");
}
%>
<table width="497" height="181" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#CC9999">
<tr>
<td width="37" height="25" align="center" class="buttonstyle">编号:</td>
<td width="105" align="center" class="code"><%=ci.getId() %></td>
<td width="104" align="center"><span class="style5">*标识必须填写</span></td>
<td width="233" align="center"> </td>
</tr>
<tr>
<td height="154" colspan="4"><form action="/Logistic/carmanageinfoupdate" method="post" name="carmanage" id="carmanage">
<table width="304" height="115" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#CC9999">
<tr>
<td height="27" align="right" class="style9">车辆号码:</td>
<td><input name="carnumber" type="text" class="style9" id="carnumber" value="<%=ci.getCarid()%>" size="20" maxlength="20">
<span class="style5"> *
<input type="hidden" name="id" value="<%=ci.getId()%>">
</span></td>
</tr>
<tr>
<td width="89" height="27" align="right" class="style9">驾驶员:</td>
<td width="205"><select name="driverid" class="style9" id="driverid">
<option value="">--驾驶员--</option>
<%
String sqldriver="select *from employeeinfotable where JobsId='1010'";
Statement statdriver=dblink.getStmtread();
ResultSet rsdriver=statdriver.executeQuery(sqldriver);
while(rsdriver.next()){
String driverid=rsdriver.getString("EmployeeId");
String drivername=rsdriver.getString("EmployeeName");
out.print("<option value="+driverid);
if(ci.getCardriverid().equals(driverid)){
out.print(" selected ");
}
out.print(">"+drivername+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr>
<td height="28" align="right" class="style9">车队名称:</td>
<td><select name="carteamid" class="style9" id="carteamid">
<option value="">--车队名--</option>
<%
String sqlcarteam="select *from carteaminfotable";
Statement statcarteam=dblink.getStmtread();
ResultSet rscarteam=statcarteam.executeQuery(sqlcarteam);
while(rscarteam.next()){
String carteamid=rscarteam.getString("CarTeamId");
String carteamname=rscarteam.getString("CarTeamName");
out.print("<option value="+carteamid);
if(ci.getCarteamid().equals(carteamid)){
out.print(" selected ");
}
out.print(">"+carteamname+"</option>");
}
dblink.close();
%>
</select>
<span class="style5">*</span></td>
</tr>
<tr align="center">
<td height="31" colspan="2"><input name="Submit" type="submit" class="buttonstyle" value="提交数据" onClick="return carmanage_check()">
<input name="cancel" type="reset" class="buttonstyle" id="cancel" value="重置数据"></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -