mybaties配置文件详解

<?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>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="${driverClass}"/>
				<property name="url" value="${url}"/>
				<property name="username" value="${username}"/>
				<property name="password" value="${password}"/>
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/sxt/model/UserMapper.xml"/>
	</mappers>
</configuration>

db.propertis的文件

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybaties
username=root
password=mysqladmin

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.sxt.mapper.PictureInfosMapper">
	<insert id="add" parameterType="com.sxt.model.PictureInfos">
		insert into pictureinfos (picturePath,userId) values(#{picturePath},1)
	</insert>
	<delete id="delete" parameterType="com.sxt.model.PictureInfos">
		delete from pictureInfos where pictureId=#{pictureId}
	</delete>
</mapper>