public void addNewStudent(String username, String password ,String firstName, String lastName, String teacherUserName) {
        PreparedStatement newData1 = null;
        PreparedStatement newData2 = null;
        PreparedStatement teacherIDFinder = null;
        int teacherID = -1;

        try {

            newData1 = connect.prepareStatement(
                    " insert into User (username, password, firstName, lastName, isAStudent) " +
                            " values (?, ?, ?, ?, ?); ");
            newData1.setString(1, username);
            newData1.setString(2, password);
            newData1.setString(3, firstName);
            newData1.setString(4, lastName);
            newData1.setInt(5, 1);
            newData1.executeUpdate();

            teacherIDFinder = connect.prepareStatement(
                    " select userID from User "
                            + "where username = ?;");
            teacherIDFinder.setString(1, teacherUserName);
            ResultSet results = teacherIDFinder.executeQuery();
            if (results.next()) {
                teacherID = results.getInt(1);
            }


            newData2 = connect.prepareStatement(
                    " insert into Student (studentID, teacherID, teamTemplate) " +
                            " values (last_insert_id(), ?, ?); ");
            newData2.setInt(1, teacherID);
            newData2.setInt(2, 1);
            newData2.executeUpdate();

            connect.commit();

        } catch(SQLException sqex) {
            try { connect.rollback(); System.err.println(sqex.toString()); }
            catch (SQLException sqex2) { System.err.println("Dammit\n" + sqex2.toString()); }
        } finally {
            if (newData1 != null) {
                try { newData1.close(); }  catch (SQLException sqex) { System.err.println(sqex.toString()); }
            }
            if (newData2 != null) {
                try { newData2.close(); }  catch (SQLException sqex) { System.err.println(sqex.toString()); }
            }
            if (teacherIDFinder != null) {
                try { teacherIDFinder.close(); }  catch (SQLException sqex) { System.err.println(sqex.toString()); }
            }
        }
    }