通用java jdbc连接Oracle执行增删改查

import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.Hashtable;

import oracle.jdbc.OracleConnection;
import oracle.jdbc.OraclePreparedStatement;
import oracle.jdbc.OracleResultSet;
import oracle.jdbc.OracleResultSetMetaData;

public class OracleDb {

public static OracleConnection getConnection() {
OracleConnection connection = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = (OracleConnection) DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:aodb", "dbo", "sunshine");

} catch (Exception e) {
e.printStackTrace();
}
return connection;
}

public static ArrayList<Hashtable<String, Object>> executeQuery(String sql,ArrayList<Object> params) {
ArrayList<Hashtable<String, Object>> result = null;
OracleConnection connection = getConnection();
OraclePreparedStatement pstmt = null;
OracleResultSet rs = null;
try {
pstmt = (OraclePreparedStatement) connection.prepareStatement(sql);
if (null != params) {
if (params.size() > 0) {
for (int i = 0; i < params.size(); i++) {
pstmt.setObject(i + 1, params.get(i));
}
}
}
rs = (OracleResultSet) pstmt.executeQuery();
if (null != rs) {
result = new ArrayList<Hashtable<String, Object>>();
while (rs.next()) {
Hashtable<String, Object> row = new Hashtable<String, Object>();
OracleResultSetMetaData rsmd = (OracleResultSetMetaData) rs
.getMetaData();
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
if (null != rs.getObject(i)) {
row.put(rsmd.getColumnName(i).toLowerCase(), rs.getObject(i));
}

}
result.add(row);
}
}

} catch (Exception e) {
e.printStackTrace();
} finally {
closeAll(rs, pstmt, connection);
}

return result;

}

public static int executeSava(String sql, ArrayList<Object> params) {
int result = 0;
OracleConnection connection = getConnection();
OraclePreparedStatement pstmt = null;

try {
pstmt = (OraclePreparedStatement) connection.prepareStatement(sql);
if (null != params) {
if (params.size() > 0) {
for (int i = 0; i < params.size(); i++) {
pstmt.setObject(i + 1, params.get(i));
}
}
}
result = pstmt.executeUpdate();

} catch (Exception e) {
e.printStackTrace();
} finally {
closeAll(null, pstmt, connection);
}
return result;
}

public static void closeAll(OracleResultSet rs, OraclePreparedStatement pstmt, OracleConnection connection) {
try {
if (null != rs) {
rs.close();
rs = null;
}
if (null != pstmt) {
pstmt.close();
pstmt = null;
}
if (null != connection) {

connection.close();
connection = null;
}
} catch (Exception e) {
e.printStackTrace();
}

}

}