【Spring】JdbcTemplate函数接口方法:RowMaper、RowCallbackhandler、ResultSetExtractor、PreparedStatementCreator

RowMaper的使用

    /**
     * RowMaper Test
     */
    @Test
    public void test_RowMapper() {
   
        //学生成绩表字段映射类 -- 局部内部类
        class Score{
   
            private Integer id;
            private String sid;
            private Integer chinese;
            private Integer math;
            private Integer english;

            public Integer getId() {
   
                return id;
            }

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

            public String getSid() {
   
                return sid;
            }

            public void setSid(String sid) {
   
                this.sid = sid;
            }

            public Integer getChinese() {
   
                return chinese;
            }

            public void setChinese(Integer chinese) {
   
                this.chinese = chinese;
            }

            public Integer getMath() {
   
                return math;
            }

            public void setMath(Integer math) {
   
                this.math = math;
            }

            public Integer getEnglish() {
   
                return english;
            }

            public void setEnglish(Integer english) {
   
                this.english = english;
            }

            @Override
            public String toString() {
   
                return "Score{" +
                        "id=" + id +
                        ", sid='" + sid + '\'' +
                        ", chinese=" + chinese +
                        ", math=" + math +
                        ", english=" + english +
                        '}';
            }
        }