<dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.3.19</version></dependency>

<!-- DataSource配置 --><bean id="dataSource"class="com.mchange.v2.c3p0.ComboPooledDataSource"destroy-method="close" p:driverClass="${jdbc.driverClassName}"p:jdbcUrl="${jdbc.url}" p:user="${jdbc.username}"p:password="${jdbc.password}" /><!-- jdbcTemplate配置 -->	<bean id="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"></property></bean>

package testSpring;import java.util.ArrayList;
import java.util.List;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;import test.spring.model.User;public class TestSpring {@Testpublic void testUser() {ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");JdbcTemplate jdbcTemplate= ac.getBean(JdbcTemplate.class);/* 增加 */String sql1="insert into 'users' ('userName','password') values (?,?) ";jdbcTemplate.update(sql1, "abc","abc123");/* 刪除 */String sql2="delete from 'users' where id=? ";jdbcTemplate.update(sql2, 1);/* 查找一個對象 */String sql3 = "select * from User where id=?";RowMapper< User> mapper=new BeanPropertyRowMapper<>(User.class);User user=jdbcTemplate.queryForObject(sql3, mapper, 1);System.out.println(user);/* 查找出多個數據 */String sql4 = "select * from User where id>?";RowMapper< User> mapper2=new BeanPropertyRowMapper<>(User.class);List<User> users =jdbcTemplate.query(sql4, mapper2, 0);System.out.println(users);/* 查找顯示單個列值 */String sql5 = "select count(id) from users";Long count=jdbcTemplate.queryForObject(sql5, Long.class);System.out.println(count);/*批量插入*/String sql7="insert into 'users' ('userName','password') values (?,?) ";List<Object[]> args=new ArrayList<>();args.add(new Object[] {"aa","aa123"});args.add(new Object[] {"bb","bb123"});jdbcTemplate.batchUpdate(sql7, args);}}