📄 moneyquery.jsp

📁 毕业设计代码
💻 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语句
	int id;
	String luxianming=request.getParameter("luxianming");
	float juli=0;
	float danjia=0;
	String huiyuanzhekou=null;
	String beizhu=null;
	
	int i=0;
	if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{ 
		if(luxianming!=null){
			luxianming=new String(luxianming.getBytes("8859_1"));
			strSQL="select * from airline_yunhuoxinxi where luxianming='"+luxianming+"'";//遍历数据，所有主题的信息
		}
		else{
			strSQL="select * from airline_yunhuoxinxi";
		}
        rs=db.executeQuery(strSQL);
%>
<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="">
    <TABLE WIDTH="620" CLASS="TABLE1">
        <TR>
            <TD CLASS="TITLE2" COLSPAN="6"></TD>
        </TR>
        <TR>
            <TD COLSPAN="6">&nbsp;</TD>
        </TR>
		 <TR>
            <TD COLSPAN="6"><DIV ALIGN="RIGHT"><A HREF="transorder.jsp" TARGET="mainFrame"><IMG SRC="../../../image/transorder.gif" WIDTH="88" HEIGHT="28" BORDER="0"></A></DIV></TD>
        </TR>
        <TR CLASS="HD2">
            <TD WIDTH="42">序号</TD>
            <TD WIDTH="107">路线</TD>
            <TD WIDTH="84">里程（公里）</TD>
            <TD WIDTH="129">单价（元／吨.公里）</TD>
            <TD WIDTH="78">会员折扣</TD>
            <TD WIDTH="89">备注</TD>
        </TR>
<%
    while(rs.next()){
		i++;
		id=rs.getInt(1);
		luxianming=rs.getString(2);
		juli=rs.getFloat(3);
		danjia=rs.getFloat(4);
		huiyuanzhekou=rs.getString(5);
		beizhu=rs.getString(6);
		
%>
        <TR CLASS="ODDTR">
            <TD><%=i%></TD>
            <TD><%=luxianming%></TD>
            <TD><%=juli%></TD>
            <TD><%=danjia%></TD>
            <TD><%=huiyuanzhekou%></TD>
            <TD><%=beizhu%></TD>
        </TR>
<%
	}
%>
        <TR ALIGN="RIGHT">
            <TD COLSPAN="6"><A HREF="transorder.jsp" TARGET="mainFrame"><IMG SRC="../../../image/transorder.gif" WIDTH="88" HEIGHT="28" BORDER="0"></A></TD>
        </TR>
        <TR ALIGN="LEFT">
            <TD COLSPAN="6"><HR COLOR="#999999" SIZE="1"></TD>
        </TR>
        <TR ALIGN="CENTER">
            <TD COLSPAN="6" CLASS="TEXT">共有 N 条数据 第 页 ／共 页  首页 前页 后页 末页 </TD>
        </TR>
    </TABLE>
<%
	}
    catch(SQLException e2){
         out.println("数据库异常！");
         out.println(e2.toString());
    }
	finally{
		try{
			if(rs!=null) rs.close();
		}
        catch(Exception e){}
    }
%>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -