韩顺平SqlHelper.docxVIP

package com.utils;import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.Properties;import java.sql.*;public class SqlHelper{ //定义变量 private static Connection ct = null; //大多数情况下用preparedstatement替代statement private static PreparedStatement ps = null; private static ResultSet rs = null; //连接数据库的参数 private static String url = ; private static String username = ; private static String driver = ; private static String passwd = ; private static CallableStatement cs = null; public static CallableStatement getCs() { return cs; } private static Properties pp = null; private static InputStream fis = null; //加载驱动，只需要一次，用静态代码块 static { try { //从perties pp = new Properties(); fis=SqlHelper.class.getClassLoader().getResourceAsStream(perties); //fis = new FileInputStream(); pp.load(fis); url = pp.getProperty(dbUrl); username = pp.getProperty(dbUserName); driver = pp.getProperty(dbDriver); passwd = pp.getProperty(dbPassWord); Class.forName(driver); } catch (Exception e) { e.printStackTrace(); } finally { try { fis.close();} catch(IOException e) {e.printStackTrace();} fis = null;//垃圾回收站上收拾 } } //得到连接 public static Connection getConnection() { try {ct = DriverManager.getConnection(url,username,passwd);} catch(Exception e) {e.printStackTrace();} return ct; } //*callPro1存储过程函数1* public static CallableStatement callPro1(String sql,String[] parameters) { try{ ct = getConnection(); cs = ct.prepareCall(sql); if(parameters!=null){ for(int i=0;iparameters.length;i++){ cs.setObject(i+1,parameters[i]); } } cs.execute(); } catch(Exception e) { e.printStackTrace(); throw new RuntimeException(e.getMessage());} finally { close(rs,cs,ct);} return cs; } //*callpro2存储过程2public static CallableStatement callPro2(String sql,String[] inparameters,Inte