orderconfirm.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 strSQL2;  //要执行的sql语句

	String id=request.getParameter("id");
	String dingdanhao=request.getParameter("dingdanhao");
	String userTruename=request.getParameter("userTruename");
	String userZhengjianhao=request.getParameter("userZhengjianhao");
	String fromCity=request.getParameter("fromCity");
	String userSex=request.getParameter("userSex");
	String userTel=request.getParameter("userTel");
	String ruzhuDate=request.getParameter("ruzhuDate");
	String likaiDate=request.getParameter("likaiDate");
	String fangjianType=request.getParameter("fangjianType");
	String fangjianNum=request.getParameter("fangjianNum");
	String fuyan=request.getParameter("fuyan");
	


	userTruename=new String(userTruename.getBytes("8859_1"));
	fromCity=new String(fromCity.getBytes("8859_1"));
	fangjianType=new String(fangjianType.getBytes("8859_1"));
	fuyan=new String(fuyan.getBytes("8859_1"));
	

    if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{

		 strSQL2="insert into airline_hotelDingdanxinxi(dingdanhao,hotelId,";
		 strSQL2=strSQL2+"userTruename,userZhengjianhao,fromCity,userSex,userTel,";
		 strSQL2=strSQL2+"ruzhuDate,likaiDate,fangjianType,fangjianNum,fuyan)";
		 strSQL2=strSQL2+" values('"+dingdanhao+"',"+id;
		 strSQL2=strSQL2+" ,'"+userTruename+"'";
		 strSQL2=strSQL2+" ,'"+userZhengjianhao+"'";
		 strSQL2=strSQL2+",'"+fromCity+"'";
		 strSQL2=strSQL2+" ,'"+userSex+"'";
		 strSQL2=strSQL2+" ,'"+userTel+"'";
		 strSQL2=strSQL2+" ,"+ruzhuDate;
		 strSQL2=strSQL2+" ,"+likaiDate;
		 strSQL2=strSQL2+" ,'"+fangjianType+"'";
		 strSQL2=strSQL2+" ,"+fangjianNum;
		 strSQL2=strSQL2+" ,'"+fuyan+"')";

		 db.executeUpdate(strSQL2);
		 out.print("<script language=JavaScript>");
		 out.print("alert('您的订单号是"+dingdanhao+"');");
		 out.print("window.location.href ='../main.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){}
    }
%>