📄 transorder.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
ResultSet rs=null;
String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
String url="jdbc:odbc:airline"; //数据源的url
String user1=""; //连接数据库的用户名
String pass1=""; //连接数据库的口令
String strSQL; //要执行的sql语句
String option=null;
int i=0;
int con;
Integer count=(Integer)application.getAttribute("count");
if(count==null) {
con=0;
}
else {
con=count.intValue();
}
con++;
application.setAttribute("count",new Integer(con));
if(!db.initialization(driver,url,user1,pass1)) //进行初始化
{
out.println(db.getHint());
}
else try{
strSQL="select * from airline_yunhuoxinxi";//遍历数据，所有主题的信息
rs=db.executeQuery(strSQL);
while(rs.next())
{
int id=rs.getInt(1);
String lu=rs.getString(2);
float ju=rs.getFloat(3);
float dan=rs.getFloat(4);
option=option+"<option value="+id+","+ju+","+dan+">"+lu+"</option>";
}
}
catch(SQLException e2){
out.println("数据库异常！");
out.println(e2.toString());
}
finally{
try{
if(rs!=null) rs.close();
}
catch(Exception e){}
}
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>货运信息</TITLE>
<LINK HREF="../../../css/style.css" REL="stylesheet" TYPE="text/css">
</HEAD>
<BODY>
<FORM NAME="form1" METHOD="post" ACTION="orderconfirm.jsp">
<input type="hidden" value="" name="id">
<input type="hidden" value="" name="danjia">
<input type="hidden" value="" name="zongjia">
<input type="hidden" value="" name="juli">
<TABLE WIDTH="620" CLASS="TABLE1">
<TR>
<TD COLSPAN="4" CLASS="TITLE2">货运订单</TD>
</TR>
<TR>
<TD COLSPAN="4"> </TD>
</TR>
<TR>
<TD COLSPAN="4" CLASS="TEXT">注意:带 <SPAN CLASS="style1">** </SPAN>部分必须填写，谢谢合作。</TD>
</TR>
<TR>
<TD CLASS="RIGHT">订单号：</TD>
<TD CLASS="TEXT"><INPUT NAME="dingdanhao" TYPE="hidden" SIZE="20" value="<%=con%>"><INPUT NAME="dingdanhao" TYPE="text" SIZE="20" value="<%=con%>" DISABLED></TD>
<TD CLASS="RIGHT"></TD>
<TD CLASS="TEXT"></TD>
</TR>
<TR>
<TD WIDTH="133" CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN><STRONG> </STRONG>真实姓名：</TD>
<TD COLSPAN="3"><INPUT NAME="userTruename" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">证件号码：</TD>
<TD COLSPAN="3"><INPUT NAME="userZhengjianhao" TYPE="text" SIZE="30"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"> <SPAN CLASS="style1">**</SPAN> 运货路线：</TD>
<TD WIDTH="150"><SELECT NAME="luxianming" onChange="fChangeSales(this.selectedIndex);">
<option value="">请选择路线</option>
<%=option%>
</SELECT></TD>
<TD WIDTH="83" CLASS="RIGHT"></TD>
<TD WIDTH="234"></TD>
</TR>
<TR>
<TD CLASS="RIGHT"> 里程：</TD>
<TD CLASS="TEXT"><input type="text" value="" name="juli1" disabled size="10">公里</TD>
<TD CLASS="RIGHT"><SPAN CLASS="style1">**</SPAN>重量：</TD>
<TD CLASS="TEXT"><INPUT NAME="zhongliang" TYPE="text" SIZE="10" onchange="jisuan();">
吨</TD>
</TR>
<TR>
<TD CLASS="RIGHT"> <SPAN CLASS="style1">**</SPAN> 单价：</TD>
<TD CLASS="TEXT"><input type="text" value="" name="danjia1" disabled size="10"></TD>
<TD CLASS="RIGHT">总价：</TD>
<TD CLASS="TEXT"><input type="text" value="" name="zongjia1" disabled size="10">人民币</TD>
</TR>
<TR>
<TD CLASS="RIGHT"> <SPAN CLASS="style1">**</SPAN> 联系电话：</TD>
<TD COLSPAN="3"><INPUT NAME="userTel" TYPE="text" SIZE="20"></TD>
</TR>
<TR>
<TD CLASS="RIGHT">装货日期：</TD>
<TD COLSPAN="3"><INPUT NAME="zhuanghuoDate" TYPE="text" SIZE="20"></TD>
</TR>
<TR>
<TD HEIGHT="57" CLASS="RIGHT"> 附言：</TD>
<TD COLSPAN="3"><TEXTAREA NAME="fuyan" COLS="50"></TEXTAREA></TD>
</TR>
<TR>
<TD COLSPAN="4" ALIGN="RIGHT"><HR COLOR="#999999" SIZE="1"></TD>
</TR>
<TR>
<TD COLSPAN="4" ALIGN="CENTER">
<INPUT TYPE="SUBMIT" NAME="Submit" VALUE="提交" onclick="return check()">
<INPUT TYPE="RESET" NAME="Reset" VALUE="重填"></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
<script language="JavaScript">
<!--
function fChangeSales(strIndex){
var frm = document.form1;
var strVal = "";
var strVal1 = "";
var strVal2 = "";
strVal12 = frm.luxianming.options[strIndex].value.split(",")[0];
strVal = frm.luxianming.options[strIndex].value.split(",")[1];
strVal1 = frm.luxianming.options[strIndex].value.split(",")[2];
frm.juli.value = strVal;
frm.juli1.value = strVal;
frm.danjia.value = strVal1;
frm.danjia1.value = strVal1;
frm.id.value = strVal12;
}
function jisuan(){
var frm = document.form1;
var zongjia;
var danjia;
var juli;
var zhongliang;
danjia=frm.danjia.value;
juli=frm.juli.value;
zhongliang=frm.zhongliang.value;
zongjia=danjia*juli*zhongliang;
frm.zongjia.value=zongjia;
frm.zongjia1.value=zongjia;
}
function check(){
var yValue = document.form1.zhuanghuoDate.value.substring(0,4);
var mValue = document.form1.zhuanghuoDate.value.substring(5,7);
var dValue = document.form1.zhuanghuoDate.value.substring(8,10);
if (document.form1.zhuanghuoDate.value.substring(4,5) != "/" || document.form1.zhuanghuoDate.value.substring(7,8) != "/" || document.form1.zhuanghuoDate.value.length != 10) {
alert ("日期类型是(yyyy/mm/dd)，请正确输入！");
alert (document.form1.zhuanghuoDate.value);
return false;
}
else{
if (parseInt(yValue) < 1900){
alert ("请输入的年大于1900！");
return false;
}
}
if ((mValue > 12) || (mValue < 1)) {
alert ("月份在12和1之间！");
return false;
}
if ((mValue=="01") || (mValue=="03") || (mValue=="05") || (mValue=="07") || (mValue=="08") || (mValue=="10") || (mValue=="12")){
if (dValue > 31 || dValue < 1) {
alert ("日期输入错误，超出范围！");
return false;
}
}
if ((mValue=="04") || (mValue=="06") || (mValue=="09") || (mValue == "11")) {
if ((dValue > 30) || (dValue < 1)) {
alert ("日期输入错误，超出范围！");
return false;
}
}
if (mValue=="02") {
if (yValue % 4 == 0 && yValue/100!=0) {
if (dValue > 29 || dValue < 1) {
alert ("日期输入错误，超出范围！");
return false;
}
}
else {
if ((dValue > 28) || (dValue < 1)) {
alert ("日期输入错误，超出范围！");
return false;
}
}
}
}
-->
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -