用Servlet校验密码2

用Servlet校验密码2

学号：201631062509

姓名：杨菓

1.主效果图

 

 数据库

 

 

主界面同前面做的一样

用户名为空

 

 

用户名或密码错误

 

登陆成功

 

2.源代码

Servlet

import java.io.IOException;
import java.sql.*;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import DaoUtils.JdbcUtils;



/**
 * Servlet implementation class check
 */
@WebServlet("/check")
public class check extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public check() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        
        Connection con = null;
        PreparedStatement preparedStatement = null;
        ResultSet rs = null;
        
        request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        
        String userName = request.getParameter("checkInID");
        String userPass = request.getParameter("checkInPass");
        
        try {
            con = JdbcUtils.getConnection();
            String sql = "SELECT * FROM USER WHERE userName = '" + userName + "' AND userPass = " + userPass;
            preparedStatement = con.prepareStatement("SELECT * FROM USER WHERE userName = ? AND userPass = ?");
            preparedStatement.setString(1, userName);
            preparedStatement.setInt(2, Integer.valueOf(userPass));
            rs = preparedStatement.executeQuery();
            
            if(!rs.next()){
                response.getWriter().write("用户名或密码错误");
            }else{
                
                response.getWriter().write("用户名：" + rs.getString(1));
                response.getWriter().write("</br>");
                response.getWriter().write("密码：" + rs.getInt(2));
            }
            
        } catch (SQLException | ClassNotFoundException e) {
            // TODO 自动生成的 catch 块
            e.printStackTrace();
        } finally {
            release(con, preparedStatement, rs);
        }
        
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }
    
    public static void release(Connection conn, Statement st, ResultSet rs){
        if(rs != null){
            try{
                rs.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            rs = null;
        }
        
        if(st != null){
            try{
                st.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            st = null;
        }
        
        if(conn != null){
            try{
                conn.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            conn = null;
        }
    }

}

JDBC

package DaoUtils;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;


public class JdbcUtils {
    private static String driver = null;
    private static String url = null;
    private static String username = null;
    private static String password = null;
    
    public static void setDriver(String driver) {
        JdbcUtils.driver = driver;
    }
    
    public static void setPassword(String password) {
        JdbcUtils.password = password;
    }
    
    public static void setUsername(String username) {
        JdbcUtils.username = username;
    }
    
    public static void setUrl(String url) {
        JdbcUtils.url = url;
    }
    
    public static String getDriver() {
        return driver;
    }
    
    public static String getPassword() {
        return password;
    }
    
    public static String getUrl() {
        return url;
    }
    
    public static String getUsername() {
        return username;
    }
    
    static{
        //try{
            /*String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/checkprojectdb";
        String username = "root";
        String password = "980420";*/
            
            Properties p = new Properties();
            try{
                //通过相对路径加载文件
                String path = (Thread.currentThread().getContextClassLoader().getResource("").getFile()).substring(1);
                path=java.net.URLDecoder.decode(path, "utf-8");
                path=path.replace('/', '\\');
                path=path.replace("file:", "");
                path=path.replace("classes\\", "");
                path+="classes/DaoUtils/db.properties";
                p.load(new FileInputStream(new File(path)));
                //用getProperties方法通过关键字获取信息
                driver = p.getProperty("driver");
                url = p.getProperty("url");
                username = p.getProperty("username");
                password = p.getProperty("password");
            //}
                Class.forName(driver);
        }catch (Exception e) {
            // TODO: handle exception
            System.out.println(driver +" " + url + " " + username +" " + password );
            throw new ExceptionInInitializerError(e);
        }
    }
    
    public static Connection getConnection() throws SQLException, ClassNotFoundException{
        return DriverManager.getConnection(url, username, password);
    }
    
    public static void release(Connection conn, Statement st, ResultSet rs){
        if(rs != null){
            try{
                rs.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            rs = null;
        }
        
        if(st != null){
            try{
                st.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            st = null;
        }
        
        if(conn != null){
            try{
                conn.close();
            }catch (Exception e) {
                // TODO: handle exception
                e.printStackTrace();
            }
            
            conn = null;
        }
    }
    
    public static void main(String[] args) {
        System.out.println(driver + "; " + username + "; " + password + "; " + url);
    }
}

JdbcUtils

HTML

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8"/>
        <title>登录</title>
        <link href="style/loginP.css" type="text/css" rel="stylesheet"/>
        <script type="text/javascript" src="script/identify.js"></script>
    </head>
    <body>
        <div id="topBar">
            <div class="topContent">
                <i></i>
                <p>西南石油大学新闻发布后台登录</p>
                <span>帮助</span>
            </div>
        </div>

        <div id="main">
            <div id="sign_in_part" class="login_form">
                <p class="title_caption">账号登录</p>
                <div class="login_block">
                    <form method="post" action="check" id="loginForm" onsubmit="return checkForm()">
                        <fieldset>
                            <h1 id="login-info">用户登录</h1>
                            <div class="login_input">
                                <input type="text" id="checkInID" name="checkInID" placeholder="请输入账号" required/>
                                <div class="clear"></div>
                            </div>
                            <div class="login_input">
                                <input type="password" id="checkInPass" name="checkInPass" placeholder="请输入密码" required/>
                                <div class="clear"></div>
                            </div>
                            
                            <div class="login_sub_in">
                                <button type="submit" value="登录" id="subBut">登录</button>
                            </div>
                        </fieldset>
                    </form>
                </div>
            </div>
        </div>
        <div id="foot">
            <p>西南石油大学登录</p>
        </div>
    </body>
</html>

HTML

HTML

CSS

.h{
    width: 964px;
    margin: 0 auto;
}
*{
    margin: 0;
    padding: 0;
}
.t{
    height: 95px;
    line-height: 90px;
    background-color:#f5f5f5 ;
    border-bottom-width: 1px;
    border-bottom-style: solid;
    border-bottom-color: #e5ecf0;
    overflow:hidden;
}
.logo{
    padding-top: 15px;
    float: left;
}
.help{
    float: right;
    font-size: 14px;
    font-weight: 700;
    color: #787878;
    text-decoration: none;
}
body{
    font-family: "微软雅黑",verdana,geneva,sans-serif;
    font-size: 12px;
    background: #fff;
}
.box{
    width: 376px;
    position: absolute;
    box-shadow: 0px 0px 5px rgba(0,0,0,0,4);
}
.c{
    width: 964px;
    height: 460px;
    margin: 20px auto 0 auto;
    background: url(../img/backimg.png) no-repeat;
    background-attachment: scroll;
    background-repeat: no-repeat;
    background-position-x: 0%;
    background-position-y: 0%;
    background-size: cover;
    background-origin: padding-box;
    background-clip: border-box;
    background-color: transparent;
    position: relative;
}
.tab li.current{
    background-attachment: scroll;
    background-repeat: repeat;
    background-size: auto;
    background: #ff7e00;    
}
.tab li.dragbar{
    width: 22px;
    cursor: move;
    overflow: hidden;
}
.tab li{
    height: 40px;
    line-height: 40px;
    float: left;
    width: 354px;
    text-align: center;
    background: #333;
    color: #fff;
    font-size: 16px;
    cursor: pointer;
}
.msg{
    position: absolute;
    background: #cc3300;
    color: #FFFFFF;
    padding: 0 10px;
    font-size: 14px;
}
ul{
list-style-type: none;
list-style-position: outside;
list-style-image: none;
}
.tab{
    border-bottom: 3px solid rgba(255,126,0,0.8);
    overflow: hidden;
}
.boxc{
    background: #FFFFFF;
    padding: 20px 0 30px 42px;
}
.text{
    height: 36px;
    line-height: 36px;
    outline: none;
    width: 280px;
    border: 1px solid #c7c7c7;
    background: #f3f3f3;
    border-radius: 1px;
    padding: 0 5px;
    font-family: "微软雅黑";
}
.text_item{
    height: 38px;
    line-height: 38px;
    width: 292px;
    margin: 15px 0 30px 0;
}
.btnb{
    margin: 20px 0 0 0;
    width: 292px;
    position: relative;
}
.btn{
    height: 38px;
    width: 142px;
    border: none;
    color: #fff;
    font-weight: 400;
    font-size:20px;
    font-family: "微软雅黑";    
}
.nouser{
    position: absolute;
    background: #CC3300;
    color: #fff;
    padding: 0 10px;
    font-size: 14px;
    height: 30px;
    line-height: 30px;
    left: 42px;
    right: 42px;
    text-align: center;
    display: none;
}

JS

function checkForm(){
    var subButton = document.getElementById("subBut");
    var userID = document.getElementById("checkInID");
    var userP = document.getElementById("checkInPass");
    
    if(userID.value == "" || userP.value == ""){
        var info = document.getElementById("login-info");
        var infoStyle = info.style;
        infoStyle.visibility = "visible";
        info.innerText = "请输入用户名";
        return false;
    }else{
        return true;
    }
}

3.百度云地址

链接：https://pan.baidu.com/s/1sME4oc60WjYKx7_doM_bkw
提取码：s3ek