• MyBatis框架 注解的形式开发

    目录

    1.注解开发项目整体框架（与xml形式开发 在resource里面 没了xxxmapper.xml）

    2.配置资源

    (1)jdbc.properties

     (2)SqlMapConfig.xml

    3.实体类

    (1)User

    (2)Order

    (3)Role

    4.SqlSessionutils 工具类

    5.mapper 接口

    （1）UserMapper

    （2）OrderMapper

    （3）RoleMapper

    6.数据库信息（创建并使用数据库 然后先创建user表 在创建其他的）

    7.测试

    （1）一对一查询，查询一个订单，与此同时查询出该订单所属的用户

    测试代码

    （2）一对多查询，查询一个用户，与此同时查询出该用户具有的订单

     测试语句

    （3）多对多查询 ，查询所有用户，同时查询出该用户的所有角色

    sql语句

    测试语句

    1.注解开发项目整体框架（与xml形式开发 在resource里面 没了xxxmapper.xml）

    * @Insert：实现新增，代替了<insert></insert>
    * @Delete：实现删除，代替了<delete></delete>
    * @Update：实现更新，代替了<update></update>
    * @Select：实现查询，代替了<select></select>
    * @Result：实现结果集封装，代替了<result></result>
    * @Results：可以与@Result 一起使用，封装多个结果集，代替了<resultMap></resultMap>
    * @One：实现一对一结果集封装，代替了<association></association>
    * @Many：实现一对多结果集封装，代替了<collection></collection>

    2.配置资源

    (1)jdbc.properties

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/mydb?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=true
    3. jdbc.username=root
    4. jdbc.password=root

     (2)SqlMapConfig.xml

    1. <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    2.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    3. <configuration>
    4.     <!--     加载外部的配置文件-->
    5.     <properties resource="jdbc.properties"></properties>
    6.     <settings>
    7.         <!--  控制台  打印sql       -->
    8.         <setting name="logImpl" value="STDOUT_LOGGING"/>
    9.  
    10.     </settings>
    11.  
    12.  
    13.     <!--    别名配置-->
    14.     <typeAliases>
    15.         <typeAlias type="com.qiku.pojo.User" alias="user"></typeAlias>
    16.         <typeAlias type="com.qiku.pojo.Order" alias="order"></typeAlias>
    17.         <typeAlias type="com.qiku.pojo.Role" alias="role"></typeAlias>
    18.     </typeAliases>
    19. <!--    配置数据库环境 default 可以自定义-->
    20.     <environments default="MYSQL">
    21.         <environment id="MYSQL">
    22.             <transactionManager type="JDBC"></transactionManager>
    23.             <dataSource type="POOLED">
    24.                 <property name="driver" value="${jdbc.driver}"/>
    25.                 <property name="url" value="${jdbc.url}"/>
    26.                 <property name="username" value="${jdbc.username}"/>
    27.                 <property name="password" value="${jdbc.password}"/>
    28.             </dataSource>
    29.         </environment>
    30.     </environments>
    31. <!--    核心配置文件加载OrderMapper.xml-->
    32.     <mappers>
    33. <!--        resource 属性实现-->
    34. <!--        <mapper resource="com/qiku/mapper/UserMapper.xml"></mapper>-->
    35. <!--        <mapper resource="com/qiku/mapper/OrderMapper.xml"></mapper>-->
    36. <!--        <mapper resource="com/qiku/mapper/RoleMapper.xml"></mapper>-->
    37. <!--        //用包名-->
    38.         <package name="com.qiku.mapper"/>
    39.     </mappers>
    40.  
    41. </configuration>

    3.实体类

    (1)User

    1. package com.qiku.pojo;
    2.  
    3. import java.io.Serializable;
    4. import java.util.Date;
    5. import java.util.List;
    6.  
    7. /**
    8.  * 2022/6/16 20:46
    9.  *
    10.  * @author yrc
    11.  * @version MybatisTest
    12.  */
    13. public class User implements Serializable {
    14.     private Integer id;
    15.     private String username;
    16.     private Date birthday;
    17.     private String sex;
    18.     private String address;
    19.  
    20.     public User(String username, Date birthday, String sex, String address) {
    21.         this.username = username;
    22.         this.birthday = birthday;
    23.         this.sex = sex;
    24.         this.address = address;
    25.     }
    26.  
    27.     // 一对多
    28.     private List<Order> orderList;
    29.  
    30.     private List<Role> roleList;
    31.  
    32.     public List<Role> getRoleList() {
    33.         return roleList;
    34.     }
    35.  
    36.     public void setRoleList(List<Role> roleList) {
    37.         this.roleList = roleList;
    38.     }
    39.  
    40.     public List<Order> getOrderList() {
    41.         return orderList;
    42.     }
    43.  
    44.     public void setOrderList(List<Order> orderList) {
    45.         this.orderList = orderList;
    46.     }
    47.  
    48.     public Integer getId() {
    49.         return id;
    50.     }
    51.  
    52.     public void setId(Integer id) {
    53.         this.id = id;
    54.     }
    55.  
    56.     public String getUsername() {
    57.         return username;
    58.     }
    59.  
    60.     public void setUsername(String username) {
    61.         this.username = username;
    62.     }
    63.  
    64.     public Date getBirthday() {
    65.         return birthday;
    66.     }
    67.  
    68.     public void setBirthday(Date birthday) {
    69.         this.birthday = birthday;
    70.     }
    71.  
    72.     public String getSex() {
    73.         return sex;
    74.     }
    75.  
    76.     public void setSex(String sex) {
    77.         this.sex = sex;
    78.     }
    79.  
    80.     public String getAddress() {
    81.         return address;
    82.     }
    83.  
    84.     public void setAddress(String address) {
    85.         this.address = address;
    86.     }
    87.  
    88.     public User() {
    89.     }
    90.  
    91.     public User(Integer id, String username, Date birthday, String sex, String address, List<Order> orderList) {
    92.         this.id = id;
    93.         this.username = username;
    94.         this.birthday = birthday;
    95.         this.sex = sex;
    96.         this.address = address;
    97.         this.orderList = orderList;
    98.     }
    99.  
    100.     @Override
    101.     public String toString() {
    102.         return "User{" +
    103.                 "id=" + id +
    104.                 ", username='" + username + '\'' +
    105.                 ", birthday=" + birthday +
    106.                 ", sex='" + sex + '\'' +
    107.                 ", address='" + address + '\'' +
    108.                 ", orderList=" + orderList +
    109.                 ", roleList=" + roleList +
    110.                 '}';
    111.     }
    112. }

    (2)Order

    1. package com.qiku.pojo;
    2.  
    3. import java.io.Serializable;
    4. import java.util.Date;
    5.  
    6. /**
    7.  * 2022/6/21 15:54
    8.  *
    9.  * @author yrc
    10.  * @version Mybatis
    11.  */
    12. public class Order implements Serializable {
    13.     private Integer id;
    14.     private Date orderTime;
    15.     private double money;
    16.  
    17.     // 表示当前订单属于哪个用户
    18.     private User user;
    19.  
    20.     @Override
    21.     public String toString() {
    22.         return "Order{" +
    23.                 "id=" + id +
    24.                 ", orderTime=" + orderTime +
    25.                 ", money=" + money +
    26.                 ", user=" + user +
    27.                 '}';
    28.     }
    29.  
    30.     public Order() {
    31.     }
    32.  
    33.     public Order(Integer id, Date orderTime, double money, User user) {
    34.         this.id = id;
    35.         this.orderTime = orderTime;
    36.         this.money = money;
    37.         this.user = user;
    38.     }
    39.  
    40.     public Integer getId() {
    41.         return id;
    42.     }
    43.  
    44.     public void setId(Integer id) {
    45.         this.id = id;
    46.     }
    47.  
    48.     public Date getOrderTime() {
    49.         return orderTime;
    50.     }
    51.  
    52.     public void setOrderTime(Date orderTime) {
    53.         this.orderTime = orderTime;
    54.     }
    55.  
    56.     public double getMoney() {
    57.         return money;
    58.     }
    59.  
    60.     public void setMoney(double money) {
    61.         this.money = money;
    62.     }
    63.  
    64.     public User getUser() {
    65.         return user;
    66.     }
    67.  
    68.     public void setUser(User user) {
    69.         this.user = user;
    70.     }
    71. }

    (3)Role

    1. package com.qiku.pojo;
    2.  
    3. /**
    4.  * 2022/6/22 9:38
    5.  *
    6.  * @author yrc
    7.  * @version Mybatis
    8.  */
    9. public class Role {
    10.     private  Integer id;
    11.     private  String roleName;
    12.     private  String roleDesc;
    13.  
    14.     @Override
    15.     public String toString() {
    16.         return "Role{" +
    17.                 "id=" + id +
    18.                 ", roleName='" + roleName + '\'' +
    19.                 ", roleDesc='" + roleDesc + '\'' +
    20.                 '}';
    21.     }
    22.  
    23.     public Integer getId() {
    24.         return id;
    25.     }
    26.  
    27.     public void setId(Integer id) {
    28.         this.id = id;
    29.     }
    30.  
    31.     public String getRoleName() {
    32.         return roleName;
    33.     }
    34.  
    35.     public void setRoleName(String roleName) {
    36.         this.roleName = roleName;
    37.     }
    38.  
    39.     public String getRoleDesc() {
    40.         return roleDesc;
    41.     }
    42.  
    43.     public void setRoleDesc(String roleDesc) {
    44.         this.roleDesc = roleDesc;
    45.     }
    46.  
    47.     public Role() {
    48.     }
    49.  
    50.     public Role(Integer id, String roleName, String roleDesc) {
    51.         this.id = id;
    52.         this.roleName = roleName;
    53.         this.roleDesc = roleDesc;
    54.     }
    55. }

    4.SqlSessionutils 工具类

    12.SqlSession 的工具类 获取sqlsession_羊肉串学爪哇的博客-CSDN博客

    5.mapper 接口

    （1）UserMapper

    1. package com.qiku.mapper;
    2.  
    3. import com.qiku.pojo.Order;
    4. import com.qiku.pojo.User;
    5. import org.apache.ibatis.annotations.*;
    6. import org.apache.ibatis.mapping.FetchType;
    7.  
    8. import java.util.List;
    9.  
    10. /**
    11.  * 2022/6/22 10:35
    12.  *
    13.  * @author yrc
    14.  * @version Mybatis
    15.  */
    16. @CacheNamespace
    17. public interface UserMapper {
    18.     @Insert("insert into user(username,birthday,sex,address) " +
    19.             "values(#{username},#{birthday},#{sex},#{address})")
    20.       public void addUser(User user);
    21.  
    22.     @Delete("delete from user where id=#{id}")
    23.     public void deleteUser(Integer id);
    24.  
    25.     @Update("update user set username=#{username} where id=#{id}")
    26.     public void updateUser(User user);
    27.  
    28.     @Select("select * from user")
    29.     public List<User> selectUser();
    30.  
    31.     @Select("select * from user where id=#{id}")
    32.     public User findUserById(Integer id);
    33.  
    34.     @Select("select  * from user")
    35.     @Results({
    36.             @Result(id=true ,column = "id",property ="id"),
    37.             @Result(column = "username" ,property="username"),
    38.             @Result(column = "birthday" ,property="birthday"),
    39.             @Result(column = "sex" ,property="sex"),
    40.             @Result(column = "address" ,property="address"),
    41.             @Result(column = "id",property ="orderList",javaType = List.class,
    42.                     many = @Many(select = "com.qiku.mapper.OrderMapper.findOrderByUid",
    43.                             fetchType = FetchType.EAGER))
    44.     })
    45.     //一对多
    46.     public List<User> findAllUserWithOrder();
    47.  
    48.     //查询所有用户以及角色信息
    49.     @Select("select  * from user")
    50.     @Results({
    51.             @Result(id=true ,column = "id",property ="id"),
    52.             @Result(column = "username" ,property="username"),
    53.             @Result(column = "birthday" ,property="birthday"),
    54.             @Result(column = "sex" ,property="sex"),
    55.             @Result(column = "address" ,property="address"),
    56.             @Result(column = "id",property ="roleList",javaType = List.class,
    57.                     many = @Many(select = "com.qiku.mapper.RoleMapper.findRoleByUid",
    58.                             fetchType = FetchType.EAGER))
    59.     })
    60.     public List<User> findAllUserWithRole();
    61. }

    （2）OrderMapper

    1. package com.qiku.mapper;
    2.  
    3. import com.qiku.pojo.Order;
    4. import com.qiku.pojo.User;
    5. import net.sf.jsqlparser.schema.Column;
    6. import org.apache.ibatis.annotations.One;
    7. import org.apache.ibatis.annotations.Result;
    8. import org.apache.ibatis.annotations.Results;
    9. import org.apache.ibatis.annotations.Select;
    10. import org.apache.ibatis.mapping.FetchType;
    11.  
    12. import java.util.List;
    13.  
    14. /**
    15.  * 2022/6/22 11:10
    16.  *
    17.  * @author yrc
    18.  * @version Mybatis
    19.  */
    20. public interface OrderMapper {
    21.  
    22.     // 查询所有订单以及订单的用户信息
    23. @Select("select  * from orders ")
    24. @Results({
    25. //                 主键      数据库字段     实体类字段
    26.         @Result(id=true ,column = "id" ,property="id"),
    27.         //          数据库字段              实体类字段
    28.         @Result(column = "ordertime" ,property="orderTime"),
    29.         @Result(column = "total" ,property="money"),
    30.         @Result(column = "uid",property ="user",javaType = User.class,
    31.                 one = @One(select = "com.qiku.mapper.UserMapper.findUserById",
    32.                 fetchType = FetchType.EAGER)
    33.         )
    35. })
    36.   public List<Order> findAllOrderWithUser();
    37.  
    38. @Select("select * from orders where id=#{uid}")
    39. @Results({
    40.         @Result(id =true,column = "id" ,property = "id"),
    41.         @Result(column = "ordertime",property = "orderTime"),
    42.         @Result(column = "total",property = "money")
    43. })
    44.  public List<Order> findOrderByUid(Integer uid);
    45.  
    46. }

    （3）RoleMapper

    1. package com.qiku.mapper;
    2.  
    3. import com.qiku.pojo.Role;
    4. import org.apache.ibatis.annotations.Select;
    5.  
    6. import java.util.List;
    7.  
    8. /**
    9.  * 2022/6/22 15:18
    10.  *
    11.  * @author yrc
    12.  * @version Mybatis
    13.  */
    14. public interface RoleMapper {
    15.  
    16.     @Select("select * from sys_role r LEFT JOIN sys_user_role ur\n" +
    17.             "on r.id = ur.roleid WHERE ur.userid = #{userId}")
    18.     public List<Role> findRoleByUid(Integer userId);
    19. }

    6.数据库信息（创建并使用数据库 然后先创建user表 在创建其他的）

    1.  
    2.  
    3. SET NAMES utf8mb4;
    4. SET FOREIGN_KEY_CHECKS = 0;
    5.  
    6. -- ----------------------------
    7. -- Table structure for orders
    8. -- ----------------------------
    9. DROP TABLE IF EXISTS `orders`;
    10. CREATE TABLE `orders` (
    11.   `id` int(11) NOT NULL AUTO_INCREMENT,
    12.   `ordertime` varchar(255) DEFAULT NULL,
    13.   `total` double DEFAULT NULL,
    14.   `uid` int(11) DEFAULT NULL,
    15.   PRIMARY KEY (`id`),
    16.   KEY `uid` (`uid`),
    17.   CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
    18. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
    19.  
    20. -- ----------------------------
    21. -- Records of orders
    22. -- ----------------------------
    23. BEGIN;
    24. INSERT INTO `orders` VALUES (1, '2022-12-12', 3000, 1);
    25. INSERT INTO `orders` VALUES (2, '2022-12-12', 4000, 1);
    26. INSERT INTO `orders` VALUES (3, '2022-12-12', 5000, 2);
    27. COMMIT;
    28.  
    29. -- ----------------------------
    30. -- Table structure for store
    31. -- ----------------------------
    32. DROP TABLE IF EXISTS `store`;
    33. CREATE TABLE `store` (
    34.   `id` int(11) NOT NULL AUTO_INCREMENT,
    35.   `shop_owner` varchar(32) DEFAULT NULL COMMENT '店主姓名',
    36.   `id_number` varchar(18) DEFAULT NULL COMMENT '身份证号',
    37.   `name` varchar(100) DEFAULT NULL COMMENT '店铺名称',
    38.   `industry` varchar(100) DEFAULT NULL COMMENT '行业分类',
    39.   `area` varchar(200) DEFAULT NULL COMMENT '店铺区域',
    40.   `phone` varchar(11) DEFAULT NULL COMMENT '手机号码',
    41.   `status` int(11) DEFAULT '0' COMMENT '审核状态。 0：待审核  1：审核通过  2：审核失败 3：重新审核 ',
    42.   `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
    43.   PRIMARY KEY (`id`)
    44. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
    45.  
    46. -- ----------------------------
    47. -- Records of store
    48. -- ----------------------------
    49. BEGIN;
    50. INSERT INTO `store` VALUES (1, '张三丰', '441322199309273014', '张三丰包子铺', '美食', '北京市海淀区', '18933283299', 0, '2017-12-08 12:35:30');
    51. INSERT INTO `store` VALUES (2, '令狐冲', '441322199009102104', '华冲手机维修', '电子维修', '北京市昌平区', '18933283299', 1, '2019-01-20 20:20:00');
    52. INSERT INTO `store` VALUES (3, '赵敏', '441322199610205317', '托尼美容美发', '美容美发', '北京市朝阳区', '18933283299', 2, '2020-08-08 10:00:30');
    53. INSERT INTO `store` VALUES (5, '齐云霄', '1111', '云霄子阁', '阵法专卖', '元武国', '110', 0, '2022-06-20 10:30:29');
    54. INSERT INTO `store` VALUES (8, '齐云霄', '1111', '云霄阁', '阵法专卖', '元武国', '110', 0, '2022-06-21 09:46:42');
    55. COMMIT;
    56.  
    57. -- ----------------------------
    58. -- Table structure for sys_role
    59. -- ----------------------------
    60. DROP TABLE IF EXISTS `sys_role`;
    61. CREATE TABLE `sys_role` (
    62.   `id` int(11) NOT NULL AUTO_INCREMENT,
    63.   `rolename` varchar(255) DEFAULT NULL,
    64.   `roleDesc` varchar(255) DEFAULT NULL,
    65.   PRIMARY KEY (`id`)
    66. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    67.  
    68. -- ----------------------------
    69. -- Records of sys_role
    70. -- ----------------------------
    71. BEGIN;
    72. INSERT INTO `sys_role` VALUES (1, 'CTO', 'CTO');
    73. INSERT INTO `sys_role` VALUES (2, 'CEO', 'CEO');
    74. COMMIT;
    75.  
    76. -- ----------------------------
    77. -- Table structure for sys_user_role
    78. -- ----------------------------
    79. DROP TABLE IF EXISTS `sys_user_role`;
    80. CREATE TABLE `sys_user_role` (
    81.   `userid` int(11) NOT NULL,
    82.   `roleid` int(11) NOT NULL,
    83.   PRIMARY KEY (`userid`,`roleid`),
    84.   KEY `roleid` (`roleid`),
    85.   CONSTRAINT `sys_user_role_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `user` (`id`),
    86.   CONSTRAINT `sys_user_role_ibfk_2` FOREIGN KEY (`roleid`) REFERENCES `sys_role` (`id`)
    87. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    88.  
    89. -- ----------------------------
    90. -- Records of sys_user_role
    91. -- ----------------------------
    92. BEGIN;
    93. INSERT INTO `sys_user_role` VALUES (1, 1);
    94. INSERT INTO `sys_user_role` VALUES (2, 1);
    95. INSERT INTO `sys_user_role` VALUES (1, 2);
    96. INSERT INTO `sys_user_role` VALUES (2, 2);
    97. COMMIT;
    98.  
    99. -- ----------------------------
    100. -- Table structure for user
    101. -- ----------------------------
    102. DROP TABLE IF EXISTS `user`;
    103. CREATE TABLE `user` (
    104.   `id` int(11) NOT NULL AUTO_INCREMENT,
    105.   `username` varchar(32) NOT NULL COMMENT '用户名称',
    106.   `birthday` datetime DEFAULT NULL COMMENT '生日',
    107.   `sex` char(1) DEFAULT NULL COMMENT '性别',
    108.   `address` varchar(256) DEFAULT NULL COMMENT '地址',
    109.   PRIMARY KEY (`id`)
    110. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    111.  
    112. -- ----------------------------
    113. -- Records of user
    114. -- ----------------------------
    115. BEGIN;
    116. INSERT INTO `user` VALUES (1, '张三', '2020-11-11 00:00:00', '男', '北京海淀');
    117. INSERT INTO `user` VALUES (2, '李四', '2020-12-12 00:00:00', '男', '北京海淀');
    118. COMMIT;
    119.  
    120. SET FOREIGN_KEY_CHECKS = 1;

    7.测试

    （1）一对一查询，查询一个订单，与此同时查询出该订单所属的用户

    测试代码

    1.   @Test
    2.     public void testFindAllOrderWithUser(){
    3.         SqlSession sqlSession = SqlSessionUtils.getSqlSession();
    4.         OrderMapper mapper = sqlSession.getMapper(OrderMapper.class);
    5.         List<Order> orderList = mapper.findAllOrderWithUser();
    6.         for(Order order:orderList){
    7.             System.out.println(order);
    8.         }
    9.     }

    （2）一对多查询，查询一个用户，与此同时查询出该用户具有的订单

     测试语句

    1.    @Test
    2.     public void findAllUserWithOrder(){
    3.         SqlSession sqlSession = SqlSessionUtils.getSqlSession();
    4.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    5.         List<User> allUserWithOrder = mapper.findAllUserWithOrder();
    6.         for(User user:allUserWithOrder){
    7.             System.out.println(user);
    8.         }
    9.     }

    （3）多对多查询 ，查询所有用户，同时查询出该用户的所有角色

    sql语句

    1. SELECT * FROM `user`; 
    2. SELECT * FROM role r INNER JOIN user_role ur ON r.`id` = ur.`rid` 
    3. 	WHERE ur.`uid` = #{id};

    测试语句

    1.    @Test
    2.     public void findAllUserWithRole(){
    3.  
    4.         SqlSession sqlSession = SqlSessionUtils.getSqlSession();
    5.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    6.         List<User> allUserWithRole = mapper.findAllUserWithRole();
    7.         for(User user:allUserWithRole){
    8.             System.out.println(user);
    9.         }
    10.  
    11.     }

  • 相关阅读:
    java计算机毕业设计医疗器械销售电子商城源码+系统+mysql数据库+lw文档
    Linux：进程的本质和fork初识
    化妆品展示网页设计作业 静态HTML化妆品网站 DW美妆网站模板下载 大学生简单网页作品代码 个人网页制作 学生个人网页设计作业
    【考研】操作系统——同步互斥问题（P、V操作）3
    Flink学习:Flink支持的数据类型
    代码随想录笔记_动态规划_337打家劫舍III
    java计算机毕业设计化妆品销售网站源码+mysql数据库+系统+lw文档+部署
    基于Internet应用的分销ERP系统源码
    ChatTTS web应用；基于文本指导的图像生成；使用Groq和Llama3在几秒内生成整本书；协作机器人画家，可以根据语言描述或图像在画布上作画
    【GEE】6、在 Google 地球引擎中构建各种遥感指数
  • 原文地址：https://blog.csdn.net/weixin_45172902/article/details/125435516