{"id":4062,"date":"2024-08-26T20:01:26","date_gmt":"2024-08-26T12:01:26","guid":{"rendered":"https:\/\/qaqaq.top\/?p=4062"},"modified":"2024-08-27T15:57:11","modified_gmt":"2024-08-27T07:57:11","slug":"mybatis-plus%e7%9a%84mybatisx%e6%8f%92%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=4062","title":{"rendered":"MyBatis-Plus\u7684MyBatisX\u63d2\u4ef6"},"content":{"rendered":"\n

\u4ee3\u7801\u751f\u6210<\/h2>\n\n\n\n

\u9996\u5148\u5728idea\u4e2d\u5b89\u88c5MyBatisX\u63d2\u4ef6<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

\u53f3\u952e\u6570\u636e\u8868<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

\u5982\u56fe\u6240\u793a\uff0c\u8bbe\u7f6e\u5b9e\u4f53\u7c7b\u5305\u540d\u7b49<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

\u5982\u56fe\u6240\u793a\uff0c\u751f\u6210\u6ce8\u89e3\uff0c\u5b9e\u4f53\u7c7b\u6ce8\u89e3\uff0c\u65b9\u6cd5\u7b49<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

\u5feb\u901f\u751f\u6210\u6dfb\u52a0<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

UserMapper<\/p>\n\n\n\n

public interface UserMapper extends BaseMapper<User> {\n\n    int insertSelective(User user);\n\n}<\/code><\/pre>\n\n\n\n
UserMapper.xml<\/p>\n\n\n\n
    <insert id=\"insertSelective\">\n        insert into t_user\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">,<\/if>\n            <if test=\"userName != null\">user_name,<\/if>\n            <if test=\"age != null\">age,<\/if>\n            <if test=\"email != null\">email,<\/if>\n            <if test=\"sex != null\">sex,<\/if>\n            <if test=\"isDeleted != null\">is_deleted,<\/if>\n        <\/trim>\n        values\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">#{uid,jdbcType=NUMERIC},<\/if>\n            <if test=\"userName != null\">#{userName,jdbcType=VARCHAR},<\/if>\n            <if test=\"age != null\">#{age,jdbcType=NUMERIC},<\/if>\n            <if test=\"email != null\">#{email,jdbcType=VARCHAR},<\/if>\n            <if test=\"sex != null\">#{sex,jdbcType=NUMERIC},<\/if>\n            <if test=\"isDeleted != null\">#{isDeleted,jdbcType=NUMERIC},<\/if>\n        <\/trim>\n    <\/insert><\/code><\/pre>\n\n\n\n
\u5feb\u901f\u751f\u6210\u5220\u9664<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
UserMapper<\/p>\n\n\n\n
public interface UserMapper extends BaseMapper<User> {\n\n    int insertSelective(User user);\n\n    int deleteByUidAndUserName(@Param(\"uid\") Long uid, @Param(\"userName\") String userName);\n\n}<\/code><\/pre>\n\n\n\n
UserMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatisplus.mapper.UserMapper\">\n\n    <!--Map<String, Object> selectMapById(Long id);-->\n    <select id=\"selectMapById\" resultType=\"map\">\n        select id, name, age, email from user where id = #{id}\n    <\/select>\n\n    <!--Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);-->\n    <select id=\"selectPageVo\" resultType=\"User\">\n        select uid, user_name, age, email from t_user where age > #{age}\n    <\/select>\n    <insert id=\"insertSelective\">\n        insert into t_user\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">,<\/if>\n            <if test=\"userName != null\">user_name,<\/if>\n            <if test=\"age != null\">age,<\/if>\n            <if test=\"email != null\">email,<\/if>\n            <if test=\"sex != null\">sex,<\/if>\n            <if test=\"isDeleted != null\">is_deleted,<\/if>\n        <\/trim>\n        values\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">#{uid,jdbcType=NUMERIC},<\/if>\n            <if test=\"userName != null\">#{userName,jdbcType=VARCHAR},<\/if>\n            <if test=\"age != null\">#{age,jdbcType=NUMERIC},<\/if>\n            <if test=\"email != null\">#{email,jdbcType=VARCHAR},<\/if>\n            <if test=\"sex != null\">#{sex,jdbcType=NUMERIC},<\/if>\n            <if test=\"isDeleted != null\">#{isDeleted,jdbcType=NUMERIC},<\/if>\n        <\/trim>\n    <\/insert>\n    <delete id=\"deleteByUidAndUserName\">\n        delete\n        from t_user\n        where\n            = #{uid,jdbcType=NUMERIC}\n          AND user_name = #{userName,jdbcType=VARCHAR}\n    <\/delete>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
\u5feb\u901f\u751f\u6210\u4fee\u6539<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
UserMapper<\/p>\n\n\n\n
public interface UserMapper extends BaseMapper<User> {\n\n    int insertSelective(User user);\n\n    int deleteByUidAndUserName(@Param(\"uid\") Long uid, @Param(\"userName\") String userName);\n\n    int updateAgeAndSexByUid(@Param(\"age\") Integer age, @Param(\"sex\") Integer sex, @Param(\"uid\") Long uid);\n\n}<\/code><\/pre>\n\n\n\n
UserMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatisplus.mapper.UserMapper\">\n\n    <!--Map<String, Object> selectMapById(Long id);-->\n    <select id=\"selectMapById\" resultType=\"map\">\n        select id, name, age, email from user where id = #{id}\n    <\/select>\n\n    <!--Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);-->\n    <select id=\"selectPageVo\" resultType=\"User\">\n        select uid, user_name, age, email from t_user where age > #{age}\n    <\/select>\n    <insert id=\"insertSelective\">\n        insert into t_user\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">,<\/if>\n            <if test=\"userName != null\">user_name,<\/if>\n            <if test=\"age != null\">age,<\/if>\n            <if test=\"email != null\">email,<\/if>\n            <if test=\"sex != null\">sex,<\/if>\n            <if test=\"isDeleted != null\">is_deleted,<\/if>\n        <\/trim>\n        values\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">#{uid,jdbcType=NUMERIC},<\/if>\n            <if test=\"userName != null\">#{userName,jdbcType=VARCHAR},<\/if>\n            <if test=\"age != null\">#{age,jdbcType=NUMERIC},<\/if>\n            <if test=\"email != null\">#{email,jdbcType=VARCHAR},<\/if>\n            <if test=\"sex != null\">#{sex,jdbcType=NUMERIC},<\/if>\n            <if test=\"isDeleted != null\">#{isDeleted,jdbcType=NUMERIC},<\/if>\n        <\/trim>\n    <\/insert>\n    <delete id=\"deleteByUidAndUserName\">\n        delete\n        from t_user\n        where\n            = #{uid,jdbcType=NUMERIC}\n          AND user_name = #{userName,jdbcType=VARCHAR}\n    <\/delete>\n    <update id=\"updateAgeAndSexByUid\">\n        update t_user\n        set age = #{age,jdbcType=NUMERIC},\n            sex = #{sex,jdbcType=NUMERIC}\n        where\n            = #{uid,jdbcType=NUMERIC}\n    <\/update>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
\u5feb\u901f\u751f\u6210\u67e5\u8be2<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
UserMapper<\/p>\n\n\n\n
public interface UserMapper extends BaseMapper<User> {\n\n    int insertSelective(User user);\n\n    int deleteByUidAndUserName(@Param(\"uid\") Long uid, @Param(\"userName\") String userName);\n\n    int updateAgeAndSexByUid(@Param(\"age\") Integer age, @Param(\"sex\") Integer sex, @Param(\"uid\") Long uid);\n\n    List<User> selectAgeAndSexByAgeBetween(@Param(\"beginAge\") Integer beginAge, @Param(\"endAge\") Integer endAge);\n\n}<\/code><\/pre>\n\n\n\n
UserMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatisplus.mapper.UserMapper\">\n\n    <!--Map<String, Object> selectMapById(Long id);-->\n    <select id=\"selectMapById\" resultType=\"map\">\n        select id, name, age, email from user where id = #{id}\n    <\/select>\n\n    <!--Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);-->\n    <select id=\"selectPageVo\" resultType=\"User\">\n        select uid, user_name, age, email from t_user where age > #{age}\n    <\/select>\n    <insert id=\"insertSelective\">\n        insert into t_user\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">,<\/if>\n            <if test=\"userName != null\">user_name,<\/if>\n            <if test=\"age != null\">age,<\/if>\n            <if test=\"email != null\">email,<\/if>\n            <if test=\"sex != null\">sex,<\/if>\n            <if test=\"isDeleted != null\">is_deleted,<\/if>\n        <\/trim>\n        values\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">#{uid,jdbcType=NUMERIC},<\/if>\n            <if test=\"userName != null\">#{userName,jdbcType=VARCHAR},<\/if>\n            <if test=\"age != null\">#{age,jdbcType=NUMERIC},<\/if>\n            <if test=\"email != null\">#{email,jdbcType=VARCHAR},<\/if>\n            <if test=\"sex != null\">#{sex,jdbcType=NUMERIC},<\/if>\n            <if test=\"isDeleted != null\">#{isDeleted,jdbcType=NUMERIC},<\/if>\n        <\/trim>\n    <\/insert>\n    <delete id=\"deleteByUidAndUserName\">\n        delete\n        from t_user\n        where\n            = #{uid,jdbcType=NUMERIC}\n          AND user_name = #{userName,jdbcType=VARCHAR}\n    <\/delete>\n    <update id=\"updateAgeAndSexByUid\">\n        update t_user\n        set age = #{age,jdbcType=NUMERIC},\n            sex = #{sex,jdbcType=NUMERIC}\n        where\n            = #{uid,jdbcType=NUMERIC}\n    <\/update>\n    <select id=\"selectAgeAndSexByAgeBetween\" resultMap=\"BaseResultMap\">\n        select age, sex\n        from t_user\n        where age between #{beginAge,jdbcType=NUMERIC} and #{endAge,jdbcType=NUMERIC}\n    <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
\u5feb\u901f\u751f\u6210\u6392\u5e8f<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
UserMapper<\/p>\n\n\n\n
public interface UserMapper extends BaseMapper<User> {\n\n    int insertSelective(User user);\n\n    int deleteByUidAndUserName(@Param(\"uid\") Long uid, @Param(\"userName\") String userName);\n\n    int updateAgeAndSexByUid(@Param(\"age\") Integer age, @Param(\"sex\") Integer sex, @Param(\"uid\") Long uid);\n\n    List<User> selectAgeAndSexByAgeBetween(@Param(\"beginAge\") Integer beginAge, @Param(\"endAge\") Integer endAge);\n\n    List<User> selectAllOrderByAgeDesc();\n\n}<\/code><\/pre>\n\n\n\n
UserMapper.xml<\/p>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"top.qaqaq.mybatisplus.mapper.UserMapper\">\n\n    <!--Map<String, Object> selectMapById(Long id);-->\n    <select id=\"selectMapById\" resultType=\"map\">\n        select id, name, age, email from user where id = #{id}\n    <\/select>\n\n    <!--Page<User> selectPageVo(@Param(\"page\") Page<User> page, @Param(\"age\") Integer age);-->\n    <select id=\"selectPageVo\" resultType=\"User\">\n        select uid, user_name, age, email from t_user where age > #{age}\n    <\/select>\n    <insert id=\"insertSelective\">\n        insert into t_user\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">,<\/if>\n            <if test=\"userName != null\">user_name,<\/if>\n            <if test=\"age != null\">age,<\/if>\n            <if test=\"email != null\">email,<\/if>\n            <if test=\"sex != null\">sex,<\/if>\n            <if test=\"isDeleted != null\">is_deleted,<\/if>\n        <\/trim>\n        values\n        <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n            <if test=\"uid != null\">#{uid,jdbcType=NUMERIC},<\/if>\n            <if test=\"userName != null\">#{userName,jdbcType=VARCHAR},<\/if>\n            <if test=\"age != null\">#{age,jdbcType=NUMERIC},<\/if>\n            <if test=\"email != null\">#{email,jdbcType=VARCHAR},<\/if>\n            <if test=\"sex != null\">#{sex,jdbcType=NUMERIC},<\/if>\n            <if test=\"isDeleted != null\">#{isDeleted,jdbcType=NUMERIC},<\/if>\n        <\/trim>\n    <\/insert>\n    <delete id=\"deleteByUidAndUserName\">\n        delete\n        from t_user\n        where\n            = #{uid,jdbcType=NUMERIC}\n          AND user_name = #{userName,jdbcType=VARCHAR}\n    <\/delete>\n    <update id=\"updateAgeAndSexByUid\">\n        update t_user\n        set age = #{age,jdbcType=NUMERIC},\n            sex = #{sex,jdbcType=NUMERIC}\n        where\n            = #{uid,jdbcType=NUMERIC}\n    <\/update>\n    <select id=\"selectAgeAndSexByAgeBetween\" resultMap=\"BaseResultMap\">\n        select age, sex\n        from t_user\n        where age between #{beginAge,jdbcType=NUMERIC} and #{endAge,jdbcType=NUMERIC}\n    <\/select>\n    <select id=\"selectAllOrderByAgeDesc\" resultMap=\"BaseResultMap\">\n        select\n        <include refid=\"Base_Column_List\"\/>\n        from t_user\n        order by age desc\n    <\/select>\n\n<\/mapper><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u4ee3\u7801\u751f\u6210 \u9996\u5148\u5728idea\u4e2d\u5b89\u88c5MyBatisX\u63d2\u4ef6 \u53f3\u952e\u6570\u636e\u8868 \u5982\u56fe\u6240\u793a\uff0c\u8bbe\u7f6e\u5b9e\u4f53\u7c7b\u5305\u540d\u7b49 \u5982\u56fe\u6240\u793a\uff0c\u751f\u6210\u6ce8\u89e3 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165],"tags":[183],"class_list":["post-4062","post","type-post","status-publish","format-standard","hentry","category-mybatisplus-","tag-mybatisplus"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4062"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4062"}],"version-history":[{"count":8,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4062\/revisions"}],"predecessor-version":[{"id":4082,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/4062\/revisions\/4082"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}