String dbURL = "jdbc:mysql://localhost:3306/mysql/";
    String dbUser = "root";
    String dbPwd = "sesame";

    try {
        userid = request.getParameter("userid").trim();
        passattempt = Long.parseLong(request.getParameter("password").trim());
        Connection conn = DriverManager.getConnection(dbURL, dbUser, dbPwd);//creates connection each time the server runs
        Statement s = conn.createStatement();
        sql = "SELECT * FROM tblMembers WHERE Memid='" + userid + "'";//since id is numbers it needs to be surrounded by apostrophes, also sql is not case sensitive, semicolon is taken care of
        ResultSet r = s.executeQuery(sql);
        if (r.next()) {
            m = new Member();
            m.setMemid(userid);
            m.setPassword(r.getLong("Password"));
            m.setPassAttempt(passattempt);
            if (m.isAuthenticated()) {
                msg = "Userid " + userid + " authenticated!<br>";
                m.setLastnm(r.getString("LastName"));
                m.setFirstnm(r.getString("FirstName"));
                m.setMiddlenm(r.getString("MiddleName"));
                m.setStatus(r.getString("Status"));
                m.setMemdt(r.getString("MemDt"));
                URL = "/MemberScreen.jsp";