📄 login.jsp
字号:
<%@page contentType="text/html"%>
<%@page pageEncoding="GB2312"%>
<%@page import = "java.sql.*" %>
<%
if(request.getParameter("memberid") !=null &&
request.getParameter("memberpwd") != null){
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:member");
Statement smt =con.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String getpaperdata = "SELECT * FROM member WHERE memberid='" +
request.getParameter("memberid") + "' AND memberpwd='" +
request.getParameter("memberpwd") + "'" ;
ResultSet paperrs =smt.executeQuery(getpaperdata) ;
if(paperrs.next()){
response.sendRedirect("accesspage.jsp") ;
}else
out.println("密码账号不符 !!") ;
}
%>
<html>
<head><title>登录网页</title></head>
<body>
<form method="post">
<table border="0" width="898">
<tr>
<td width="890" align="left" colspan="2">
<b><font size="5">系统登录</font></b>
<hr>
</td>
</tr>
<tr>
<td width="75" align="center">
<p align="right">账号：</p>
</td>
<td width="809" align="center">
<p align="left">
<input type="text" name="memberid" size="20"></td>
</tr>
<tr>
<td width="75" align="center">
<p align="right">密码：</p>
</td>
<td width="809" align="center">
<p align="left">
<input type="password" name="memberpwd" size="20">
<input type="submit" value="登录" name="loginButton"></td>
</tr>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -