Guest User

Untitled

a guest
Dec 26th, 2017
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.30 KB | None | 0 0
  1. spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
  2. spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
  3. spring.datasource.username=talon
  4. spring.datasource.password=talon
  5.  
  6. @Configuration
  7. public class Db {
  8.  
  9. @NotNull
  10. private String username;
  11. @NotNull
  12. private String password;
  13. @NotNull
  14. private String url;
  15.  
  16. public void setUsername(String username) {
  17. this.username = username;
  18. }
  19.  
  20. public void setPassword(String password) {
  21. this.password = password;
  22. }
  23.  
  24. public void setUrl(String url) {
  25. this.url = url;
  26. }
  27.  
  28. public Db() {
  29. OracleDataSource dataSource = null;
  30. try {
  31. dataSource = new OracleDataSource();
  32. dataSource.setUser(username);
  33. dataSource.setPassword(password);
  34. dataSource.setURL(url);
  35. dataSource.setImplicitCachingEnabled(true);
  36. dataSource.setFastConnectionFailoverEnabled(true);
  37. Connection connection = dataSource.getConnection();
  38. Statement statement = connection.createStatement();
  39. ResultSet rs = statement.executeQuery("select * from BOOK");
  40. rs.next();
  41. System.out.println(rs.getString(2));
  42. } catch (SQLException e) {
  43. e.printStackTrace();
  44. }
  45. }
  46.  
  47. }
Add Comment
Please, Sign In to add comment