New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.EmployeeMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,unionId = #{unionId},userId = #{userId},cnName = #{cnName},enName = #{enName},tel = #{tel},email = #{email},imgUrl = #{imgUrl},apiId = #{apiId},isJob = #{isJob},gender = #{gender},employeeNo = #{employeeNo},roleId = #{roleId},isSyncRole = #{isSyncRole},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.Employee"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into employee (id,unionId,userId,cnName,enName,tel,email,imgUrl,apiId,isJob,gender,employeeNo,roleId,isSyncRole,isDel,createTime) values (#{id},#{unionId},#{userId},#{cnName},#{enName},#{tel},#{email},#{imgUrl},#{apiId},#{isJob},#{gender},#{employeeNo},#{roleId},#{isSyncRole},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.Employee" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.Employee" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from employee |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.Employee" parameterType="java.lang.Object" > |
| | | select |
| | | id,unionId,userId,cnName,enName,tel,email,imgUrl,apiId,isJob,gender,employeeNo,roleId,isSyncRole,isDel,createTime |
| | | from employee |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.Employee" parameterType="java.lang.Object" > |
| | | select |
| | | id,unionId,userId,cnName,enName,tel,email,imgUrl,apiId,isJob,gender,employeeNo,roleId,isSyncRole,isDel,createTime |
| | | from employee |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | employee |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.Employee"> |
| | | update employee |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from employee WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from employee WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.EmployeeRoleAdminAuthorityMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,sysAdAuId = #{sysAdAuId},roleTypeId = #{roleTypeId},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.EmployeeRoleAdminAuthority"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into emloyee_role_admin_authority (id,sysAdAuId,roleTypeId,isDel,createTime) values (#{id},#{sysAdAuId},#{roleTypeId},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.EmployeeRoleAdminAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.EmployeeRoleAdminAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from emloyee_role_admin_authority |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.EmployeeRoleAdminAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,sysAdAuId,roleTypeId,isDel,createTime |
| | | from emloyee_role_admin_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.EmployeeRoleAdminAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,sysAdAuId,roleTypeId,isDel,createTime |
| | | from emloyee_role_admin_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | emloyee_role_admin_authority |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.EmployeeRoleAdminAuthority"> |
| | | update emloyee_role_admin_authority |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from emloyee_role_admin_authority WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from emloyee_role_admin_authority WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.EmployeeRoleMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,employeeId = #{employeeId},shopId = #{shopId},roleTypeId = #{roleTypeId},roleUniqueStr = #{roleUniqueStr},oldId = #{oldId},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.EmployeeRole"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into employee_role (id,employeeId,shopId,roleTypeId,roleUniqueStr,oldId,isDel,createTime) values (#{id},#{employeeId},#{shopId},#{roleTypeId},#{roleUniqueStr},#{oldId},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.EmployeeRole" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.EmployeeRole" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from employee_role |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.EmployeeRole" parameterType="java.lang.Object" > |
| | | select |
| | | id,employeeId,shopId,roleTypeId,roleUniqueStr,oldId,isDel,createTime |
| | | from employee_role |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.EmployeeRole" parameterType="java.lang.Object" > |
| | | select |
| | | id,employeeId,shopId,roleTypeId,roleUniqueStr,oldId,isDel,createTime |
| | | from employee_role |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | employee_role |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.EmployeeRole"> |
| | | update employee_role |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from employee_role WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from employee_role WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.EmployeeRoleTypeMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,name = #{name},uniqueStr = #{uniqueStr},isUp = #{isUp},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.EmployeeRoleType"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into employee_role_type (id,name,uniqueStr,isUp,isDel,createTime) values (#{id},#{name},#{uniqueStr},#{isUp},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.EmployeeRoleType" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.EmployeeRoleType" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from employee_role_type |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.EmployeeRoleType" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,uniqueStr,isUp,isDel,createTime |
| | | from employee_role_type |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.EmployeeRoleType" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,uniqueStr,isUp,isDel,createTime |
| | | from employee_role_type |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | employee_role_type |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.EmployeeRoleType"> |
| | | update employee_role_type |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from employee_role_type WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from employee_role_type WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.ErrorLogMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,gradeNum = #{gradeNum},systemInfo = #{systemInfo},errorInfo = #{errorInfo},KeyId = #{KeyId},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.ErrorLog"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into error_log (id,gradeNum,systemInfo,errorInfo,KeyId,isDel,createTime) values (#{id},#{gradeNum},#{systemInfo},#{errorInfo},#{KeyId},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.ErrorLog" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.ErrorLog" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from error_log |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.ErrorLog" parameterType="java.lang.Object" > |
| | | select |
| | | id,gradeNum,systemInfo,errorInfo,KeyId,isDel,createTime |
| | | from error_log |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.ErrorLog" parameterType="java.lang.Object" > |
| | | select |
| | | id,gradeNum,systemInfo,errorInfo,KeyId,isDel,createTime |
| | | from error_log |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | error_log |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.ErrorLog"> |
| | | update error_log |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from error_log WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from error_log WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.SysAdminAuthorityGroupMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,name = #{name},tag = #{tag},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.SysAdminAuthorityGroup"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into sys_admin_authority_group (id,name,tag,isDel,createTime) values (#{id},#{name},#{tag},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.SysAdminAuthorityGroup" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.SysAdminAuthorityGroup" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from sys_admin_authority_group |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.SysAdminAuthorityGroup" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,tag,isDel,createTime |
| | | from sys_admin_authority_group |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.SysAdminAuthorityGroup" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,tag,isDel,createTime |
| | | from sys_admin_authority_group |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | sys_admin_authority_group |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.SysAdminAuthorityGroup"> |
| | | update sys_admin_authority_group |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from sys_admin_authority_group WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from sys_admin_authority_group WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.SysAdminAuthorityMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,name = #{name},tag = #{tag},gropId = #{gropId},gorpTag = #{gorpTag},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.SysAdminAuthority"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into sys_admin_authority (id,name,tag,gropId,gorpTag,isDel,createTime) values (#{id},#{name},#{tag},#{gropId},#{gorpTag},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.SysAdminAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.SysAdminAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from sys_admin_authority |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.SysAdminAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,tag,gropId,gorpTag,isDel,createTime |
| | | from sys_admin_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.SysAdminAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,tag,gropId,gorpTag,isDel,createTime |
| | | from sys_admin_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | sys_admin_authority |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.SysAdminAuthority"> |
| | | update sys_admin_authority |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from sys_admin_authority WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from sys_admin_authority WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.SysAdminMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,account = #{account},password = #{password},isUse = #{isUse},name = #{name},tel = #{tel},imgUrl = #{imgUrl},type = #{type},sysAdRoleId = #{sysAdRoleId},loginTime = #{loginTime},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.SysAdmin"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into sys_admin (id,account,password,isUse,name,tel,imgUrl,type,sysAdRoleId,loginTime,isDel,createTime) values (#{id},#{account},#{password},#{isUse},#{name},#{tel},#{imgUrl},#{type},#{sysAdRoleId},#{loginTime},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.SysAdmin" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.SysAdmin" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from sys_admin |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.SysAdmin" parameterType="java.lang.Object" > |
| | | select |
| | | id,account,password,isUse,name,tel,imgUrl,type,sysAdRoleId,loginTime,isDel,createTime |
| | | from sys_admin |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.SysAdmin" parameterType="java.lang.Object" > |
| | | select |
| | | id,account,password,isUse,name,tel,imgUrl,type,sysAdRoleId,loginTime,isDel,createTime |
| | | from sys_admin |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | sys_admin |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.SysAdmin"> |
| | | update sys_admin |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from sys_admin WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from sys_admin WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.SysAdminRoleAuthorityMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,sysAdAuId = #{sysAdAuId},sysAdRoId = #{sysAdRoId},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.SysAdminRoleAuthority"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into sys_admin_role_authority (id,sysAdAuId,sysAdRoId,isDel,createTime) values (#{id},#{sysAdAuId},#{sysAdRoId},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.SysAdminRoleAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.SysAdminRoleAuthority" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from sys_admin_role_authority |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.SysAdminRoleAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,sysAdAuId,sysAdRoId,isDel,createTime |
| | | from sys_admin_role_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.SysAdminRoleAuthority" parameterType="java.lang.Object" > |
| | | select |
| | | id,sysAdAuId,sysAdRoId,isDel,createTime |
| | | from sys_admin_role_authority |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | sys_admin_role_authority |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.SysAdminRoleAuthority"> |
| | | update sys_admin_role_authority |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from sys_admin_role_authority WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from sys_admin_role_authority WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.SysAdminRoleMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,name = #{name},isUse = #{isUse},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.SysAdminRole"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into sys_admin_role (id,name,isUse,isDel,createTime) values (#{id},#{name},#{isUse},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.SysAdminRole" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.SysAdminRole" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from sys_admin_role |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.SysAdminRole" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,isUse,isDel,createTime |
| | | from sys_admin_role |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.SysAdminRole" parameterType="java.lang.Object" > |
| | | select |
| | | id,name,isUse,isDel,createTime |
| | | from sys_admin_role |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | sys_admin_role |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.SysAdminRole"> |
| | | update sys_admin_role |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from sys_admin_role WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from sys_admin_role WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <!-- namespace:该mapper.xml映射文件的 唯一标识 --> |
| | | <mapper namespace="com.hx.medical.dao.mapper.UserMapper"> |
| | | |
| | | <!-- 整个实体类修改,表字段=实体类字段--> |
| | | <sql id="Update_Column_All"> |
| | | <trim prefixOverrides=","> |
| | | ,userNo = #{userNo},userName = #{userName},nickName = #{nickName},sexType = #{sexType},headImg = #{headImg},province = #{province},city = #{city},openId = #{openId},unionId = #{unionId},sessionKey = #{sessionKey},linkMan = #{linkMan},linkTel = #{linkTel},recomUserId = #{recomUserId},channelType = #{channelType},channelCode = #{channelCode},channelInto = #{channelInto},loginTime = #{loginTime},shopPersonalId = #{shopPersonalId},isDel = #{isDel},createTime = #{createTime} |
| | | </trim> |
| | | </sql> |
| | | |
| | | <!-- 后续通过 namespace.id--> |
| | | <!--parameterType:输入参数的类型 |
| | | resultType:查询返回结果值的类型 ,返回类型 --> |
| | | <insert id="insert" parameterType="com.hx.medical.model.User"> |
| | | <selectKey keyProperty="id" resultType="String" order="BEFORE"> |
| | | select replace(uuid(),'-','') from dual |
| | | </selectKey> |
| | | insert into user (id,userNo,userName,nickName,sexType,headImg,province,city,openId,unionId,sessionKey,linkMan,linkTel,recomUserId,channelType,channelCode,channelInto,loginTime,shopPersonalId,isDel,createTime) values (#{id},#{userNo},#{userName},#{nickName},#{sexType},#{headImg},#{province},#{city},#{openId},#{unionId},#{sessionKey},#{linkMan},#{linkTel},#{recomUserId},#{channelType},#{channelCode},#{channelInto},#{loginTime},#{shopPersonalId},#{isDel},#{createTime}) |
| | | </insert> |
| | | |
| | | <select id="selectList" resultType="com.hx.medical.model.User" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectListMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOne" resultType="com.hx.medical.model.User" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneMap" resultType="java.util.Map" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCount" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | select |
| | | COUNT(*) |
| | | from user |
| | | WHERE ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectCountSql" resultType="int" parameterType="com.hx.mybatisTool.SqlSentence" > |
| | | ${sqlSentence} |
| | | </select> |
| | | |
| | | <select id="selectOneByKey" resultType="com.hx.medical.model.User" parameterType="java.lang.Object" > |
| | | select |
| | | id,userNo,userName,nickName,sexType,headImg,province,city,openId,unionId,sessionKey,linkMan,linkTel,recomUserId,channelType,channelCode,channelInto,loginTime,shopPersonalId,isDel,createTime |
| | | from user |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <select id="selectOneByKeyBlob" resultType="com.hx.medical.model.User" parameterType="java.lang.Object" > |
| | | select |
| | | id,userNo,userName,nickName,sexType,headImg,province,city,openId,unionId,sessionKey,linkMan,linkTel,recomUserId,channelType,channelCode,channelInto,loginTime,shopPersonalId,isDel,createTime |
| | | from user |
| | | WHERE id = #{value} |
| | | </select> |
| | | |
| | | <update id="updateWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | update |
| | | user |
| | | SET ${sqlSentence} |
| | | </update> |
| | | |
| | | <update id="updateAll" parameterType="com.hx.medical.model.User"> |
| | | update user |
| | | SET <include refid="Update_Column_All"/> |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteWhere" parameterType="com.hx.mybatisTool.SqlSentence"> |
| | | delete from user WHERE ${sqlSentence} |
| | | </delete> |
| | | |
| | | <delete id="deleteById" parameterType="java.lang.Object"> |
| | | delete from user WHERE id = #{value} |
| | | </delete> |
| | | |
| | | </mapper> |
| | |
| | | |
| | | import com.hx.auto.GeneratorUtil; |
| | | import com.hx.auto.common.UrlData; |
| | | import com.hx.medical.model.specoffer.SpecOffer; |
| | | import com.hx.medical.model.Employee; |
| | | |
| | | /** |
| | | * 自动生成工具 |
| | |
| | | //生成全部的xml和mapper |
| | | //GeneratorUtil.generatorXmlAndMapper("com.hx.medical.model",urlData); |
| | | |
| | | Class<?> clas = SpecOffer.class; |
| | | Class<?> clas = Employee.class; |
| | | //dao |
| | | GeneratorUtil.generatorDao(clas,urlData); |
| | | //GeneratorUtil.generatorDao(clas,urlData); |
| | | //mapper |
| | | GeneratorUtil.generatorMapper(clas, urlData); |
| | | //GeneratorUtil.generatorMapper(clas, urlData); |
| | | // 生成service |
| | | GeneratorUtil.generatorService(clas,urlData); |
| | | //GeneratorUtil.generatorService(clas,urlData); |
| | | GeneratorUtil.generatorTableByPackUrl("com.hx.medical.model.Employee",urlData); |
| | | |
| | | /*Class cl = TestM2.class; |
| | | Field[] fields = cl.getDeclaredFields(); |
| | |
| | | data.put("arr", arrAuth); |
| | | |
| | | //插入登录日志 |
| | | /*OperationRecord or = new OperationRecord(); |
| | | or.setAdmin(employee.getCnName()); |
| | | or.setAdminId(employee.getId()); |
| | | or.setOpName("员工管理员登陆"); |
| | | or.setAdminType(OperationRecord.ADMIN_TYPE_EMPLOYEE); |
| | | operationRecordService.insert(or);*/ |
| | | |
| | | |
| | | return Result.success(data); |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | @RequestMapping(value ="/test",method = RequestMethod.POST) |
| | | public Result test(HttpServletRequest request){ |
| | | //redisUtil.set("222","44444444444"); |
| | | System.out.println(redisUtil.get("222")); |
| | | return Result.success("2222222"); |
| | | } |
| | | |
| | | } |
| | |
| | | import org.springframework.web.context.request.ServletRequestAttributes; |
| | | |
| | | import javax.servlet.http.HttpServletRequest; |
| | | import java.security.KeyPair; |
| | | import java.util.Map; |
| | | |
| | | import static com.hx.medical.util.RSAUtil.getPublicKey; |
| | | |
| | | /** |
| | | * 前端设计一拦截器 |
| | |
| | | HttpServletRequest request = sra.getRequest(); |
| | | Map<String, String> header = HttpServletRequestUtil.getHeader(request); |
| | | String sign = header.get("sign"); |
| | | String appId = header.get("appId"); |
| | | logger.info("paySign:"+sign); |
| | | String appId = header.get("appid"); |
| | | String privateKeyStr = header.get("privateKeyStr"); |
| | | logger.info("sign:"+sign); |
| | | logger.info("appId:"+appId); |
| | | logger.info("appId:"+privateKeyStr); |
| | | |
| | | if (StringUtils.isEmpty(sign)) { |
| | | return Result.failure(ResponseCode.ERROR_SIGN, "签名错误,登录失败!"); |
| | |
| | | return Result.failure(ResponseCode.ERROR_SIGN, "签名错误,登录失败!"); |
| | | } |
| | | |
| | | KeyPair keyPair = RSAUtil.getKeyPair(); |
| | | String publicKeyStr = getPublicKey(keyPair); |
| | | String decrypt = RSAUtil.privateDecrypt(sign, publicKeyStr); |
| | | String decrypt = RSAUtil.privateDecrypt(sign, privateKeyStr); |
| | | logger.info("decrypt"+decrypt); |
| | | |
| | | if (StringUtils.isEmpty(decrypt)) { |
| | |
| | | |
| | | #redis配置 |
| | | # Redis服务器地址 |
| | | #spring.redis.host=r-bp16fgy4t2giny01ov.redis.rds.aliyuncs.com |
| | | spring.redis.host=127.0.0.1 |
| | | spring.redis.host=r-bp16fgy4t2giny01ovpd.redis.rds.aliyuncs.com |
| | | #spring.redis.host=127.0.0.1 |
| | | # Redis服务器连接端口 |
| | | spring.redis.port=6379 |
| | | # Redis服务器连接密码(默认为空) |
| | | #spring.redis.password=UYWoCz#4^@w5Soj* |
| | | spring.redis.password= |
| | | spring.redis.password=UYWoCz#4^@w5Soj* |
| | | #spring.redis.password= |
| | | # 连接超时时间(毫秒) |
| | | spring.redis.timeout=1000 |