Java——JDBC和DbUtils

1. 学生管理系统使用JdbcUitl，BaseDao完成数据持久化操作

1.1 Student实体类

public class Student {
   
    private Integer id;
    private String name;
    private Integer age;
    private Boolean gender;
    private Float score;
    private String address;

    public Student() {
   
    }

    public Student(String name, Integer age, Boolean gender, Float score, String address) {
   
        this.name = name;
        this.age = age;
        this.gender = gender;
        this.score = score;
        this.address = address;
    }

    public Student(Integer id, String name, Integer age, Boolean gender, Float score, String address) {
   
        this.id = id;
        this.name = name;
        this.age = age;
        this.gender = gender;
        this.score = score;
        this.address = address;
    }

    public Integer getId() {
   
        return id;
    }

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

    public String getName() {
   
        return name;
    }

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

    public Integer getAge() {
   
        return age;
    }

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

    public Boolean getGender() {
   
        return gender;
    }

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

    public Float getScore() {
   
        return score;
    }

    public void setScore(Float score) {
   
        this.score = score;
    }

    public String getAddress() {
   
        return address;
    }

    public void setAddress(String address) {
   
        this.address = address;
    }

    @Override
    public String toString() {
   
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", gender=" + gender +
                ", score=" + score +
                ", address='" + address + '\'' +
                '}';
    }
}

1.2 StudentDao规范

public interface StudentDao {
   
    /**
     * 添加学生方法要求，参数为Student类对象， 返回值为int类型，操作成功返回1, 失败
     * 返回0
     *
     * @param student Student类对象
     * @return 添加成功返回1，否则返回0
     */
    int addStudent(Student student);

    /**
     * 根据指定ID删除对应的学生
     *
     * @param id 指定的ID
     * @return 删除成功返回1，否则返回0
     */
    int deleteStudent(int id);

    /**
     * 修改学生信息，传入的参数是一个Student类对象
     *
     * @param student Student类对象
     * @return 更新成功返回1，否则返回0
     */
    int updateStudent(Student student);

    /**
     * 查询指定ID的学生，没有找到返回null
     *
     * @param id 指定的ID号
     * @return 查询成功返回Student类对象，失败返回null
     */
    Student findStudentById(int id);

    /**
     * 查询当前数据库中所有学生信息
     *
     * @return 返回值List集合，如果没有数据返回null
     */
    List<Student> findAllStudent();
}

1.3 StudentDaoImpl实现

public class StudentDaoImpl extends BaseDao implements StudentDao {
   
    @Override
    public int addStudent(Student student) {
   
        String sql = "insert into student(name, age, gender, score, address) value (?, ?, ?, ?, ?)";
        Object[] parameters = {
   student.getName(), student.getAge(), student.getGender()
                , student.getScore(), student.getAddress()};

        return super.update(sql, parameters);
    }

    @Override
    public int deleteStudent(int id) {
   
        String sql = "delete from student where id = " + id;

        return super.update(sql, null);
    }

    @Override
    public int updateStudent(Student student) {
   
        String sql = "update student set name = ?, age = ?, gender = ?, score = ?, address = ? where  id = ?";
        Object[] parameters = {
   student.getName(), student.getAge(), student.getGender()
                , student.getScore(), student.getAddress(), student.getId()};

        return super.update(sql, parameters);
    }

    @Override
    public Student findStudentById(int id) {
   
        String sql = "select * from student where id = " + id;

        Student student = super.queryBean(sql, null, Student.class);

        return student;
    }

    @Override
    public List<Student> findAllStudent() {
   
        String sql = "select * from student";

        return super.queryBeanList(sql, null, Student.class);
    }
}

1.4 StudentService规范

public interface StudentService {
   
    /*
    增删改查排序
     */

    /**
     * Service层规定的添加学生方法，返回值类型是boolean
     *
     * @param student Student类对象
     * @return 添加成功返回true，失败返回false
     */
    boolean addStudent(Student student);

    /**
     * 删除指定ID学生
     *
     * @param id 指定学生的ID
     * @return 删除成功返回true，失败返回false
     */
    boolean deleteStudentById(Integer id);

    /**
     * 更新学生信息
     *
     * @param student 需要更新信息的一个Student类对象
     * @return 更新成功返回true，失败返回false
     */
    boolean updateStudent(Student student);

    /**
     * 查询指定ID的学生
     *
     * @param id 指定的学生的ID号
     * @return Student类对象，没有找到返回null
     */
    Student