mybatis中实体类,po类继承另一个po类的情况
来源:互联网 发布:韶关市新丰网络问政 编辑:程序博客网 时间:2024/06/05 16:53
表
CREATE TABLE tbl_admin(id int(12) NOT NULL AUTO_INCREMENT,username VARCHAR(32) NOT NULL COMMENT '用户名',password VARCHAR(32) NOT NULL COMMENT '密码',create_time VARCHAR(20) DEFAULT 0 COMMENT '创建时间',status int(2) DEFAULT 1 COMMENT '是否启用 0:停用;1:启用;',shenhe int(2) DEFAULT 0 COMMENT '当usertype=1时, 0:管理员自己创建; >0时审核 1:未审核;2:审核通过;3:审核不通过;',remark VARCHAR(32) DEFAULT '' COMMENT '备注',usertype int(2) DEFAULT 0 COMMENT '0:管理员;1:商家',PRIMARY KEY (id))ENGINE=INNODB COMMENT '管理员表';
父类
public class BaseAdmin {private Integer id;private String username;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}}
子类
public class Admin extends BaseAdmin {//密码private String password;//创建时间private String create_time;//状态private int status;public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public String getCreate_time() {return create_time;}public void setCreate_time(String create_time) {this.create_time = create_time;}public int getStatus() {return status;}public void setStatus(int status) {this.status = status;}}
情况一
dao
@Mapperpublic interface IAdminDao {public Admin query(String username);}
xml
<?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"><mapper namespace="com.ldgx.eshop.dao.IAdminDao"><!-- 根据条件查询管理员 --><select id="query" resultType="com.ldgx.eshop.entity.Admin">select * from tbl_admin <where><if test="_parameter != null and !_parameter.equals("")">username = #{_parameter}</if></where>limit 1</select></mapper>
这种可以
情况二
也可以
xml
<?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"><mapper namespace="com.ldgx.eshop.dao.IAdminDao"><resultMap id="adminMap" type="com.ldgx.eshop.entity.Admin"><id column="id" jdbcType="INTEGER" property="id"/><result column="username" jdbcType="VARCHAR" property="username"/><result column="password" jdbcType="VARCHAR" property="password"/><result column="create_time" jdbcType="VARCHAR" property="create_time"/><result column="status" jdbcType="INTEGER" property="status"/></resultMap><!-- 根据条件查询管理员 --><select id="query" resultMap="adminMap">select * from tbl_admin <where><if test="_parameter != null and !_parameter.equals("")">username = #{_parameter}</if></where>limit 1</select></mapper>
阅读全文