package com.itmark.utils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @author makuan
* @date 2021/8/15 15:56
*/
public class ConUtils {
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws
SQLException {
return java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.119.128:1521:orcl",
"makuan", "mxxxxu");
}
public static void closeAll(Connection connection, PreparedStatement pst, ResultSet resultSet) {
if (connection != null) {
try {
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (pst != null) {
try {
pst.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
//方法重载,因为只有查询需要关闭结果集
public static void closeAll(Connection connection, PreparedStatement pst) {
closeAll(connection,pst,null);
}
}
oracle是基于用户维护数据的,知道用户名密码即可操作对应的数据表。另外表是属于表空间的,类似于mysql的数据表名。