⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 system.jsp

📁 用jsp和Oracle写的一个网上订票系统
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ include file="conn.jsp"%>
<% 
int r1,jobnum;
String sql="select count(id) as ccount from scott.company"; 
ResultSet rs=stmt.executeQuery(sql); 
rs.next();
r1=rs.getInt("ccount");

//r1=rs.recordcount
String sql2="select count(id) as ccount from scott.company where job is not null order by id desc"; 
ResultSet rs2=stmt.executeQuery(sql2); 
rs2.next();
jobnum=rs2.getInt("ccount");

//jobnum=rs.recordcount %> 

<html>
<title>订票—&gt;首页</title>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Content-Language" content="zh-cn">
<link rel="stylesheet" href="inc/index.css" type="text/css">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

</head>

<body topmargin="0" leftmargin="0">
<%@ include file="inc/top.htm"%>
<SCRIPT language=JavaScript src="inc/f-index.js"></SCRIPT>
<div align="center">
  <center>
  <table border="0" cellpadding="0" cellspacing="0" width="780" height="120">
    <tr bgcolor="#5388C1"> 
      <td width="778" height="18" colspan="5" valign="top">   </td>
    </tr>
    <tr>
      <td height="46" valign="top" bgcolor="#5388C1" rowspan="2" width="152"> 
        <div align="center">
          <center>
          <table border="0" cellpadding="0" cellspacing="0" width="140" height="142" background="images/loginbg.GIF">
            <tr>
              <td width="136" height="19" valign="top"> </td>
            </tr>
            <form name=login action=login.jsp method=post>
			<tr>
              <td width="136" height="47" valign="top">&nbsp;&nbsp;&nbsp;&nbsp; 用户名:<input type="text" name="uname" size="7" maxLength=20 style="font-family: 宋体; font-size: 9pt; background-color: #EBEBEB; color: #00006A"><br>                                                                                                     
                &nbsp;&nbsp;&nbsp;&nbsp; 密&nbsp; 码:<input type="password" name="pwd" maxLength=20 size="7" style="font-family: 宋体; font-size: 9pt; background-color: #EBEBEB; color: #00006A"></td>                                                                                                      
            </tr>
            
          </center>
  </center>
            <tr>
              <td width="136" height="71" valign="top">
                <p align="center"><br>
                <input type="button" value="登 录" name="B1" style="position: relative; color: #00006A; font-family: 宋体; font-size: 9pt; height: 19" onClick="check()"><br>
                <br>
                <a href="addnew.jsp"><font color="#00006A">新用户注册</font></a></td>
            </tr>
          </table>
  <center>
          <center></form>
            </center>
        </div>
        <div align="center">
          <center>
          <form name=search action=search.jsp method=post target="_blank">
		  <table border="0" cellpadding="0" cellspacing="0" width="138" height="168" background="images/search-bg.GIF">
            <tr>
                      <td width="136" height="167">
                        <p align="center"><font color="#0000FF"><br>
                        </font><font color="#000055">=== 站内搜索 ===</font><font color="#000000"><br>                              
                        <br>
                        </font><SELECT 
                  size=1 name=stype style="background-color: #EBEBEB; color: #00006A; font-family: 宋体; font-size: 9pt">
                  <OPTION value="" selected>请选择搜索类别</option>
				  <option value="company">火车票搜索</option>
                  <option value="person">汽车票搜索</option>
                </SELECT>
                        <p align="center"><SELECT size=1 name=gzdd style="color: #00006A; font-family: 宋体; font-size: 9pt; background-color: #EBEBEB"> 
              <OPTION selected>请选择所在地区</OPTION>
			  <OPTION value=noxz>不&nbsp; 限
			  <OPTION value=北京市>北京市
              <OPTION value=天津市>天津市
              <OPTION value=上海市>上海市
			  <OPTION value=重庆市>重庆市
              <OPTION value=安徽省>安徽省
              <OPTION value=福建省>福建省
              <OPTION value=甘肃省>甘肃省
              <OPTION value=广东省>广东省
			  <OPTION value=四川省>四川省
              <OPTION value=贵州省>贵州省
              <OPTION value=湖北省>湖北省
              <OPTION value=湖南省>湖南省
			  <OPTION value=吉林省>吉林省
              <OPTION value=江苏省>江苏省
              <OPTION value=江西省>江西省
              <OPTION value=辽宁省>辽宁省
              <OPTION value=青海省>青海省
			  <OPTION value=山东省>山东省
              <OPTION value=山西省>山西省
			  <OPTION value=陕西省>陕西省
              <OPTION value=云南省>云南省
			  <OPTION value=浙江省>浙江省
			  <OPTION value=黑龙江省>黑龙江省
			 </SELECT></p>
            <p align="center"><INPUT 
            maxLength=20 size=16 name=key style="color: #00006A; font-family: 宋体; font-size: 9pt; background-color: #EBEBEB" value="请输入关键字" onclick="Javascript:this.value='';"><br>
             <br>
             <input type="button" value="搜 索" style="font-family: 宋体; font-size: 9pt; color: #00006A; position: relative; height: 20" onclick="s_check()">
             <br>
             <br>
			</td>
            </tr>
          </table>
          </form>
          </center>
        </div>
        
      <td width="446" height="18" valign="top">
      <TABLE borderColor=#000000 cellSpacing=2 cellPadding=2 width="120%" bgColor=#ffffff border=1 heihgt="">
<TBODY>
<TR>
<TD>
<P>铁路问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8346712 <BR><BR>汽车分站售票处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8335747 <BR><BR>汽车北站售票处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8226453 <BR><BR>火车站售票处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8235747 <BR><BR>客运站售票问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8333688 <BR><BR>汽车总站问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8221003</P>
<P>汽车东站问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8334880 <BR><BR>小件快递&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8254658 <BR><BR>东方高速问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8331728 <BR><BR>第三汽车公司客运站&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8331857 <BR><BR>汽车站问事处&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2881176  <BR><BR>出租车监督投诉电话&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8779177 </P></TD>
<TD>
<P>&nbsp;<STRONG>大连&nbsp;&nbsp;&nbsp;&nbsp;高速直达&nbsp;&nbsp;&nbsp;&nbsp;北京 </STRONG></P>
<P>总站&nbsp;&nbsp;&nbsp;&nbsp;大连火车站&nbsp;&nbsp;&nbsp;&nbsp;手机 <BR>5:40&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13333333333 <BR>6:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13:00&nbsp;&nbsp;&nbsp;&nbsp; 13333333333<BR>6:50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13:50&nbsp;&nbsp;&nbsp;&nbsp; 13333333333 <BR>免费接送只要您一个电话,剩下的事由我们来做! <BR>服务热线:0411-8221378&nbsp;&nbsp;1333333333</P>
<p align=center><img src="images/keche1.gif" height=100 border=0></p>

<P>&nbsp;</P></TD></TR></TBODY></TABLE></P><p align=right>
                 </p></td>
              </tr>
            </table></td>
        </tr>
        
         <tr>
      <td height="14" valign="top" colspan="5" width="778">
      <p align="center"><script language="javascript" src="inc/copyright.js"></script>
      </td>
    </tr>
    <tr>
      <td height="3" valign="top" colspan="5" width="778">
      </td>
    </tr>
  </table>
</div>

</body>

</html>

⌨️ 快捷键说明

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