This action will force synchronization from tanghc/code-gen, which will overwrite any changes that you have made since you forked the repository, and can not be recovered!!!
Synchronous operation will process in the background and will refresh the page when finishing processing. Please be patient.
/*SQLyog Ultimate v11.33 (64 bit)MySQL - 5.1.71-community : Database - auto_code**********************************************************************//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`auto_code` /*!40100 DEFAULT CHARACTER SET utf8 */;USE `auto_code`;/*Table structure for table `back_user` */DROP TABLE IF EXISTS `back_user`;CREATE TABLE `back_user` (`username` varchar(20) NOT NULL COMMENT '用户名',`password` varchar(50) NOT NULL COMMENT '密码',`add_time` datetime NOT NULL COMMENT '添加时间',PRIMARY KEY (`username`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*Data for the table `back_user` */insert into `back_user`(`username`,`password`,`add_time`) values ('aaaa','123456','2015-01-05 11:52:26'),('admin','admin','2014-06-24 10:12:49');/*Table structure for table `datasource_config` */DROP TABLE IF EXISTS `datasource_config`;CREATE TABLE `datasource_config` (`dc_id` int(11) NOT NULL AUTO_INCREMENT,`driver_class` varchar(50) DEFAULT NULL COMMENT '数据库驱动',`db_name` varchar(50) DEFAULT NULL,`ip` varchar(50) DEFAULT NULL,`port` int(11) DEFAULT NULL,`username` varchar(50) DEFAULT NULL,`password` varchar(50) DEFAULT NULL,`back_user` varchar(20) DEFAULT NULL,PRIMARY KEY (`dc_id`)) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;/*Data for the table `datasource_config` */insert into `datasource_config`(`dc_id`,`driver_class`,`db_name`,`ip`,`port`,`username`,`password`,`back_user`) values (4,'com.mysql.jdbc.Driver','auto_code','localhost',3306,'root','root','admin'),(6,'com.mysql.jdbc.Driver','rms','localhost',3306,'root','root','admin'),(9,'com.mysql.jdbc.Driver','stu','localhost',3306,'root','root','admin'),(11,'com.mysql.jdbc.Driver','ymm','127.0.0.1',3306,'root','root','admin'),(12,'com.mysql.jdbc.Driver','vback','127.0.0.1',3306,'root','root','admin');/*Table structure for table `template_config` */DROP TABLE IF EXISTS `template_config`;CREATE TABLE `template_config` (`tc_id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) DEFAULT NULL,`save_path` varchar(100) DEFAULT NULL,`suffix` varchar(20) DEFAULT NULL,`file_name` varchar(50) DEFAULT NULL,`content` text,`back_user` varchar(20) DEFAULT NULL,PRIMARY KEY (`tc_id`),KEY `f_backuser` (`back_user`)) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='模板表';/*Data for the table `template_config` */insert into `template_config`(`tc_id`,`name`,`save_path`,`suffix`,`file_name`,`content`,`back_user`) values (8,'bui_Entity','entity','java','${context.javaBeanName}.java','package ${context.packageName}.entity;\n\n/**\n ${table.comment}\n*/\npublic class ${context.javaBeanName} {\n#foreach($column in $columns)\n // ${column.comment}\n private ${column.javaTypeBox} ${column.javaFieldName};\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}(${column.javaTypeBox} ${column.javaFieldName}){\n this.${column.javaFieldName} = ${column.javaFieldName};\n }\n\n public ${column.javaTypeBox} get${column.javaFieldNameUF}(){\n return this.${column.javaFieldName};\n }\n\n#end\n}','admin'),(9,'bui_DAO','dao','java','${context.javaBeanName}Dao.java','package ${context.packageName}.dao;\n\nimport org.durcframework.core.dao.BaseDao;\nimport ${context.packageName}.entity.${context.javaBeanName};\n\npublic interface ${context.javaBeanName}Dao extends BaseDao<${context.javaBeanName}> {\n}','admin'),(10,'bui_Service','service','java','${context.javaBeanName}Service.java','package ${context.packageName}.service;\n\nimport org.durcframework.core.service.CrudService;\nimport ${context.packageName}.dao.${context.javaBeanName}Dao;\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport org.springframework.stereotype.Service;\n\n@Service\npublic class ${context.javaBeanName}Service extends CrudService<${context.javaBeanName}, ${context.javaBeanName}Dao> {\n\n}','admin'),(11,'durc_SearchEntity','entity','java','${context.javaBeanName}Sch.java','package ${context.packageName}.entity;\n\nimport org.durcframework.core.SearchEntity;\nimport org.durcframework.core.expression.annotation.ValueField;\n\npublic class ${context.javaBeanName}Sch extends SearchEntity{\n\n#foreach($column in $columns) \n private ${column.javaTypeBox} ${column.javaFieldName}Sch;\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}Sch(${column.javaTypeBox} ${column.javaFieldName}Sch){\n this.${column.javaFieldName}Sch = ${column.javaFieldName}Sch;\n }\n\n @ValueField(column = \"${column.columnName}\")\n public ${column.javaTypeBox} get${column.javaFieldNameUF}Sch(){\n return this.${column.javaFieldName}Sch;\n }\n\n#end\n\n}','admin'),(12,'bui_Mybatis','mapper','xml','${context.javaBeanNameLF}Mapper.xml','#set($jq=\"$\")\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\" >\r\n<!-- \r\n This file is automatically generated by autoCode(https://git.oschina.net/durcframework/autoCode)\r\n-->\r\n<mapper namespace=\"${context.packageName}.dao.${context.javaBeanName}Dao\">\r\n <resultMap id=\"queryResultMap\" type=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n #foreach($column in $columns)\r\n #if( \"${column.comment}\" != \"\" )\r\n <!-- ${column.comment} -->\r\n #end\r\n <result column=\"${column.columnName}\" property=\"${column.javaFieldName}\" jdbcType=\"${column.mybatisJdbcType}\" />\r\n #end\r\n </resultMap>\r\n\r\n <!-- 聚合查询 -->\r\n <select id=\"findProjection\" parameterType=\"org.durcframework.core.expression.projection.ProjectionQuery\" resultType=\"java.util.HashMap\">\r\n SELECT\r\n <include refid=\"expressionBlock.projectionColumn\"/>\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\"/> \r\n <include refid=\"expressionBlock.groupBy\"/>\r\n <include refid=\"expressionBlock.having\"/>\r\n <if test=\"order != null\">\r\n ORDER BY ${jq}{order}\r\n </if>\r\n </select>\r\n\r\n <!-- 根据条件查询记录 -->\r\n <select id=\"find\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\"\r\n resultMap=\"queryResultMap\">\r\n SELECT \r\n <choose>\r\n <when test=\"columns.size>0\">\r\n <foreach collection=\"columns\" item=\"column\" separator=\",\" >\r\n ${jq}{column}\r\n </foreach>\r\n </when>\r\n <otherwise>\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n #set($i=$i +1) \r\n #end\r\n </otherwise>\r\n </choose>\r\n\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n <choose>\r\n <when test=\"order == null\">\r\n ORDER BY t.${context.pkName} desc\r\n </when>\r\n <otherwise>\r\n ORDER BY ${jq}{order}\r\n </otherwise>\r\n </choose>\r\n <if test=\"!isQueryAll\">\r\n LIMIT\r\n #{start,jdbcType=INTEGER},#{limit,jdbcType=INTEGER}\r\n </if>\r\n </select>\r\n\r\n <!-- 根据条件查询记录数 -->\r\n <select id=\"findTotalCount\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\"\r\n resultType=\"java.lang.Integer\">\r\n SELECT count(*) FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n </select>\r\n\r\n <!-- 保存,保存全部字段 -->\r\n <insert id=\"save\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\r\n#if(${pkColumn.isIdentity})\r\n keyProperty=\"${context.javaPkName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\r\n#end\r\n >\r\n INSERT INTO ${table.tableName}\r\n (\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n #if($i > 0),#end `${column.columnName}`\r\n#set($i=$i +1)\r\n #end \r\n #end\r\n )\r\n VALUES (\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n #if($i > 0),#end #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\r\n#set($i=$i +1)\r\n #end \r\n #end\r\n\r\n )\r\n </insert>\r\n\r\n <!-- 保存,保存不为NULL的字段 -->\r\n <insert id=\"saveNotNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\r\n #if(${pkColumn.isIdentity})\r\n keyProperty=\"${context.javaPkName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\r\n #end\r\n >\r\n INSERT INTO ${table.tableName}\r\n\r\n <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\"> \r\n\r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n <if test=\"${column.javaFieldName} != null\">\r\n `${column.columnName}`,\r\n </if>\r\n #end \r\n #end\r\n </trim>\r\n <trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\"> \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n <if test=\"${column.javaFieldName} != null\" >\r\n #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </trim>\r\n </insert>\r\n\r\n <!-- 更新,更新全部字段 -->\r\n <update id=\"update\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n UPDATE ${table.tableName}\r\n <set> \r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n #end \r\n #end\r\n </set> \r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </update>\r\n\r\n <!-- 根据指定条件更新 -->\r\n <update id=\"updateByExpression\">\r\n UPDATE ${table.tableName}\r\n <set> \r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n ${column.columnName}=#{entity.${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n #end \r\n #end\r\n </set>\r\n <include refid=\"expressionBlock.updateWhere\" />\r\n </update>\r\n\r\n <!-- 更新不为NULL的字段 -->\r\n <update id=\"updateNotNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n UPDATE ${table.tableName}\r\n <set>\r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n <if test=\"${column.javaFieldName} != null\" >\r\n ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </set>\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </update>\r\n\r\n <!-- 根据指定条件更新不为NULL的字段 -->\r\n <update id=\"updateNotNullByExpression\">\r\n UPDATE ${table.tableName}\r\n <set>\r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n <if test=\"entity.${column.javaFieldName} != null\" >\r\n ${column.columnName}=#{entity.${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </set>\r\n <include refid=\"expressionBlock.updateWhere\" />\r\n </update>\r\n\r\n <!-- 根据主键获取单条记录 -->\r\n <select id=\"get\" resultMap=\"queryResultMap\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n SELECT \r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n#set($i=$i +1) \r\n #end\r\n FROM ${table.tableName} t\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </select>\r\n\r\n <!-- 根据条件获取单条记录 -->\r\n <select id=\"getByExpression\" resultMap=\"queryResultMap\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\">\r\n SELECT\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n #set($i=$i +1) \r\n #end\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n </select>\r\n\r\n <!-- 根据主键删除记录 -->\r\n <delete id=\"del\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n DELETE FROM ${table.tableName}\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </delete> \r\n\r\n <!-- 根据条件删除记录 -->\r\n <delete id=\"delByExpression\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\">\r\n DELETE FROM ${table.tableName}\r\n <include refid=\"expressionBlock.where\" />\r\n </delete>\r\n\r\n</mapper>','admin'),(14,'bui_Controller','controller','java','${context.javaBeanName}Controller.java','package ${context.packageName}.controller;\n\nimport org.durcframework.core.GridResult;\nimport org.durcframework.core.MessageResult;\nimport org.durcframework.core.controller.CrudController;\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport ${context.packageName}.entity.${context.javaBeanName}Sch;\nimport ${context.packageName}.service.${context.javaBeanName}Service;\nimport org.springframework.stereotype.Controller;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.ResponseBody;\n\n@Controller\npublic class ${context.javaBeanName}Controller extends\n CrudController<${context.javaBeanName}, ${context.javaBeanName}Service> {\n\n @RequestMapping(\"/add${context.javaBeanName}.do\")\n public ModelAndView add${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.add(entity);\n }\n\n @RequestMapping(\"/list${context.javaBeanName}.do\")\n public ModelAndView list${context.javaBeanName}(${context.javaBeanName}Sch searchEntity) {\n return this.list(searchEntity);\n }\n\n @RequestMapping(\"/update${context.javaBeanName}.do\")\n public ModelAndView update${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.modify(entity);\n }\n\n @RequestMapping(\"/del${context.javaBeanName}.do\")\n public ModelAndView del${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.remove(entity);\n }\n\n}','admin'),(15,'sw-mybatis-sqlserver','${context.javaBeanNameLF}/mapper','xml','${context.javaBeanNameLF}Mapper.xml','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\" >\n<mapper namespace=\"${context.packageName}.${context.javaBeanNameLF}.dao.${context.javaBeanName}Dao\">\n<resultMap id=\"BaseResultMap\" type=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\">\n#foreach($column in $columns)\n <result column=\"${column.columnName}\" property=\"${column.javaFieldName}\" jdbcType=\"${column.mybatisJdbcType}\"/>\n#end \n</resultMap>\n <select id=\"query\" resultMap=\"BaseResultMap\" parameterType=\"com.shunwang.business.framework.mybatis.query.ConditionQuery\" >\n <if test=\"paramMap.rp>0\">\n SELECT t0.* FROM (\n </if>\n select row_number() over(order by\n <choose>\n <when test=\"paramMap.orderCol!=null\">\n ${paramMap.orderCol}\n </when>\n <otherwise>\n ${context.pkName} desc\n </otherwise>\n </choose>\n ) row\n\n #foreach($column in $columns) \n ,${column.columnName} \n #end\n from ${table.tableName} t \n <include refid=\"conditionQuery.core\" />\n <if test=\"paramMap.rp > 0\">\n ) t0 WHERE t0.row BETWEEN (#{paramMap.firstResult} +1) AND\n (#{paramMap.firstResult} + #{paramMap.rp})\n </if>\n </select>\n <select id=\"get\" resultMap=\"BaseResultMap\" parameterType=\"java.lang.Integer\" >\n SELECT \n#set ($i=0) \n #foreach($column in $columns) \n #if($i > 0),#end \n ${column.columnName}\n #set($i=$i +1) \n #end\n FROM ${table.tableName}\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </select>\n <delete id=\"delete\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\" >\n DELETE FROM ${table.tableName}\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </delete>\n <insert id=\"save\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\" useGeneratedKeys=\"true\" keyProperty=\"${context.javaPkName}\">\n INSERT INTO ${table.tableName}\n (\n #set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n #if($i > 0),#end ${column.columnName}\n #set($i=$i +1)\n #end \n #end\n )\n VALUES (\n #set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n #if($i > 0),#end #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\n #set($i=$i +1)\n #end \n #end\n\n )\n </insert>\n <select id=\"queryCnt\" parameterType=\"com.shunwang.business.framework.mybatis.query.ConditionQuery\" resultType=\"java.lang.Integer\" >\n select count(*) from ${table.tableName} t\n <include refid=\"conditionQuery.core\" />\n </select>\n\n <update id=\"update\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\">\n UPDATE ${table.tableName}\n SET \n#set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isPk}) \n #if($i > 0),#end ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\n #set($i=$i +1)\n #end \n #end \n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </update>\n</mapper>','admin'),(16,'sw-pojo','${context.javaBeanNameLF}/pojo','java','${context.javaBeanName}.java','package ${context.packageName}.${context.javaBeanNameLF}.pojo;\n\nimport com.shunwang.business.framework.pojo.BasePojo;\n\npublic class ${context.javaBeanName} extends BasePojo {\n#foreach($column in $columns) \n private ${column.javaTypeBox} ${column.javaFieldName};\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}(${column.javaTypeBox} ${column.javaFieldName}){\n this.${column.javaFieldName} = ${column.javaFieldName};\n }\n\n public ${column.javaTypeBox} get${column.javaFieldNameUF}(){\n return this.${column.javaFieldName};\n }\n\n#end\n}','admin'),(17,'sw-dao','${context.javaBeanNameLF}/dao','java','${context.javaBeanName}Dao.java','package ${context.packageName}.${context.javaBeanNameLF}.dao;\n\nimport com.shunwang.business.framework.dao.CrudDao;\nimport ${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName};\n\npublic interface ${context.javaBeanName}Dao extends CrudDao<${context.javaBeanName}> {\n}','admin'),(18,'sw-bo','${context.javaBeanNameLF}/bo','java','${context.javaBeanName}Bo.java','package ${context.packageName}.${context.javaBeanNameLF}.bo;\n\nimport org.springframework.stereotype.Service;\n\nimport com.shunwang.business.framework.bo.CrudBo;\nimport ${context.packageName}.${context.javaBeanNameLF}.dao.${context.javaBeanName}Dao;\nimport ${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName};\n\n@Service\npublic class ${context.javaBeanName}Bo extends CrudBo<${context.javaBeanName}, ${context.javaBeanName}Dao> {\n\n}','admin'),(19,'durc_jspEasyUICRUD','jsp','jsp','${context.javaBeanNameLF}.jsp','<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n<title>后台管理</title>\n<%@ include file=\"easyui_lib.jsp\" %>\n</head>\n<body>\n\n <div class=\"easyui-panel search-panel\">\n <form id=\"schForm\">\n <table>\n <tr>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <td class=\"fm_lab\">${column.javaFieldName}:</td><td><input name=\"${column.javaFieldName}Sch\" type=\"text\"></td> \n #end\n#end\n<td><a id=\"schBtn\" class=\"easyui-linkbutton\" iconCls=\"icon-search\">查询</a></td>\n </tr>\n </table>\n </form>\n </div>\n\n <div id=\"toolbar\">\n <a id=\"addBtn\" class=\"easyui-linkbutton\" iconCls=\"icon-add\" plain=\"true\">添加</a>\n </div>\n\n <table id=\"dg\"></table>\n\n <div id=\"dlg\" class=\"easyui-dialog\" style=\"width:320px;height:280px;padding:10px 20px\"\n closed=\"true\" modal=\"true\" buttons=\"#dlg-buttons\">\n <form id=\"fm\" method=\"post\">\n <table class=\"insert-tab\">\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <tr>\n <td class=\"fm_lab\">${column.javaFieldName}:</td><td><input name=\"${column.javaFieldName}\" type=\"text\" class=\"easyui-validatebox\" required=\"true\"></td>\n </tr>\n #end\n#end\n </table>\n </form>\n </div>\n <div id=\"dlg-buttons\">\n <a id=\"saveBtn\" class=\"easyui-linkbutton\" iconCls=\"icon-ok\">保存</a>\n <a id=\"cancelBtn\" class=\"easyui-linkbutton\" iconCls=\"icon-cancel\">取消</a>\n </div>\n\n<script type=\"text/javascript\">\n#set($jq=\"$\") \n(function(){\nvar that = this;\n\nvar pk = \'${context.javaPkName}\'; // java类中的主键字段\nvar listUrl = ctx + \'list${context.javaBeanName}.do\'; // 查询\nvar addUrl = ctx + \'add${context.javaBeanName}.do\'; // 添加\nvar updateUrl = ctx + \'update${context.javaBeanName}.do\'; // 修改\nvar delUrl = ctx + \'del${context.javaBeanName}.do\'; // 删除\nvar submitUrl = \'\'; // 提交URL\n\nvar toolbarId = \'toolbar\'; // 工具条ID\n\nvar ${jq}dialog = ${jq}(\'#dlg\'); // 窗口\nvar ${jq}form = ${jq}(\'#fm\'); // 表单\nvar ${jq}grid = ${jq}(\'#dg\'); // 表格\nvar ${jq}schForm = ${jq}(\'#schForm\'); // 查询表单\n\nvar ${jq}schBtn = ${jq}(\'#schBtn\'); // 查询按钮\nvar ${jq}saveBtn = ${jq}(\'#saveBtn\'); // 保存按钮\nvar ${jq}cancelBtn = ${jq}(\'#cancelBtn\'); // 取消按钮\nvar ${jq}addBtn = ${jq}(\'#addBtn\'); // 添加按钮\n\n// 初始化表格\n${jq}grid.datagrid({ \n url:listUrl\n ,columns:[[\n#set($i=0)\n#foreach($column in $columns)\n #if($i>0),#end\n #if(!${column.isIdentityPk})\n {field:\'${column.javaFieldName}\',title:\'${column.javaFieldName}\'}\n #set($i=$i+1)\n #end \n#end \n ,{field:\'_btn1\',title:\'操作\',align:\'center\',formatter:function(val,row){\n return \'<a href=\"#\" onclick=\"\'+FunUtil.createFun(that,\'edit\',row)+\' return false;\">修改</a>\'\n + \'<span class=\"opt-split\">|</span>\'\n + \'<a href=\"#\" onclick=\"\'+FunUtil.createFun(that,\'del\',row)+\' return false;\">删除</a>\'\n }}\n ]]\n ,toolbar:\'#\' + toolbarId\n ,pagination:true\n ,fitColumns:true\n ,singleSelect:true\n ,striped:true\n ,pageSize:20\n});\n\n// 初始化事件\n${jq}addBtn.click(function(){\n ${jq}dialog.dialog(\'open\').dialog(\'setTitle\',\'添加\');\n ${jq}form.trigger(\'reset\');\n submitUrl = addUrl;\n});\n\n${jq}schBtn.click(function(){\n var data = getFormData(${jq}schForm);\n ${jq}grid.datagrid(\'load\',data);\n});\n\n${jq}saveBtn.click(function(){\n save();\n});\n\n${jq}cancelBtn.click(function(){\n ${jq}dialog.dialog(\'close\');\n});\n\n\n// 编辑\nthis.edit = function(row){\n if (row){\n ${jq}dialog.dialog(\'open\').dialog(\'setTitle\',\'修改\');\n ${jq}form.form(\'clear\').form(\'load\',row);\n\n submitUrl = updateUrl + [\'?\',pk,\'=\',row[pk]].join(\'\');\n }\n}\n\n// 保存\nthis.save = function(){\n var self = this;\n ${jq}form.form(\'submit\',{\n url: submitUrl,\n onSubmit: function(){\n return ${jq}(this).form(\'validate\');\n },\n success: function(resultTxt){\n var result = ${jq}.parseJSON(resultTxt);\n Action.execResult(result,function(result){\n ${jq}dialog.dialog(\'close\');// close the dialog\n ${jq}grid.datagrid(\'reload\');\n });\n }\n });\n}\n\n// 删除\nthis.del = function(row){\n if(row){\n ${jq}.messager.confirm(\'确认\',\'确定要删除该数据吗?\',function(r){\n if (r){\n Action.post(delUrl,row,function(result){\n Action.execResult(result,function(result){\n ${jq}grid.datagrid(\'reload\');\n });\n });\n }\n });\n }\n}\n\n})();\n</script>\n</body>\n</html>','admin'),(20,'sw-mybatis-mysql','${context.javaBeanNameLF}/mapper','xml','${context.javaBeanNameLF}Mapper.xml','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\" >\n<mapper namespace=\"${context.packageName}.${context.javaBeanNameLF}.dao.${context.javaBeanName}Dao\">\n<resultMap id=\"BaseResultMap\" type=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\">\n#foreach($column in $columns)\n <result property=\"${column.javaFieldName}\" column=\"${column.columnName}\" jdbcType=\"${column.mybatisJdbcType}\"/>\n#end \n</resultMap>\n <select id=\"query\" resultMap=\"BaseResultMap\" parameterType=\"com.shunwang.business.framework.mybatis.query.ConditionQuery\" >\n SELECT *\n FROM ${table.tableName} t\n <include refid=\"conditionQuery.core\" />\n <choose>\n <when test=\"paramMap.orderCol!=null\">\n ORDER BY ${paramMap.orderCol}\n </when>\n <otherwise>\n ORDER BY ${context.pkName} desc\n </otherwise>\n </choose>\n <if test=\"paramMap.rp>0\">\n LIMIT #{paramMap.firstResult},#{paramMap.rp}\n </if>\n </select>\n\n <select id=\"get\" resultMap=\"BaseResultMap\" parameterType=\"java.lang.Integer\" >\n SELECT \n#set ($i=0) \n #foreach($column in $columns) \n #if($i > 0),#end \n ${column.columnName}\n #set($i=$i+ 1) \n #end\n FROM ${table.tableName}\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </select>\n <delete id=\"delete\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\" >\n DELETE FROM ${table.tableName}\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </delete>\n <insert id=\"save\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\" useGeneratedKeys=\"true\" keyProperty=\"${context.javaPkName}\">\n INSERT INTO ${table.tableName}\n (\n #set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n #if($i > 0),#end ${column.columnName}\n #set($i=$i +1)\n #end \n #end\n )\n VALUES (\n #set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n #if($i > 0),#end #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\n #set($i=$i +1)\n #end \n #end\n\n )\n </insert>\n <select id=\"queryCnt\" parameterType=\"com.shunwang.business.framework.mybatis.query.ConditionQuery\" resultType=\"java.lang.Integer\" >\n select count(*) from ${table.tableName} t\n <include refid=\"conditionQuery.core\" />\n </select>\n\n <update id=\"update\" parameterType=\"${context.packageName}.${context.javaBeanNameLF}.pojo.${context.javaBeanName}\">\n UPDATE ${table.tableName}\n SET \n#set ($i=0) \n #foreach($column in $columns) \n #if(!${column.isPk}) \n #if($i > 0),#end ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\n #set($i=$i +1)\n #end \n #end \n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\n </update>\n</mapper>','admin'),(23,'durc-jspFduiCRUD','jsp',NULL,'${context.javaBeanNameLF}.jsp','<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"../taglib.jsp\" %>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html>\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n<title>增删改查</title>\n</head>\n<body>\n<div class=\"search-wrap\">\n <div class=\"search-content\">\n <table class=\"search-tab\">\n <tr>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <th>${column.javaFieldName}:</th><td id=\"txt-${column.javaFieldName}Sch\"></td> \n #end\n#end\n <td>\n <div id=\"btnSch\"></div>\n </td>\n </tr>\n </table>\n </div>\n </div>\n <div class=\"result-wrap\">\n <div class=\"result-title\">\n <div class=\"result-list\">\n <a id=\"addNew\" href=\"javascript:void(0)\"><i class=\"icon-font\"></i>新增</a>\n </div>\n </div>\n <div class=\"result-content\">\n <div id=\"grid\"></div>\n </div>\n </div>\n\n <div id=\"crudWin\" style=\"display: none;\">\n <table class=\"insert-tab\" width=\"100%\">\n <caption id=\"formMsg\"></caption>\n <tbody>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <tr>\n <th>${column.javaFieldName}:</th><td id=\"txt-${column.javaFieldName}\"></td>\n </tr>\n #end\n#end\n </tbody>\n </table>\n </div>\n\n<script type=\"text/javascript\">\n(function(){\n\nvar schPanel;\nvar grid;\nvar formPanel;\nvar crudWin;\n\nvar pk = \'${context.javaPkName}\'; // java类中的主键字段\nvar listUrl = ctx + \'list${context.javaBeanName}.do\'; // 查询\nvar addUrl = ctx + \'add${context.javaBeanName}.do\'; // 添加\nvar updateUrl = ctx + \'update${context.javaBeanName}.do\'; // 修改\nvar delUrl = ctx + \'del${context.javaBeanName}.do\'; // 删除\n\nschPanel = new FDFormPanel({\n controls:[\n#set($i=0)\n#foreach($column in $columns) \n #if(!${column.isIdentityPk})\n #if($i>0),#end new FDTextBox({domId:\'txt-${column.javaFieldName}Sch\',name:\'${column.javaFieldName}Sch\'}) \n #set($i=$i+1) \n #end\n#end\n ]\n});\n\nnew FDButton({domId:\'btnSch\',text:\'查询\',onclick:function(){\n search();\n}});\n\ngrid = new FDGrid({\n domId:\'grid\'\n ,url:listUrl\n ,columns:[\n#set($i=0)\n#foreach($column in $columns)\n #if(!${column.isIdentityPk}) \n #if($i>0),#end {text:\'${column.javaFieldName}\',name:\'${column.javaFieldName}\'}\n #set($i=$i+1)\n #end \n#end \n ]\n ,actionButtons:[\n {text:\'修改\',onclick:update}\n ,{text:\'删除\',onclick:del}\n ]\n});\n\ncrudWin = new FDWindow({\n contentId:\'crudWin\'\n ,buttons:[\n {text:\'保存\',onclick:function(){\n formPanel.save();\n }}\n ,{text:\'取消\',onclick:function(){\n crudWin.hide();\n }}\n ]\n});\n\nformPanel = new FDFormPanel({\n grid:grid\n ,win:crudWin\n // 服务器端的请求\n ,crudUrl:{\n add: addUrl\n ,update: updateUrl\n ,del: delUrl\n }\n ,controls:[\n new FDHidden({name:pk,defaultValue:0})\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n ,new FDTextBox({domId:\'txt-${column.javaFieldName}\',name:\'${column.javaFieldName}\',msgId:\'formMsg\',width:200\n ,validates:[\n {rule:{notNull:true},successClass:\'green\',errorClass:\'require-red\',errorMsg:\'${column.javaFieldName}不能为空\'}\n ]\n })\n #end\n#end\n ]\n});\n\n$(\'#addNew\').click(function(){\n add();\n});\n\nfunction add() {\n formPanel.add();\n}\n\nfunction update(rowData,rowIndex) {\n formPanel.update(rowData);\n}\n\n\nfunction del(row,rowIndex) {\n formPanel.del(row);\n}\n\nfunction search() {\n grid.search(schPanel.getData());\n}\n\n})();\n</script>\n</body>\n</html>','admin'),(24,'durc-bootstrap-ajax','jsp',NULL,'${context.javaBeanNameLF}.jsp','##请编辑velocity模板\n#set($jq=\"$\")\n<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"taglib.jsp\" %>\n<c:set var=\"bluenile\" value=\"${jq}{res}bluenile/\"/>\n<c:set var=\"bsgrid\" value=\"${jq}{res}bsgrid/\"/>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html lang=\"en\">\n <head>\n <meta charset=\"utf-8\">\n <title>后台管理</title>\n <meta content=\"IE=edge,chrome=1\" http-equiv=\"X-UA-Compatible\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <script type=\"text/javascript\">var ctx = \'${ctx}\';</script>\n <link rel=\"stylesheet\" type=\"text/css\" href=\"${jq}{bluenile}lib/bootstrap/css/bootstrap.min.css\">\n <link rel=\"stylesheet\" type=\"text/css\" href=\"${jq}{bluenile}stylesheets/theme.css\">\n <link rel=\"stylesheet\" href=\"${jq}{bluenile}lib/font-awesome/css/font-awesome.css\">\n <script src=\"${jq}{bluenile}lib/jquery-1.7.2.min.js\" type=\"text/javascript\"></script>\n <script src=\"${jq}{res}js/common.js\" type=\"text/javascript\"></script>\n <!-- datepicker -->\n <script src=\"${jq}{res}My97DatePicker/WdatePicker.js\" type=\"text/javascript\"></script>\n <!-- validate -->\n <script src=\"${jq}{res}jqueryValidate/jquery.validate.min.js\" type=\"text/javascript\"></script>\n <script src=\"${jq}{res}jqueryValidate/localization/messages_zh.min.js\" type=\"text/javascript\"></script>\n <!-- dialog -->\n <link rel=\"stylesheet\" href=\"${jq}{res}artDialog/css/ui-dialog.css\">\n <script src=\"${jq}{res}artDialog/dist/dialog-plus-min.js\"></script>\n <!-- bsgrid -->\n <link rel=\"stylesheet\" href=\"${jq}{bsgrid}merged/bsgrid.all.min.css\"/>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}js/lang/grid.zh-CN.min.js\"></script>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}merged/bsgrid.all.min.js\"></script>\n\n <!--[if lt IE 9]>\n <script type=\"text/javascript\" src=\"${jq}{bluenile}lib/bootstrap/js/respond.min.js\"></script>\n <![endif]-->\n <!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->\n <!--[if lt IE 9]>\n <script src=\"${jq}{bluenile}lib/html5.js\"></script>\n <![endif]-->\n </head>\n\n <!--[if lt IE 7 ]> <body class=\"ie ie6\"> <![endif]-->\n <!--[if IE 7 ]> <body class=\"ie ie7 \"> <![endif]-->\n <!--[if IE 8 ]> <body class=\"ie ie8 \"> <![endif]-->\n <!--[if IE 9 ]> <body class=\"ie ie9 \"> <![endif]-->\n <!--[if (gt IE 9)|!(IE)]><!--> \n <body class=\"\"> \n <!--<![endif]-->\n <div class=\"navbar\">\n <div class=\"navbar-inner\">\n <ul class=\"nav pull-right\">\n <li><a href=\"#\" class=\"hidden-phone visible-tablet visible-desktop\">设置</a></li>\n <li id=\"fat-menu\" class=\"dropdown\">\n <a href=\"#\" role=\"button\" class=\"dropdown-toggle\" data-toggle=\"dropdown\">\n <i class=\"icon-user\"></i> admin\n <i class=\"icon-caret-down\"></i>\n </a>\n <ul class=\"dropdown-menu\">\n <li><a href=\"#\">我的账号</a></li>\n <li class=\"divider\"></li>\n <li><a href=\"#\">退出</a></li>\n </ul>\n </li>\n </ul>\n <a class=\"brand\" href=\"#\"><span class=\"first\">后台管理</span></a>\n </div>\n </div>\n\n <div class=\"sidebar-nav\">\n <a href=\"#dashboard-menu\" class=\"nav-header\" data-toggle=\"collapse\"><i class=\"icon-dashboard\"></i>基础管理</a>\n <ul id=\"dashboard-menu\" class=\"nav nav-list collapse in\">\n <li class=\"active\"><a href=\"orderInfo_bootstrap_ajax.jsp\">订单管理</a></li>\n\n </ul>\n </div>\n\n <div class=\"content\">\n <div class=\"header\">\n <span class=\"page-title\">订单管理</span>\n </div>\n\n <div class=\"container-fluid\">\n <div class=\"row-fluid\">\n <div style=\"padding-top: 20px;\">\n <!-- content here -->\n <form id=\"schFrm\" class=\"form-inline\" onsubmit=\"return false;\">\n <table>\n <tr>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <td>${column.javaFieldName}:</td><td><input name=\"${column.javaFieldName}Sch\" type=\"text\"></td> \n #end\n#end\n </tr>\n </table>\n <button id=\"schBtn\" class=\"btn\"><i class=\"icon-search\"></i>查询</button>\n <input type=\"reset\" class=\"btn\" value=\"清空\">\n </form>\n <hr>\n <div class=\"btn-toolbar\">\n <button id=\"addBtn\" class=\"btn btn-primary\"><i class=\"icon-plus\"></i> 新增订单</button>\n <div class=\"btn-group\">\n </div>\n </div>\n <table id=\"searchTable\">\n <tr> \n#foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n <th w_index=\"${column.javaFieldName}\">${column.javaFieldName}</th>\n #end \n#end \n<th w_render=\"operate\" width=\"10%;\">操作</th>\n </tr>\n </table>\n\n <div id=\"crudWin\">\n <form id=\"crudFrm\">\n <table>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <tr>\n <td>${column.javaFieldName}:</td><td><input name=\"${column.javaFieldName}\" type=\"text\" required=\"true\"></td>\n </tr>\n #end\n#end\n </table>\n </form>\n </div>\n\n<script type=\"text/javascript\"> \nvar that = this;\n\nvar pk = \'${context.javaPkName}\'; // java类中的主键字段\nvar listUrl = ctx + \'list${context.javaBeanName}.do\'; // 查询\nvar addUrl = ctx + \'add${context.javaBeanName}.do\'; // 添加\nvar updateUrl = ctx + \'update${context.javaBeanName}.do\'; // 修改\nvar delUrl = ctx + \'del${context.javaBeanName}.do\'; // 删除\nvar submitUrl = \'\'; // 提交URL\n\nvar gridObj; // 表格\nvar crudWin; // 窗口\nvar ${jq}schFrm = ${jq}(\'#schFrm\'); // 查询表单\nvar ${jq}crudFrm = ${jq}(\'#crudFrm\'); // 编辑表单\n\nvar ${jq}schBtn = ${jq}(\'#schBtn\'); // 查询按钮\nvar ${jq}addBtn = ${jq}(\'#addBtn\'); // 添加按钮\n\nvar validator; // 验证器\n\nfunction reset() {\n ${jq}crudFrm.get(0).reset();\n validator.resetForm();\n}\n\n\n// 初始化事件\n${jq}addBtn.click(function() {\n reset();\n crudWin.title(\'添加\');\n crudWin.show();\n submitUrl = addUrl;\n});\n\n${jq}schBtn.click(function() {\n search();\n});\n\ngridObj = ${jq}.fn.bsgrid.init(\'searchTable\', {\n url: listUrl\n ,pageSizeSelect: true\n ,stripeRows: true\n ,rowHoverColor: true\n ,rowSelectedColor: false\n ,pageSize: 10\n});\n\ncrudWin = dialog({\n title: \'编辑\',\n width:400,\n content: document.getElementById(\'crudWin\'),\n okValue: \'保存\',\n ok: function () {\n that.save();\n return false;\n },\n cancelValue: \'取消\',\n cancel: function () {\n this.close();\n return false;\n }\n});\n\nfunction search(){\n gridObj.options.otherParames = getFormData(${jq}schFrm);\n gridObj.gotoPage(1);\n}\n\nfunction operate(row, rowIndex, colIndex, options) {\n return \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'edit\', row)\n + \' return false;\">修改</a>\'\n + \' \'\n + \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'del\', row)\n + \' return false;\">删除</a>\';\n}\n\n// 保存\nthis.save = function() {\n var self = this;\n var data = getFormData(${jq}crudFrm);\n var validateVal = validator.form();\n if(validateVal) {\n Action.post(submitUrl, data, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n crudWin.close();\n });\n });\n }\n}\n // 编辑\nthis.edit = function(row) {\n if (row) {\n reset();\n crudWin.title(\'修改\');\n loadFormData(${jq}crudFrm,row);\n submitUrl = updateUrl + \'?\' + pk + \'=\' + row[pk];\n crudWin.show();\n }\n}\n\n// 删除\nthis.del = function(row) {\n if (row) {\n var d = dialog({\n title: \'提示\',\n width: 200,\n content: \'确定要删除该记录吗?\',\n okValue: \'确定\',\n ok: function () {\n Action.post(delUrl, row, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n });\n });\n },\n cancelValue: \'取消\',\n cancel: function () {}\n });\n d.showModal();\n }\n}\n\nvalidator = ${jq}crudFrm.validate();\n</script>\n <footer>\n <hr>\n <p>© 2016</p>\n </footer>\n </div>\n </div>\n </div>\n </div>\n\n <script src=\"${jq}{bluenile}lib/bootstrap/js/bootstrap.min.js\"></script>\n </body>\n</html>\n','admin'),(25,'durc_SearchEntityBs','entity',NULL,'${context.javaBeanName}Sch.java','package ${context.packageName}.entity;\n\nimport org.durcframework.core.SearchEntity;\nimport org.durcframework.core.expression.annotation.ValueField;\n\nimport org.durcframework.core.support.BsgridSearch;\n\npublic class ${context.javaBeanName}Sch extends BsgridSearch {\n\n#foreach($column in $columns) \n private ${column.javaTypeBox} ${column.javaFieldName}Sch;\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}Sch(${column.javaTypeBox} ${column.javaFieldName}Sch){\n this.${column.javaFieldName}Sch = ${column.javaFieldName}Sch;\n }\n\n @ValueField(column = \"${column.columnName}\")\n public ${column.javaTypeBox} get${column.javaFieldNameUF}Sch(){\n return this.${column.javaFieldName}Sch;\n }\n\n#end\n\n}','admin'),(27,'durc_ControllerBs','controller',NULL,'${context.javaBeanName}Controller','package ${context.packageName}.controller;\n\nimport org.durcframework.core.support.BsgridController;\nimport org.springframework.stereotype.Controller;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.servlet.ModelAndView;\n\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport ${context.packageName}.entity.${context.javaBeanName}Sch;\nimport ${context.packageName}.service.${context.javaBeanName}Service;\n\n\n@Controller\npublic class ${context.javaBeanName}Controller extends\n BsgridController<${context.javaBeanName}, ${context.javaBeanName}Service> {\n\n @RequestMapping(\"/add${context.javaBeanName}.do\")\n public ModelAndView add${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.add(entity);\n }\n\n @RequestMapping(\"/list${context.javaBeanName}.do\")\n public ModelAndView list${context.javaBeanName}(${context.javaBeanName}Sch searchEntity) {\n return this.list(searchEntity);\n }\n\n @RequestMapping(\"/update${context.javaBeanName}.do\")\n public ModelAndView update${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.modify(entity);\n }\n\n @RequestMapping(\"/del${context.javaBeanName}.do\")\n public ModelAndView del${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.remove(entity);\n }\n\n}\n','admin'),(28,'durc-jsp-flatlab','jsp',NULL,'${context.javaBeanNameLF}.jsp','##请编辑velocity模板\n#set($jq=\"$\")\n<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"taglib.jsp\" %>\n<c:set var=\"flatlab\" value=\"${jq}{res}flatlab/\"/>\n<c:set var=\"bsgrid\" value=\"${jq}{res}bsgrid/\"/>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html lang=\"en\">\n <head>\n <meta charset=\"utf-8\">\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n <link rel=\"shortcut icon\" href=\"${jq}{flatlab}img/favicon.png\">\n <title>后台管理</title>\n <script type=\"text/javascript\">var ctx = \'${jq}{ctx}\';</script>\n <!-- Bootstrap core CSS -->\n <link href=\"${jq}{flatlab}css/bootstrap.min.css\" rel=\"stylesheet\">\n <link href=\"${jq}{flatlab}css/bootstrap-reset.css\" rel=\"stylesheet\">\n <!--external css-->\n <link href=\"${jq}{flatlab}assets/font-awesome/css/font-awesome.css\" rel=\"stylesheet\" />\n <!-- Custom styles for this template -->\n <link href=\"${jq}{flatlab}css/style.css\" rel=\"stylesheet\">\n <link href=\"${jq}{flatlab}css/style-responsive.css\" rel=\"stylesheet\" />\n <!-- HTML5 shim and Respond.js IE8 support of HTML5 tooltipss and media queries -->\n <!--[if lt IE 9]>\n <script src=\"${jq}{flatlab}js/html5shiv.js\"></script>\n <script src=\"${jq}{flatlab}js/respond.min.js\"></script>\n <![endif]-->\n <script src=\"${jq}{flatlab}js/jquery.js\"></script>\n\n <script src=\"${jq}{res}js/common.js\" type=\"text/javascript\"></script>\n <!-- datepicker -->\n <script src=\"${jq}{res}My97DatePicker/WdatePicker.js\" type=\"text/javascript\"></script>\n <!-- validate -->\n <script src=\"${jq}{res}jqueryValidate/jquery.validate.min.js\" type=\"text/javascript\"></script>\n <script src=\"${jq}{res}jqueryValidate/localization/messages_zh.min.js\" type=\"text/javascript\"></script>\n <!-- dialog -->\n <link rel=\"stylesheet\" href=\"${jq}{res}artDialog/css/ui-dialog.css\">\n <script src=\"${jq}{res}artDialog/dist/dialog-plus-min.js\"></script>\n <!-- bsgrid -->\n <link rel=\"stylesheet\" href=\"${jq}{bsgrid}merged/bsgrid.all.min.css\"/>\n <link rel=\"stylesheet\" href=\"${jq}{bsgrid}css/skins/grid_flexigrid.min.css\"/>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}js/lang/grid.zh-CN.min.js\"></script>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}merged/bsgrid.all.min.js\"></script>\n </head>\n\n <body>\n\n <section id=\"container\" class=\"\">\n <!--header start-->\n <header class=\"header dark-bg\">\n <div class=\"sidebar-toggle-box\">\n <div data-original-title=\"显示/隐藏菜单\" data-placement=\"right\" class=\"fa fa-bars tooltips\"></div>\n </div>\n <!--logo start-->\n <a href=\"#\" class=\"logo\" >后台<span>管理</span></a>\n <!--logo end-->\n <div class=\"top-nav \">\n <ul class=\"nav pull-right top-menu\">\n <!-- user login dropdown start-->\n <li class=\"dropdown\">\n <a data-toggle=\"dropdown\" class=\"dropdown-toggle\" href=\"#\">\n <span class=\"username\">admin</span>\n <b class=\"caret\"></b>\n </a>\n <ul class=\"dropdown-menu extended logout\">\n <div class=\"log-arrow-up\"></div>\n <li><a href=\"#\"><i class=\"fa fa-cog\"></i> 修改密码</a></li>\n <li><a href=\"#\"><i class=\"fa fa-key\"></i> 退出</a></li>\n </ul>\n </li>\n <!-- user login dropdown end -->\n </ul>\n </div>\n </header>\n <!--header end-->\n <!--sidebar start-->\n <aside>\n <div id=\"sidebar\" class=\"nav-collapse \">\n <!-- sidebar menu start-->\n <ul class=\"sidebar-menu\" id=\"nav-accordion\">\n <li>\n <a href=\"#\">\n <i class=\"fa fa-dashboard\"></i>\n <span>首页</span>\n </a>\n </li>\n <li class=\"sub-menu\">\n <a href=\"javascript:;\" class=\"active\">\n <i class=\"fa fa-laptop\"></i>\n <span>基础管理</span>\n </a>\n <ul class=\"sub\" >\n <li class=\"active\"><a href=\"${ctx}orderInfo.jsp\">订单管理</a></li>\n </ul>\n </li>\n\n </ul>\n <!-- sidebar menu end-->\n </div>\n </aside>\n <!--sidebar end-->\n <!--main content start-->\n <section id=\"main-content\">\n <section class=\"wrapper site-min-height\">\n <!-- page start-->\n <div class=\"row\">\n <div class=\"col-lg-12\">\n <div class=\"border-head\">\n <h3>订单管理</h3>\n </div>\n </div>\n </div>\n <div class=\"row\">\n <div class=\"col-lg-12\">\n <section class=\"panel\">\n <div class=\"panel-body\">\n <form id=\"schFrm\" class=\"form-inline\" onsubmit=\"return false;\"> \n #foreach($column in $columns)\n #if(!${column.isIdentityPk})\n ${column.javaFieldName}:<input name=\"${column.javaFieldName}Sch\" type=\"text\" class=\"form-control\"> \n #end\n #end\n <button id=\"schBtn\" class=\"btn btn-primary\"><i class=\"icon-search\"></i>查询</button>\n <input type=\"reset\" class=\"btn\" value=\"清空\">\n </form>\n </div>\n </section>\n <section class=\"panel\">\n <div class=\"panel-body\">\n <div class=\"btn-group\">\n <a id=\"addBtn\" class=\"btn btn-primary\">\n <i class=\"fa fa-plus\"></i> 新增订单 \n </a>\n </div>\n <hr>\n <table id=\"searchTable\">\n <tr> \n#foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n <th w_index=\"${column.javaFieldName}\">${column.javaFieldName}</th>\n #end \n#end \n<th w_render=\"operate\" width=\"10%;\">操作</th>\n </tr>\n </table>\n </div>\n </section>\n </div>\n </div>\n\n <div id=\"crudWin\">\n <form id=\"crudFrm\">\n <table class=\"table table-bordered\">\n #foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <tr>\n <td>${column.javaFieldName}:</td><td><input name=\"${column.javaFieldName}\" type=\" required=\"true\"></td>\n </tr>\n #end\n #end\n </table>\n </form>\n </div>\n\n<script type=\"text/javascript\"> \nvar that = this;\n\nvar pk = \'${context.javaPkName}\'; // java类中的主键字段\nvar listUrl = ctx + \'listBsgrid${context.javaBeanName}.do\'; // 查询\nvar addUrl = ctx + \'addBsgrid${context.javaBeanName}.do\'; // 添加\nvar updateUrl = ctx + \'updateBsgrid${context.javaBeanName}.do\'; // 修改\nvar delUrl = ctx + \'delBsgrid${context.javaBeanName}.do\'; // 删除\nvar submitUrl = \'\'; // 提交URL\n\nvar gridObj; // 表格\nvar crudWin; // 窗口\nvar ${jq}schFrm = ${jq}(\'#schFrm\'); // 查询表单\nvar ${jq}crudFrm = ${jq}(\'#crudFrm\'); // 编辑表单\n\nvar ${jq}schBtn = ${jq}(\'#schBtn\'); // 查询按钮\nvar ${jq}addBtn = ${jq}(\'#addBtn\'); // 添加按钮\n\nvar validator; // 验证器\n\nfunction reset() {\n ${jq}crudFrm.get(0).reset();\n validator.resetForm();\n}\n\n\n// 初始化事件\n${jq}addBtn.click(function() {\n submitUrl = addUrl;\n reset();\n crudWin.title(\'添加\');\n crudWin.show(); \n});\n\n${jq}schBtn.click(function() {\n search();\n});\n\ngridObj = ${jq}.fn.bsgrid.init(\'searchTable\', {\n url: listUrl\n ,pageSizeSelect: true\n ,stripeRows: true\n ,rowHoverColor: true\n ,rowSelectedColor: false\n ,pageSize: 10\n});\n\ncrudWin = dialog({\n title: \'编辑\',\n width:400,\n content: document.getElementById(\'crudWin\'),\n okValue: \'保存\',\n ok: function () {\n that.save();\n return false;\n },\n cancelValue: \'取消\',\n cancel: function () {\n this.close();\n return false;\n }\n});\n\nfunction search(){\n gridObj.options.otherParames = getFormData(${jq}schFrm);\n gridObj.gotoPage(1);\n}\n\nfunction operate(row, rowIndex, colIndex, options) {\n return \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'edit\', row)\n + \' return false;\">修改</a>\'\n + \' \'\n + \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'del\', row)\n + \' return false;\">删除</a>\';\n}\n\n// 保存\nthis.save = function() {\n var self = this;\n var data = getFormData(${jq}crudFrm);\n var validateVal = validator.form();\n if(validateVal) {\n Action.post(submitUrl, data, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n crudWin.close();\n });\n });\n }\n}\n // 编辑\nthis.edit = function(row) {\n if (row) {\n submitUrl = updateUrl + \'?\' + pk + \'=\' + row[pk];\n reset();\n crudWin.title(\'修改\');\n loadFormData(${jq}crudFrm,row); \n crudWin.show();\n }\n}\n\n// 删除\nthis.del = function(row) {\n if (row) {\n var d = dialog({\n title: \'提示\',\n width: 200,\n content: \'确定要删除该记录吗?\',\n okValue: \'确定\',\n ok: function () {\n Action.post(delUrl, row, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n });\n });\n },\n cancelValue: \'取消\',\n cancel: function () {}\n });\n d.showModal();\n }\n}\n\nvalidator = ${jq}crudFrm.validate();\n</script>\n <!-- page end-->\n </section>\n </section>\n <!--main content end-->\n\n <!--footer start-->\n <footer class=\"site-footer\">\n <div class=\"text-center\">\n 2016 © \n <a href=\"#\" class=\"go-top\">\n <i class=\"fa fa-angle-up\"></i>\n </a>\n </div>\n </footer>\n <!--footer end-->\n </section>\n\n <!-- js placed at the end of the document so the pages load faster -->\n <script src=\"${jq}{flatlab}js/bootstrap.min.js\"></script>\n <script class=\"include\" type=\"text/javascript\" src=\"${jq}{flatlab}js/jquery.dcjqaccordion.2.7.js\"></script>\n <script src=\"${jq}{flatlab}js/jquery.scrollTo.min.js\"></script>\n <script src=\"${jq}{flatlab}js/slidebars.min.js\"></script>\n <script src=\"${jq}{flatlab}js/jquery.nicescroll.js\" type=\"text/javascript\"></script>\n <script src=\"${jq}{flatlab}js/respond.min.js\" ></script>\n\n <!--common script for all pages-->\n <script src=\"${jq}{flatlab}js/common-scripts.js\"></script>\n </body>\n</html>\n','admin'),(29,'durc-jsp-AdminLTE','jsp',NULL,'${context.javaBeanNameLF}.jsp','#set($jq=\"$\")\n<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"taglib.jsp\" %>\n<c:set var=\"AdminLTE\" value=\"${jq}{res}AdminLTE/\"/>\n<c:set var=\"bsgrid\" value=\"${jq}{res}bsgrid/\"/>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html>\n <head>\n <meta charset=\"utf-8\">\n <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n <title>后台管理</title>\n <script type=\"text/javascript\">var ctx = \'${jq}{ctx}\';</script>\n <!-- Tell the browser to be responsive to screen width -->\n <meta content=\"width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no\" name=\"viewport\">\n <!-- Bootstrap 3.3.5 -->\n <link rel=\"stylesheet\" href=\"${jq}{AdminLTE}bootstrap/css/bootstrap.min.css\">\n <!-- Font Awesome -->\n <link rel=\"stylesheet\" href=\"${jq}{AdminLTE}plugins/font-awesome/css/font-awesome.min.css\">\n <!-- Ionicons -->\n <link rel=\"stylesheet\" href=\"${jq}{AdminLTE}plugins/ionicons/css/ionicons.min.css\">\n <!-- Theme style -->\n <link rel=\"stylesheet\" href=\"${jq}{AdminLTE}dist/css/AdminLTE.min.css\">\n <!-- AdminLTE Skins. We have chosen the skin-blue for this starter\n page. However, you can choose any other skin. Make sure you\n apply the skin class to the body tag so the changes take effect.\n -->\n <link rel=\"stylesheet\" href=\"${jq}{AdminLTE}dist/css/skins/skin-blue-light.min.css\">\n\n <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->\n <!-- WARNING: Respond.js doesn\'t work if you view the page via file:// -->\n <!--[if lt IE 9]>\n <script src=\"${jq}{AdminLTE}plugins/html5shiv.js\"></script>\n <script src=\"${jq}{AdminLTE}plugins/respond.min.js\"></script>\n <![endif]-->\n <script src=\"${jq}{AdminLTE}plugins/jQuery/jquery.min.js\"></script>\n\n <script src=\"${jq}{res}js/common.js\" type=\"text/javascript\"></script>\n <!-- datepicker -->\n <script src=\"${jq}{res}My97DatePicker/WdatePicker.js\" type=\"text/javascript\"></script>\n <!-- validate -->\n <script src=\"${jq}{res}jqueryValidate/jquery.validate.min.js\" type=\"text/javascript\"></script>\n <script src=\"${jq}{res}jqueryValidate/localization/messages_zh.min.js\" type=\"text/javascript\"></script>\n <!-- dialog -->\n <link rel=\"stylesheet\" href=\"${jq}{res}artDialog/css/ui-dialog.css\">\n <script src=\"${jq}{res}artDialog/dist/dialog-plus-min.js\"></script>\n <!-- bsgrid -->\n <link rel=\"stylesheet\" href=\"${jq}{bsgrid}merged/bsgrid.all.min.css\"/>\n <link rel=\"stylesheet\" href=\"${jq}{bsgrid}css/skins/grid_skin.min.css\"/>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}js/lang/grid.zh-CN.min.js\"></script>\n <script type=\"text/javascript\" src=\"${jq}{bsgrid}merged/bsgrid.all.min.js\"></script>\n\n </head>\n <body class=\"hold-transition skin-blue-light sidebar-mini\">\n <div class=\"wrapper\">\n\n <!-- Main Header -->\n <header class=\"main-header\">\n\n <!-- Logo -->\n <a href=\"#\" class=\"logo\">\n <!-- mini logo for sidebar mini 50x50 pixels -->\n <span class=\"logo-mini\"></span>\n <!-- logo for regular state and mobile devices -->\n <span class=\"logo-lg\">后台管理</span>\n </a>\n\n <!-- Header Navbar -->\n <nav class=\"navbar navbar-static-top\" role=\"navigation\">\n <!-- Sidebar toggle button-->\n <a href=\"#\" class=\"sidebar-toggle\" data-toggle=\"offcanvas\">\n <span class=\"sr-only\">Toggle navigation</span>\n </a>\n <!-- Navbar Right Menu -->\n <div class=\"navbar-custom-menu\">\n <ul class=\"nav navbar-nav\">\n <li>\n <a href=\"#\"><i class=\"fa fa-share\"></i>退出</a>\n </li>\n </ul>\n </div>\n </nav>\n </header>\n <!-- Left side column. contains the logo and sidebar -->\n <aside class=\"main-sidebar\">\n\n <!-- sidebar: style can be found in sidebar.less -->\n <section class=\"sidebar\">\n <!-- Sidebar user panel -->\n <div class=\"user-panel\">\n <div>你好,<span>admin</span></div>\n </div>\n <!-- Sidebar Menu -->\n <ul class=\"sidebar-menu\">\n <!-- Optionally, you can add icons to the links -->\n <li><a href=\"#\"><i class=\"fa fa-dashboard\"></i> <span>首页</span></a></li>\n <li class=\"treeview active\">\n <a href=\"#\"><i class=\"fa fa-link\"></i> <span>基础管理</span> <i class=\"fa fa-angle-left pull-right\"></i></a>\n <ul class=\"treeview-menu\">\n <li class=\"active\"><a href=\"#\"><i class=\"fa fa-circle-o\"></i> 订单管理</a></li>\n </ul>\n </li>\n </ul><!-- /.sidebar-menu -->\n </section>\n <!-- /.sidebar -->\n </aside>\n\n <!-- Content Wrapper. Contains page content -->\n <div class=\"content-wrapper\">\n <!-- Content Header (Page header) -->\n <section class=\"content-header\">\n <h1>订单管理\n<!-- <small>管理您的订单</small> -->\n </h1>\n </section>\n\n <!-- Main content -->\n <section class=\"content\">\n\n <!-- Your Page Content Here -->\n <div class=\"box box-default\">\n <div class=\"box-body\">\n <!-- form start -->\n <form id=\"schFrm\" class=\"form-inline\" onsubmit=\"return false;\">\n #foreach($column in $columns)\n #if(!${column.isIdentityPk})\n${column.javaFieldName}:<input name=\"${column.javaFieldName}Sch\" type=\"text\" class=\"form-control\"> \n #end\n #end\n <button id=\"schBtn\" type=\"submit\" class=\"btn btn-primary\"><i class=\"fa fa-search\"></i> 查询</button>\n <button type=\"reset\" class=\"btn btn-default\"><i class=\"fa fa-remove\"></i> 清空</button>\n </form>\n </div><!-- /.box-body -->\n </div>\n\n <div class=\"box\">\n <div class=\"box-header\">\n <div class=\"btn-group\">\n <a id=\"addBtn\" class=\"btn btn-primary\">\n <i class=\"fa fa-plus\"></i> 新增订单 \n </a>\n </div>\n </div><!-- /.box-header -->\n\n <div class=\"box-body\"> \n <table id=\"searchTable\">\n <tr> \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n <th w_index=\"${column.javaFieldName}\">${column.javaFieldName}</th>\n #end \n #end \n <th w_render=\"operate\" width=\"10%;\">操作</th>\n </tr>\n </table>\n </div><!-- /.box-body -->\n </div>\n\n <div id=\"crudWin\">\n <form id=\"crudFrm\" class=\"form-horizontal\">\n #foreach($column in $columns)\n #if(!${column.isIdentityPk}) \n <div class=\"form-group\">\n <label class=\"col-sm-3 control-label\">${column.javaFieldName}</label>\n <div class=\"col-sm-7\">\n <input name=\"${column.javaFieldName}\" type=\"text\" class=\"form-control\" required=\"true\">\n </div>\n </div>\n #end\n #end \n </form>\n </div>\n\n<script type=\"text/javascript\"> \nvar that = this;\n\nvar pk = \'${context.javaPkName}\'; // java类中的主键字段\nvar listUrl = ctx + \'listBsgrid${context.javaBeanName}.do\'; // 查询\nvar addUrl = ctx + \'addBsgrid${context.javaBeanName}.do\'; // 添加\nvar updateUrl = ctx + \'updateBsgrid${context.javaBeanName}.do\'; // 修改\nvar delUrl = ctx + \'delBsgrid${context.javaBeanName}.do\'; // 删除\nvar submitUrl = \'\'; // 提交URL\n\nvar gridObj; // 表格\nvar crudWin; // 窗口\nvar ${jq}schFrm = ${jq}(\'#schFrm\'); // 查询表单\nvar ${jq}crudFrm = ${jq}(\'#crudFrm\'); // 编辑表单\n\nvar ${jq}schBtn = ${jq}(\'#schBtn\'); // 查询按钮\nvar ${jq}addBtn = ${jq}(\'#addBtn\'); // 添加按钮\n\nvar validator; // 验证器\n\nfunction reset() {\n ${jq}crudFrm.get(0).reset();\n validator.resetForm();\n}\n\n\n// 初始化事件\n${jq}addBtn.click(function() {\n submitUrl = addUrl;\n reset();\n crudWin.title(\'添加\');\n crudWin.showModal(); \n});\n\n${jq}schBtn.click(function() {\n search();\n});\n\ngridObj = ${jq}.fn.bsgrid.init(\'searchTable\', {\n url: listUrl\n ,pageSizeSelect: true\n ,rowHoverColor: true // 移动行变色\n ,rowSelectedColor: false // 选择行不高亮\n ,isProcessLockScreen:false // 加载数据不显示遮罩层\n ,displayBlankRows: false\n ,pageSize: 10\n});\n\ncrudWin = dialog({\n title: \'编辑\',\n width:400,\n content: document.getElementById(\'crudWin\'),\n okValue: \'保存\',\n ok: function () {\n that.save();\n return false;\n },\n cancelValue: \'取消\',\n cancel: function () {\n this.close();\n return false;\n }\n});\n\nfunction search(){\n var schData = getFormData(${jq}schFrm);\n gridObj.search(schData);\n}\n\nfunction operate(row, rowIndex, colIndex, options) {\n return \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'edit\', row)\n + \' return false;\">修改</a>\'\n + \' \'\n + \'<a href=\"#\" onclick=\"\'\n + FunUtil.createFun(that, \'del\', row)\n + \' return false;\">删除</a>\';\n}\n\n// 保存\nthis.save = function() {\n var self = this;\n var data = getFormData(${jq}crudFrm);\n var validateVal = validator.form();\n if(validateVal) {\n Action.post(submitUrl, data, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n crudWin.close();\n });\n });\n }\n}\n // 编辑\nthis.edit = function(row) {\n if (row) {\n submitUrl = updateUrl + \'?\' + pk + \'=\' + row[pk];\n reset();\n crudWin.title(\'修改\');\n loadFormData(${jq}crudFrm,row); \n crudWin.showModal();\n }\n}\n\n// 删除\nthis.del = function(row) {\n if (row) {\n var d = dialog({\n title: \'提示\',\n width: 200,\n content: \'确定要删除该记录吗?\',\n okValue: \'确定\',\n ok: function () {\n Action.post(delUrl, row, function(result) {\n Action.execResult(result, function(result) {\n gridObj.refreshPage();\n });\n });\n },\n cancelValue: \'取消\',\n cancel: function () {}\n });\n d.showModal();\n }\n}\n\nvalidator = ${jq}crudFrm.validate();\n</script>\n\n </section><!-- /.content -->\n </div><!-- /.content-wrapper -->\n\n <!-- Main Footer -->\n <footer class=\"main-footer\">\n <!-- Default to the left -->\n <strong>Copyright © 2016</strong>\n </footer>\n\n </div><!-- ./wrapper -->\n\n <!-- REQUIRED JS SCRIPTS -->\n <!-- Bootstrap 3.3.5 -->\n <script src=\"${jq}{AdminLTE}bootstrap/js/bootstrap.min.js\"></script>\n <!-- AdminLTE App -->\n <script src=\"${jq}{AdminLTE}dist/js/app.min.js\"></script>\n\n <!-- Optionally, you can add Slimscroll and FastClick plugins.\n Both of these plugins are recommended to enhance the\n user experience. Slimscroll is required when using the\n fixed layout. -->\n </body>\n</html>\n','admin'),(30,'bui_jsp','jsp',NULL,'${context.javaBeanNameLF}.jsp','#set($jq=\"$\")\n<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"taglib.jsp\" %>\n<c:set var=\"bui\" value=\"${jq}{res}bui/\"/>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html>\n <head>\n <title>后台管理</title>\n <script type=\"text/javascript\">var ctx = \'${ctx}\';</script>\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n <link href=\"${jq}{bui}css/dpl-min.css\" rel=\"stylesheet\" type=\"text/css\" />\n <link href=\"${jq}{bui}css/bui-min.css\" rel=\"stylesheet\" type=\"text/css\" />\n <link href=\"${jq}{bui}css/page-min.css\" rel=\"stylesheet\" type=\"text/css\" />\n </head>\n<body>\n\n <div class=\"container\">\n <div class=\"row\">\n <form id=\"searchForm\" class=\"form-horizontal\">\n <div class=\"row\"> \n #foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <div class=\"control-group span8\">\n <label class=\"control-label\">${column.javaFieldName}:</label>\n <div class=\"controls\">\n <input type=\"text\" class=\"control-text\" name=\"${column.javaFieldName}Sch\">\n </div>\n </div> \n #end\n #end\n\n\n <div class=\"control-group\">\n <div class=\"controls\">\n <button type=\"button\" id=\"schBtn\" class=\"button button-primary\">搜索</button>\n </div>\n </div>\n </div>\n </form>\n </div>\n <hr>\n <div class=\"search-grid-container\">\n <div id=\"grid\"></div>\n </div>\n </div>\n\n <div id=\"content\" class=\"hide\">\n <form id=\"J_Form\" class=\"form-horizontal\"> \n #foreach($column in $columns)\n #if(!${column.isIdentityPk}) \n <div class=\"row\">\n <div class=\"control-group span8\">\n <label class=\"control-label\"><s>*</s>${column.javaFieldName}</label>\n <div class=\"controls\">\n <input name=\"${column.javaFieldName}\" data-rules=\"{required:true}\" class=\"input-normal control-text\" type=\"text\"/>\n </div>\n </div>\n </div>\n #end\n #end \n\n </form>\n </div>\n\n <script type=\"text/javascript\" src=\"${jq}{bui}js/jquery-1.8.1.min.js\"></script>\n <script type=\"text/javascript\" src=\"${jq}{bui}js/bui-min.js\"></script>\n <script type=\"text/javascript\" src=\"${jq}{res}js/common.js\"></script>\n\n<script type=\"text/javascript\">\n${jq}(function(){\n var TYPE_ADD = \'add\', TYPE_EDIT = \'update\',TYPE_REMOVE = \'remove\';\n\n var listUrl = ctx + \'list${context.javaBeanName}.do\'; // 查询\n var addUrl = ctx + \'add${context.javaBeanName}.do\'; // 添加\n var updateUrl = ctx + \'update${context.javaBeanName}.do\'; // 修改\n var delUrl = ctx + \'del${context.javaBeanName}.do\'; // 删除\n var exportUrl = ctx + \'export${context.javaBeanName}.do\'; // 导出 \n\n var Grid = BUI.Grid;\n var Store = BUI.Data.Store;\n var Form = BUI.Form;\n\n var grid; // 表格\n var store; // 数据\n var schForm; // 查询form\n var editing;// 编辑表单\n\n function init() {\n initForm();\n initData();\n initEditing();\n initGrid();\n initEvent();\n }\n\n function initForm() {\n var formCfg = {\n srcNode : \'#searchForm\'\n ,value : {}\n };\n schForm = new Form.HForm(formCfg);\n schForm.render();\n }\n\n function initData() {\n store = new Store({\n url : listUrl,\n autoLoad:true,\n totalProperty:\'total\',\n pageSize:10, // 配置分页数目\n proxy : {\n save : { //也可以是一个字符串,那么增删改,都会往那么路径提交数据,同时附加参数saveType\n addUrl : addUrl,\n updateUrl : updateUrl,\n removeUrl : delUrl\n }\n ,method:\'POST\'\n }\n\n });\n }\n\n function initEditing() {\n editing = new BUI.Editor.DialogEditor({\n contentId:\'content\'\n ,form:{srcNode:${jq}(\'#J_Form\')}\n ,buttons:[\n {text:\'确定\',elCls : \'button button-primary\',handler : function(){\n save();\n }}\n ,{text:\'取消\',elCls : \'button\',handler : function(){\n this.close();\n }}\n ]\n });\n }\n\n function initGrid() {\n var columns = [\n #set($i=0)\n#foreach($column in $columns)\n #if(!${column.isIdentityPk}) \n #if($i>0),#end {title:\'${column.javaFieldName}\',dataIndex:\'${column.javaFieldName}\'}\n #set($i=$i+1)\n #end \n#end \n ,{title:\'操作\',dataIndex:\'\',width:200,renderer : function(value,obj){\n var updateStr = \'<span class=\"grid-command btn-edit\">修改</span>\';\n var delStr = \'<span class=\"grid-command btn-del\">删除</span>\';\n return updateStr + delStr;\n }}\n ]; \n\n grid = new Grid.Grid({\n render:\'#grid\'\n ,columns : columns\n ,loadMask: true\n ,store: store\n ,emptyDataTpl : \'<div class=\"centered\"><h2>查询的数据不存在</h2></div>\'\n ,tbar : {\n items : [\n {text : \'<i class=\"icon-plus\"></i>新建\',btnCls : \'button button-small\',handler:add}\n ,{text : \'<i class=\"icon-download\"></i>导出\',btnCls : \'button button-small\',handler:exportFile}\n ]\n }\n // 底部工具栏\n ,bbar:{\n // pagingBar:表明包含分页栏\n pagingBar:true\n }\n });\n\n grid.render();\n }\n\n function initEvent() {\n //监听事件,删除一条记录\n grid.on(\'cellclick\',function(ev){\n var sender = ${jq}(ev.domTarget); //点击的Dom\n if(sender.hasClass(\'btn-del\')){\n var record = ev.record;\n del(record);\n }\n if(sender.hasClass(\'btn-edit\')){\n var record = ev.record;\n edit(record);\n }\n });\n\n ${jq}(\'#schBtn\').on(\'click\',function(ev){\n ev.preventDefault();\n search();\n });\n }\n\n\n //////// functions ////////\n\n function search() {\n var param = schForm.serializeToObject();\n param.start = 0;\n store.load(param);\n }\n\n function exportFile() {\n var data = schForm.serializeToObject();\n ExportUtil.doExport(exportUrl,data);\n }\n\n function save() {\n editing.valid();\n if(editing.isValid()) {\n var editType = editing.get(\'editType\');\n var form = editing.get(\'form\');\n var curRecord = editing.get(\'record\'); // 表格中的数据\n var record = form.serializeToObject(); // 表单数据\n\n BUI.mix(curRecord,record); // 将record赋值到curRecord中\n\n store.save(editType,curRecord,function(){\n store.load();\n editing.close();\n })\n }\n }\n\n function add(){\n editing.set(\'editType\',TYPE_ADD);\n showEditor({});\n }\n\n function edit(record) {\n editing.set(\'editType\',TYPE_EDIT);\n showEditor(record);\n }\n\n function showEditor(record) {\n editing.set(\'record\',record);\n editing.show();\n editing.setValue(record,true); //设置值,并且隐藏错误\n }\n\n function del(record){\n if(record){\n BUI.Message.Confirm(\'确认要删除选中的记录么?\',function(){\n store.save(TYPE_REMOVE,record,function(){\n store.load();\n })\n },\'question\');\n }\n }\n\n init();\n\n});\n</script>\n\n</body>\n</html>\n','admin'),(31,'bui_SearchEntity','entity',NULL,'${context.javaBeanName}Sch.java','package ${context.packageName}.entity;\n\nimport org.durcframework.core.expression.annotation.ValueField;\nimport org.durcframework.core.support.SearchBUI;\n\npublic class ${context.javaBeanName}Sch extends SearchBUI {\n\n#foreach($column in $columns) \n private ${column.javaTypeBox} ${column.javaFieldName}Sch;\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}Sch(${column.javaTypeBox} ${column.javaFieldName}Sch){\n this.${column.javaFieldName}Sch = ${column.javaFieldName}Sch;\n }\n\n @ValueField(column = \"${column.columnName}\")\n public ${column.javaTypeBox} get${column.javaFieldNameUF}Sch(){\n return this.${column.javaFieldName}Sch;\n }\n\n#end\n\n}','admin'),(32,'v_Entity','entity',NULL,'${context.javaBeanName}.java','package ${context.packageName}.entity;\n\n#if( \"${table.comment}\" != \"\" )\n/**\n ${table.comment}\n*/\n#end\npublic class ${context.javaBeanName} {\n#foreach($column in $columns)\n#if( \"${column.comment}\" != \"\" )\n // ${column.comment}\n#end\n private ${column.javaTypeBox} ${column.javaFieldName};\n#end\n\n#foreach(${column} in ${columns})\n#if( \"${column.comment}\" != \"\" )\n /** 设置 ${column.comment},对应字段 ${table.tableName}.${column.columnName} */\n#end \n public void set${column.javaFieldNameUF}(${column.javaTypeBox} ${column.javaFieldName}){\n this.${column.javaFieldName} = ${column.javaFieldName};\n }\n#if( \"${column.comment}\" != \"\" )\n /** 获取 ${column.comment},对应字段 ${table.tableName}.${column.columnName} */\n#end \n public ${column.javaTypeBox} get${column.javaFieldNameUF}(){\n return this.${column.javaFieldName};\n }\n\n#end\n}','admin'),(33,'v_DAO','dao',NULL,'${context.javaBeanName}Dao.java','package ${context.packageName}.dao;\n\nimport org.durcframework.core.dao.BaseDao;\nimport ${context.packageName}.entity.${context.javaBeanName};\n\npublic interface ${context.javaBeanName}Dao extends BaseDao<${context.javaBeanName}> {\n}','admin'),(34,'v_Service','service',NULL,'${context.javaBeanName}Service.java','package ${context.packageName}.service;\n\nimport org.durcframework.core.service.CrudService;\nimport ${context.packageName}.dao.${context.javaBeanName}Dao;\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport org.springframework.stereotype.Service;\n\n@Service\npublic class ${context.javaBeanName}Service extends CrudService<${context.javaBeanName}, ${context.javaBeanName}Dao> {\n\n}','admin'),(35,'v_SearchEntity','entity',NULL,'${context.javaBeanName}Sch.java','package ${context.packageName}.entity;\n\nimport org.durcframework.core.expression.annotation.ValueField;\nimport org.durcframework.core.support.SearchEasyUI;\n\npublic class ${context.javaBeanName}Sch extends SearchEasyUI {\n\n#foreach($column in $columns) \n private ${column.javaTypeBox} ${column.javaFieldName}Sch;\n#end\n\n#foreach(${column} in ${columns}) \n public void set${column.javaFieldNameUF}Sch(${column.javaTypeBox} ${column.javaFieldName}Sch){\n this.${column.javaFieldName}Sch = ${column.javaFieldName}Sch;\n }\n\n @ValueField(column = \"${column.columnName}\")\n public ${column.javaTypeBox} get${column.javaFieldNameUF}Sch(){\n return this.${column.javaFieldName}Sch;\n }\n\n#end\n\n}','admin'),(36,'v_Controller','controller',NULL,'${context.javaBeanName}Controller.java','package ${context.packageName}.controller;\n\nimport org.durcframework.core.GridResult;\nimport org.durcframework.core.MessageResult;\nimport org.durcframework.core.controller.CrudController;\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport ${context.packageName}.entity.${context.javaBeanName}Sch;\nimport ${context.packageName}.service.${context.javaBeanName}Service;\nimport org.springframework.stereotype.Controller;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.ResponseBody;\n\n@Controller\npublic class ${context.javaBeanName}Controller extends\n CrudController<${context.javaBeanName}, ${context.javaBeanName}Service> {\n\n @RequestMapping(\"/add${context.javaBeanName}.do\")\n public @ResponseBody MessageResult add${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.save(entity);\n }\n\n @RequestMapping(\"/list${context.javaBeanName}.do\")\n public @ResponseBody GridResult list${context.javaBeanName}(${context.javaBeanName}Sch searchEntity) {\n return this.query(searchEntity);\n }\n\n @RequestMapping(\"/update${context.javaBeanName}.do\")\n public @ResponseBody MessageResult update${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.update(entity);\n }\n\n @RequestMapping(\"/del${context.javaBeanName}.do\")\n public @ResponseBody MessageResult del${context.javaBeanName}(${context.javaBeanName} entity) {\n return this.delete(entity);\n }\n\n}','admin'),(37,'v_Mybatis','mapper',NULL,'${context.javaBeanNameLF}Mapper.xml','#set($jq=\"$\")\r\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\" >\r\n<!-- \r\n This file is automatically generated by autoCode(https://git.oschina.net/durcframework/autoCode)\r\n-->\r\n<mapper namespace=\"${context.packageName}.dao.${context.javaBeanName}Dao\">\r\n <resultMap id=\"queryResultMap\" type=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n #foreach($column in $columns)\r\n #if( \"${column.comment}\" != \"\" )\r\n <!-- ${column.comment} -->\r\n #end\r\n <result column=\"${column.columnName}\" property=\"${column.javaFieldName}\" jdbcType=\"${column.mybatisJdbcType}\" />\r\n #end\r\n </resultMap>\r\n\r\n <!-- 聚合查询 -->\r\n <select id=\"findProjection\" parameterType=\"org.durcframework.core.expression.projection.ProjectionQuery\" resultType=\"java.util.HashMap\">\r\n SELECT\r\n <include refid=\"expressionBlock.projectionColumn\"/>\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\"/> \r\n <include refid=\"expressionBlock.groupBy\"/>\r\n <include refid=\"expressionBlock.having\"/>\r\n <if test=\"order != null\">\r\n ORDER BY ${jq}{order}\r\n </if>\r\n </select>\r\n\r\n <!-- 根据条件查询记录 -->\r\n <select id=\"find\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\"\r\n resultMap=\"queryResultMap\">\r\n SELECT \r\n <choose>\r\n <when test=\"columns.size>0\">\r\n <foreach collection=\"columns\" item=\"column\" separator=\",\" >\r\n ${jq}{column}\r\n </foreach>\r\n </when>\r\n <otherwise>\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n #set($i=$i +1) \r\n #end\r\n </otherwise>\r\n </choose>\r\n\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n <choose>\r\n <when test=\"order == null\">\r\n ORDER BY t.${context.pkName} desc\r\n </when>\r\n <otherwise>\r\n ORDER BY ${jq}{order}\r\n </otherwise>\r\n </choose>\r\n <if test=\"!isQueryAll\">\r\n LIMIT\r\n #{start,jdbcType=INTEGER},#{limit,jdbcType=INTEGER}\r\n </if>\r\n </select>\r\n\r\n <!-- 根据条件查询记录数 -->\r\n <select id=\"findTotalCount\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\"\r\n resultType=\"java.lang.Integer\">\r\n SELECT count(*) FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n </select>\r\n\r\n <!-- 保存,保存全部字段 -->\r\n <insert id=\"save\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\r\n#if(${pkColumn.isIdentity})\r\n keyProperty=\"${context.javaPkName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\r\n#end\r\n >\r\n INSERT INTO ${table.tableName}\r\n (\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n #if($i > 0),#end `${column.columnName}`\r\n#set($i=$i +1)\r\n #end \r\n #end\r\n )\r\n VALUES (\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n #if($i > 0),#end #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}\r\n#set($i=$i +1)\r\n #end \r\n #end\r\n\r\n )\r\n </insert>\r\n\r\n <!-- 保存,保存不为NULL的字段 -->\r\n <insert id=\"saveNotNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\r\n #if(${pkColumn.isIdentity})\r\n keyProperty=\"${context.javaPkName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\r\n #end\r\n >\r\n INSERT INTO ${table.tableName}\r\n\r\n <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\"> \r\n\r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n <if test=\"${column.javaFieldName} != null\">\r\n `${column.columnName}`,\r\n </if>\r\n #end \r\n #end\r\n </trim>\r\n <trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\"> \r\n #foreach($column in $columns) \r\n #if(!${column.isIdentityPk}) \r\n <if test=\"${column.javaFieldName} != null\" >\r\n #{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </trim>\r\n </insert>\r\n\r\n <!-- 更新,更新全部字段 -->\r\n <update id=\"update\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n UPDATE ${table.tableName}\r\n <set> \r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n #end \r\n #end\r\n </set> \r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </update>\r\n\r\n <!-- 根据指定条件更新 -->\r\n <update id=\"updateByExpression\">\r\n UPDATE ${table.tableName}\r\n <set> \r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n ${column.columnName}=#{entity.${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n #end \r\n #end\r\n </set>\r\n <include refid=\"expressionBlock.updateWhere\" />\r\n </update>\r\n\r\n <!-- 更新不为NULL的字段 -->\r\n <update id=\"updateNotNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n UPDATE ${table.tableName}\r\n <set>\r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n <if test=\"${column.javaFieldName} != null\" >\r\n ${column.columnName}=#{${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </set>\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </update>\r\n\r\n <!-- 根据指定条件更新不为NULL的字段 -->\r\n <update id=\"updateNotNullByExpression\">\r\n UPDATE ${table.tableName}\r\n <set>\r\n #foreach($column in $columns) \r\n #if(!${column.isPk}) \r\n <if test=\"entity.${column.javaFieldName} != null\" >\r\n ${column.columnName}=#{entity.${column.javaFieldName},jdbcType=${column.mybatisJdbcType}}, \r\n </if>\r\n #end \r\n #end\r\n </set>\r\n <include refid=\"expressionBlock.updateWhere\" />\r\n </update>\r\n\r\n <!-- 根据主键获取单条记录 -->\r\n <select id=\"get\" resultMap=\"queryResultMap\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n SELECT \r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n#set($i=$i +1) \r\n #end\r\n FROM ${table.tableName} t\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </select>\r\n\r\n <!-- 根据条件获取单条记录 -->\r\n <select id=\"getByExpression\" resultMap=\"queryResultMap\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\">\r\n SELECT\r\n #set ($i=0) \r\n #foreach($column in $columns) \r\n #if($i > 0),#end t.${column.columnName}\r\n #set($i=$i +1) \r\n #end\r\n FROM ${table.tableName} t\r\n <include refid=\"expressionBlock.where\" />\r\n </select>\r\n\r\n <!-- 根据主键删除记录 -->\r\n <delete id=\"del\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\r\n DELETE FROM ${table.tableName}\r\n WHERE ${context.pkName} = #{${context.javaPkName},jdbcType=${context.mybatisPkType}}\r\n </delete> \r\n\r\n <!-- 根据条件删除记录 -->\r\n <delete id=\"delByExpression\" parameterType=\"org.durcframework.core.expression.ExpressionQuery\">\r\n DELETE FROM ${table.tableName}\r\n <include refid=\"expressionBlock.where\" />\r\n </delete>\r\n\r\n</mapper>','admin'),(38,'v_jsp','jsp',NULL,'${context.javaBeanNameLF}.jsp','#set($jq=\"$\")\n<%@ page language=\"java\" contentType=\"text/html; charset=UTF-8\"\n pageEncoding=\"UTF-8\"%>\n<%@ include file=\"../taglib.jsp\" %>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\"\"http://www.w3.org/TR/html4/loose.dtd\">\n<html>\n <head>\n <title>后台管理</title>\n </head>\n<body>\n <form id=\"searchForm\">\n <table>\n <tr>\n#foreach($column in $columns)\n #if(!${column.isIdentityPk})\n <th>${column.javaFieldName}:</th><td><input type=\"text\" name=\"${column.javaFieldName}Sch\"></td> \n #end\n#end\n <td>\n <button type=\"button\" id=\"schBtn\" class=\"button button-primary\">搜索</button>\n </td>\n </tr>\n </table>\n <button type=\"button\" id=\"schBtn\" class=\"button button-primary\">搜索</button>\n </form>\n <hr>\n <div class=\"grid-bar\"> \n <button type=\"button\" id=\"addBtn\" class=\"button button-primary\">新增</button> \n </div>\n\n <div id=\"grid\"></div>\n\n <div id=\"dlg\" class=\"hide\">\n <form id=\"editForm\">\n <input type=\"hidden\" name=\"orderId\">\n <table>\n #foreach($column in $columns)\n #if(!${column.isIdentityPk}) \n <tr> \n <th><s>*</s>${column.javaFieldName}</th>\n <td>\n <input name=\"${column.javaFieldName}\"\n rules=\"[\n {rule:{notNull:true},errorMsg:\'不能为空\'}\n ]\"\n type=\"text\"/>\n </td> \n </tr>\n #end\n #end \n\n </table>\n </form>\n </div>\n\n\n<script type=\"text/javascript\">\n\nVUI.use([\'PageForm\'],function(){\n var listUrl = ctx + \'list${context.javaBeanName}.do\'; // 查询\n var addUrl = ctx + \'add${context.javaBeanName}.do\'; // 添加\n var updateUrl = ctx + \'update${context.javaBeanName}.do\'; // 修改\n var delUrl = ctx + \'del${context.javaBeanName}.do\'; // 删除\n var ${jq}schBtn = ${jq}(\'#schBtn\'); // 查询按钮\n var ${jq}addBtn = ${jq}(\'#addBtn\'); // 添加按钮\n var ${jq}exportBtn = ${jq}(\'#exportBtn\');\n\n var grid; // 表格\n var schForm,pageForm; \n var dialog;// 编辑表单\n\n function init() {\n initEditing();\n initGrid();\n initEvent();\n initForm();\n }\n\n function initForm() {\n schForm = new VUI.Form({formId:\'searchForm\'});\n\n pageForm = new VUI.PageForm({\n formId:\'editForm\'\n ,grid:grid\n ,win:dialog\n ,crudUrl:{\n add:addUrl\n ,update:updateUrl\n ,del:delUrl\n }\n });\n }\n\n function initEditing() {\n dialog = new VUI.DialogForm({\n contentId:\'dlg\'\n ,formId:\'editForm\'\n ,onOk:function(){\n save();\n }\n });\n }\n\n function initGrid() {\n\n grid = new VUI.Grid({\n renderId:\'grid\'\n ,url:listUrl\n ,columns : [[\n {title:\'订单编号\',field:\'orderId\'}\n ,{title:\'手机号\',field:\'mobile\'}\n ,{title:\'城市名\',field:\'cityName\'}\n ,{title:\'地址\',field:\'address\'}\n ,{title:\'下单时间\',field:\'createDate\'}\n ,{title:\'操作\',field:\'\',width:200,formatter : function(value,obj){\n var updateStr = \'<span class=\"grid-command btn-edit\">修改</span>\';\n var delStr =\'<span class=\"grid-command btn-del\">删除</span>\';\n return updateStr + delStr;\n }}\n ]]\n ,striped:true // 斑马线\n ,pagination :true\n ,rownumbers :true\n });\n\n }\n\n function initEvent() {\n grid.on(\'ClickCell\',function(ev){\n var sender = ${jq}(ev.target); //点击的Dom\n if(sender.hasClass(\'btn-del\')){\n var record = ev.row;\n del(record);\n }\n if(sender.hasClass(\'btn-edit\')){\n var record = ev.row;\n edit(record);\n }\n });\n\n ${jq}schBtn.on(\'click\',function(ev){\n search();\n });\n\n ${jq}addBtn.on(\'click\',function(ev){\n add();\n });\n\n ${jq}exportBtn.on(\'click\',function(ev){\n exportFile();\n });\n }\n\n\n //////// functions ////////\n\n function search() {\n grid.load(schForm.getData());\n }\n\n function exportFile() {\n var data = schForm.getData();\n ExportUtil.doExport(exportUrl,data);\n }\n\n function save() {\n pageForm.save();\n }\n\n function add(){\n pageForm.add();\n }\n\n function edit(record) {\n pageForm.update(record);\n }\n\n function del(record){\n pageForm.del(record);\n }\n\n init();\n\n});\n\n</script>\n</body>\n</html>','admin');/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。