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();
}
}
}
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();
}
}
}