java preparestatement oracle,求帮忙用prepareStatement 预编译 封装

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import java.sql.*;

public class SQLBeanDemo{

private static String DRIVER_NAME = "oracle.jdbc.driver.OracleDriver";

private static String DRIVER_URL = "jdbc:oracle:thin:@localhost:1521:orcl";

private static String USER_NAME = "scott";

private static String PASSWORD = "tiger";

private Connection con;

static{

try{

Class.forName(DRIVER_NAME);

}catch(Exception e){

System.out.println ("加载驱动程序失败");

}

}

public Connection getConnection(){

try{

if(con==null||con.isClosed()){

con=DriverManager.getConnection(DRIVER_URL,USER_NAME,PASSWORD);

}

}catch(Exception ex){

System.out.println ("连接数据源失败");

}

return con;

}

//关闭的方法

public void closeConnection(){

try{

if(con!=null&& !con.isClosed()){

con.close();

}

}

catch(Exception ex){

}

}

public boolean insert(String sql,Object[] str){

return executeUpdate(sql,str);

}

public boolean update(String sql,Object[] str){

return executeUpdate(sql,str);

}

public boolean delete(String sql,Object[] str){

return executeUpdate(sql,str);

}

private boolean executeUpdate(String sql,Object str){

PreparedStatement ps = null;

int i = 0;

try{

ps = getConnection().prepareStatement(sql); //createStatement();

i = ps.executeUpdate();

}catch(Exception ex){

System.out.println ("SQL执行失败");

}finally{

try{

if(ps!=null&& !ps.isClosed()){

ps.close();

}

closeConnection();

}

catch(Exception ex){

}

}

return i > 0;

}

public ResultSet query(String sql){

PreparedStatement ps = null;

ResultSet rs = null;

try{

ps = getConnection().prepareStatement(sql);

rs = ps.executeQuery();

}

catch(Exception ex){

System.out.println ("执行查询失败");

}

return rs;

}

}

求帮忙用prepareStatement 预编译

改下这个代码