Java连接
package com.example.demo;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
@SpringBootTest
class DemoApplicationTests {
@Test
void contextLoads() throws Exception{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@*********:1521:helowin", "scott", "tiger");
PreparedStatement pstm = connection.prepareStatement("select * from emp");
ResultSet resultSet = pstm.executeQuery();
while(resultSet.next()){
System.out.println(resultSet.getString("ename"));
}
resultSet.close();
pstm.close();
connection.close();
}
}