1.maven>next>finsh
2.在pom.xml中加入打包方式
3.导入下面4个依赖
<dependencies> <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> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.12</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.11</version> <scope>test</scope> </dependency> </dependencies>
4.准备数据库数据,准备一张用户表。
CREATE TABLE `user`(
`id` int(11) not null auto_increment,
`usernaem` VARCHAR(32) not null COMMENT '用户名称',
`birthday` datetime DEFAULT NULL comment '生日',
`sex` char(1) DEFAULT NULL COMMENT '性别',
`adress` VARCHAR(256) DEFAULT NULL COMMENT '地址',
primary KEY (`id`)
)ENGINE=INNODB DEFAULT charset=utf8;
insert into `user` (`id`,`username`,`birthday`,`sex`,`adress`)VALUES(41,'老王', '2018-02-27','男','麻布新村')
5.创建一个实体类,与数据库中表对应的实体类,同时实现序列化接口,还有生成get,set方法,和tostring方法。
6.创建一个dao接口和一个dao的包,里面写方法
7.在resources目录下新建mybatis的主配置文件,同时做相关配置
<?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">
<?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"> <environment id="mysql"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis_test"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/cskaoyan/dao/IUserDao.xml"/> </mappers> </configuration>
8.创建包结构,在resource目录下,注意与上面的文件夹对应,这个很重要,在里面创建配置对应的配置文件。
<?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">
9.在配置文件中写sql
10.总结一下步骤
11.注意事项
12.创建测试类
13.重要内容,测试类里面
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml"); SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = builder.build(in); SqlSession session = factory.openSession(); IUserDao userDO = session.getMapper(IUserDao.class); List<User> users = userDO.findAll(); for (User user : users) { System.out.println(user); } session.close(); in.close();
14.可以运行了,如果报错,加上下面的内容,resultType是指定查询的结果封装到的地方。
15.出现如下结果表明,环境搭建成功