adminuserDao改造

yujian

2019-03-27 04130387df9674459cd4d1a514c530bb4e3f3d27

adminuserDao改造

 fanli/src/main/java/com/yeshi/fanli/dao/AdminUserDao.java

File was deleted

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/AdminUserMapper.java

@@ -1,18 +1,11 @@
package com.yeshi.fanli.dao.mybatis;

import org.apache.ibatis.annotations.Param;

import com.yeshi.fanli.dao.BaseMapper;
import com.yeshi.fanli.entity.common.AdminUser;

public interface AdminUserMapper {
public interface AdminUserMapper extends BaseMapper<AdminUser>{

    int deleteByPrimaryKey(Long id);

    int insert(AdminUser record);

    int insertSelective(AdminUser record);

    AdminUser selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(AdminUser record);

    int updateByPrimaryKey(AdminUser record);
    AdminUser getByAccountAndPwd(@Param("account") String account, @Param("pwd") String pwd);
}

 fanli/src/main/java/com/yeshi/fanli/entity/common/AdminUser.java

@@ -2,54 +2,39 @@


import java.io.Serializable;



import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

import org.yeshi.utils.mybatis.Column;

import org.yeshi.utils.mybatis.Table;



import com.google.gson.annotations.Expose;



@Entity

@Table(name = "`yeshi_ec_adminuser`")

@org.yeshi.utils.mybatis.Table("yeshi_ec_adminuser")

@Table("yeshi_ec_adminuser")

public class AdminUser implements Serializable{

    /**

     * 

     */

    private static final long serialVersionUID = 1L;



    @Id

    @GeneratedValue(strategy = GenerationType.AUTO)

    @org.yeshi.utils.mybatis.Column(name = "id")

    @Column(name = "id")

    private Long id;



    @org.yeshi.utils.mybatis.Column(name = "name")

    @Column(name = "name", length = 32)

    @Expose

    @Column(name = "name")

    private String name;



    @org.yeshi.utils.mybatis.Column(name = "account")

    @Column(name = "account", length = 50)

    @Column(name = "account")

    private String account;



    @org.yeshi.utils.mybatis.Column(name = "pwd")

    @Column(name = "pwd", length = 50)

    @Column(name = "pwd")

    private String pwd;



    @org.yeshi.utils.mybatis.Column(name = "createtime")

    @Column(name = "createtime", length = 16)

    @Column(name = "createtime")

    private String createtime;



    @org.yeshi.utils.mybatis.Column(name = "authority")

    @Column(name = "authority", length = 1)

    @Column(name = "authority")

    private Integer authority;// 0-超级权限 1-普�?权限



    // 邮箱

    @org.yeshi.utils.mybatis.Column(name = "email")

    @Column(name = "email", length = 30)

    @Column(name = "email")

    private String email;

    

    

@@ -57,24 +42,6 @@
    

    public AdminUser(Long id){

        this.id=id;

    }

	
	


    public String getEmail() {

        return email;

    }



    public void setEmail(String email) {

        this.email = email;

    }



    public int getAuthority() {

        return authority;

    }



    public void setAuthority(int authority) {

        this.authority = authority;

    }



    public Long getId() {

@@ -116,4 +83,21 @@
    public void setCreatetime(String createtime) {

        this.createtime = createtime;

    }



    public Integer getAuthority() {

        return authority;

    }



    public void setAuthority(Integer authority) {

        this.authority = authority;

    }



    public String getEmail() {

        return email;

    }



    public void setEmail(String email) {

        this.email = email;

    }



}


 fanli/src/main/java/com/yeshi/fanli/mapping/AdminUserMapper.xml

@@ -12,7 +12,7 @@
        <result column="id" property="id" jdbcType="BIGINT" />
        <result column="email" property="email" jdbcType="VARCHAR" />
    </resultMap>
    <sql id="Base_Column_List">id,name,account,pwd,createtime,authority,email</sql>
    <sql id="Base_Column_List">id,`name`,`account`,`pwd`,createtime,authority,`email`</sql>
    <select id="selectByPrimaryKey" resultMap="BaseResultMap"
        parameterType="java.lang.Long">
        select
@@ -23,21 +23,21 @@
        yeshi_ec_adminuser where id = #{id,jdbcType=BIGINT}</delete>
    <insert id="insert" parameterType="com.yeshi.fanli.entity.common.AdminUser"
        useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_adminuser
        (id,name,account,pwd,createtime,authority,id,email) values
        (id,`name`,`account`,`pwd`,createtime,authority,`email`) values
        (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{account,jdbcType=VARCHAR},
        #{pwd,jdbcType=VARCHAR},#{createtime,jdbcType=VARCHAR},#{authority,jdbcType=INTEGER},#{id,jdbcType=BIGINT},#{email,jdbcType=VARCHAR})
        #{pwd,jdbcType=VARCHAR},#{createtime,jdbcType=VARCHAR},#{authority,jdbcType=INTEGER},#{email,jdbcType=VARCHAR})
    </insert>
    <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.common.AdminUser"
        useGeneratedKeys="true" keyProperty="id">
        insert into yeshi_ec_adminuser
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="name != null">name,</if>
            <if test="account != null">account,</if>
            <if test="pwd != null">pwd,</if>
            <if test="name != null">`name`,</if>
            <if test="account != null">`account`,</if>
            <if test="pwd != null">`pwd`,</if>
            <if test="createtime != null">createtime,</if>
            <if test="authority != null">authority,</if>
            <if test="email != null">email,</if>
            <if test="email != null">`email`,</if>
        </trim>
        values
        <trim prefix="(" suffix=")" suffixOverrides=",">
@@ -51,22 +51,28 @@
        </trim>
    </insert>
    <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.common.AdminUser">update
        yeshi_ec_adminuser set name = #{name,jdbcType=VARCHAR},account =
        #{account,jdbcType=VARCHAR}, pwd = #{pwd,jdbcType=VARCHAR},createtime
        yeshi_ec_adminuser set `name` = #{name,jdbcType=VARCHAR},`account` =
        #{account,jdbcType=VARCHAR}, `pwd` = #{pwd,jdbcType=VARCHAR},createtime
        = #{createtime,jdbcType=VARCHAR}, authority =
        #{authority,jdbcType=INTEGER} ,email =#{email,jdbcType=VARCHAR} where
        #{authority,jdbcType=INTEGER} ,`email` =#{email,jdbcType=VARCHAR} where
        id = #{id,jdbcType=BIGINT}</update>
    <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.common.AdminUser">
        update yeshi_ec_adminuser
        <set>
            <if test="name != null">name=#{name,jdbcType=VARCHAR},</if>
            <if test="account != null">account=#{account,jdbcType=VARCHAR},</if>
            <if test="pwd != null">pwd=#{pwd,jdbcType=VARCHAR},</if>
            <if test="name != null">`name`=#{name,jdbcType=VARCHAR},</if>
            <if test="account != null">`account`=#{account,jdbcType=VARCHAR},</if>
            <if test="pwd != null">`pwd`=#{pwd,jdbcType=VARCHAR},</if>
            <if test="createtime != null">createtime=#{createtime,jdbcType=VARCHAR},</if>
            <if test="authority != null">authority=#{authority,jdbcType=INTEGER},</if>
            <if test="id !=null">id =#{id,jdbcType=BIGINT},</if>
            <if test="email !=null">email =#{email,jdbcType=VARCHAR},</if>
            <if test="email !=null">`email` =#{email,jdbcType=VARCHAR},</if>
        </set>
        where id = #{id,jdbcType=BIGINT}
    </update>
	
    <select id="getByAccountAndPwd" resultMap="BaseResultMap">
        SELECT * FROM yeshi_ec_adminuser u 
        WHERE u.`account` = #{account} AND u.`pwd`= #{pwd}
        LIMIT 1
    </select>
</mapper>

 fanli/src/main/java/com/yeshi/fanli/service/impl/AdminUserServiceImpl.java

@@ -1,15 +1,10 @@
package com.yeshi.fanli.service.impl;



import java.io.Serializable;

import java.util.List;



import javax.annotation.Resource;



import org.springframework.stereotype.Service;



import com.yeshi.fanli.dao.AdminUserDao;

import com.yeshi.fanli.dao.mybatis.AdminUserMapper;

import com.yeshi.fanli.entity.bus.user.ExtractAuditRecord;

import com.yeshi.fanli.entity.common.AdminUser;

import com.yeshi.fanli.service.AdminUserService;



@@ -17,21 +12,14 @@
public class AdminUserServiceImpl implements AdminUserService {



    @Resource

    private AdminUserDao adminUserDao;

    @Resource

    private AdminUserMapper adminUserMapper;

    

    

    public AdminUser login(final String acction, final String pwd) {

			
        List<AdminUser> list = adminUserDao.list("from AdminUser a where a.account=? and a.pwd=? ",new Serializable[]{acction,pwd});	
			
        if(list.size() > 0){

            return list.get(0);

        }

        return null;

    public AdminUser login(String acction, String pwd) {

        return adminUserMapper.getByAccountAndPwd(acction, pwd);

    }

    

	
    @Override

    public AdminUser selectByPrimaryKey(Long id){

        return adminUserMapper.selectByPrimaryKey(id);