j2ee基础应用j2ee中sql语句自动构造方法（J2EE basic application automatic construction of SQL statement in J2EE）.docVIP

j2ee基础应用j2ee中sql语句自动构造方法（J2EE basic application automatic construction of SQL statement in J2EE） J2EE basic application: automatic construction of SQL statement in J2EE Number of reads: 227 release time: 2008-04-23 09:19:24, Publisher: bvyab Source: CSAI INSERT, DELETE, UPDATE three SQL statements are three basic statements of database technology in web development. Usually in the processing of which can be said to be everywhere. If the simple are manually constructed the SQL statement, a great work for our development, on the other hand, the flexibility of the system by very limited. So can let the system automatically removed from the page elements in the form to construct the SQL statement based on certain rules? Let us look at the basic form of the general INSERT, DELETE, UPDATE three: INSERT INTO table_name statements (col_1, col_2, col_3, VALUES) (value_1, value_2, value_3... FROM table_name WHERE col_n=value_n) DELETE UPDATE table_name SET col_1=value_1, col_2=value_2 col_3=value_3, WHERE col_x=value_x we know that J2EE request.getParameterNames (borrow) method can name all the elements in the form of reading, the element name from request.getParameter (elementName) method can obtain the value of the element. Lets say that in development, we let the name of the page element match the field name of the underlying database table. So, in these three statements, col_n and value_n are not unknown to us, and the rest of the unknown data is table_name, col_x, and value_x. Now, if we write a method that passes in the request object and then passes the table_name, col_x, and value_x arguments as arguments, we can easily construct the SQL statement automatically. But it is less flexible, because on the one hand, each time using this method we have to manually set table_name, col_x and value_x; on the other hand, dont forget the single quotes in the SQL statement for string fields with single quotes and replace the middle of the string, integer, floating-point, and syst