构建Mybatis项目(一)

 

构建MyBatis项目

 

建库，建表
库名:test,表名people,结构如下:
id,userName,passWord,realName;

创建JAVA项目

结构如下:

Org.test.mybatis.mapper

Org.test.mybatis.model

Org.test.mybatis.root

第一个包我们用来放映射操作类，第二个包用来放数据表映射实体对象，第三个包用来写包含main方法的测试类

添加依赖文件(mybatis.3.0.5需要javassist.jar,mybatis.3.0.4不需要)

javassist-3.9.0.GA.jar

mybatis-3.0.5-SNAPSHOT.jar

mysql-connector-java-5.1.14-bin.jar

创建配置文件(src目录下)

<?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="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/test" />
<property name="username" value="root" />
<property name="password" value="root" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="org/test/mybatis/mapper/PeopleMapper.xml" />
</mappers>
</configuration> 

 

创建映射文件

<?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.test.mybatis.mapper.PeopleMapper"> 
</mapper>