线,若没有的话则没有显示,如果存在的话则显示相关的信息:如:该线路经过的所有站点,冬夏季节的首末班情况,该车次的发车时间等。
点击网页左边导航内的站点查询进入站点查询页面,输入要查询的站点,显示界面如下:
公交用户站点查询页面
其主要的实现代码如下:
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=province";
String uname="sa";
String upass="sa";
request.setCharacterEncoding("utf-8");
String roadsearch=request.getParameter("roadsearch");
String sql="select * from busdetail inner join busall on busdetail.busid=busall.busid where busdetail.sitename='"+roadsearch+"'";
try{
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,uname,upass);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(
sql);
while(rs.next()){
out.println(rs.getString("busid"));
out.println(rs.getString("allsite")); out.println(rs.getString("time1"));
out.println(rs.getString("time2"));
out.println(rs.getString("time3"));
}}
catch(Exception e){
out.println("wrong");
}
5.1.3按路线查询
路线查询模块:用户进入系统后,点击左侧
导航条中的路线查询,在路线查询模块的下拉框中选择要查询的站点,点击确定,系统会检测用户所查询路线,若没有选择直接点击确定的话,则会显示所有的公交路线基本情况,或者选择自己想查询的路线路线。
点击网页左边导航内的路线查询进入路线查询页面,选择要查询的路线,显示界面如下:
公交用户路线查询页面
其主要实现代码如下:
String sql1="select * from busall order by busid asc";
String sql="select bus.busnum,busdetail.sitename,busdetail.siteid from bus inner join busdetail on bus.busid=busdetail.busid and bus.busid='"+request.getParameter("sitesearch")+"' order by busdetail.siteid asc";
try{
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,uname,pword);
Statement stmt=conn.createStatement();
ResultSet rs=null;
if(request.getParameter("sitesearch")==""){
rs=stmt.executeQuery(sql1);
while(rs.next()){
out.println(rs.getString("busid"));
out.println(rs.getString("allsite"));
out.println(rs.getString("time1"));
out.println(rs.getString("time2"));
out.println(rs.getString("time3"));
} }
else{
rs=stmt.executeQuery(sql);
request.getParameter("sitesearch");
while(rs.next()){
-->
<%
out.println(rs.getString("sitename"));