创建一个Mybatis工程

x33g5p2x  于2022-02-07 转载在 其他  
字(3.3k)|赞(0)|评价(0)|浏览(313)

1:首先,设计好框架:

2:写工具类:

  1. package com.ftz.Demo.utils;
  2. import org.apache.ibatis.io.Resources;
  3. import org.apache.ibatis.session.SqlSession;
  4. import org.apache.ibatis.session.SqlSessionFactory;
  5. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  6. import java.io.IOException;
  7. import java.io.InputStream;
  8. public class MybatisUtil {
  9. private static SqlSessionFactory sqlSessionFactory;
  10. static {
  11. try {
  12. String resource = "mybatis-config.xml";
  13. InputStream inputStream = Resources.getResourceAsStream(resource);
  14. sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  15. } catch (IOException e) {
  16. e.printStackTrace();
  17. }
  18. }
  19. public static SqlSession getSqlSession(){
  20. return sqlSessionFactory.openSession();
  21. }
  22. }

3:配置文件:

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6. <environments default="development">
  7. <environment id="development">
  8. <transactionManager type="JDBC"/>
  9. <dataSource type="POOLED">
  10. <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
  11. <property name="url"
  12. value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT%2B8&amp;useSSL=false"/>
  13. <property name="username" value="root"/>
  14. <property name="password" value="root"/>
  15. </dataSource>
  16. </environment>
  17. </environments>
  18. <mappers>
  19. <mapper resource="com/ftz/Demo/dao/userMapper.xml"/>
  20. </mappers>
  21. </configuration>

4:写实体类:

  1. package com.ftz.Demo.po;
  2. import lombok.Data;
  3. @Data
  4. public class User {
  5. private int id; //id
  6. private String name; //姓名
  7. private String pwd; //密码
  8. }

5:写接口:

  1. package com.ftz.Demo.dao;
  2. import com.ftz.Demo.po.User;
  3. import java.util.List;
  4. public interface UserMapper {
  5. List<User> getUserList();
  6. }

6:写Mapper.xml:

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.ftz.Demo.dao.UserMapper">
  6. <select id="getUserList" resultType="com.ftz.Demo.po.User">
  7. select * from mybatis.user
  8. </select>
  9. </mapper>

7:测试:

  1. package com.ftz.Demo.dao;
  2. import com.ftz.Demo.po.User;
  3. import com.ftz.Demo.utils.MybatisUtil;
  4. import org.apache.ibatis.session.SqlSession;
  5. import org.junit.Test;
  6. import java.util.List;
  7. public class UserDaoTest {
  8. @Test
  9. public void test() {
  10. SqlSession sqlSession = MybatisUtil.getSqlSession();
  11. UserMapper mapper = sqlSession.getMapper(UserMapper.class);
  12. List<User> userList = mapper.getUserList();
  13. for (User user : userList) {
  14. System.out.println(user);
  15. }
  16. sqlSession.close();
  17. }
  18. }

注意:配置文件的过滤:在pom里面写:

  1. <build>
  2. <resources>
  3. <resource>
  4. <directory>src/main/java</directory>
  5. <includes>
  6. <include>**/*.xml</include>
  7. <include>**/*.properties</include>
  8. </includes>
  9. <filtering>true</filtering>
  10. </resource>
  11. <resource>
  12. <directory>src/main/resources</directory>
  13. <includes>
  14. <include>**/*.xml</include>
  15. <include>**/*.properties</include>
  16. </includes>
  17. <filtering>true</filtering>
  18. </resource>
  19. </resources>
  20. </build>

相关文章