扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

spring鏁村悎mybatis瀹炵幇澧炲垹鏀规煡鎿嶄綔

扬州沐宇科技
2024-03-27 15:37:42
mybatis, spring

  1. 棣栧厛纭繚鍦╬om.xml涓坊鍔爏pring鍜宮ybatis鐨勪緷璧栵細
<dependencies>
    <!-- Spring -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>5.2.5.RELEASE</version>
    </dependency>

    <!-- MyBatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.3</version>
    </dependency>
</dependencies>
  1. 閰嶇疆mybatis鐨凷qlSessionFactory鍜孧apperScannerConfigurer锛?/li>
<!-- MyBatis閰嶇疆鏂囦欢 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.example.mapper" />
</bean>
  1. 鍒涘缓MyBatis鐨勬槧灏勬枃浠跺拰Mapper鎺ュ彛锛?/li>
<!-- com/example/mapper/UserMapper.xml -->
<mapper namespace="com.example.mapper.UserMapper">
    <select id="selectUserById" resultType="com.example.model.User">
        SELECT * FROM user WHERE id = #{id}
    </select>

    <insert id="insertUser" parameterType="com.example.model.User">
        INSERT INTO user(name, age) VALUES(#{name}, #{age})
    </insert>

    <!-- 鍚岀悊锛屾坊鍔爑pdate鍜宒elete鐨凷QL璇彞 -->
</mapper>
// com/example/mapper/UserMapper.java
package com.example.mapper;

import com.example.model.User;

public interface UserMapper {
    User selectUserById(int id);
    void insertUser(User user);
    // 娣诲姞update鍜宒elete鐨勬柟娉?/span>
}
  1. 鍒涘缓User绫讳綔涓哄疄浣撶被锛?/li>
// com/example/model/User.java
package com.example.model;

public class User {
    private int id;
    private String name;
    private int age;

    // 鐪佺暐getter鍜宻etter鏂规硶
}
  1. 缂栧啓Service绫昏皟鐢∕apper鎺ュ彛瀹炵幇澧炲垹鏀规煡鎿嶄綔锛?/li>
// com/example/service/UserService.java
package com.example.service;

import com.example.mapper.UserMapper;
import com.example.model.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;

    public User getUserById(int id) {
        return userMapper.selectUserById(id);
    }

    public void addUser(User user) {
        userMapper.insertUser(user);
    }

    // 娣诲姞update鍜宒elete鐨勬柟娉?/span>
}

鑷虫锛屽氨瀹屾垚浜哠pring鏁村悎MyBatis瀹炵幇澧炲垹鏀规煡鎿嶄綔鐨勫熀鏈楠ゃ€傞€氳繃閰嶇疆MyBatis鐨凷qlSessionFactory鍜孧apperScannerConfigurer锛屼互鍙婄紪鍐橫apper鎺ュ彛鍜屾槧灏勬枃浠讹紝鍐嶉€氳繃Service绫昏皟鐢∕apper鎺ュ彛瀹炵幇鍏蜂綋鐨勬暟鎹簱鎿嶄綔銆?/p>

扫码添加客服微信