Java 数据库的Util

 import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import com.paic.is.dispatch.TMPEntry;
import javapasswordsdk.PSDKPassword;
import javapasswordsdk.PSDKPasswordRequest;
import javapasswordsdk.exceptions.PSDKException;
public class DBUtil
{
public final static String SELECT = " select ";
public final static String from = " from ";
public final static String WHERE = " where ";
public final static String ON = " on ";
public final static String LEFT_JOIN = " left join ";
public final static String RIGHT_JOIN = " right join ";
public final static String INNER_JOIN = " inner join ";
public final static String COLUMN_SEPARATOR = " , ";
public final static String INSERT = " insert ";
public final static String INTO = " into ";
public final static String UPDATE = " update ";
public final static String SET = " set ";
public final static String LEFT_PARENTHESES = " ( ";
public final static String RIGHT_PARENTHESES = " ) ";
public final static String SINGLE_QUOTATION = "'";
public final static String TO_DATE = "to_date";
public final static String COMMA = " , ";
public final static String VALUES = " values ";
public final static String CONCATENATE_SING = "&";
public final static String CONCATENATE_STRING = "||";
public final static String CONCATENEATE_REPLACEMENT = "||'&'||";
public static String packColumnName(String columnName)
{
return " " + columnName + " ";
}

public static void executeSqlMapBatch(HashMap<String, ArrayList<String>> sqlMap)
{
if(null == sqlMap || sqlMap.size() <=0)
{
return;
}

Connection conn = DBConnection.getConnection();
Statement stmt = null;
try
{
conn.setAutoCommit(false);
stmt = conn.createStatement();
for(Iterator<String> i