页面
页面代码
<% layout('/layouts/default.html', {title: '健康知识管理', libs: ['dataGrid']}){ %>
< div class = " main-content" >
< div class = " box box-main" >
< div class = " box-header" >
< div class = " box-title" >
< i class = " fa icon-notebook" > </ i> ${text('健康知识管理')}
</ div>
< div class = " box-tools pull-right" >
< a href = " #" class = " btn btn-default" id = " btnSearch" title = " ${text('查询')}" > < i class = " fa fa-filter" > </ i> ${text('查询')}</ a>
<% if(hasPermi('health:health:edit')){ %>
< a href = " ${ctx}/health/health/form" class = " btn btn-default btnTool" title = " ${text('新增健康知识')}" > < i class = " fa fa-plus" > </ i> ${text('新增')}</ a>
<% } %>
< a href = " #" class = " btn btn-default" id = " btnSetting" title = " ${text('设置')}" > < i class = " fa fa-navicon" > </ i> </ a>
</ div>
</ div>
< div class = " box-body" >
< #form: form id = " searchForm" model = " ${health}" action = " ${ctx}/health/health/listData" method = " post" class = " form-inline hide"
data-page-no = " ${parameter.pageNo}" data-page-size = " ${parameter.pageSize}" data-order-by = " ${parameter.orderBy}" >
< div class = " form-group" >
< label class = " control-label" > ${text('健康知识')}:</ label>
< div class = " control-inline" >
< #form: input path = " healthKnowleage" class = " form-control width-120" />
</ div>
</ div>
< div class = " form-group" >
< button type = " submit" class = " btn btn-primary btn-sm" > < i class = " glyphicon glyphicon-search" > </ i> ${text('查询')}</ button>
< button type = " reset" class = " btn btn-default btn-sm isQuick" > < i class = " glyphicon glyphicon-repeat" > </ i> ${text('重置')}</ button>
</ div>
</ #form: form>
< table id = " dataGrid" > </ table>
< div id = " dataGridPage" > </ div>
</ div>
</ div>
</ div>
<% } %>
< script>
$ ( '#dataGrid' ) . dataGrid ( {
searchForm : $ ( '#searchForm' ) ,
columnModel : [
{ header : '${text("健康知识")}' , name : 'healthKnowleage' , index : 'a.health_knowleage' , width : 150 , align : "left" , frozen : true , formatter : function ( val, obj, row, act ) {
return '<a href="${ctx}/health/health/form?healthCode=' + row. healthCode+ '" class="btnList" data-title="${text("编辑健康知识")}">' + ( val|| row. id) + '</a>' ;
} } ,
{ header : '${text("操作")}' , name : 'actions' , width : 120 , formatter : function ( val, obj, row, act ) {
var actions = [ ] ;
actions. push ( '<a href="${ctx}/health/health/form?healthCode=' + row. healthCode+ '" class="btnList" title="${text("编辑健康知识")}"><i class="fa fa-pencil"></i></a> ' ) ;
actions. push ( '<a href="${ctx}/health/health/delete?healthCode=' + row. healthCode+ '" class="btnList" title="${text("删除健康知识")}" data-confirm="${text("确认要删除该健康知识吗?")}"><i class="fa fa-trash-o"></i></a> ' ) ;
return actions. join ( '' ) ;
} }
] ,
ajaxSuccess : function ( data ) {
}
} ) ;
</ script>
数据库表
CREATE TABLE ` health` (
` health_code` varchar ( 100 ) NOT NULL COMMENT '编号' ,
` health_knowleage` text COMMENT '健康知识' ,
PRIMARY KEY ( ` health_code` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '健康知识' ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '1' , '如果牛奶不喝,就喝酸奶;酸奶不喝,就喝豆浆;如果牛奶、酸奶、豆浆都不喝,那就等死了。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '2' , '鹿群没有了敌人,越来越胖,是狼救了它们。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '3' , '每日250克碳水就能调控体重。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '4' , '为什么广东人瘦,饭前喝汤。饭后喝汤,越喝越胖。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '5' , '获得“健康食品”的殊荣,世界上仅有两种:黄豆和燕麦。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '6' , '每顿不能吃太饱。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '7' , '水果、蔬菜,预防癌症最好。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '8' , '红黄色蔬菜-维生素A之最。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '9' , '饮料里茶最好,茶叶当中绿茶最好。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '10' , '吃了一个半月黑木耳,3个血管都通了。' ) ;
INSERT INTO ` jeesite` . ` health` ( ` health_code` , ` health_knowleage` ) VALUES ( '11' , '少纤维,少运动,能不便秘?广播操,多按摩,保你健康。' ) ;