myeclipse jsp 用户数据库登录1

来源：互联网发布：淘宝茶叶拍摄技巧编辑：程序博客网时间：2024/06/07 04:05

数据库建立：

1—————————————————数据库建立——————————————

--删除数据表
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;

2------------------------------------------------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>

3-----------------------------------------------------------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();      //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);       %>      <table border = "1" width="90%">           <tr>       <td><%=ename%></td>       <td><%=epaserword%> </td>          </tr>        </table>            <%                        }      %>             <%     conn.close();     %>  </body></html>

0 0