<%--
  Created by IntelliJ IDEA.
  User: Dell
  Date: 2021/4/11
  Time: 21:44
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<form action="dologin.jsp" method="post">
    用户名:<input type="text" name="username"/><br/>
    密码:<input type="password" name="password"/><br/>
    验证码:<input type="text" name="inputVcode"/><img src="/WebProject_war_exploded/createCode"><br/>
    <input type="submit" value="登录">
</form>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<%
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 'dologin.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 Name = request.getParameter("user");  //获取输入的用户名
        String ps = request.getParameter("password");  // 密码
        String code = request.getParameter("code");   //验证码
        Name.trim();  //去空格
        ps.trim();
         
         
        PreparedStatement pre = null;
        Connection con =null;
        Statement sql;
        ResultSet rs; 
        request.setCharacterEncoding("utf-8");
         
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }catch(Exception e){
            out.print("<h1>加载错误"+e);
        }
         
         
        String user = "root";
        String password="root";
     
         
        con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test",user,password);
             
             
        try{
            sql = con.createStatement();
             
            String SQLL = "select * from user where uname=? and upwd=?";
            pre=con.prepareStatement(SQLL);
            pre.setString(1,Name);
            pre.setString(2,ps);
             
             
            rs = pre.executeQuery();
             
            if(rs.next()){
                String na = rs.getString(2);
                session.setAttribute("uname",na);
                response.sendRedirect("welcome.jsp");
                 
                 
            }else{
            %>
            <script >         //弹窗提示
            alert('输入密码或用户名错误');
            </script>
            <%
                response.sendRedirect("index.jsp");
            }          
        }catch(SQLException e){
            out.print("<h1>查询错误"+e);
        }
         
             
         
        %>
   </body>
</html>
<<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
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 'welcome.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>
    欢迎<%=session.getAttribute("uname") %></body>
</html>