📄 adminlogin.jsp

📁 可在线考试JSP等课程

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312"   %>
<%@ page import="java.sql.*" %>
<%  
   String username="";
   String passwd="";
   String msg1="";
   String msg2="";
   if (request.getParameter("name")==null)
    { msg1="姓名不能为空";} 
          if (request.getParameter("pass")==null)
   { msg2="密码不能为空";}
   if (request.getParameter("name")!=null && request.getParameter("pass")!=null)
   { username=request.getParameter("name");
      passwd=request.getParameter("pass");
	  String SQL="SELECT * From admin";
	  SQL=SQL+" Where user="+"'"+username+"'"+" And password='"+passwd+"'";
	
	  Connection conn=null;
	  Statement stmt=null;
	  ResultSet  rs=null;
	  try{
	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  }
	   catch(ClassNotFoundException ce){
	   out.println(ce.getMessage());
	   }
	   try{
	     conn=DriverManager.getConnection("jdbc:odbc:test");
		 stmt=conn.createStatement();
		 rs=stmt.executeQuery(SQL);
	   }
	    catch(SQLException e){
		System.out.println(e.getMessage());
		}
		
		  if(!rs.next())
		{ response.sendRedirect("error.html"); }
		else
		{response.sendRedirect("framezt2.jsp");}
		rs.close();
		
   }
 %>
<html>
<title>管理员登录</title>
<head><BODY background="AdminLogin.jpg">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
<!--
.STYLE1 {
	font-family: "宋体";
	font-size: 36px;
	color: #FF33FF;
	font-weight: bold;
}
body {	background-color: #339944;}
-->
</style>
</head>
<body>
<center>
<p class="STYLE1">管理员登录</p>
<form id="form1" name="form1" method="post" action="ryxinxi.jsp">
  用户名：<input name="name" type="text" id="name" size="18" />
  <font color="#99FF00"><%=msg1%></font>
 <p>
  密码： <input name="pass" type="password" id="pass" size="18" />
  <font color="#99FF00"><%=msg2%></font> 
 <p>
<input type="submit" name="Submit" value="进入人员信息界面" /></p>
</form>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -