📄 display.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script language="JavaScript">
function checkdata(){
     
	 detail=document.add.detail.value;
	 a_startime=document.add.a_startime.value;
	 a_endtime=document.add.a_endtime.value;
	 w_startime=document.add.w_startime.value;
	 w_endtime=document.add.w_endtime.value;
	 t_value=document.add.t_value.value; 
     value=document.add.value.value;
   if(t_value==""||isNaN(t_value)||parseInt(t_value)<0)
	     { alert("请正确输入票价,票价必须是不大于三位数的数字!");
		    return false;
		 }
    if(value==""||isNaN(value)||parseInt(value)<0)
	     { alert("请正确输入排序号,排序号必须是不大于五位数的数字!");
		    return false;
		 }
	 if(detail==""||(detail.indexOf('->')==-1))	
	     {  alert('请正确输入站点信息,站点之间请以"->"符号连接!');
		    return false;
		 }
	 if(a_startime==""||(a_startime.indexOf(':')==-1))	 
	     { alert("请正确输入夏季发车时间,格式为18:30!")	;
		   return false;
		   }
     if(a_endtime==""||(a_endtime.indexOf(':')==-1))	 
	     { alert("请正确输入夏季结束时间,格式为18:30!")	;
		   return false;
		   }
	 if(w_startime==""||(w_startime.indexOf(':')==-1))	 
	     { alert("请正确输入冬季发车时间,格式为18:30!")	;
		   return false;
		   }
	 if(w_endtime==""||(w_endtime.indexOf(':')==-1))	 
	     { alert("请正确输入冬季结束时间,格式为18:30!")	;
		   return false;
		  }
	
		  
   }
</script>

<title>信息显示</title>
<style type="text/css">
<!--
body {
	background-image: url(../Picture/index-top_2.gif);
	margin-left: 30px;
}
.STYLE1 {
	font-weight: bold;
	font-size: 18px;
}
.STYLE2 {
	font-size: 14px;
	font-weight: bold;
}
-->
</style><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>

<body>

<%  
    String detail="";
	String a_startime="";
	String a_endtime="";
	String w_startime="";
	String w_endtime="";
    int value=0;
    int t_value=0;
	int i=0;
    Connection con;
    String statement="";
	ResultSet result;
	String busid= new String(request.getParameter("busid").getBytes("ISO8859_1"),"GBK");
	session.setAttribute("busid",busid);
	
 try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	     }
		catch(ClassNotFoundException e){}
		 
	try{  
	      con=DriverManager.getConnection("jdbc:odbc:nbos","","");
	      Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
		  statement="select * from bus where BusID='"+busid+"'";
		  result=sql.executeQuery(statement);
		  if(result.next())
		      {
			    detail=result.getString("Detail");
				//out.println(detail);
			    a_startime=result.getString("A_STime");
	            a_endtime=result.getString("A_ETime");
	            w_startime=result.getString("W_STime");
	            w_endtime=result.getString("W_ETime");
                value=result.getInt("Sort");
                t_value=result.getInt("T_Value");
			    i++;
			  }  
		%>
<form name="add" method="post" action="checkmodify.jsp" OnSubmit="return checkdata();">		
 <table background="../Picture/l33.gif" width="601"  align="left">
    <tr background="../Picture/topbg.gif">
      <td colspan="5" background="../Picture/topbg.gif"><div align="center" class="STYLE1">修改车次信息</div></td>
    </tr>
    <tr background="../Picture/l33.gif">
      <td height="26"><div align="center" class="STYLE2">车次号:<%=busid%></div></td>
      <td width="129" height="26"><div align="right">票价：</div></td>
      <td height="26"><input name="t_value" type="text" size="10" value="<%=t_value%>"></td>
      <td width="55" height="26"><div align="center">排序：</div></td>
      <td width="127"><input name="value" type="text" size="6" value="<%=value%>"></td>
    </tr>
    <tr background="../Picture/l33.gif">
      <td width="140" height="64"><div align="right">全部站点:</div>
      <div align="left"></div></td>
      <td colspan="4"><textarea name="detail" cols="55" rows="5" id="detail"><%=detail%></textarea>
      </input></td>
    </tr>
    <tr background="../Picture/l33.gif">
      <td height="36"><div align="right">夏季发车时间：</div></td>
      <td><input  name="a_startime" id="a_startime" type="text" size="15" value="<%=a_startime%>"></td>
      <td width="126"><div align="center">夏季结束时间：</div></td>
      <td colspan="2">
      <input name="a_endtime" id="a_endtime" type="text" size="15" value="<%=a_endtime%>">      </td>
    </tr>
    <tr background="../Picture/l33.gif">
      <td height="40"><div align="right">冬季发车时间：</div></td>
      <td>
      <input name="w_startime" id="w_startime" type="text" size="15" value="<%=w_startime%>">      </td>
      <td><div align="center">冬季结束时间：</div></td>
      <td colspan="2">
      <input name="w_endtime" id="w_endtime" type="text" size="15" value="<%=w_endtime%>">      </td>
    </tr>
    <tr background="../Picture/l33.gif">
      <td><p align="center"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p></td>
      <td>
        <div align="center">
          <input type="submit" name="Submit" value="修改" />
          
      </div>      </td>
      <td>
        <div align="center">
          <input type="reset" name="reset" value="重置" />
      </div>      </td>
      <td colspan="2">&nbsp;</td>
    </tr>
    <tr>
      <td height="21" colspan="5" background="../Picture/bottombg.gif">&nbsp;</td>
    </tr>
</table>
</form>
 <%  result.close(); }
     catch(Exception e){ }   %>
</body>
</html>
⌨️ 快捷键说明

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