Spring(纯注解&整合C3P0)

步骤:

1. 导包

2. 书写配置类

• 书写spring配置类

 @Configuration
@Import(value={JdbcConfig.class})
@PropertySource("classpath:db.properties")
public class SpringConfig {

}

• 书写Jdbc配置类

public class JdbcConfig {

@Value("${driverClass}")
private String driverClass;
@Value("${jdbcUrl}")
private String jdbcUrl;
@Value("${jdbc.username}")
private String user;
@Value("${password}")
private String password;

@Bean(name = "dataSource")
public DataSource createDataSource() {
System.out.println(user);
ComboPooledDataSource ds = new ComboPooledDataSource();

try {
ds.setDriverClass(driverClass);
ds.setJdbcUrl(jdbcUrl);
ds.setUser(user);
ds.setPassword(password);
} catch (PropertyVetoException e) {
e.printStackTrace();
}
return ds;
}

@Bean(name = "runner")
public QueryRunner createQueryRunner(@Qualifier("dataSource") DataSource ds) {
return new QueryRunner(ds);
}
}

3. 测试

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes={SpringConfig.class})
public class Demo {
   
	@Autowired
	private QueryRunner runner;
	
	@Test
	public void  fun () throws SQLException{
		
		String sql = "select * from cst_customer";
		List<Customer> query = runner.query(sql, new BeanListHandler<Customer>(Customer.class));
		for (Customer customer : query) {
			System.out.println(customer);
		}
	}
}