such as Peng Network. NET three-tier architecture chapter fourth code generator

Introduction to business and code generators, how to write your own code generator

SELECT * from INFORMATION_SCHEMA. ' TABLES '
WHERE table_type= ' base TABLE ' and ' ENGINE ' = ' InnoDb ' and table_schema= ' Rpcaterdb '

SELECT * from INFORMATION_SCHEMA. ' COLUMNS ' where table_name= ' t_orders '

1, fully handwritten using three-layer architecture (without the help of code generator) to write a student's additions and deletions to the program, the main information: Student name (can not be empty), student birthday (can not be empty), student gender (can not be empty), height (may be empty), weight (can be empty), home address (can be empty Note: SqlHelper also have to write on their own. Record the time it takes to complete.

2, the user selects an arbitrary worksheet number, the arbitrary format Excel file, reads each sheet, generates to the HTML file, each sheet a table. For example, for the following Excel:

Generate the following HTML:

<table>

<tr><td> name </td><td> URL </td><td> principal </td></tr>

<tr><td> New Assistant Institute of Engineering </td><td>www.xiaobai.edu.jp</td><td> Xiao Xin </td></tr >

<tr><td> Yao Ming Sports University </td><td>www.yaoming.edu.cn</td><td> Yao Ming </td></tr>

</table>

<table>

<tr><td> Provinces </td><td> Specialties </td></tr>

<tr><td> Beijing </td><td> Haze </td></tr>

<tr><td> Henan </td><td> Braised noodles </td></tr>

</table>

</body>

such as Peng Network: http://www.rupeng.com

such as Peng Network. NET three-tier architecture chapter fourth code generator