mybatis配置xml的一个文件

kiloyp

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

<!-- N_模糊查询与分页查询返回模板 -->     <resultMap type="com.itrus.msign.entity.Contract" id="selectconinfo">         <id column="id" property="id" jdbcType="BIGINT" />         <result column="date_created" property="dateCreated" jdbcType="TIMESTAMP" />         <result column="doc_num" property="docNum" jdbcType="VARCHAR" />         <result column="is_deleted" property="isDeleted" jdbcType="VARCHAR" />         <result column="original_doc_id" property="originalDocId"             jdbcType="BIGINT" />         <result column="pages" property="pages" jdbcType="INTEGER" />         <result column="signed_doc_id" property="signedDocId" jdbcType="BIGINT" />         <result column="status" property="status" jdbcType="INTEGER" />         <result column="is_entrust" property="isEntrust" jdbcType="INTEGER" />         <result column="title" property="title" jdbcType="VARCHAR" />         <result column="cnum" property="cnum" jdbcType="INTEGER" />         <result column="snum" property="snum" jdbcType="INTEGER" />         <result column="uuid" property="uuid" jdbcType="VARCHAR" />         <result column="order_no" property="orderNo" jdbcType="VARCHAR" />         <collection property="signatures" ofType="com.itrus.msign.entity.Signature">             <result column="cert_id" jdbcType="BIGINT" property="certId" />             <result column="contract_id" jdbcType="BIGINT" property="contractId" />             <result column="seal_id" jdbcType="BIGINT" property="sealId" />             <result column="user_info_id" jdbcType="BIGINT" property="userInfoId" />             <result column="sdate_created" jdbcType="TIMESTAMP" property="dateCreated" />             <result column="offset_positiony" jdbcType="INTEGER" property="offsetPositionY" />             <result column="offset_positionx" jdbcType="INTEGER" property="offsetPositionX" />             <result column="suuid" jdbcType="VARCHAR" property="uuid" />             <result column="signature_file_id" jdbcType="BIGINT" property="signatureFileId" />             <result column="signing_time" jdbcType="TIMESTAMP" property="signingTime" />             <result column="signed_value" jdbcType="VARCHAR" property="signedValue" />             <result column="signature_num" jdbcType="VARCHAR" property="signatureNum" />             <result column="seal_image_width" jdbcType="INTEGER" property="sealImageWidth" />             <result column="seal_image_height" jdbcType="INTEGER"                 property="sealImageHeight" />             <result column="positiony" jdbcType="INTEGER" property="positiony" />             <result column="positionx" jdbcType="INTEGER" property="positionx" />             <result column="page" jdbcType="INTEGER" property="page" />             <result column="mobile" jdbcType="VARCHAR" property="mobile" />             <result column="sis_entrust" jdbcType="INTEGER" property="isEntrust" />             <result column="is_signed" jdbcType="INTEGER" property="isSigned" />             <result column="sis_deleted" jdbcType="INTEGER" property="isDeleted" />         </collection>     </resultMap>

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

<!-- 新的合同查询方法 --> <select id="seleconinfo" resultMap="selectconinfo"     parameterType="map">     select * from (select * from(select count(contract.id)     as     snum,contract.id from contract inner join signature on     contract.id=signature.contract_id and signature.is_signed=1) as a     inner join (select count(signature.contract_id) as cnum,contract_id     from contract inner join signature on     contract.id=signature.contract_id) as b     on a.id=b.contract_id) as c     inner join contract where     c.contract_id=contract.id     <include refid="where_Search_DocNum"></include>     ORDER BY contract.id     DESC limit     #{startIndex},#{pageSize}; </select>

1 2 3 4 5 6 7

<!-- NEW合同模糊查询判断条件 -->     <sql id="where_Search_DocNum">         <if test="contract.docNum != null">             and doc_num LIKE             CONCAT('%',#{contract.docNum,jdbcType=VARCHAR},'%')         </if>     </sql>

contract 为java 传入的对象名

1 2 3 4 5 6

<insert id="insertPojoUser" parameterType="com.yjm.entry.PojoUser"     useGeneratedKeys="true" keyProperty="id">     insert into pojouser(pojouser_username,pojouser_password,pojouser_desinfo)     values(#{username},#{password},#{desinfo}); </insert>

插入一条数据

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

private static void test2() {     InputStream is = TestDa.class             .getResourceAsStream("/mybaties-config.xml");     SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()             .build(is);     SqlSession sqlsession = sqlSessionFactory.openSession();     PojoUserMapper pojoUserMapper = sqlsession             .getMapper(PojoUserMapper.class);     PojoUser pojouser = new PojoUser();     pojouser.setUsername("username");     pojouser.setPassword("password");     int i = pojoUserMapper.insertPojoUser(pojouser);     System.out.println(i);     System.out.println(pojouser.getId());     sqlsession.commit(); }

数据结果为:
1
7

插入数据的行数 和 该条记录的ID