Main Function: Get the schema of database include table name, field name, type and length etc. User can use these fields directly and design template in javascript, then generate code. Used in Cases: Generate code to insert, update, delete and select data from database. Especially it should be used when the process logic is similar but the table is different. It will increase the efficiency by generate code automatically instead of copy&paste. For example, you want to generate 10 bean classes which present 10 tables, you can just write lines of javascript code to do it without had to code the bean class 10 times. How to use£º Tags which means start javascript in template Javascript: 1. <$ //Javascript code like: println(sys_fields[0].name); $> 2. <$=sys_fields[0].name$> Quick Start: ¡¡¡¡1. Create a new project, input the project name and destination folder to generate source code. ¡¡¡¡2. Setup the database connection include db type, and required information. ¡¡¡¡3. Create folder if needed and add one or more templates and edit the template. ¡¡¡¡4. Select the table which you want to generate code. ¡¡¡¡5. a. Select Menu "Template-> Generate File" to generate code for current template. b. Select Menu "Project-> Generate Project Files" to generate all the template code for current selected table. ¡¡¡¡6. Save the project for future use. Predefined variables: 1. sys_table_name: current selected table name 2. sys_fields: Array of Field object. use sys_fields.length to get the field count of current table. 3. sys_keys: Array of Primary key column, use sys_keys.length to get the field count of current table. 4. sys_user_name: User name used to connect to current database. 5. sys_db_name: Database name used to connect to. 6. sys_output: Internal use only which store the temporary generated code. User can use it too by println(sys_output). 7. Field Object Declaration And Example name: field name, String. For Example: sys_fields[i].name type: field type, String, For Example: sys_fields[i].type size: field length, integer, For Example: sys_fields[i].size scale: field scale, integer, For Example: sys_fields[i].scale default_value: Default value for the field, String. For Example: sys_fields[i].default_value is_null: if the field can be null or not, boolean. For Example: sys_fields[i].is_null is_primary_key: if the field is primary key, boolean. For Example: sys_fields[i].is_primary_key Predefined Functions: 1. print(str). Print the code without new line. 2. println(str). Print the code with new line. 3. getFieldList(). Return field list separated by ',' DB Connection Setting: Support db client plugin, Support MySql and ADO (Windows) for now. If you need other type db connection, please told me by EMail, we'll add it as soon as possible. Steps to config: 1. Select Database Type. Click next. 2. Input required information like host, port, username, password and database name depends on your database type. You can use the configuration wizard if you use ado db client. That's it! Hope it's useful for you. And hope it will decrease your time of copy & paste.