卢田田

导航

jsp第五六周作业 

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page language="java" import="java.util.*"%>
<%@ page import ="java.sql.*"%>
<html>
<head>
    <title>内容收集界面</title>
</head>
<body>
<%--<%--%>

<%--    String name=request.getParameter("name");--%>
<%--    String password=request.getParameter("password");--%>
<%--    if(name.equals("zs")&&password.equals("123")){--%>
<%--%><p>welcome<%=name%></p><%--%>
<%--}else{--%>
<%--%><p>登陆失败</p><%--%>
<%--    }--%>
<%--%>--%>
<%
    PreparedStatement pre = null;
    Statement sql;
    ResultSet rs;
    request.setCharacterEncoding("utf-8");
    String Name = request.getParameter("name");  //获取输入的用户名
    String Ps = request.getParameter("password");  // 密码
    Name.trim();
    Ps.trim();
    request.setCharacterEncoding("utf-8");

    Class.forName("com.mysql.cj.jdbc.Driver");
    // 建立连接
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?serverTimezone=GMT", "root", "135790");
    sql =conn.createStatement();
    String SQL = "select * from jsp_data where uname=? and upassword=?";
    pre=conn.prepareStatement(SQL);
    pre.setString(1,Name);
    pre.setString(2,Ps);
    rs=pre.executeQuery();
    if (rs.next()) {
        String name = rs.getString(1);
        session.setAttribute("name",name);
%><p>欢迎登陆：<%=name%></p><%
      }else{%> <p>输入错误，请重新登录</p><a href="index.jsp"><button>返回登录界面</button></a>
<%
      }
      rs.close();
    sql.close();
    conn.close();
    %>

</body>
</html>
<%@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>

 

posted on 2021-04-12 15:48  可爱小卢没脑袋  阅读(42)  评论(1)    收藏  举报