声明本人参考李兴华老师的课程初学JAVAWEB开发
--删除数据表
DROP TABLE users;
--创建数据表
CREATE TABLE users(
userid VARCHAR2(20),
password VARCHAR2(20),
CONSTRAINT pk_uid PRIMARY KEY(userid)
);
--测试数据
INSERT INTO users(userid,password) VALUES ('admin','administror');
INSERT INTO users(userid,password) VALUES ('admin1','administror');
INSERT INTO users(userid,password) VALUES ('admin2','administror');
INSERT INTO users(userid,password) VALUES ('admin3','administror');
INSERT INTO users(userid,password) VALUES ('admin4','administror');
INSERT INTO users(userid,password) VALUES ('admin5','administror');
INSERT INTO users(userid,password) VALUES ('admin6','administror');
SELECT COUNT(userid) FROM users WHERE userid='admin' AND password='administror';
--事务提交
COMMIT;
SELECT userid,password FROM users;
----------------index.jsp----------------------
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action = "logincheck.jsp" method = "post">
<table border = "1">
<tr>
<td colspan ="2">user log in</td>
</tr>
<tr>
<td> username </td>
<td><input type = "text" name= "username" id="username"></td>
</tr>
<tr>
<td> password </td>
<td><input type = "text" name= "password" id = "password"> </td>
</tr>
<tr>
<td colspan="2">
<input type = "submit" value = "login">
<input type = "reset" value = "reset">
</td>
<tr>
</table>
</form>
</body>
</html>
------------logincheck.jsp--------------------------
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@page import="java.util.*" %>
<%@page import="java.text.*" %>
<%@page import="java.sql.*" %>
<%@page import="java.net.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'logincheck.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
boolean flag = false;
System.out.println("username:"+username);
System.out.println("password:"+password);
%>
<%!
private static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORCL";
private static final String DBUSER = "scott";
private static final String PASSWORD = "tiger";
%>
<%
Connection conn;
PreparedStatement pstmt;
ResultSet rs;
%>
<%
//System.out.println("------------------------1-----------------");
// String sql = "SELECT userid,password FROM users";
//String sql = " SELECT empno ,ename,job,hiredate,sal,comm FROM emp";
String sql = "SELECT COUNT(userid) FROM users WHERE userid=? AND password=?";
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, PASSWORD); // 连接数据库
System.out.println(conn); // 如果不为null表示已连接
//conn.close() ;
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,username);
pstmt.setString(2,password);
rs = pstmt.executeQuery();
if(rs.next()){
if(rs.getInt(1)==1){
flag = true;
}
}
conn.close();
//System.out.println("------------------------2-----------------");
%>
<%
//System.out.println(rs.next());
// while(rs.next()){
//System.out.println("-----------------------3----------------");
//String ename = rs.getString(1);
//String epaserword = rs.getString(2);
//System.out.println(ename);
//System.out.println(epaserword);
if(flag){
%>
<jsp:forward page="welcom.jsp"></jsp:forward>
<%
}else{
%>
<jsp:forward page="index.jsp"></jsp:forward>
<%
}
%>
</body>
</html>
------------------welcom.jsp-------------------------------
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'welcom.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
welcom login. <br>
</body>
</html>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
