JdbcTemplate_注解使用方式

启动类

@ComponentScan
@Configuration
@PropertySource("classpath:c3p0dataSource.properties")
public class SpringConfig {
		    @Value("${jdbc.driver}")
		    private String driver;
		    @Value("${jdbc.url}")
		    private String url;
		    @Value("${jdbc.username}")
		    private String username;
		    @Value("${jdbc.password}")
		    private String password;
		    // 产生dataSource的Bean对象
		    @Bean("dataSource")
		    public DataSource c3p0DataSource() throws PropertyVetoException {
		        // 设置数据源对象
		        ComboPooledDataSource dataSource = new ComboPooledDataSource();
		        dataSource.setDriverClass(driver);
		        dataSource.setJdbcUrl(url);
		        dataSource.setUser(username);
		        dataSource.setPassword(password);
		        return dataSource;
		    }
		    // 产生JdbcTemplate的Bean对象，并且将dataSource数据源以参数的形式进行注入到JdbcTemplate的Bean对象中
		    @Bean("jdbcTemplate")
		    public JdbcTemplate returnJdbcTemplate(DataSource dataSource){
		        return new JdbcTemplate(dataSource);
		    }
		}
 

数据源文件

jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/ajax
jdbc.username = root
jdbc.password = root

实体类

@Getter
@Setter
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {
    private int id;
    private String username;
    private String address;
}

测试类

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = {SpringConfig.class})
public class UserTest {

    @Autowired
    JdbcTemplate jdbcTemplate;
    @Test
    public void test() throws PropertyVetoException {

        // 将数据源对象置入JdbcTemplate对象中
        int i  = jdbcTemplate.update("insert into userinfo (username,address) values (?,?)","zhangsan","xian");
        System.out.println(i);

    }