public class test {
public static void main(String[] args) {
BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName("com.mysql.jdbc.Driver");
ds.setUrl("jdbc:mysql://192.168.1.89:3306/yuncai_user?useUnicode=true&characterEncoding=UTF-8&SelectMethod=Cursor");
ds.setUsername("root");
ds.setPassword("123123");
ds.setInitialSize(3);
ds.setMaxActive(10); BasicDataSource ds2 = new BasicDataSource();
ds2.setDriverClassName("com.mysql.jdbc.Driver");
ds2.setUrl("jdbc:mysql://localhost:1234/db1");
ds2.setUsername("root");
ds2.setPassword("123123");
ds2.setInitialSize(3);
ds2.setMaxActive(10);
JdbcTemplate disneyNewT = new JdbcTemplate(ds);
JdbcTemplate disneyOldT = new JdbcTemplate(ds2);
List<Map> users = disneyNewT.queryForList("select * from users");
for(Map m : users){
System.out.println(m.get("uid"));
}
}
}