generate-form-by-table-structure's Introduction

generate-form-by-table-structure

According to the table structure to automatically generate the form

根据表结构自动生成表单，支持数据库有mysql、oracle

在开发复杂的业务系统经常遇到几十，上百个字段的表，或者一个模块涉及十多张表的时候，可以借助自动生成表单的方式，加快表单搭建速度！

Usage

npm install，如果oracledb不能正常安装，请参考>>nodejs链接oracle
修改oracle/dbconfig.js配置
运行node oracle/builder.js

生成表单在builder目录下，如mainForm.html文件是自动生成的angular表单模板

	<table class="dataTables" width="100%" id="main_form">
	    <thead>
	        <tr>
	            <th class="head center">ID</th>
	            <th class="head center">NAME</th>
	            <th class="head center">COUNTRYCODE</th>
	            <th class="head center">DISTRICT</th>
	            <th class="head center">POPULATION</th>
	        </tr>
	    </thead>
	    <tbody>
	        <tr ng-repeat=" curRow  in formObject.list">
	            <td>
	                <a ng-click="" class="text-tips" title="{{curRow.ID}}">
	                    <label ng-bind="curRow.ID"></label>
	                </a>
	            </td>
	            <td>
	                <a ng-click="" class="text-tips" title="{{curRow.NAME}}">
	                    <label ng-bind="curRow.NAME"></label>
	                </a>
	            </td>
	            <td>
	                <a ng-click="" class="text-tips" title="{{curRow.COUNTRYCODE}}">
	                    <label ng-bind="curRow.COUNTRYCODE"></label>
	                </a>
	            </td>
	            <td>
	                <a ng-click="" class="text-tips" title="{{curRow.DISTRICT}}">
	                    <label ng-bind="curRow.DISTRICT"></label>
	                </a>
	            </td>
	            <td>
	                <a ng-click="" class="text-tips" title="{{curRow.POPULATION}}">
	                    <label ng-bind="curRow.POPULATION"></label>
	                </a>
	            </td>
	        </tr>
	    </tbody>
	</table>