mybatis学习及上传git

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.9</version>
</dependency>
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>2.0.7</version>
</dependency>
###########################################
<build>
    <resources>
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.xml</include>
            </includes>
            <filtering>true</filtering>
        </resource>
    </resources>
</build>

mapper namespace="com.spring.www.DAO.BookDAO">

<select id="queryAll" resultType="Book">

<select id="queryAllByIf" resultType="Book" parameterType="String">
	select * from book where true
    <if test="Bname!=null and Bname!=''">
    	and Bname like concat('%',#{name},'%')
    </if>
</select>

Preparing: select * from book where true and Bname like concat('%',?,'%')

<select id="querryAllByforeach" parameterType="List" resultType="Book">
	select * from book where Bisdn in
    <foreach item="item" index="index" collection="list" open="(" separator=","close=")">
    	 #{item}
    </foreach>
</select>

==> Preparing: select * from book where Bisdn in ( ? , ? )
==> Parameters: 001(String), 002(String)

<select id="querryAllByBind" parameterType="Book" resultType="Book">
	<bind name="paran_name" value="'%'+Bname+'%'"/>
    	select * from book where Bname like #{paran_name}
</select>

select * from book where Bname like ?

<!--配置事务管理器-->
<bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
      p:dataSource-ref="dataSource"/>

import com.spring.www.Business.SaleService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.testng.AbstractTransactionalTestNGSpringContextTests;
import org.testng.annotations.Test;

@ContextConfiguration("classpath*:database-context.xml")
public class TransactionTest extends AbstractTransactionalTestNGSpringContextTests {
    @Autowired
    SaleService service;
    @Test
    public void transTest(){
        service.onSale(0.5f);
    }
}

bushgit init
 git remote add origin 远端仓库地址