jsp

14
插入一个字段并加注释alter table commodity_comment add type int unsigned default 0 comment '评价类型(0好评,1中评,2差评)'

alter table sc_bd_yjjs_b add qz char(10)；
ALTER TABLE table1 ADD column1 int default 0
ALTER TABLE 表名 ADD 字段名 bit

alter table commodity_comment add type int unsigned default 0 comment '评价类型(0好评,1中评,2差评)'
alter table commodity_comment add color varchar(20) default NULL comment '商品颜色'
alter table commodity_comment add size_code varchar(20) default NULL comment '商品尺码'
alter table commodity_comment add order_time datetime default NULL comment '购买时间'
alter table commodity_comment add type int unsigned default 0 comment '评价类型(0好评,1中评,2差评)'

1.表结构语句
CREATE TABLE `directory` (
`id` varchar(50) NOT NULL COMMENT '书页ID',
`novel_id` varchar(50) default NULL COMMENT '小说ID',
`site_id` varchar(50) default NULL COMMENT '站点ID',
`dir_url` varchar(256) default NULL COMMENT '书页链接',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

2.添加带注释列语句
alter table directory add index_url varchar(256) default null comment '章节书目链接' after dir_url;

3.删除列语句

alter table directory drop index_url;


15jsp时间转换
<fmt:formatDate pattern="yyyy-MM-dd HH:mm:ss" value="${cos.createTime}" />

16
数据获取set进新增字段
CommodityComment commodityComment = ReflectionFromParamUtil.getObject( request, CommodityComment.class );
String orderItemId = request.getParameter( "orderItemId" );
OrderItem orderItem = orderItemService.selectByPrimaryKey( Integer.parseInt( orderItemId ) );
Date date = new Date();
commodityComment.setUserNo( UserContext.getCurrentUserNo() );
commodityComment.setUserName( UserContext.getCurrentUser().getName() );
commodityComment.setCreateTime( date );
commodityComment.setStatus( 0 );
// 新增的好中差评价类型
String grade = request.getParameter( "grade" );
if( StringUtil.parseInt( grade, -1 ) >= 0 ) {
int g = StringUtil.parseInt( grade );
if( g == 1 ) {
commodityComment.setType( CommentType.bad.getId() );
}
else if( g >= 4 ) {
commodityComment.setType( CommentType.good.getId() );
}
else {
commodityComment.setType( CommentType.middle.getId() );
}
}
commodityComment.setGrade( 1 );
if( orderItem != null ) {
commodityComment.setColor( orderItem.getColor() );
commodityComment.setSizeCode( orderItem.getSizeCode() );
commodityComment.setOrderTime( orderItem.getOrderTime() );

16
获取集合长度，或者总数comment.getCommentCount()
{fn:length(commodityModel.listComment_a) }

17
插入查询的数据，字段数据可有唯一的才行
INSERT into commodity_comment (order_id, user_name, user_no, commodity_id, commodity_name, brand_id, size_id,
brand_name, grade, shot_comment, content, create_time, status, audit_name, audit_no,
audit_time, pack_satisficing, speed_satisficing, service_satisficing, replay_content,
replay_user_no, replay_time, replay_user_nick_name, order_item_id,type,color,size_code,
order_time)SELECT order_id, user_name, user_no, commodity_id, commodity_name, brand_id, size_id,
brand_name, grade, shot_comment, content, create_time, status, audit_name, audit_no,
audit_time, pack_satisficing, speed_satisficing, service_satisficing, replay_content,
replay_user_no, replay_time, replay_user_nick_name, order_item_id,type,color,size_code,
order_time FROM commodity_comment where commodity_id = 399

18、
jsp ${}显示NAN%，因为{}中运算分母为零，或者结果为零

19.
异步加载数据，就是将div写在js文件，jsp用div的id去加载
controller写好方法数据

20.
Mybatis xmlsql语句，不能定义Java的map对象

21

//默认点击全部评论tab
$(".tab li").eq(0).trigger("click");

//默认点击全部评论tab
$(".tab li").eq(0).trigger("click",true);

22

{{if admin}}
<p>admin</p>
{{else if code > 0}}
<p>master</p>
{{else}}
<p>error!</p>
{{/if}}

23
定义百分比

<fmt:formatNumber pattern="00.0%" value="${(commodityModel.badCount)/(commodityModel.commodityComment.commentCount)}" />