import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
public class ConnOracle {
public Connection getConnection() {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
public void test() {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
String sql = "select * from emp0608";
try {
// 2. 获取数据库连接
conn = this.getConnection();
// 3. 创建 Statement 对象
stmt = conn.prepareStatement(sql);
// 4. 执行 SQL 语句
rs = stmt.executeQuery();
// 5. 处理结果集
int empno = rs.getInt("empno");