构建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>