oracle 连接... 修改.....查询

package com.Utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;

public class DBUtils {
static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

private DBUtils() {
}

public static Connection getConnection() {
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String dbname = "scott";
String dbpwd = "tiger";
try {
return DriverManager.getConnection(url, dbname, dbpwd);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public static boolean update(String sql, Object[] param) {
Connection conn = null;
PreparedStatement stmt = null;
int rs = 0;
try {
conn = getConnection();
stmt = conn.prepareStatement(sql);
pstmt(stmt, param);
rs = stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(null, stmt, conn);
}
return rs != 0;
}
private static void pstmt(PreparedStatement stmt, Object[] param) {
if (param != null) {
try {
for (int i = 0; i < param.length; i++) {
if (param[i].getClass() == java.lang.Integer.class) {
stmt.setInt(i + 1, (Integer) param[i]);
} else if (param[i].getClass() == java.lang.String.class) {
stmt.setString(i + 1, (String) param[i]);
} else if (param[i].getClass() == java.util.Date.class) {
stmt.setTimestamp(i + 1,new Timestamp(((java.util.Date) param[i]).getTime()));
}
}
} catch (SQLException e) {
e.printStackTrace();
}

}
}


public static List<String[]> query(String sql, Object[] param) {
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
ResultSetMetaData meta = null;// 列名，列数量，列类型,,,
List<String[]> lists = new ArrayList<String[]>();

try {
conn = getConnection();
stmt = conn.prepareStatement(sql);
pstmt(stmt, param);
rs = stmt.executeQuery();

meta = stmt.getMetaData();
int count = meta.getColumnCount();// 一共查询几列...
while (rs.next()) {// 一行..
String[] arr = new String[count];// 一行放在一个String 数组当中...
for (int i = 1; i <= count; i++) {// 每一个列..放在数组....
arr[i - 1] = rs.getString(i);
}
lists.add(arr);// 再把数且放在list
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(rs, stmt, conn);

}
return lists;// 返回列..
}
public static void close(ResultSet rs, Statement stmt, Connection conn) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}