您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

02-mybatis的多表操作-订单环境代码实现

发布时间：2025-02-01 16:21:19编辑：雪饮阅读（）

新建一个新的module，然后将上篇中的module的mapper接口及映射文件xml拷贝到新的module后将拷贝后的mapper接口及映射文件中的对应标签都清空。以及package如果改变了就也修改下package
package sp28.dao;
public interface UserMapper {
}
<?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="sp28.dao.UserMapper">

</mapper>
然后新建一个order的实体如：
package sp28.domain;

import java.util.Date;

public class Order {
    private int id;
    private Date ordertime;
    private double total;
    //当前订单属于哪一个用户
    private User user;

    public int getId() {
        return id;
    }

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

    public Date getOrdertime() {
        return ordertime;
    }

    public void setOrdertime(Date ordertime) {
        this.ordertime = ordertime;
    }

    public double getTotal() {
        return total;
    }

    public void setTotal(double total) {
        this.total = total;
    }

    public User getUser() {
        return user;
    }

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


}
以及OrderMapper
package sp28.dao;

public interface OrderMapper {
}
以及创建OrderMapper.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="sp28.dao.OrderMapper">
</mapper>
与前番的UserMapper.xml是同路径，如D:\os\SpringWebApp\SpringProject2Module8\src\main\resources\sp28\mapper
UserMapper.xml也是从上一个module拷贝过来修改的
<?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="sp28.dao.UserMapper">

</mapper>
以及UserMapper.java:
package sp28.dao;
public interface UserMapper {
}
pom依赖照样和上篇一样
<dependencies>
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.32</version>
  </dependency>
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.6</version>
  </dependency>
  <dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
  </dependency>
  <dependency>
    <groupId>log4j</groupId>
    <artifactId>log4j</artifactId>
    <version>1.2.17</version>
  </dependency>
  <dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>3.7.5</version>
  </dependency>
  <dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9.1</version>
  </dependency>
</dependencies>
jdbc.properties、log4j.properties、sqlMapConfig.xml都从上篇中拷贝过来。
但sqlMapConfig.xml中的mappers里面需要新增我们的OrderMapper
<mappers>
    <mapper resource="sp28/mapper/UserMapper.xml"></mapper>
    <mapper resource="sp28/mapper/OrderMapper.xml"></mapper>
</mappers>
还有类型处理器和类型别名用的package路径也确认修改下
<typeAliases>
    <typeAlias type="sp28.domain.User" alias="user"/>
</typeAliases>

<typeHandlers>
    <typeHandler handler="sp28.handler.DateTypeHandler"/>
</typeHandlers>
最后创建数据表
CREATE TABLE `orders`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordertime` datetime NULL DEFAULT NULL,
  `total` double NULL DEFAULT NULL,
  `uid` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
至此，环境搭建差不多了。