How to build a Struts database application with landing pages and roles

How to build a Struts database application with landing pages and roles

[aims]

The goal of this example is to implement a user login application. Save user information with SQL Server 2000 database. Implement the user login page, user login verification, login check tag and other functions.

Define a field named "Users" table:

Enter some test data:

For example, the above data may have a role or multiple roles. For multiple characters, you can use multiple records to indicate that a record represents a role or a record represents a plurality of roles, each role is separated by ";".

[effect]

Welcome page:

login page:

The main menu page after the landing is completed:

If you do not log in but run the main menu page user query page, you will automatically go to the user login page, and no longer give a show.

[background knowledge]

[step]

This example is compared with the steps in the "Struts Database Application", in addition to a selection "Struts Database Application Template" with Land and Roles "when establishing a new project, another selection" empty struts database application template ", And in the JSP page, you need to check if the user has logged in. "", the other steps are exactly the same, so the same step details see "How to implement the Struts database application ".

1. Open the Visual Struts development environment:

Start JavaWebStudio.exe files from the desktop JavaWebstudio fast or bin directory launched the Visual Struts development environment of JavaWebStudio.

2. Create an "empty Struts database application template application" application:

Select the menu "File" - "New" - "New Project", pop up the new project dialog, as shown in Figure 1 below:

Select "Empty Struts Database Application Template" in the dialog box, enter "Logon", Package (Package ", and location (path path) in the project name, which is of course changed as needed. Finally, click the "OK" button to complete the establishment of the new project.

In the root of the Logon project, you contain four subdirectories and two files, which is the standard structure of the JavaWebStudio project, it is best not to change their default names, otherwise there will be problems.

Using the project generated by the Struts Database Application Template with Logging Page and Roles, the logon.jsp and logonaction.java file required for the user login, and also generates files for user login demo, where Index.htm It is a "landing" button, click the "Log" button to go to the Logon.jsp Enter the input page, the login input is completed and submit, and if you log in, go to the MainMenu.jsp main menu page. Add a label after the main menu page tag "" is used to check if the user has already logged in, where the ROLE property is used to specify the user role, which means that only the role is "system "The user can pass. If you have already logged in, you will continue to display the page, otherwise you will automatically go to the login page.

Logon.jsp file:

INDEX.HTM file:

MainMenu.jsp file:

3. Use the Struts Database Application File Wizard to establish a new application:

To click the right mouse button in the JavaWebStudio file manager, select the Struts Database Application File Wizard to enter the Struts File Wizard dialog box, or select the menu "file" - "Struts Database Application File Wizard" The Struts File Wizard dialog box.

Enter the "Useredit" file name in the filename input field under the Struts file wizard dialog jsp file, other files use the default settings. (1) Enter the file name:

(2) Import the field information of the SQL statement and the data table from the data source (field name, and field type):

(3) Select the desired table "User" from the data table.

It is important to note that the "Field information of the SQL statement and data table from the data source" and "Select the table from the data table" is merely generated to automatically generate SQL statements and read field information, here Complete can be manually entered directly, unrelated to the configuration of the database connection pool, below, and then configure the database connection pool separately.

Next, configure the database connection pool, and other property pages can be used by default, and the data connection configuration property page is directly turned directly.

(4) JSPOUT property page settings:

The setting of the JSPOUT property page is the only step in the "How to Implement Struts Database Application", which is the core content of this example. As can be seen from the figure, we have to do it just to add the "Record Operation" selection in the settings of the "Record Operation" selection item.

(5) Configure the database connection pool:

Here you need to note that the user login is also used to use this database connection configuration.

(6) Plus the user login check tab in the newly generated JSP file :

The newly generated JSP file has three, query conditions Enter file useerEdit.jsp, add new record input files UserEditInsert.jsp and query results display file useritout.jsp. Add the user login check tag after the tag of these three files, respectively.

4, project file structure

Project directory structure analysis See "How to achieve the simplest struts program", this Struts database application file wizard automatically generates six files, where the web directory is input, output two JSP files, the SRC directory is a Java file. All program source code is automatically generated by the file wizard except that the file name is automatically generated, and all configurations are also automatically completed.

Refresh the JavaWebStudio file manager, then the three files are automatically generated in the web directory, which is useeredit.jsp and useeredit.jsp and useritinsert.jsp, the former is an input JSP file, the middle is output JSP file, the latter is adding a record Page file; SRC / EMPTYPRJ directory automatically generates four files, which are useeredit action.java, useeredit form.java, the former is an action file, the latter is a formaction file; there is a database operation file Useredit.java and Usereditdao. Java, the former is used to save the bean recorded by the data table, and the latter is a database operation DAO file.

4.1, modify the DAO file:

If the data is selected, SQL Server 2000, you need to put the following code in the DAO file:

// Please join the down with SQL Server:

//con.setautoCommit (true);

// SQL Server

Both rewritten into the following code:

// Please join the down with SQL Server:

Con.SetAutocommit (True); // Note !! This is this line, it turned out to be annotated, now you have to get your annotation !!

// SQL Server

Through the above rewriting, the SQL Server 2000 can be recorded, deleted, and adding the SQL Server 2000 by JDBC. 4.2 Join the login identification label on the place where the user login identification is required

(1) Useredit.jsp file:

Plus tag before

<% @ page contenttype = "text / html; charset = GB2312" Language = "java"%>

<% @ Taglib Uri = "/ Web-INF / STRUTS-Bean.tld" prefix = "bean"%>

<% @ Taglib URI = "/ Web-INF / STRUTS-HTML.TLD" prefix = "html"%>

<% @ Taglib URI = "/ Web-INF / STRUTS-LOGIC.TLD" prefix = "logic"%>

<% @ Taglib URI = "/ Web-INF / STRUTS-TEMPLATE.TLD" prefix = "template"%>