Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
- spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
- spring.datasource.username=talon
- spring.datasource.password=talon
- @Configuration
- public class Db {
- @NotNull
- private String username;
- @NotNull
- private String password;
- @NotNull
- private String url;
- public void setUsername(String username) {
- this.username = username;
- }
- public void setPassword(String password) {
- this.password = password;
- }
- public void setUrl(String url) {
- this.url = url;
- }
- public Db() {
- OracleDataSource dataSource = null;
- try {
- dataSource = new OracleDataSource();
- dataSource.setUser(username);
- dataSource.setPassword(password);
- dataSource.setURL(url);
- dataSource.setImplicitCachingEnabled(true);
- dataSource.setFastConnectionFailoverEnabled(true);
- Connection connection = dataSource.getConnection();
- Statement statement = connection.createStatement();
- ResultSet rs = statement.executeQuery("select * from BOOK");
- rs.next();
- System.out.println(rs.getString(2));
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment