package com.h.oa.util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class UtilConnectionLocal {public static final String USERNAME = "oa";public static final String USERPASS = "oa";public static final String URL =
"jdbc:oracle:thin:@localhost:1521:ORCL";public static final String ClASSSTRING =
"oracle.jdbc.driver.OracleDriver";public static Connection conn = null;public static ResultSet rs = null;public static Statement stm = null;public static ResultSet executeQuery(String sql, String[]
params) {try {Class.forName(ClASSSTRING).newInstance();conn = DriverManager.getConnection(URL, USERNAME,
USERPASS);stm = conn.createStatement();PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);int i = 0;if (params.length > 0) {for (int j = 0; j < params.length; j++) {ps.setString(++i, params[j]);}}rs = ps.executeQuery();} catch (InstantiationException e) {// instance exceptione.printStackTrace();} catch (IllegalAccessException e) {// ill exceptione.printStackTrace();} catch (ClassNotFoundException e) {// class exceptione.printStackTrace();} catch (SQLException e) {// sql exceptione.printStackTrace();} finally {try {//rs.close();//stm.close();//conn.close();} catch (Exception e) {// sql exceptione.printStackTrace();}}return rs;}public static int executeUpdate(String sql, String[] params)
{int target = 0;try {Class.forName(ClASSSTRING).newInstance();conn = DriverManager.getConnection(URL, USERNAME,
USERPASS);stm = conn.createStatement();PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);int i = 0;if (params.length > 0) {for (int j = 0; j < params.length; j++) {ps.setString(++i, params[j]);}}target = ps.executeUpdate();} catch (InstantiationException e) {// instance exceptione.printStackTrace();} catch (IllegalAccessException e) {// ill exceptione.printStackTrace();} catch (ClassNotFoundException e) {// class exceptione.printStackTrace();} catch (SQLException e) {// sql exceptione.printStackTrace();} finally {try {//rs.close();//stm.close();//conn.close();} catch (Exception e) {// sql exceptione.printStackTrace();}}return target;}}
