mybatis基于xml实现简单的一对一，一对多（用户和账户）

最新推荐文章于 2024-04-19 12:24:42 发布

CenZn

最新推荐文章于 2024-04-19 12:24:42 发布

阅读量602

点赞数

分类专栏： mybatis 文章标签： xml

本文链接：https://blog.csdn.net/qq_43589241/article/details/105798311

版权

mybatis 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

文章目录

项目目录
导入maven坐标
创建account表
创建user表
实体类
- 账户类Acount.java
- 用户类User.java
持久层
- 账户类的持久层接口IAccount.java
- 用户类的持久层接口IUser.java
映射xml文件
- 账户类的映射xml文件IAccount.xml
- 用户类的映射xml文件IUser.xml
mybatis的配置xml文件
测试

项目目录

在这里插入图片描述

导入maven坐标

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.48</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

创建account表

DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `date` datetime NULL DEFAULT NULL,
  `money` float(255, 0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`, `uid`) USING BTREE,
  INDEX `a_uid`(`uid`) USING BTREE,
  CONSTRAINT `a_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES (1, 1, '2020-04-27 16:25:57', 100);
INSERT INTO `account` VALUES (2, 1, '2020-04-27 16:26:02', 1000);
INSERT INTO `account` VALUES (3, 2, '2020-04-27 16:26:05', 200);
INSERT INTO `account` VALUES (4, 2, '2020-04-27 16:26:08', 2000);

创建user表

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'aaa');
INSERT INTO `user` VALUES (2, 'bbb');
INSERT INTO `user` VALUES (3, 'ccc');
INSERT INTO `user` VALUES (4, 'ddd');
INSERT INTO `user` VALUES (5, 'eee');

实体类

账户类Acount.java

package com.cenzn.domain;

import java.util.Date;

public class Account {

    private Integer id;
    private Integer uid;
    private Date date;
    private Float money;

    //从表实体应该包含一个主表实体的对象引用
    private User user;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public Date getDate() {
        return date;
    }

    public void setDate(Date date) {
        this.date = date;
    }

    public Float getMoney() {
        return money;
    }

    public void setMoney(Float money) {
        this.money = money;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    @Override
    public String toString() {
        return "Account{" +
                "id=" + id +
                ", uid=" + uid +
                ", date=" + date +
                ", money=" + money +
                '}';
    }
}

用户类User.java

package com.cenzn.domain;

import java.util.List;

public class User {

    private Integer id;
    private String username;
    
    == //一对多关系映射：主表方法应该包含一个从表方的集合引用 ==
    private List<Account> accounts;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public List<Account> getAccounts() {
        return accounts;
    }

    public void setAccounts(List<Account> accounts) {
        this.accounts = accounts;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                '}';
    }
}

持久层

账户类的持久层接口IAccount.java

package com.cenzn.dao;

import com.cenzn.domain.Account;

import java.util.List;

public interface IAccountDao  {

    List<Account> findAccountAll();

}

用户类的持久层接口IUser.java

package com.cenzn.dao;

import com.cenzn.domain.User;

import java.util.List;

public interface IUserDao{

    List<User> findUserAll();

}

映射xml文件

账户类的映射xml文件IAccount.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="com.cenzn.dao.IAccountDao">
    <!--     id:resultMap标签的标识  type:返回值的全限定类名-->
    <resultMap id="AccountMap" type="com.cenzn.domain.Account">
        <!--    property:需要映射到JavaBean的属性名称-->
        <!--    column 数据表的列名或者标签别名-->
        <id column="aid" property="id"/>
        <result column="uid" property="uid"/>
        <result column="date" property="date"/>
        <result column="money" property="money"/>
        <association property="user" column="uid">
            <id column="id" property="id"/>
            <result column="username" property="username"/>
        </association>
    </resultMap>

    <select id="findAccountAll" resultMap="AccountMap">
        select u.* ,a.id as aid ,a.uid,a.date ,a.money from account a ,user u where a.uid = u.id
    </select>
</mapper>

用户类的映射xml文件IUser.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="com.cenzn.dao.IUserDao">


<!--     id:resultMap标签的标识  type:返回值的全限定类名-->
    <resultMap id="UserMap" type="com.cenzn.domain.User">
<!--    property:需要映射到JavaBean的属性名称-->
<!--    column 数据表的列名或者标签别名-->
        <id column="id" property="id"/>
        <result column="username" property="username"/>
<!--        collection 是用于建立一对多中集合属性的对应关系-->
<!--        ofType 用于指定集合元素的数据类型-->
        <collection property="accounts" ofType="com.cenzn.domain.Account">
            <id column="aid" property="id"/>
            <result column="uid" property="uid"/>
            <result column="date" property="date"/>
            <result column="money" property="money"/>
        </collection>
    </resultMap>

    <select id="findUserAll" resultMap="UserMap">
        select * from user u left outer join account a on a.uid = u.id
    </select>

</mapper>

mybatis的配置xml文件

<?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:///mybatis"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper class="com.cenzn.dao.IAccountDao"/>
        <mapper class="com.cenzn.dao.IUserDao"/>
    </mappers>
</configuration>

测试

测试一对一（每个账户只有一个用户）

    @Test
    public void findAccountTest() throws IOException {

        InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");

        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

        SqlSessionFactory factory = builder.build(in);

        SqlSession session = factory.openSession(true);

        IAccountDao accountDao = session.getMapper(IAccountDao.class);

        List<Account> accounts = accountDao.findAccountAll();

        for (Account account : accounts){
            System.out.println("-----------每个account的信息------------");
            System.out.println(account);
            System.out.println(account.getUser());
        }
    }

运行结果

在这里插入图片描述

测试一对多（一个用户可以有多个账户）

    @Test
    public void findUserTest() throws IOException {

        InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");

        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

        SqlSessionFactory factory = builder.build(in);

        SqlSession session = factory.openSession(true);

        IUserDao UserDao = session.getMapper(IUserDao.class);

        List<User> users = UserDao.findUserAll();

        for (User user : users){
            System.out.println("---------------------每个用户拥有的账户---------------------");
            System.out.println(user);
            System.out.println(user.getAccounts());
        }
    }

运行结果

在这里插入图片描述

CenZn

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mybatis基于xml实现简单的一对一，一对多（用户和账户）

文章目录项目目录导入maven坐标创建account表创建user表实体类账户类Acount.java用户类User.java持久层账户类的持久层接口IAccount.java用户类的持久层接口IUser.java映射xml文件账户类的映射xml文件IAccount.xml用户类的映射xml文件IUser.xmlmybatis的配置xml文件测试测试一对一（每个账户只有一个用户）运行结果测试一对多...
复制链接

扫一扫