1.jar包
2.utils
JDBCtemplate依赖于DataSource 所以对DataSource方法封装
public static DataSource getDataSource() {
try {
ds = DruidDataSourceFactory.createDataSource(pro);
} catch (Exception e) {
e.printStackTrace();
}
return ds;
}
3.各种方法的实现
public class Test {
DruidUtils utils = new DruidUtils();
//在外面获取jdbcTemplate 以后不用每次都获取
private JdbcTemplate jdbcTemplate = new JdbcTemplate(utils.getDataSource());
@org.junit.Test
// DML update 修改
public void update() {
String sql = "update test1 set username = ? where uid = ?";
int update = jdbcTemplate.update(sql, 1234, 1);
System.out.println(update);
}
@org.junit.Test
// DML 添加一条记录
public void add() {
String sql = "insert into test1 values(?,?,?,?)";
int num = jdbcTemplate.update(sql, 2, "古力娜扎", "123", "456");
System.out.println(num);
}
@org.junit.Test
//DML 删除一条记录
public void delete() {
String sql = "delete from test1 where uid = ?";
int num2 = jdbcTemplate.update(sql, 2);
System.out.println(num2);
}
@org.junit.Test
//DQL 根据id查询 结果返回一条 一条用map集合装 queryForMap方法
public void findbyid() {
String sql = "select * from test1 where uid = ?";
Map<String, Object> map = jdbcTemplate.queryForMap(sql, 1);
System.out.println(map);
}
@org.junit.Test
//DQL 全查 结果返回多条map集合 再利用list集合装map queryForList方法
public void findall() {
String sql = "select * from test1";
List<Map<String, Object>> list = jdbcTemplate.queryForList(sql);
for (Map<String, Object> list1 : list) {
System.out.println(list1);
}
}
@org.junit.Test
//查询所有对象 将其封装成javabean对象
public void javaBean(){
String sql = "select * from test1";
List<User> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
for(User list1:list){
System.out.println(list1);
}
}
@org.junit.Test
//查询总记录数
public void findNumber(){
String sql = "select count(*) from test1";
Long aLong = jdbcTemplate.queryForObject(sql, long.class);
System.out.println(aLong);
}
}