Spring-基于注解-practice

结构

StudentController

package com.dc.controller;

import com.dc.pojo.Student;
import com.dc.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.stereotype.Service;

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

@Controller
public class StudentController {
    @Autowired
    private StudentService studentService;
    public void findAll(){
        List<Student> all=studentService.findAll();
        System.out.println("all:"+all);
    }
}

StudentDaoImpl
package com.dc.dao;

import com.dc.pojo.Student;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public class StudentDaoImpl implements StudentDao{
@Autowired
private JdbcTemplate jdbcTemplate;

@Override
public List<Student> queryAll(){
    String sql="select id,name,gender,age,class as classes from students";
    List<Student> studentList=jdbcTemplate.query(sql,new BeanPropertyRowMapper<>(Student.class));
    return studentList;
}

}

在这里插入代码片

Student

package com.dc.pojo;

public class Student {
    private Integer id;
    private String name;
    private String gender;
    private Integer age;
    private String classes;

    public Integer getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getGender() {
        return gender;
    }

    public Integer getAge() {
        return age;
    }

    public String getClasses() {
        return classes;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public void setClasses(String classes) {
        this.classes = classes;
    }

    @Override
    public String toString() {
        return "Student:"+id+"  "+name+"  "+gender+"  "+age+"  "+classes;
    }
}

StudentService

package com.dc.service;

import com.dc.dao.StudentDao;
import com.dc.pojo.Student;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class StudentServiceImpl implements StudentService{
    @Autowired
    private StudentDao studentDao;
    @Override
    public List<Student> findAll(){
        List<Student> studentList=studentDao.queryAll();
        return studentList;
    }
}

结果