📄 login.jsp
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<jsp:directive.page import="java.sql.ResultSet"/>
<html>
<head>
<title>My JSP 'login.jsp' starting page</title>
<link rel="stylesheet" href="newstyle.css" type="text/css">
</head>
<jsp:useBean id="db" scope="session" class="news.sql_data"/>
<body >
<%
String name=request.getParameter("name");
String password=request.getParameter("password");
session.setAttribute("name",name);
session.setAttribute("password",password);
ResultSet rs=db.executeQuery("select * from news where name='"+name+"'and password='"+password+"'");
if(rs.next()){
session.setAttribute("ID",rs.getString("ID"));
session.setAttribute("roleid",rs.getString("roleid"));
int roleid=Integer.parseInt(rs.getString("roleid"));
if(roleid==0){
%>
<script language="JavaScript" type="text/JavaScript">
window.location="admin.jsp"
</script>
<%}
else
if(roleid==1){%>
<script language="JavaScript" type="text/JavaScript">
window.location="teacher.jsp"
</script>
<%}
else
if(roleid==2){%>
<script language="JavaScript" type="text/JavaScript">
window.location="student.jsp"
</script>
<%}
else{%>
<script language="JavaScript" type="text/JavaScript">
window.location="error.html"//跳到错误页面
</script>
<% }}
rs.close();
db.closeStmt();
db.closeConn();
%>
<form method="post" action="login.jsp">
<table align="center" border="1" cellspacing="2" cellpadding="2" bgcolor="#66CCFF" bordercolor="#66CCFF" >
<tr >
<td colspan=2 align="center" valign="bottom"><h4><font color="#FF0000" >系统登录</font></h4></td>
</tr>
<tr>
<td>用户名：</td>
<td><input name="name" type="text" size="20" maxlength="20">
</td>
</tr>
<tr>
<td>密码：</td>
<td><input name="password" type="password" size="20" maxlength="25"></td>
</tr>
<tr align="center">
<td colspan="2"><input name="submit" type="submit" value="提交">
<input name="reset" type="reset"value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -