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 + "]";
}
}
遇到的问题：数据库查询中文的时候一直无法查询；
解决办法：在地址链接的地方添加?useUnicode=true&characterEncoding=utf8
