config的约束
<?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">
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">
最后附上mybatis的maven依赖
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
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>
<!-- 配置环境-->
<environments default="mysql">
<!-- 配置mysql的环境-->
<environment id="mysql">
<!-- 配置事务-->
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<!-- 配置连接池-->
<property name="driver" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql:///db1"></property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</dataSource>
</environment>
</environments>
<!--配置映射文件-->
<mappers>
<!-- xml文件方式 -->
<!-- <mapper resource="com/jlyk/dao/UserDao.xml"/>-->
<!-- 注解方式-->
<mapper class="com.jlyk.dao.UserDao"/>
</mappers>
</configuration>
Mapper 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">
<!--namespace填写dao接口-->
<mapper namespace="com.jlyk.dao.UserDao" >
<!-- id里填写方法 ,resultType 写实体类的全限定类名,封装某对象 select 标签里写sql语句-->
<select id="findAll" resultType="com.jlyk.domain.User">
select * from user
</select>
</mapper>
注解方式
public interface UserDao {
@Select("select * from user")
List<User> findAll();
}