Guest User

Untitled

a guest
Feb 13th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. @Configuration
  2. public class SpringConfig {
  3. @Bean
  4. @Singleton
  5. public DataSource getDataSource() {
  6. BasicDataSource basicDataSource = new BasicDataSource();
  7. basicDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
  8. basicDataSource.setUrl("jdbc:mysql://localhost:3306/db?serverTimezone=UTC");
  9. basicDataSource.setUsername("name");
  10. basicDataSource.setPassword("password");
  11. basicDataSource.setInitialSize(5);
  12. basicDataSource.setMinIdle(3);
  13. basicDataSource.setMaxIdle(15);
  14. basicDataSource.setMaxWait(10000);
  15. basicDataSource.setMaxActive(100);
  16. return basicDataSource;
  17. }
  18. }
  19.  
  20. @Configuration
  21. @PropertySource("classpath:database.properties")
  22. public class SpringConfig {
  23. private @Value("${propertyName}") String propertyField;
  24.  
  25. @Bean
  26. @Singleton
  27. public DataSource getDataSource() {
  28. BasicDataSource basicDataSource = new BasicDataSource();
  29. basicDataSource.setConnectionProperties(propertyField);
  30. return basicDataSource;
  31. }
  32. }
  33.  
  34. driverClassName = "com.mysql.cj.jdbc.Driver"
  35. url="jdbc:mysql://localhost:3306/db"
  36. username="user"
  37. password="password"
  38.  
  39. @Configuration
  40. @PropertySource("classpath:/database.properties")
  41. public class SpringConfig {
  42. @Autowired
  43. Environment environment;
  44.  
  45. @Bean
  46. @Singleton
  47. public DataSource getDataSource() {
  48. BasicDataSource basicDataSource = new BasicDataSource();
  49. basicDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
  50. basicDataSource.setUrl("jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC");
  51. basicDataSource.setUsername(environment.getProperty("username"));
  52. basicDataSource.setPassword(environment.getProperty("password"));
  53. ..other actions is here
  54. }
  55. }
Add Comment
Please, Sign In to add comment