?? login.jsp~30~
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>圖書館</title>
<meta name="author" content="李楠">
<meta name="keywords" content="圖書館">
<meta name="description" content="這是一個用jsp編寫的圖書館資源管理系統">
</head>
<body>
<form name="form1" method="post" action="">
<p>user:
<input name="user" type="text" id="user" size="15" maxlength="12">
</p>
<p>code:
<input name="code" type="password" id="code" size="15" maxlength="12">
</p>
<p>
<select name="rights" size="1" id="rights">
<option selected>user</option>
<option>administrator</option>
</select>
</p>
<p>
<input type="submit" name="Submit" value="enter">
<input name="reset" type="reset" id="reset" value="reset">
</p>
</form>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<%
String validrights1 = "user";
String validrights2 = "administrator";
try{
if(request.getParameter("Submit")!=null){
Connection conn=Library.getConn();
Statement stmt=conn.createStatement();
String id = request.getParameter("user");
String code = request.getParameter("code");
String rights = request.getParameter("rights");
if(validrights2.equals(rights)){
String checkUser="select * from administrator where id ='" + id + "'and code ='" + code + "'";
ResultSet rs = stmt.executeQuery(checkUser);
if(rs.next()){
response.sendRedirect("administratorlogin.jsp");
stmt.close();
conn.close();
}else{
response.sendRedirect("fail.jsp");
}
}else {
String checkUser="select * from user where id ='" + id + "'and code ='" + code + "'";
ResultSet rs = stmt.executeQuery(checkUser);
if(rs.next()){
Library.setid(id);
// String s=Library.getid();
// out.println("<p>"+s+"</p>");
response.sendRedirect("userlogin.jsp");
stmt.close();
conn.close();
}else{
response.sendRedirect("fail.jsp");
}
}
}
}catch (Exception ex) {
ex.printStackTrace();}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -