DriverManagerDataSource dataSource=new DriverManagerDataSource();    dataSource.setDriverClassName("com.mysql.jdbc.Driver");    dataSource.setUrl("jdbc:mysql:///springjdbc");    dataSource.setUsername("root");    dataSource.setPassword("1997WFY.....");    JdbcTemplate template=new JdbcTemplate();    template.setDataSource(dataSource);    template.execute("create table book(id int primary key auto_increment,name varchar(20) not null,author varchar(25))");

  <!-- XML配置Spring默認(rèn)的連接池 -->  <bean id="driverManagerDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>    <property name="url" value="jdbc:mysql:///springjdbc"/>     <property name="username" value="root"/>    <property name="password" value="1997WFY....."/>  </bean>  <bean class="org.springframework.jdbc.core.JdbcTemplate">    <property name="dataSource" ref="driverManagerDataSource"/>  </bean>

/** * @author BeautifulSoup * 首先使用Spring內(nèi)置的連接池 */@ContextConfiguration("classpath:applicationContext.xml")@RunWith(SpringJUnit4ClassRunner.class)public class SpringJdbcTest {  @Autowired  private JdbcTemplate template;  @Test  public void testDriverManagerDataSource() {    template.execute("create table book(id int primary key auto_increment,name varchar(20) not null,author varchar(25))");  }}

  <!-- 配置Druid的連接池 -->  <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">    <property name="driverClassName" value="com.mysql.jdbc.Driver" />    <property name="url" value="jdbc:mysql:///springjdbc" />    <property name="username" value="root" />    <property name="password" value="1997WFY....." />    <!-- 設(shè)置初始的連接數(shù)目,最小的連接數(shù)，最大的連接數(shù) -->    <property name="initialSize" value="1" />    <property name="minIdle" value="1" />    <property name="maxActive" value="8" />    <!-- 配置獲取連接等待超時(shí)的時(shí)間 -->    <property name="maxWait" value="10000" />    <!-- 配置間隔多久才進(jìn)行一次檢測需要關(guān)閉的空閑連接 -->    <property name="timeBetweenEvictionRunsMillis" value="60000" />    <!-- 配置一個(gè)連接在池中最小的生存時(shí)間 -->    <property name="minEvictableIdleTimeMillis" value="300000" />    <property name="testWhileIdle" value="true" />    <!-- 這里建議配置為TRUE，防止取到的連接不可用 -->    <property name="testOnBorrow" value="true" />    <property name="testOnReturn" value="false" />    <!-- 打開PSCache，并且指定每個(gè)連接上PSCache的大小 -->    <property name="poolPreparedStatements" value="true" />    <property name="maxPoolPreparedStatementPerConnectionSize"      value="20" />    <!-- 這里配置提交方式，默認(rèn)就是TRUE，可以不用配置 -->    <property name="defaultAutoCommit" value="true" />    <!-- 驗(yàn)證連接有效與否的SQL，不同的數(shù)據(jù)配置不同 -->    <property name="validationQuery" value="select 1 " />    <property name="filters" value="stat" />  </bean>  <bean class="org.springframework.jdbc.core.JdbcTemplate">    <property name="dataSource" ref="druidDataSource" />  </bean>

/** * @author BeautifulSoup * 首先使用Spring內(nèi)置的連接池 */@ContextConfiguration("classpath:applicationContext.xml")@RunWith(SpringJUnit4ClassRunner.class)public class SpringJdbcTest {  @Autowired  private JdbcTemplate template;  @Test  public void testSpringJdbc() {    template.execute("create table book(id int primary key auto_increment,name varchar(20) not null,author varchar(25))");  }}

/** * @author BeautifulSoup * 創(chuàng)建實(shí)體類對象 */public class Book {  private Integer id;  private String name;  private String author;  public Integer getId() {    return id;  }  public void setId(Integer id) {    this.id = id;  }  public String getName() {    return name;  }  public void setName(String name) {    this.name = name;  }  public String getAuthor() {    return author;  }  public void setAuthor(String author) {    this.author = author;  }  @Override  public String toString() {    return "Book [id=" + id + ", name=" + name + ", author=" + author + "]";  }}

<bean class="com.fuyunwang.springjdbc.dao.BookDao">    <property name="jdbcTemplate" ref="jdbcTemplate"/></bean>

/** * @author BeautifulSoup 完成基本的增刪改查 */public class BookDao extends JdbcDaoSupport {  public void add(Book book) {    String sql = "insert into book values(?,?,?)";    getJdbcTemplate().update(sql, book.getId(), book.getName(),        book.getAuthor());  }  public void update(Book book) {    String sql = "update book set name = ? , author = ? where id =?";    getJdbcTemplate().update(sql, book.getName(), book.getAuthor(),        book.getId());  }  public void delete(Book book) {    String sql = "delete from book where id =?";    getJdbcTemplate().update(sql, book.getId());  }  public int findCount() {    String sql = "select count(*) from book";    return getJdbcTemplate().queryForInt(sql);  }  public String findNameById(int id) {    String sql = "select name from book where id = ?";    return getJdbcTemplate().queryForObject(sql, String.class, id);  }  public Book findById(int id) {    String sql = "select * from book where id = ?";    return getJdbcTemplate().queryForObject(sql, new BookMapper(), id);  }  public List<Book> findAll(){    String sql="select * from book";    return getJdbcTemplate().query(sql, new BookMapper());  }  class BookMapper implements RowMapper<Book> {    public Book mapRow(ResultSet rs, int rowNum) throws SQLException {      Book book = new Book();      book.setId(rs.getInt("id"));      book.setName(rs.getString("name"));      book.setAuthor(rs.getString("author"));      return book;    }  }}

/** * @author BeautifulSoup * 首先使用Spring內(nèi)置的連接池 */@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration("classpath:applicationContext.xml")public class SpringJdbcTest {  @Autowired  private BookDao bookDao;  @Test  public void jdbcTemplateAdd(){    Book book=new Book();    book.setId(1);    book.setName("SpringBoot實(shí)戰(zhàn)");    book.setAuthor("Craig Walls");    bookDao.add(book);  }}