Online Tutorials and Reader Comments

"Grover Blue" <[email protected]> Wed, 21 Jun 2006 14:27:22 -0400
Newsgroups gmane.comp.java.netbeans.webteam
Message-ID <[email protected]>
If anyone has read tutorials and/or documentation like mySQL's online docs,
you'll notice at the end of each section readers can leave feedback.  This
would be nice addition to the Netbeans article pages.

For instance, I would like to add comments on where to find information on
using Netbeans to configure database connections and datasources, which is
needed to complete http://www.netbeans.org/kb/articles/security-webapps.html

Or, that "find user query" should be "find-user-query"

Or, SELECT GROUP_NAME FROM PERSON P, GROUP G WHERE P.GROUP_ID = G.ID AND
USERID = ?
        should be
     SELECT GROUP_NAME FROM PERSON P, "GROUP" G WHERE P.GROUP_ID = G.ID AND
USERID = ?

Or, Derby documentation is at http://db.apache.org/derby/docs/dev/ref/

Or, SQL to create the tables could be something like:

create table "GROUP" (
    ID          SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START
WITH 5, INCREMENT BY 5),
    GROUP_NAME  VARCHAR(15),
    ADDRESS     VARCHAR(100),
    PHONE       VARCHAR(15),
    CONSTRAINT GROUP_QU UNIQUE (ID)
);
create table PERSON (
    IDENTIFIER  INT NOT NULL GENERATED ALWAYS AS IDENTITY,
    UserID      Varchar(10),
    password    varchar(10),
    fname       varchar(20),
    lname       varchar(20),
    GROUP_ID    SMALLINT NOT NULL,
    CONSTRAINT PERSON_PK PRIMARY KEY (UserID),
    CONSTRAINT PERSON_FK FOREIGN KEY (GROUP_ID) REFERENCES "GROUP"
(ID) ON DELETE RESTRICT
);
INSERT INTO "GROUP" (GROUP_NAME,ADDRESS,PHONE) VALUES ('user','123
Slow Cheetah Lane','973-770-3200');
INSERT INTO PERSON (UserID,password,fname,lname,GROUP_ID) VALUES
('testuser','testpass','John','Doe',5);


Most people that follow these tutorials are new to Java and/or new to
Netbeans.  There shouldn't be an assumption that they know everything not
explicitly covered, but which is required to get a project going.

Perhaps there can also be a "Related Tutorials/Articles" section at the
bottom of each article.

In addition, the above mentioned article lists 3 possible results of testing
the application.  The last being:

"Password for this user is correct, but user does not have right to access
the secured content -> browser displays Error 403 Access to the requested
resource has been denied"

The author, however, doesn't point to a resource that would help the reader
resolve this.  Perhaps it's not the authors job, but if there were  a
"Reader's Comments" section, someone certainly could.

Thank you for listening, and I hope you consider these additions to an
already great site.