SpringBoot整合MyBatis的程式碼詳解

2022-05-21 13:01:56

SpringBoot整合MyBatis

依賴的匯入

整合mybatis之前我們需要相對應的匯入相關依賴。

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.1</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

大致目錄

我們首先需要在java的目錄和resources下建立mapper資料夾。前者是方法的介面，後者則是xml檔案的編寫。

例如：

@Mapper
@Repository
public interface UserLoginMapper {
    //查詢
    public List<User> queryAll();
    //新增資料
    public int add(User user);
    //根據使用者名稱查詢資料
    public User queryByName(String name);

}

xml實現

<mapper namespace="com.example.springbootdemo03.mapper.UserLoginMapper">
    <select id="queryAll" resultType="com.example.springbootdemo03.bean.User">
        select * from student
    </select>
    <insert id="add" parameterType="com.example.springbootdemo03.bean.User">
        insert into student values (#{name},#{password})
    </insert>
    <select id="queryByName" resultType="com.example.springbootdemo03.bean.User">
        select * from student where name = #{name}
    </select>
</mapper>

建立資料庫和相對應的Pojo類

資料庫格式：

POJO類：

@AllArgsConstructor
@NoArgsConstructor
@Data
public class User {
    private Integer id;
    private String name;
    private  String password;
    private String sex;
    private String fullName;
    private String email;
}

Service層的編寫

UserLogin介面的編寫：

public interface UserLogin {
    /**
     *查詢使用者名稱是否存在
     */
    public Boolean IsExit(String name);
    /**
     * 判斷賬號密碼是否存在
     * @param name
     * @return
     */
    public User Login(String name);
}

UserLoginImpl介面實現類的編寫：

@Service
public class UserLoginImpl implements UserLogin {
    //自動注入UserLoginMapper
    @Autowired
    UserLoginMapper userLoginMapper;

    @Override
    public Boolean IsExit(String name){
        if(userLoginMapper.queryByName(name) == null){
            return false;
        }else return true;
    }
    @Override
    public User Login(String name) {
        User user = userLoginMapper.queryByName(name);
        return user;
    }
}

Controller層的編寫

我們可以通過Controller層編寫來測試登入註冊。

@Autowired
    UserLogin userLogin;
    @GetMapping(value = {"/","/login"})
    public String Index(){
        return "login";
    }
    @GetMapping("main.html")
    public String Main(){
        return "index";
    }
    @PostMapping("/login")
    public String Login(User user, HttpSession session, Model model){
        if(!userLogin.IsExit(user.getName())){
            session.setAttribute("msg", "登入失敗");
            return "redirect:/login";
        }
        User login = userLogin.Login(user.getName());
        if(user.getName().equals(login.getName()) && user.getPassword().equals(login.getPassword())){
            session.setAttribute("loginUser",user);
            return "redirect:/main.html";
        }
        else {
            session.setAttribute("msg", "登入失敗");
            return "redirect:/login";
        }
    }