摘要:
1,基础查询 //1.group by+ 聚合函数+ HAVING条件过滤 SELECT SEX, AVG(AGE) FROM `user` GROUP BY SEX HAVING SEX='女' 2,DCL语句 1,创建用户,当前主机访问 CREATE user 'serlyf'@'localho 阅读全文
摘要:
1.Mybatis常用select语句 <select id="getRolesByParam" parameterType="java.util.HashMap" resultType="com.serlyf.system.entity.Role"> SELECT sr.ROLE_ID AS ro 阅读全文
摘要:
<insert id="insertRole" parameterType="com.serlyf.system.entity.Role"> insert into sys_role (ROLE_ID,ROLE_NAME,REMARK,IS_ACTIVE,CREATE_DATETIME,CREATE 阅读全文