📄 checkadd.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>增加车次验证</title>
</head>

<body>

  <%  String busid=new String(request.getParameter("busid").getBytes("ISO8859_1"),"GBK");
      String add_busid=busid;
      session.setAttribute("add_busid",add_busid);
      String detail=new String(request.getParameter("detail").getBytes("ISO8859_1"),"GBK");
	  String a_startime=request.getParameter("a_startime");
	  String a_endtime=request.getParameter("a_endtime");
	  String w_startime=request.getParameter("w_startime");
	  String w_endtime=request.getParameter("w_endtime");
      int t_value=Integer.parseInt(request.getParameter("t_value"));
      int value=Integer.parseInt(request.getParameter("value"));
	  
	  Statement sql1=null;
	  Statement sql2=null;
	  Connection con=null;
	  int success=0;    
		     
		    try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		         }
		   catch(ClassNotFoundException e){
			    e.printStackTrace();
		        }
	  try{   con=DriverManager.getConnection("jdbc:odbc:nbos","","");
		      sql1=con.createStatement();
		      String condition1="select * from bus where BusID='"+busid+"'";
              
		      ResultSet result = sql1.executeQuery(condition1); 
              
		      if (result.next())
		      { response.sendRedirect("Er_add.html");
		    	 
		      }
		      else{
                 
                sql2=con.createStatement();
                String condition2="insert into bus(BusID,Detail,A_STime,W_STime,A_ETime,W_ETime,T_Value,Sort) values ('"+busid+"','"+detail+"','"+a_startime+"','"+w_startime+"','"+a_endtime+"','"+w_endtime+"',"+t_value+","+value+")";
                 
                sql2.executeUpdate(condition2); 
                
                response.sendRedirect("Su_add.jsp");
	             }
		      result.close();
		   
		    }
        
		    catch (Exception e){
		    	
		    	e.printStackTrace();
		    }
		    	
	  %>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -