mybatis数据操作(一)

最新推荐文章于 2022-12-14 20:39:24 发布

Tw368WJZ

最新推荐文章于 2022-12-14 20:39:24 发布

阅读量289

点赞数

分类专栏： java web

本文链接：https://blog.csdn.net/Tw368WJZ/article/details/81123111

版权

java web 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

mybatis数据操作

1.前期准备

1.基本jar包
log4j-1.2.17.jar
mybatis-3.2.7.jar
mysql-connector-java-5.1.39.jar
2.数据文件如:
db.properties
jdbc.user=root
jdbc.password=123456
jdbc.jdbcUrl=jdbc:mysql://127.0.0.1:3306/mytext1
#jdbc.jdbcUrl=jdbc:mysql://212.64.11.14:3306/mytext1
jdbc.driverClass=com.mysql.jdbc.Driver

jdbc.initPoolSize=5
jdbc.maxPoolSize=10

2.mybatis基本配置

Configuration.xml

<!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
// 连接数据库文件
  <properties resource="db.properties"></properties>

  <environments default="development">
    <environment id="development">

      <transactionManager type="JDBC">
      </transactionManager>
      <dataSource type="UNPOOLED">
        <property name="driver" value="${jdbc.driverClass}"/>
        <property name="url" value="${jdbc.jdbcUrl}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
      </dataSource>
    </environment>
  </environments>
  -- 关系映射文件
  <mappers>
    <mapper resource="com/lanou/entity/User.xml" />
  </mappers>

</configuration>

3.实体类

User.java

// 属性名要与数据库一致
public class User {
    private int id;
    private String name;
    private String sex;
    private String address;
    private String phone;
    private int age;
    private String password;
    public int getId() {
        return id;
    }.......

4.实体类映射

User.xml

// 要与实体类是同级目录
<?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="Users">
// 映射类别名
    <select id="selectAll" resultType="com.lanou.entity.User">
        select * from user  //sql语句
    </select>
</mapper>

5.测试类mybatisTest.java


public class mybatisTest {
    public static void main(String[] args) throws IOException {
        //1.读取配置文件
        Reader reader = Resources.getResourceAsReader("Configuration.xml");
        //2.获取session工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        //3.获取session对象
        SqlSession session = sqlSessionFactory.openSession();
        //4.从session中执行SQL语句获取结果  格式为"实体类映射区别名.映射类别名" ()
        List<User> selectList = session.selectList("Users.selectAll");
        //5.打印执行结果
        System.out.println(selectList);
    }