MyBatis入门经典教程
-
创建一个新的maven项目工程
-
导入所需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>8.0.20</version> </dependency> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.12</version> </dependency>
-
创建实体类和对用的DAO接口
-
在Resourc文件夹下创建与DAO对应的映射文件
-
创建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> <typeAliases> <package name="com.uxteam.domain"/> </typeAliases> <environments default="mysql"> <environment id="mysql"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://192.168.38.201:3306/DBMyBatis"/> <property name="username" value="root"/> <property name="password" value="***"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/uxteam/dao/IUserDao.xml"/> </mappers> </configuration>
-
测试效果
InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml"); SqlSessionFactoryBuilder sbuilder = new SqlSessionFactoryBuilder(); SqlSessionFactory factory = sbuilder.build(inputStream); SqlSession session = factory.openSession(); IUserDao dao = session.getMapper(IUserDao.class);