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.