HikariConfig configuration = new HikariConfig(); configuration.setJdbcUrl("jdbc:oracle:thin:@localhost:1521/ORCL"); configuration.setDriverClassName("oracle.jdbc.driver.OracleDriver"); configuration.setUsername("root"); configuration.setPassword("123456"); HikariDataSource dataSource=new HikariDataSource(configuration); Connection connection = dataSource.getConnection(); PreparedStatement preparedStatement = connection.prepareStatement("SELECT PDATA FROM XCGK_IMG_DATA1 where PID=?"); preparedStatement.setString(1,"123456"); ResultSet resultSet = preparedStatement.executeQuery(); List<String> strings = new ArrayList<>(); while (resultSet.next()) { String pdata = resultSet.getString(1); strings.add(pdata); log.info("pdata->{} ;",pdata); } System.out.println(dataSource); if (preparedStatement!=null) { preparedStatement.close(); } if (dataSource!=null) { connection.close(); }
<dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc8</artifactId> <version>8</version> </dependency> <dependency> <groupId>cn.easyproject</groupId> <artifactId>orai18n</artifactId> <version>12.1.0.2.0</version> </dependency>