[置顶] mybatis总结(分文件类型)

Mybatis项目总结

几个整合的注意事项：①配置熟路库连接参数文件时，注意文件结尾是properties，同时每一个属性值的末尾千万不要有空格，不然读取文件值时时可能这样的 user="root " ②与spring整合时，如果使用c3p0连接池，记住不仅要导入c3p0的jar包，还要导入mchange-commons-java.jar ③为了防止中文传入mysql查找时的编码错误，建议使用jdbc:mysql:///test?characterset=utf-8

一、最重要的配置文件mapper.xml(与POJO的Mapper接口相连)

1、普通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="test">




<select id="findUserById" parameterType="int" resultType="com.mybatis.entity.User">
SELECT * FROM user WHERE id=#{id}
</select>

<select id="findUserByName" parameterType="java.lang.String" resultType="com.mybatis.entity.User">
SELECT * FROM user WHERE name LIKE '%${value}%'
</select>

<select id="findUsers" resultType="com.mybatis.entity.User">
SELECT * FROM user
</select>


<insert id="addUser" parameterType="com.mybatis.entity.User">











insert into user(id,name,nickname) value(#{id}, #{name}, #{nickname})


</insert>


<delete id="deleteUser" parameterType="java.lang.String">
delete from user where id = #{id}
</delete>


<update id="updateUser" parameterType="com.mybatis.entity.User">
update user set name = #{name}, nickname = #{nickname} where id = #{id}
</update>

</mapper>

2、mapper.xml(mapper接口其实就是dao接口,二者放在同一个目录下，而且方法的大部分定义通过配置文件来约束)
<?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.mybatis.dao.mapper.userMapper">




<resultMap type="user" id="userResultMap">









<collection property="users" ofType="cn.....User">

<id column="" property="" />
<result column="" property="" />
</collection>
</resultMap>


<sql id="user_where">
<if test="userCustomer.name != null and userCustomer.username != ''">
and user.name=#{userCustomer.name}
</if>
<if test="userCustomer.nickname != null and userCustomer.nickname != ''">
and user.nickname =#{userCustomer.nickname }
</if>
</sql>

<select id="findUserList3" parameterType="com.mybatis.dao.po.UserQuertVo"
resultType="com.mybatis.dao.po.UserCustomer">
SELECT * FROM user
<where>
<foreach collection=""></foreach>
<include refid="user_where"></include>
</where>
</select>




<select id="findUserList" parameterType="com.mybatis.dao.po.UserQuertVo"
resultType="com.mybatis.dao.po.UserCustomer">
SELECT * FROM user WHERE user.name = #{userCustomer.name} and user.nickname
= #{userCustomer.nickname}
</select>


<select id="findUserById" parameterType="String" resultType="User" >
SELECT * FROM user WHERE id=#{id}
</select>


<select id="findUserList2" parameterType="com.mybatis.dao.po.UserQuertVo"
resultType="com.mybatis.dao.po.UserCustomer">
SELECT * FROM user
<where>
<if test="userCustomer.name != null and userCustomer.username != ''">
and user.name=#{userCustomer.name}
</if>
<if test="userCustomer.nickname != null and userCustomer.nickname != ''">
and user.nickname =#{userCustomer.nickname }
</if>
</where>
</select>


<resultMap type="" id="">


<association property=""></association>
<collection property=""></collection>
</resultMap>


</mapper>

二、SqlMapConfig.xml的几个知识点(整合Spirng的时候，通过批量扫描spring的配置文件的mapper批量扫描可以不配置任何东西)

<?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="db.properties">


</properties>





<typeAliases>
<typeAlias type="com.mybatis.entity.User" alias="User"/>
</typeAliases>


<environments default="development">
<environment id="development">

<transactionManager type="JDBC" />



<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost/test" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>





</environment>
</environments>



<mappers>







<mapper class="com.mybatis.dao.mapper.userMapper"/>



</mappers>


<settings>

<setting name="lazyKoadingEbabled" value="true"/>

<setting name="aggressiveLazyLoading" value=""false/>
</settings>



</configuration>

三、与Spirng的applicationContext.xml的整合注意

<?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:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">

<context:property-placeholder location="classpath:db.properties" />

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="${c3p0.driver}" />
<property name="jdbcUrl" value="${c3p0.url}" />
<property name="user" value="${c3p0.username}" />
<property name="password" value="${c3p0.password}" />
</bean>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="configLocation" value="Mybatis/SqlMapConfig.xml" />

<property name="dataSource" ref="dataSource" />
</bean>





<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

<property name="basePackage" value="cn.edu.ssm.mapper"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>

</beans>

备注附上log4j.properties的配置信息
# Global logging configuration
#å¼åç¯å¢ä¸æ¥å¿çº§å«è¦è®¾ç½®æDEBUGï¼çäº§åå®è®¾ç½®æInfo/error
log4j.rootLogger=DEBUG, stdout
# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

秒客网

[置顶] mybatis总结(分文件类型)

Mybatis项目总结

一、最重要的配置文件mapper.xml(与POJO的Mapper接口相连)

二、SqlMapConfig.xml的几个知识点(整合Spirng的时候，通过批量扫描spring的配置文件的mapper批量扫描可以不配置任何东西)

三、与Spirng的applicationContext.xml的整合注意

相关文章

[置顶] mybatis总结(分文件类型)

Mybatis项目总结

一、最重要的配置文件mapper.xml(与POJO的Mapper接口相连)

二 、SqlMapConfig.xml的几个知识点(整合Spirng的时候，通过批量扫描spring的配置文件的mapper批量扫描可以不配置任何东西)

三、与Spirng的applicationContext.xml的整合注意

相关文章

二、SqlMapConfig.xml的几个知识点(整合Spirng的时候，通过批量扫描spring的配置文件的mapper批量扫描可以不配置任何东西)