书之岁华

发时达

1、未转换前2、 行转列函数：UNPIVOT()SELECT * FROM (select std0, std1,std2,std3,std4,std5,std6,std9 from table t) UNPIVOT("value" FOR "name" IN(std0 as '哈哈1',std1 as '哈哈2',std2 as '哈哈3',std3 as '哈哈4',std4 as '哈...

内连接内连接也叫连接，自然连接。内连接是从结果表中删除与其他被连接表中没有匹配行的所有行，所以内连接可能会丢失信息。select fieldlist from table1 [inner] join table2 on table1.column=table2.column...

1、jsp<div class="col-md-3"> <sys:codeselectmul name="pdjg" optionsList="${gfunc:getSysCode('pdjg') }" cssClass="bs-select form-control">

1、daovoid batchDelete(Integer[] ids);2、mapper<delete id="batchDelete"> delete from t_user where id in <foreach collection="array" item=&a