今天完成的事情：jdbcTemplate的编译

Test.java

    private String regeneration_time;
    private String declaration;
    private String senior;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getQq() {
        return name;
    }
    public void setQq(String qq) {
        this.qq = qq;
    }
    public String getType()
    {
        return type;
    }
    public void setType(String type) {
        this.type = type;
    }
    public String getSchool() {
        return school;
    }
    public void setSchool(String school) {
        this.school = school;
    }
    public String getLink() {
        return link;
    }
    public void setLink(String link) {
        this.link = link;
    }
    public String getRegeneration_time() {
        return regeneration_time;
    }
    public void setRegeneration_time(String regeneration_time) {
        this.regeneration_time = regeneration_time;
    }
    public String getDeclaration() {
        return declaration;
    }
    public void setDeclaration(String declaration) {
        this.declaration = declaration;
    }
    public String getSenior() {
        return senior;
    }
    public void setSenior(String senior) {
        this.senior = senior;
    }
}

TestDao.java

package com.wangyuchen.templateTest.no1;

public interface TestDao {
    public void insert(Test test);
    public void update(Test test);
    public void delete(long testId);
    public Test find(long testId);

}

TestDaoJdbcImpl.java

package com.wangyuchen.templateTest.no1;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

public class TestDaoJdbcImpl implements TestDao{

    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    public void insert(Test test) {
        // TODO Auto-generated method stub

    }

    public void update(Test test) {
        // TODO Auto-generated method stub

    }

    public void update(List<Test> tests) {
        // TODO Auto-generated method stub

    }

    public void delete(long testId) {
        // TODO Auto-generated method stub

    }

    public Test find(long testId) {
        return jdbcTemplate
                .queryForObject(
                        "select id,name,qq,link,school from account where id = ?",
                        new RowMapper<Test>() {
                            public Test mapRow(ResultSet rs, int rowNum)
                                    throws SQLException {
                                Test test = new Test();
                                test.setId(rs.getLong("id"));
                                test.setName(rs.getString("name"));
                                test.setQq(rs.getString("qq"));
                                test.setLink(rs.getString("link"));
                                test.setSchool(rs.getString("school"));
                                return test;
                            }

                        }, testId);
    }

    public List<Test> find(List<Long> testIds) {
        // TODO Auto-generated method stub
        return null;
    }

    public List<Test> find(String Name) {
        // TODO Auto-generated method stub
        return null;
    }
}

Main.java

package com.wangyuchen.templateTest.no1;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import java.sql.SQLException;

public class Main {
    public static void main(String[] args) throws SQLException {
        AnnotationConfigApplicationContext applicationContext = new AnnotationConfigApplicationContext(No1Configuration.class);

        TestDao testDao = applicationContext.getBean(TestDao.class);

        Test test = testDao.find(100L);

        System.out.println(test.getId());
        System.out.println(test.getName());
        System.out.println(test.getQq());
        System.out.println(test.getLink());
        System.out.println(test.getSchool());
    }
}

No1Configuration.java

package com.wangyuchen.templateTest.no1;

import javax.sql.DataSource;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

@Configuration
public class No1Configuration {
    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/test");
        dataSource.setUsername("sa");
        dataSource.setPassword("");
        return dataSource;
    }

    @Bean
    public JdbcTemplate jdbcTemplate() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate();
        jdbcTemplate.setDataSource(dataSource());
        return jdbcTemplate;
    }

    @Bean
    public TestDao testDao() {
        TestDaoJdbcImpl testDao = new TestDaoJdbcImpl();
        testDao.setJdbcTemplate(jdbcTemplate());
        return testDao;
    }

}

明天计划的事情：完成mybatis的jdbc编译

遇到的问题：敲代码的时候没有注意大小写，一个方法死活报错，害的师兄找了半天，最后看书发现首字母是小写

书上的案例用的是hibernate，编译No1Configuration.java，连接数据库的时候报错。

收获：基本掌握jdbctemplate的用法