java用jdbc操作sql2000数据库.docVIP

package com.cnnct.jxmz.shsw.hygl.lhdj; /** * 本类封装所有对数据库的操作 * @author songxf * @version 1.0 2008.02 */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.Date; import java.util.List; import java.sql.*; import java.util.*; import com.cnnct.exception.*; import com.cnnct.util.*; import com.lbs.sieaf.exception.*; import com.lbs.sieaf.util.GlobalNames; public class DB2Util{ private static DB2Util db = null; private static Connection conn; private static PreparedStatement pStatement; // private ResultSet m_rs; private static String driver_class = null; private static String url = null; private static String username = null; private static String password = null; public DB2Util(){ try { Class.forName(driver_class); } catch (ClassNotFoundException e) { e.printStackTrace(); } } static { try { driver_class = GlobalNames.DB_JDBC_DRIVER; url = GlobalNames.DB_JDBC_URL; username = GlobalNames.DB_USERNAME; password = GlobalNames.DB_PASSWORD; } catch (Exception ex) { ex.printStackTrace(); } } public static DB2Util getInstance() { if (db == null) { db = new DB2Util(); } return db; } /** * This method is used to update the current object in DB * @see com.lbs.sieaf.dao.DAO#doUpdate(Connection, Object) * @param conn java.sql.Connection * @param obj an Object being to update * @throws SQLException */ public void doUpdate( Object obj) throws