Spring 的查詢（導入相關包）

public class Main {
    public void mysqlAction(){
        DriverManagerDataSource dmd = new DriverManagerDataSource();
        dmd.setDriverClassName("com.mysql.jdbc.Driver");
        dmd.setUrl("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8");
        dmd.setUsername("root");
        dmd.setPassword("123456");
        JdbcTemplate jt = new JdbcTemplate(dmd);
        String sqlAll = "select * from user";
        List<person> lt = jt.query(sqlAll, new mymap());
        for(person p:lt){
            if(p.getName().equals("張三")){
                System.out.println("234567234567");
                System.out.println(p);
            }
        }       
    }

寫一個集成 RowMapper的類

class mymap implements RowMapper<person>{

        public person mapRow(ResultSet rs, int arg1) throws SQLException {
            // TODO Auto-generated method stub
            String name = rs.getString(1);
            String age = rs.getString(2);
            person p = new person();
            p.setName(name);
            p.setAge(age);
            return p;
        }
        
    }

person類

public class person {
    private String name;
    private String age;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    @Override
    public String toString() {
        return "person [age=" + age + ", name=" + name + "]";
    }
    
}

遇到的問題：數(shù)據(jù)庫查詢中文的時候一直無法查詢；
解決辦法：在地址鏈接的地方添加?useUnicode=true&characterEncoding=utf8