mybatis简单查询

bean文件

package com.lsl.bean;


public class Student {
    private Integer stId;
    private String stName;

    public Integer getStId() {
        return stId;
    }

    public void setStId(Integer stId) {
        this.stId = stId;
    }

    public String getStName() {
        return stName;
    }

    public void setStName(String stName) {
        this.stName = stName;
    }

    @Override
    public String toString() {
        return "Student{" +
                "stId=" + stId +
                ", stName='" + stName + '\'' +
                '}';
    }
}

studentcontroller

package com.lsl.controller;

import com.lsl.bean.Student;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.lsl.service.StudentService;

import javax.annotation.Resource;
import java.util.List;

@Controller
public class StudentController {
    @Resource
    private StudentService studentService;

    @RequestMapping("/test1")
    public String hello2(Model model){
        List<Student> students = studentService.selectListAll();
        model.addAttribute("list",students);
        return "student";
    }
}

studentmapper

package com.lsl.dao;

import com.lsl.bean.Student;

import java.util.List;



public interface StudentMapper {
    List<Student> selectListAll();
}

studentmapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lsl.dao.StudentMapper">
    <select id="selectListAll" resultType="com.lsl.bean.Student">
        select * from t_test
    </select>
</mapper>

studentservice

package com.lsl.service;

import com.lsl.bean.Student;
import com.lsl.dao.StudentMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service("StudentService")
public class StudentService {
    @Autowired
    private StudentMapper mapper;

    public List<Student> selectListAll() {
        return mapper.selectListAll();
    }
}