使用jsp2.0+mysql开发简单的火车车次查询程序_火车车次信息管理jsp页面代码-CSDN博客

本文链接：https://blog.csdn.net/hnxyy/article/details/389314

train.xml

<?xml version='1.0' encoding='utf-8'?>
<Context docBase="D:/Web/bs source/train" path="/train" reloadable="true">
        <Resource name="jdbc/train" auth="Container" type="javax.sql.DataSource"/>
        <ResourceParams name="jdbc/train">
            <parameter>
                <name>factory</name>
                <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <parameter>
                <name>maxActive</name>
                <value>3</value>
            </parameter>
            <parameter>
               <name>maxIdle</name>
                <value>1</value>
            </parameter>
            <parameter>
                <name>maxWait</name>
                <value>5000</value>
            </parameter>
            <parameter>
                <name>username</name>
                <value>root</value>
            </parameter>
            <parameter>
                <name>password</name>
                <value></value>
            </parameter>
            <parameter>
                <name>driverClassName</name>
                <value>org.gjt.mm.mysql.Driver</value>
            </parameter>
           <parameter>
                <name>url</name>
                <value><![CDATA[jdbc:mysql://localhost:3306/train?characterEncoding=GBK&useUnicode=true]]></value>
            </parameter>
         </ResourceParams>
</Context>

mysql database:train

sql:

# MySQL-Front Dump 2.5
#
# Host: localhost Database: train
# --------------------------------------------------------
# Server version 3.23.41-nt

#
# Table structure for table 'train'
#

CREATE TABLE train (
train varchar(30) NOT NULL default '',
traindate datetime default NULL,
sleepseat int(8) default '0',
seat int(8) default '0',
noseat int(8) default '0',
pubtime datetime default NULL,
PRIMARY KEY (train)
) TYPE=MyISAM;

#
# Dumping data for table 'train'
#

INSERT INTO train VALUES("1102", "2005-02-03 00:00:00", "30", "2100", "15", "2005-02-02 19:30:00");
INSERT INTO train VALUES("1101", "2005-02-04 00:00:00", "35", "2050", "20", "2005-02-03 12:35:00");

index.jsp

<%@ page contentType="text/html; charset=GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>火车车次查询</title>
</head>
<body>

<form name="form1" method="post" action="">
<table width="98%" border="1" cellspacing="0" cellpadding="3">
    <tr>
      <td width="22%">查询条件：</td>
      <td width="66%"> 车次：
        <input name="train" type="text" id="train" size="8" value="${param.train}">
        发车时间：
        <select name="traindate" id="select">
          <option value="2005-02-03" <c:if test='${param.traindate} == "2005-02-03"'>selected</c:if>>2005-02-03</option>
          <option value="2005-02-04" <c:if test='${param.traindate} == "2005-02-04"'>selected</c:if>>2005-02-04</option>
          <option value="2005-02-05" <c:if test='${param.traindate} == "2005-02-05"'>selected</c:if>>2005-02-05</option>
        </select></td>
      <td width="12%"><input type="submit" name="Submit" value="提交"></td>
    </tr>
</table>
</form>

<c:if test="${! empty param.train}">
<p align="center"> </p>
<p align="center"><font color="#000033" size="+3"> ${param.train} 次 ${param.traindate} 车票状况列表 </font></p>
<table width="98%" border="1" cellspacing="0" cellpadding="3">
<tr bgcolor="#FFCCFF">
    <td><div align="center"><font color="#FF0000">车次</font></div></td>
    <td><div align="center"><font color="#FF0000">发车日期</font></div></td>
    <td><div align="center"><font color="#FF0000">卧铺数</font></div></td>
    <td><div align="center"><font color="#FF0000">硬座数</font></div></td>
    <td><div align="center"><font color="#FF0000">站票数</font></div></td>
    <td><div align="center"><font color="#FF0000">发布时间</font></div></td>
</tr>

<sql:query var="rs" dataSource="jdbc/train">
    select * from train where train=? and traindate=? order by pubtime desc
    <sql:param value="${param.train}"/>
    <sql:param value="${param.traindate}"/>
</sql:query>

<c:forEach var="each" items="${rs.rows}">
<tr>
    <td>${each.train}</td>
    <td><fmt:formatDate pattern="yyyy-MM-dd" value="${each.traindate}"/></td>
    <td><fmt:formatNumber pattern="###,##0" value="${each.sleepseat}"/></td>
    <td><fmt:formatNumber pattern="###,##0" value="${each.seat}"/></td>
    <td><fmt:formatNumber pattern="###,##0" value="${each.noseat}"/></td>
    <td><fmt:formatDate pattern="yyyy年MM月dd日 hh:mm:ss" value="${each.pubtime}"/></td>
</tr>
</c:forEach>

</table>
</c:if>
</body>
</html>