JSP第五-六周作业

1.安装MySQL数据库，建立用户表 uid uname upwd 并插入3条数据

2.制作jsp登录页面 login.jsp 提交到dologin.jsp，使用jdbc连数据库，判断输入的用户名密码是否存在

3.如果存在，把用户名保存在SESSION中，跳转到welcome.jsp，welcome.jsp中读取session中的用户名，显示欢迎你xxx

4.若不存在，跳到登录页面。

 

<%@page import="java.nio.channels.SeekableByteChannel"%>
<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>www.school.com</title>
</head>
<body>
    <%!public static final String DBDRIVER = "com.mysql.jdbc.Driver";
    public static final String DBURL = "jdbc:mysql://localhost:3306/jspwork";
    public static final String DBUSER = "root";
    public static final String DBPASS = "root";%>
    <%
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        boolean flag = false;
        String name = null;
    %>
    <%
        try {
            Class.forName(DBDRIVER);
            conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
            String sql = "SELECT uname FROM num_one WHERE uid=? AND upwd=?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, request.getParameter("id"));
            pstmt.setString(2, request.getParameter("password"));
         
            rs = pstmt.executeQuery();
            if (rs.next()) {
                name = rs.getString(1);
                flag = true;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null)
                    rs.close();
                if (pstmt != null)
                    pstmt.close();
                if (conn != null)
                    conn.close();
                if (flag) {
                 request.getSession().setAttribute("uname",name);
                 request.getRequestDispatcher("ok.jsp").forward(request,response);
                 
                   // request.getRequestDispatcher("ok.jsp").forward(request, response);
                } else {
                    response.sendRedirect("no.jsp");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    %>
 
</body>
</html>
<%@ page language="java" contentType="text/html" import="java.util.*"  pageEncoding="utf-8"%>


<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://"
            + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>
<%
    String str = request.getParameter("address");
    String pwd = request.getParameter("password");
    if (null != str) {
        if (str.equals("ysp") && pwd.equals("123")) {
            pageContext.forward("MyJsp1.jsp");
        } else {
            out.println("登录失败,请重新登录！");
        }
    }
%>

<html>
<head>
<form action="" method="post">
    <br> 账号： <input type="text" name="address" size="20"><br>
    密码： <input type="password" name="password" size="21"><br>
    验证码： <input type="text" name="2907" size="17"> <img id="yzmtp"
        src="aaa/23.jpg" width="120px" height="70px" />换一张<br> <input
        type="submit" value="登录" name="a">
</form>
</head>

<body style="background:url(aaa/1.jpg)";>



</body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
  <head> 
  </head>
  <body style="background:url(aaa/1.jpg)">
        欢迎ysp登录
<br>
</body>
</html>

 

 

 

 

 

 

 

posted @ 2021-04-12 15:02  LILY十一啦  阅读(54)  评论(0)  编辑  收藏  举报