📄 logout.jsp

📁 毕业设计代码
💻 JSP
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="db" class="BeanLink.DBBean" scope="page"/>
<%
    ResultSet rs=null;
    String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序
    String url="jdbc:odbc:airline";    //数据源的url
    String user1="tangbohu";  //连接数据库的用户名
    String pass1="";  //连接数据库的口令
    String strSQL1;  //要执行的sql语句
	String strSQL2;  //要执行的sql语句
	String userName=request.getParameter("userName");
    String userPass=request.getParameter("userPass");
    userName=new String(userName.getBytes("8859_1"));
    if(!db.initialization(driver,url,user1,pass1))  //进行初始化
	{
		out.println(db.getHint());
	}
	else try{
        strSQL1="select count(*) from airline_user with(READCOMMITTED) where userName='"+userName+"' and userPass='"+userPass+"'";//判断是否有用户存在
        rs=db.executeQuery(strSQL1);
        rs.next();
        if(rs.getInt(1)==1)
        {
			session.setAttribute("userName",userName);//插入主题的时候用到
			out.print("<script language=JavaScript>");
                
            out.print("alert('成功登陆');");

            out.print(" </script>" );
		}
        else{
			out.print("<script language=JavaScript>");
                
            out.print("alert('用户名或密码错误');");
                
            out.print("window.location.href ='left.jsp'");

            out.print(" </script>" );
		}
	}
    catch(SQLException e2){
		out.println("数据库异常！");
        out.println(e2.toString());
    }
    finally{
		try{
			if(rs!=null) rs.close();
		}
        catch(Exception e){}
    }
%>
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<TITLE>航空售票系统</TITLE>
<LINK HREF="../../css/style.css" TYPE="text/css" REL="STYLESHEET">

</HEAD>

<BODY>

<FORM NAME="form1" METHOD="post" ACTION="">

    
  <TABLE WIDTH="179" BORDER="0" align="center" CELLPADDING="0" CELLSPACING="0">
    <TR>
            <TD WIDTH="30" HEIGHT="25" CLASS="LOGIN style1"><CENTER>
                <IMG SRC="../../image/icon00.gif" WIDTH="20" HEIGHT="20">
            </CENTER></TD>
            <TD WIDTH="149" CLASS="LOGIN"><%=userName%>：您好</TD>
        </TR>
        <TR CLASS="LOGIN">
            <TD HEIGHT="17" COLSPAN="2">&nbsp;</TD>
        </TR>
        <TR CLASS="LOGIN">
            <TD HEIGHT="24" ALIGN="CENTER" CLASS="TEXT"><IMG SRC="../../image/icon01.gif" WIDTH="16" HEIGHT="15"></TD>
            <TD CLASS="TEXT"><A HREF="vip/edit.jsp?userName=<%=userName%>" TARGET="mainFrame">修改个人信息</A></TD>
        </TR>
        <TR CLASS="LOGIN">
            <TD HEIGHT="13" COLSPAN="2">&nbsp;</TD>
        </TR>
        <TR CLASS="LOGIN">
            <TD HEIGHT="30" COLSPAN="2" ALIGN="CENTER"><A HREF="JavaScript:linkSyokomoku();" ><IMG SRC="../../image/exit.gif" WIDTH="80" HEIGHT="22" BORDER="0"></A></TD>
        </TR>
        <TR CLASS="LOGIN">
            <TD HEIGHT="7" COLSPAN="2">&nbsp;</TD>
        </TR>
        <TR>
            <TD HEIGHT="14" COLSPAN="2" ALIGN="CENTER"><IMG SRC="../../image/slide1.gif" ALT="" WIDTH="180" HEIGHT="12" BORDER="0"></TD>
        </TR>
        <TR>
            <TD HEIGHT="32" COLSPAN="2" CLASS="TEXT">&gt;&gt;飞机图片</P>
            </TD>
        </TR>
        <TR>
            <TD HEIGHT="15" COLSPAN="2" ALIGN="CENTER">
                <IMG SRC="../../image/plants.gif" ALT="飞机图片" WIDTH="100" HEIGHT="67">
            </TD>
        </TR>
        <TR>
            <TD HEIGHT="15" COLSPAN="2">&nbsp;</TD>
        </TR>        
        <TR>
            <TD HEIGHT="7" COLSPAN="2" CLASS="HD5">&nbsp;</TD>
        </TR>
        <TR>
            <TD HEIGHT="8" COLSPAN="2" CLASS="HD5">电话：0411-11111111</TD>
        </TR>
        <TR>
            <TD HEIGHT="15" COLSPAN="2" CLASS="HD5">传真：0411-22222222</TD>
        </TR>
    </TABLE>
</FORM>

</BODY>
</HTML>
<script language="javascript">
<!--
function linkSyokomoku()
{
	var frm=document.form1;
	var frmmain=parent.leftFrame.document.form1;
	frm.method = "post";
	frm.action = "main.jsp";
	frm.target = "mainFrame";
	frm.submit();
	frmmain.method = "post";
	frmmain.action = "left.jsp";
	frmmain.target = "leftFrame";
	frmmain.submit();
}
-->
</script>
⌨️ 快捷键说明

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