login.jsp
来自「jsp动态网站开发与实例(第3版) 源码」· JSP 代码 · 共 57 行
JSP
57 行
<%@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 + =
减小字号Ctrl + -
显示快捷键?