韩顺平php sqlhelper类,韩顺平SqlHelper

packagecom.utils;

importjava.io.FileInputStream;

importjava.io.IOException;

importjava.io.InputStream;

importjava.sql.Connection;

importjava.sql.DriverManager;

importjava.sql.ResultSet;

importjava.sql.ResultSetMetaData;

importjava.sql.SQLException;

importjava.sql.Statement;

importjava.util.ArrayList;

importjava.util.Properties;

importjava.sql.*;

public class SqlHelper

{

//定义变量

private static Connection ct = null;

//大多数情况下用preparedstatement替代statement

private static PreparedStatementps = null;

private static ResultSetrs = null;

//连接数据库的参数

private static String url = "";

private static String username = "";

private static String driver = "";

private static String passwd = "";

private static CallableStatementcs = null;

public static CallableStatementgetCs()

{

returncs;

}

private static Properties pp = null;

private static InputStreamfis = null;

//加载驱动，只需要一次，用静态代码块

static

{

try

{

//从dbinfo.properties

pp = new Properties();

fis=SqlHelper.class.getClassLoader().getResourceAsStream("mysql.properties");

//fis = new FileInputStream();

pp.load(fis);