1823803452testSpring

applicationContext：
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.2.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    
    
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >
    	<property name="location" value="classpath:database.properties"></property>
    </bean>
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    	<property name="driverClassName" value="${driver}"></property>	
    	<property name="url" value="${url}"></property>
    	<property name="username" value="${username}"></property>
    	<property name="password" value="${password}"/>
    </bean>
    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    	<property name="dataSource" ref="dataSource"></property>
    	<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>
    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
   		<property name="basePackage" value="dao"/>
    </bean>
    
    <context:component-scan base-package="service"/>
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	<property name="dataSource" ref="dataSource"></property>
    </bean>
    
    <tx:annotation-driven/>
</beans>


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>
   	 <!--类型别名 -->
   	 <typeAliases>
      	  <package name="entity" />
    	</typeAliases>
	</configuration>

database.properties：
	driver=com.mysql.jdbc.Driver
	url=jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&amp;characterEncoding=utf-8
	username=root
	password=123456

mapper:

	<?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="cn.smbms.dao.bill.BillMapper">
		<resultMap type="cn.smbms.pojo.Bill" id="billList">
			<result property="id" column="id"/>
			<result property="billCode" column="billCode"/>
			<result property="productName" column="productName"/>
			<result property="providerName" column="proName"/>
			<result property="isPayment" column="isPayment"/>
			<result property="creationDate" column="creationDate"/>
		</resultMap>
		<!-- 查询订单列表 -->
		<select id="getBillList" resultMap="billList">
			select b.*,p.proName from smbms_bill b,smbms_provider p 
				where b.productName like CONCAT ('%',#{productName},'%') 
					and b.providerId = #{providerId}
					and b.isPayment = #{isPayment}
					and b.providerId = p.id
		</select>
	
	</mapper>