{"id":337,"date":"2023-02-25T06:49:47","date_gmt":"2023-02-24T22:49:47","guid":{"rendered":"https:\/\/www.appblog.cn\/?p=337"},"modified":"2023-04-30T14:49:48","modified_gmt":"2023-04-30T06:49:48","slug":"spring-boot-custom-druid-data-source","status":"publish","type":"post","link":"https:\/\/www.appblog.cn\/index.php\/2023\/02\/25\/spring-boot-custom-druid-data-source\/","title":{"rendered":"Spring Boot\u81ea\u5b9a\u4e49Druid\u6570\u636e\u6e90"},"content":{"rendered":"

\u6dfb\u52a0\u76f8\u5173\u4f9d\u8d56<\/h2>\n
<dependencies>\n    <dependency>\n        <groupId>org.springframework.boot<\/groupId>\n        <artifactId>spring-boot-starter-web<\/artifactId>\n    <\/dependency>\n    <dependency>\n        <groupId>org.springframework.boot<\/groupId>\n        <artifactId>spring-boot-starter-test<\/artifactId>\n        <scope>test<\/scope>\n    <\/dependency>\n    <dependency>\n        <groupId>mysql<\/groupId>\n        <artifactId>mysql-connector-java<\/artifactId>\n    <\/dependency>\n    <dependency>\n        <groupId>org.springframework.boot<\/groupId>\n        <artifactId>spring-boot-starter-data-jpa<\/artifactId>\n    <\/dependency>\n    <dependency>\n        <groupId>com.alibaba<\/groupId>\n        <artifactId>druid<\/artifactId>\n    <\/dependency>\n<\/dependencies><\/code><\/pre>\n
<\/p>\n
Druid\u6570\u636e\u6e90\u914d\u7f6e<\/h2>\n
\u914d\u7f6eapplication.properties<\/code>\uff0c\u9996\u5148\u662f\u57fa\u672c\u7684\u94fe\u63a5\u5c5e\u6027\uff0c\u7136\u540e\u662fDruid\u7684\u76f8\u5173\u5c5e\u6027\u914d\u7f6e<\/p>\n
spring:\n  datasource:\n    #type: com.alibaba.druid.pool.DruidDataSource\n    driver-class-name: com.mysql.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/db1?useSSL=false&requireSSL=false\n    username: root\n    password: root<\/code><\/pre>\n
\u6ce8\u5165\u81ea\u5b9a\u4e49dataSource<\/h2>\n
\u4f7f\u7528@Bean("dataSource")<\/code>\u8986\u76d6\u9ed8\u8ba4\u7684dataSource\u6570\u636e\u6e90\uff0c\u7531\u4e8e\u6ca1\u6709\u914d\u7f6espring.datasource.type=com.alibaba.druid.pool.DruidDataSource<\/code>\uff0ccom.alibaba.druid.pool.DruidDataSource#configFromPropety<\/code>\u65b9\u6cd5\u4e0d\u4f1a\u5c06url\uff0cusername\uff0cpassword\uff0cdriver-class-name\u6ce8\u5165\u8fdb\u53bb\uff0c\u6240\u4ee5\u9700\u8981\u81ea\u5df2\u624b\u52a8\u8bbe\u7f6e<\/p>\n
@Configuration\npublic class CustomConfiguration {\n\n    @Value("${spring.datasource.url}")\n    String url;\n\n    @Value("${spring.datasource.username}")\n    String username;\n\n    @Value("${spring.datasource.password}")\n    String password;\n\n    @Value("${spring.datasource.driver-class-name}")\n    String driverClassName;\n\n    @Bean("dataSource")\n    public DataSource druidDataSource(StandardEnvironment env) {\n        Properties properties = new Properties();\n        DruidDataSource druidDataSource = new DruidDataSource();\n        PropertySource<?> appProperties = env.getPropertySources().get("applicationConfig: [classpath:\/application.yml]");\n        Map<String,Object>  source = (Map<String, Object>) appProperties.getSource();\n        properties.putAll(source);\n        druidDataSource.configFromPropety(properties);\n        druidDataSource.setUrl(url);\n        druidDataSource.setPassword(username);\n        druidDataSource.setUsername(password);\n        druidDataSource.setDriverClassName(driverClassName);\n        return druidDataSource;\n    }\n}<\/code><\/pre>\n
\u6d4b\u8bd5<\/h2>\n
\u5b9e\u4f53<\/h3>\n
@Setter\n@Getter\n@Entity\n@Table(name = "customer")\npublic class Customer implements Serializable {\n\n    @Id\n    @GeneratedValue(strategy = GenerationType.IDENTITY)\n    private Long id;\n\n    @Column(name = "nike_name")\n    private String nikeName;\n\n    @Column\n    private String email;\n\n    @Column\n    private String mobile;\n\n    @Column\n    private String phone;\n\n    @Column\n    private String address;\n}<\/code><\/pre>\n
Service\u5c42<\/h3>\n
@Service("customerService")\n@Transactional(rollbackFor = Exception.class)\npublic class CustomerServiceImpl implements CustomerService {\n\n    private static final String INSERT_CUSTOMER = "INSERT INTO customer (nike_name,email,mobile,phone,address) VALUES (?,?,?,?,?);";\n\n    @Autowired\n    private JdbcTemplate jdbcTemplate;\n\n    @Override\n    public void create(Customer customer) {\n        jdbcTemplate.update(INSERT_CUSTOMER, customer.getNikeName(),\n                customer.getEmail(), customer.getMobile(),\n                customer.getPhone(), customer.getAddress());\n        if("rollbackUser".equals(customer.getNikeName())){\n            throw new RuntimeException("test rollback on runtimeException.");\n        }\n    }\n}<\/code><\/pre>\n
\u6d4b\u8bd5\u7528\u4f8b<\/h3>\n
@RunWith(SpringRunner.class)\n@SpringBootTest\npublic class TestCustomerService {\n\n    @Autowired\n    private CustomerService customerService;\n\n    @Autowired\n    private JdbcTemplate jdbcTemplate;\n\n    @Test\n    public void testCreateCustomer(){\n        Customer customer = new Customer();\n        customer.setAddress("\u6d59\u6c5f\u676d\u5dde");\n        customer.setEmail("xxx@appblog.cn");\n        customer.setMobile("10086");\n        customer.setNikeName("Joe.Ye");\n        customer.setPhone("010-10086");\n        customerService.create(customer);\n    }\n\n    @Test\n    public void testRollback(){\n        Customer customer = new Customer();\n        customer.setAddress("\u6d59\u6c5f\u676d\u5dde");\n        customer.setEmail("xxx@appblog.cn");\n        customer.setMobile("10086");\n        customer.setNikeName("rollbackUser");\n        customer.setPhone("010-10086");\n        customerService.create(customer);\n    }\n\n    @Test\n    public void testSearchCustomer() {\n        String sql = "SELECT id FROM customer WHERE nike_name = 'Joe.Ye'";\n        Assert.notEmpty(jdbcTemplate.queryForList(sql, Long.class));\n    }\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u6dfb\u52a0\u76f8\u5173\u4f9d\u8d56 <dependencies> <dependency> <grou […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[110],"class_list":["post-337","post","type-post","status-publish","format-standard","hentry","category-spring-boot","tag-druid"],"_links":{"self":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/comments?post=337"}],"version-history":[{"count":0,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/posts\/337\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/media?parent=337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/categories?post=337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appblog.cn\/index.php\/wp-json\/wp\/v2\/tags?post=337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}