MyBatis：MyBatis的一些配置

MyBatis的一些配置

---

XXXMapper.xml

这个文件创建在【resources】文件夹下。

数据库处理文件的头部信息
<select id="selectBlog" resultType="Blog"> select * from Blog where id = #{id} </select>是示例的数据库操作

<?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="org.mybatis.example.BlogMapper">

	 <!--SQL执行语句-->
	 <select id="selectBlog" resultType="Blog">
	 	select * from Blog where id = #{id}
	 </select>
 
</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="com.mybatis.mapper.UserMapper">

    <!--接口UserMapper中要有insertUser方法-->
    <insert id="insertUser">
        insert into t_user values(null,'admin',20,'123@qq.com')
    </insert>
</mapper>

---

mybatis-config.xml

这个文件创建在【resources】文件夹下。

MyBatis配置文件
记得在
<property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/>处
添加数据库驱动和修改数据库连接信息

<?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>
  <!--environments：连接数据库的环境-->
 	<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="${username}"/>
			 	<property name="password" value="${password}"/>
		 	</dataSource>
 		</environment>
	 </environments>
 
	  <!--映射文件，根据实际修改-->
	 <mappers>
	 	<mapper resource="org/mybatis/example/BlogMapper.xml"/>
	 </mappers>
 
</configuration>

示例：

<?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>
 <!--environments：连接数据库的环境-->
 <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:3306/mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    
    <!--引入映射文件-->
    <mappers>
    <!--注意：UserMapper.xml要与接口UserMapper.java的名称一致-->
       	<mapper resource="myMappers/UserMapper.xml"/>
    </mappers>
    
</configuration>