spring(22)JdbcTemplate

###1.导入jar包&＃xff0c;必须jar包&＃xff1a;c3p0、mysql-connector、beans、context、dao、jdbc&＃xff0c;截图如下

###2.db.properties

jdbc.user&＃61;root
jdbc.password&＃61;123456
jdbc.driverClass&＃61;com.mysql.jdbc.Driver
jdbc.jdbcUrl&＃61;jdbc:mysql:///test?useUnicode&＃61;true&characterEncoding&＃61;UTF8jdbc.initPoolSize&＃61;10
jdbc.maxPoolSize&＃61;50

###3.applicationContext.xml

###4.jdbcTest

package com.test.spring.jdbc;import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;import javax.sql.DataSource;import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;public class JdbcTest {private ApplicationContext ctx&＃61; null;private JdbcTemplate jdbcTemplate;{ctx &＃61; new ClassPathXmlApplicationContext("applicationContext.xml");jdbcTemplate &＃61; (JdbcTemplate) ctx.getBean("jdbcTemplate");}/*** 单个 更新/插入/删除*/&＃64;Testpublic void testUpdate(){String sql &＃61; "update t_thing set content&＃61;? where id&＃61;?";jdbcTemplate.update(sql, "张三","1000000001");}/*** 批量 更新/插入/删除*/&＃64;Testpublic void testBatchInsert(){/*** 注意&＃xff1a;数据库字段是5个列&＃xff1a;id,name,content,flag,addTime* 我将id设置为自增长&＃xff0c;所以这里insert时不需要填写id*/String sql &＃61; "insert into t_thing(name,content,flag,addTime) values(?,?,?,?)";List batchArgs &＃61; new ArrayList<>();batchArgs.add(new Object[]{"王五","完成","1","20160904111700"});batchArgs.add(new Object[]{"赵六","没有完成","1","20160904111701"});jdbcTemplate.batchUpdate(sql, batchArgs);}/*** 查询单条记录* 注意&＃xff1a;* 1.使用queryForObject(String sql, RowMapper rowMapper, Object... args)查询单个对象* 2.RowMapper指定映射结果集的行&＃xff0c;常用的实现类BeanPropertyRowMapper* 3.sql语句要用别名指定返回的字段与接收对象的属性一致* 4.不支持级联查询&＃xff0c;所以需要使用mybatis等框架*/&＃64;Testpublic void testQueryForObject(){String sql &＃61; "SELECT id,name,content,flag,addTime FROM t_thing WHERE id&＃61;?";RowMapper rowMapper &＃61; new BeanPropertyRowMapper<>(Thing.class);Thing thing &＃61; (Thing)jdbcTemplate.queryForObject(sql, rowMapper,1000000000);System.out.println(thing);}/*** 查询多条记录* 注意&＃xff1a;* 1.调用的不是QueryForList()方法*/&＃64;Testpublic void testQueryForList(){String sql &＃61; "SELECT id,name,content,flag,addTime FROM t_thing";RowMapper rowMapper &＃61; new BeanPropertyRowMapper<>(Thing.class);List list &＃61; jdbcTemplate.query(sql, rowMapper);System.out.println(list);}/*** 统计查询*/&＃64;Testpublic void testQueryCount(){String sql &＃61; "SELECT COUNT(tt.id) FROM t_thing tt";long count &＃61; jdbcTemplate.queryForObject(sql, long.class);System.out.println(count);}/*** 测试数据库联通*/&＃64;Testpublic void test() throws SQLException {DataSource dataSource &＃61; (DataSource) ctx.getBean("dataSources");System.out.println(dataSource.getConnection());}}

###5.bean

public class Thing {private Integer id;private String name;private String content;private int flag;private String addTime;
}


###6.数据库