Tips for newbies: Common methods of form data storage in JSP

Abstract

This article takes the Oracle database as an example to introduce a simple and universal form data storage and processing method when developing WEB applications using JSP technology to reduce the development workload and provide the main program code.

Introduction

J2EE (Java 2 Enterprise Edition) technology has been widely used in Web application development. The JavaBean and Servlet technologies provide developers with a clearer development environment. JSP technology is used to display pages, and Servlet technology is used to complete a large number of business processes. , using Beans to store data and some business processing. In WEB applications, the processing work of storing business data in the database is often very arduous. One of the main forms is to store form data in the database. The entire application processing process involves a large number of such data storage operations, and each form needs to be processed. It takes developers a lot of time and energy to write the corresponding data storage program separately. What methods to use to reduce the development workload of form data storage is a question worth studying.

Two common form data storage and processing methods:

1. Write corresponding program code for each form

in the JSP page or JavaBean or Servlet. Use the request.getparameter() function to extract the data submitted by the form one by one, or write the corresponding JavaBean. Use the setProperty method to automatically fetch the data into the JavaBean, then generate SQL statements (insert, update, delete), and finally execute the executeupdate() function to complete the data table storage.

2. Automatically generate a JavaBean program code for each data table.

The database system must support users to read the table structure and identify key fields. Use object-oriented rapid development tools, such as PowerBuilder, Delphi, etc., to develop a Java code automatic generation program. In this program, the structure of the database table is read: field name, data type, data length, and a JavaBean code is automatically generated. In this code, define variables with the same names corresponding to the fields in the table, establish setValue and getValue methods for all variables, and establish insert, update, and delete functions to handle the generation and execution of SQL statements for insert, update, and delete respectively.

In the data processing page submitted by the form, write the following code to store the form data in JavaBean:

<jsp: useBean id="table" class="table1_bean" />

<jsp: setProperty name="table" property="* " />

(Note: table1_bean is the above-mentioned automatically generated JavaBean corresponding to a certain table)

and then calls the insert, update, and delete functions in table1_bean to complete the data table storage and return the execution results. For example:

<%boolean success =table.insert(); %>

The first method is simple and intuitive, but it requires writing corresponding data processing procedures for each form. For slightly larger applications, the number of forms may be large, resulting in a heavy development workload and low development efficiency. When the table structure changes, such as adding or subtracting fields, the corresponding data processing program needs to be modified.

The second method is much simpler than the first. The data processing of each data table is implemented by the corresponding JavaBean. The JavaBean is automatically generated and does not need to be written. When the table structure changes, you only need to regenerate a new JavaBean and overwrite it after compiling with Java. The original java class can be used. However, this method requires the development of a JavaBean automatic generation program, and JavaBeans need to be regenerated and compiled when the table structure changes.

Introducing a simple and universal method to store form data

in WEB application development. Many forms are submitted to the backend server after simple data verification on the front-end browser. The server does not perform any processing on the data and directly stores the data into a database. table. In this case, we can just write a program to process these forms uniformly and store the data in a corresponding data table. This method also requires the database system to support table structure reading and key field identification. We use JSP technology to write this program, and the program file is named DbdataStore.jsp.

1. Calling format

The Action calling method of the form in the web page is as follows:

<Form Name=Frm1 Method=Post Action="DBdataStore.jsp? tablename=table1&OperType=…">

table1 is the table name of the database table where the data will be stored, and the OperType operation There are three types: insert, update, and delete.

The name values ​​in <input type=text name=…>, <textarea name=…><select name=…> in the form should be the same as the field names of the data table. The corresponding fields submitted by the form are extracted one by one in DBdataStore.jsp If there is no input defined in the form and the resulting value is a null value, the field will not be processed.

2. View definition taking Oracle as an example

1) Create a data type view for each column of the table

CREATE OR REPLACE VIEW v_dbstru AS SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, column_id

FROM all_tab_columns WHERE owner='user1'; //user1 Be the owner of the data table.

2) Create the key column view of the table

CREATE OR REPLACE VIEW v_pkey_column AS

SELECT b.table_name, b.column_name, b.position

FROM all_constraints a, all_cons_columns b

WHERE a.owner=b.owner AND a.constraint_name=b.constraint_name AND a .owner='user1' AND a.constraint_type='P';