📄 logon.jsp

📁 办公系统的设计与实现。该系统是基于web的开发项目

💻 JSP

字号:

<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ 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>
<meta http-equiv="refresh" content="2; url=upload.jsp">
<title>登陆结果</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
	background-color: #FFCC33;
}
-->
</style></head>
<body>
<%
String aa="e:\\database\\kewei\\";
session.setAttribute("ftrace",aa);
%>
  <%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:my";

//如果是采用windwos验证方式，则采用下面的语句连接
//Connection conn = DriverManager.getConnection(driver);
//如果采用SQL Server验证方式，则采用下面语句，其中sa是用户名，密码为空，如果用户设置了密码，后面的引号中写入密码 
Connection conn = DriverManager.getConnection(driver,"","");

Statement stmt = conn.createStatement();
boolean a;
String select;
//读取提交的表单内容
String uid=request.getParameter("uid");
String pwd=request.getParameter("pwd");

//生成查询的sql命令
String sql="select * from custom where uid='"+uid+"'and pwd='"+pwd+"'";
//rs为返回结果的ResultSet对象
ResultSet rs=stmt.executeQuery(sql);
a=rs.next();

if(a==true)
{
//用户id及密码输入正确的情况
rs.close();
session.setAttribute("uid",uid);
%>
  <img src="image/smile.jpg" width="47" height="49" />欢迎您<%=uid%></p>

<table width="161" border="0">
  <tr>
    <td width="155"><form name="form2" id="form2" method="post" action="logoff.jsp">
      <div align="center">
        <input type="submit" name="Submit" value="注销" />
      </div>
    </form></td>
  </tr>
</table>
<p align="center"><img src="image/gif008.gif" width="81" height="71" /></p>
<p align="center">页面自动跳转中......请稍侯...</p>
<p align="center">&nbsp;</p>
<p>
  <%}
else
{
rs.close();
%>
</p>
</p>
<p>&nbsp;</p>
<p>对不起！您的输入有误，请重新填写！</p>
<p><input type="button" name="Button2" value="返回上一步" onclick="backward()"></p>
<%}%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -