mybatis框架配置

痛定思痛。 2022-05-14 15:57 184阅读 0赞

第一步：导入包  
log4j-1.2.16.jar  
mybatis-3.4.1.jar  
mysql-connector-java-5.1.6.jar

第二步：配置核心配置文件，mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	
    	<properties resource="zscbbs.properties" ></properties>
    	
    	<settings>
    		
    		<setting name="logImpl" value="LOG4J"/>
    		
    		<setting name="autoMappingBehavior" value="NONE"/>
    	</settings>
    	
    	
        <settings>
            <setting name="logImpl" value="STDOUT_LOGGING" />
        </settings>
    	
    	
    	<typeAliases>
    		<package name="cn.kgc.bbs.pojo"/>
    	</typeAliases>
    
    
    	
    	<environments default="development">
            <environment id="development">
                <transactionManager type="JDBC" />
                
                <dataSource type="POOLED">
                    <property name="driver" value="${driver}" />
                    <property name="url" value="${url}" />
                    <property name="username" value="${user}" />
                    <property name="password" value="${password}" />
                </dataSource>
            </environment>
        </environments>
        
        <mappers>
        	<mapper resource="cn/kgc/bbs/dao/BbsDetailMapper.xml"/>
        	<mapper resource="cn/kgc/bbs/dao/BbsUserMapper.xml" />
        	<mapper resource="cn/kgc/bbs/dao/BbsCommentsMapper.xml" />
        </mappers>
    </configuration>

第三步：创建实体类pojo  
第四步：DAO层SQL映片文件（mapper.xml）配置  
动态SQL:  
实现多条件查询：if+where  
if+trim  
实现更新操作：if+set  
if+trim  
使用foreach复杂查询：foreach迭代数组，List,Map类型入参  
choose（when,otherwise）:和java Switch语句类似

<?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.big3.dao.Bbs_detailMapper" >
      
      <resultMap id="BaseResultMap" type="com.big3.pojo.Bbs_detail" >
        <id column="id" property="id" jdbcType="BIGINT" />
        <result column="title" property="title" jdbcType="VARCHAR" />
        <result column="picPath" property="picpath" jdbcType="VARCHAR" />
        <result column="author" property="author" jdbcType="VARCHAR" />
        <result column="createDate" property="createdate" jdbcType="TIMESTAMP" />
        <result column="modifyDate" property="modifydate" jdbcType="TIMESTAMP" />
        <result column="accessCount" property="accesscount" jdbcType="INTEGER" />
      </resultMap>
      
      <sql id="Base_Column_List" >
        id, detailId, content, author, ip, createDate
      </sql>
      <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
        select
        
        <include refid="Base_Column_List" />
        from bbs_comment
        where id = #{id,jdbcType=BIGINT}
      </select>	
    
      <resultMap id="ResultMapWithBLOBs" type="com.big3.pojo.Bbs_detail" extends="BaseResultMap" >
        <result column="content" property="content" jdbcType="LONGVARCHAR" />
      </resultMap>
      <sql id="Base_Column_List" >
        id, title, picPath, author, createDate, modifyDate, accessCount
      </sql>
      <sql id="Blob_Column_List" >
        content
      </sql>
      <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Long" >
        select 
        <include refid="Base_Column_List" />
        ,
        <include refid="Blob_Column_List" />
        from bbs_detail
        where id = #{id,jdbcType=BIGINT}
      </select>
      <select id="count" resultType="int" >
        select count(1) from bbs_detail
      </select>
      <select id="getDetailById" resultMap="getDetailByIdMap"  >
        SELECT	bbs_detail.`id`,title,bbs_comment.`content`,bbs_comment.`author`,bbs_comment.`createDate` FROM bbs_detail
        INNER JOIN bbs_comment ON bbs_detail.`id`=bbs_comment.`detailId`
        WHERE bbs_detail.id=#{id}
      </select>
      <resultMap id="getDetailByIdMap" type="Bbs_detail">
        <id property="id" column="id"/>
        <result property="title" column="title"/>
        <collection property="commentList" resultMap="commentMap" ofType="Bbs_comment"/>   
      </resultMap>
    
      <resultMap id="commentMap" type="Bbs_comment">
        <result property="content" column="content"/>
        <result property="author" column="author"/>
        <result property="createDate" column="createDate"/>
      </resultMap>
    
      <select id="selectDetailIf" resultType="Bbs_detail"  >
        SELECT * FROM bbs_detail
        <trim prefix="where" prefixOverrides="and" >
        <if test="title!=null">
          and title LIKE #{title}
        </if>
        <if test="content!=null">
          AND content LIKE #{content}
        </if>
        </trim>
      </select>
    
      <select id="selectDetailByIds" resultType="Bbs_detail">
        SELECT * FROM bbs_detail WHERE id IN
        <foreach collection="id" item="detailList" open="(" separator="," close=")">
          #{detailList}
        </foreach>
      </select>
      
      <select id="selectDetailByChoose" resultType="Bbs_detail" parameterType="Bbs_detail">
        SELECT * FROM bbs_detail
        <where>
        <choose>
          <when test="id!=null">
            and id=#{id}
          </when>
          <when test="title!=null and title!=''">
            and title like #{title}
          </when>
          <when test="author!=null and author !=''">
            and author=#{author}
          </when>
        </choose>
        </where>
      </select>
      
      <update id="modfiyBydetail" parameterType="Bbs_detail" >
        UPDATE bbs_detail
        <trim prefix="set" suffixOverrides="," suffix="WHERE id=#{id}">
    
          <if test="title!=null">
            title=#{title},
          </if>
          <if test="content!=null">
            content=#{content},
          </if>
          <if test="author!=null">
            author=#{author},
          </if>
          <if test="modifyDate!=null">
            modifyDate=#{modifyDate},
          </if>
          <if test="cateid!=null">
            cateid=#{cateid},
          </if>
          picPath=#{picPath}
        </trim>
    
      </update>
      
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >
        delete from bbs_detail
        where id = #{id,jdbcType=BIGINT}
      </delete>
      <insert id="insert" parameterType="com.big3.pojo.Bbs_detail" >
        insert into bbs_detail (id, title, picPath, 
          author, createDate, modifyDate, 
          accessCount, content)
        values (#{id,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{picpath,jdbcType=VARCHAR}, 
          #{author,jdbcType=VARCHAR}, #{createdate,jdbcType=TIMESTAMP}, #{modifydate,jdbcType=TIMESTAMP}, 
          #{accesscount,jdbcType=INTEGER}, #{content,jdbcType=LONGVARCHAR})
      </insert>
      <insert id="insertSelective" parameterType="com.big3.pojo.Bbs_detail" >
        insert into bbs_detail
        <trim prefix="(" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            id,
          </if>
          <if test="title != null" >
            title,
          </if>
          <if test="picpath != null" >
            picPath,
          </if>
          <if test="author != null" >
            author,
          </if>
          <if test="createdate != null" >
            createDate,
          </if>
          <if test="modifydate != null" >
            modifyDate,
          </if>
          <if test="accesscount != null" >
            accessCount,
          </if>
          <if test="content != null" >
            content,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides="," >
          <if test="id != null" >
            #{id,jdbcType=BIGINT},
          </if>
          <if test="title != null" >
            #{title,jdbcType=VARCHAR},
          </if>
          <if test="picpath != null" >
            #{picpath,jdbcType=VARCHAR},
          </if>
          <if test="author != null" >
            #{author,jdbcType=VARCHAR},
          </if>
          <if test="createdate != null" >
            #{createdate,jdbcType=TIMESTAMP},
          </if>
          <if test="modifydate != null" >
            #{modifydate,jdbcType=TIMESTAMP},
          </if>
          <if test="accesscount != null" >
            #{accesscount,jdbcType=INTEGER},
          </if>
          <if test="content != null" >
            #{content,jdbcType=LONGVARCHAR},
          </if>
        </trim>
      </insert>
      <update id="updateByPrimaryKeySelective" parameterType="com.big3.pojo.Bbs_detail" >
        update bbs_detail
        <set >
          <if test="title != null" >
            title = #{title,jdbcType=VARCHAR},
          </if>
          <if test="picpath != null" >
            picPath = #{picpath,jdbcType=VARCHAR},
          </if>
          <if test="author != null" >
            author = #{author,jdbcType=VARCHAR},
          </if>
          <if test="createdate != null" >
            createDate = #{createdate,jdbcType=TIMESTAMP},
          </if>
          <if test="modifydate != null" >
            modifyDate = #{modifydate,jdbcType=TIMESTAMP},
          </if>
          <if test="accesscount != null" >
            accessCount = #{accesscount,jdbcType=INTEGER},
          </if>
          <if test="content != null" >
            content = #{content,jdbcType=LONGVARCHAR},
          </if>
        </set>
        where id = #{id,jdbcType=BIGINT}
      </update>
      <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.big3.pojo.Bbs_detail" >
        update bbs_detail
        set title = #{title,jdbcType=VARCHAR},
          picPath = #{picpath,jdbcType=VARCHAR},
          author = #{author,jdbcType=VARCHAR},
          createDate = #{createdate,jdbcType=TIMESTAMP},
          modifyDate = #{modifydate,jdbcType=TIMESTAMP},
          accessCount = #{accesscount,jdbcType=INTEGER},
          content = #{content,jdbcType=LONGVARCHAR}
        where id = #{id,jdbcType=BIGINT}
      </update>
      <update id="updateByPrimaryKey" parameterType="com.big3.pojo.Bbs_detail" >
        update bbs_detail
        set title = #{title,jdbcType=VARCHAR},
          picPath = #{picpath,jdbcType=VARCHAR},
          author = #{author,jdbcType=VARCHAR},
          createDate = #{createdate,jdbcType=TIMESTAMP},
          modifyDate = #{modifydate,jdbcType=TIMESTAMP},
          accessCount = #{accesscount,jdbcType=INTEGER}
        where id = #{id,jdbcType=BIGINT}
      </update>
      //一对多关系,字段映射
      //property:属性名,mName:数据库查出来字段,name:PartyMember类的属性
      <resultMap id="BaseMap" type="cn.hyt.hyt_zhdj_cs.repository.party.domain.PartyLearningSituation">
        <result column="party_member_id" jdbcType="INTEGER" property="partyMemberId" />
        <association property="partyMember" javaType="cn.hyt.hyt_zhdj_cs.repository.party.domain.PartyMember">
          <result column="mName" property="name"/>
        </association>
        <association property="partyBranch" javaType="cn.hyt.hyt_zhdj_cs.repository.party.domain.PartyBranch">
          <result column="bId" property="id" jdbcType="INTEGER"/>
          <result column="bName" property="name" javaType="VARCHAR"/>
        </association>
      </resultMap>
    </mapper>

第五步：java应用

public class BbsDatailDaoImpl  implements BbsDetailDao {
    	public int getDetailSum(){
    		String resource = "mybatis-config.xml";
    		// 获取mybatis-config.xml文件的输入流
    		InputStream is = Resources.getResourceAsStream(resource);				//java.io包
    		// 创建SqlSessionFactory对象，此对象可以完成对配置文件的读取	
    		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);	 //ibatis包
    		sqlSession=factory.openSession(false); //手动提交
    		return sqlSession.getMapper(BbsDetailDao.class).getDetailSum();  //return sqlSession.selectOne("getDetailSun")  第二种写法
    		sqlSession.commit(); 		 //提交
    		sqlSession.rollback(); 		// 回滚
    		sqlSession.close();			//关闭