confirm_process.jsp

毕业设计代码

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
    Connection con=null;
    Statement stmt=null;
    ResultSet rs=null;
    String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
    String url="jdbc:odbc:airline";    //数据源的url
    String user1="";  //连接数据库的用户名
    String pass1="";  //连接数据库的口令
    String strSQL1;  //要执行的sql语句
	String strSQL3;  //要执行的sql语句

	String hangbanhao=request.getParameter("hangbanhao");
    String hanggongcompany=request.getParameter("hanggongcompany");
	String qifeigang=request.getParameter("qifeigang");
	String mudigang=request.getParameter("mudigang");
	String startTime=request.getParameter("startTime");

	String endTime=request.getParameter("endTime");
    String price=request.getParameter("price");
	String zhekou=request.getParameter("zhekou");
	
    hanggongcompany=new String(hanggongcompany.getBytes("8859_1"));
	qifeigang=new String(qifeigang.getBytes("8859_1"));
	mudigang=new String(mudigang.getBytes("8859_1"));
	

    if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{
		 strSQL3="select count(*) from airline_hangbanxinxi with(READCOMMITTED)  where hangbanhao='"+hangbanhao+"'";//判断是否有用户存在
         strSQL1="insert into airline_hangbanxinxi(hangbanhao,hanggongcompany,qifeigang,mudigang,startTime,endTime,price,zhekou) values('"+hangbanhao+"','"+hanggongcompany+"','"+qifeigang+"',"+mudigang+","+startTime+","+endTime+","+price+",'"+zhekou+"')";
       
		 rs=db.executeQuery(strSQL3);
		 rs.next();
         if(rs.getInt(1)==1)
         {
			 
			 out.print("<script language=JavaScript>");
			 out.print("alert('该航班号已经被使用过了， 请换个新的！');");
			 out.print("window.location.href ='newairline.jsp'");
			 out.print(" </script>" );
		 }
		 else
		 {
			 db.executeUpdate(strSQL1);
			 out.print("<script language=JavaScript>");
			 out.print("alert('新的航班线路增加成功！');");
			 out.print("window.location.href ='airdetail.jsp'");
			 out.print(" </script>" );
		 }
	}
    catch(Exception e2){
         out.println("数据库异常！");
         out.println(e2.toString());
    }
    finally{
		try{
			if(rs!=null) rs.close();
            if(stmt!=null) stmt.close();
            if(con!=null) con.close();
        }
        catch(Exception e){}
    }
%>