jdbcutil.java

EasyDBO v0.4 是一个非常适合中小型软件数据库开发的数据持久层框架

package com.easyjf.dbo;

import java.math.BigDecimal;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;


public abstract class JDBCUtil {
 private final static Logger logger = Logger.getLogger(JDBCUtil.class);
	public static void setQueryParams(Collection queryParams,
	    PreparedStatement ps) throws Exception {
	    if ((queryParams == null) || (queryParams.isEmpty()))
	        return;
	    Iterator iter = queryParams.iterator();
	    int i = 1;
	    while (iter.hasNext()) {
	        Object key = iter.next();
	        setQueryParam(key,i,ps);
	       // System.out.println(i+""+key+":"+key.getClass().toString());
	        i++;
	        
	    }
	}
public static  List resultSet2List(ResultSet rs) throws Exception {
		if(rs==null)return null;	    
	    List ret = new ArrayList();
	    while (rs.next()) {	       
	        ret.add(resultSet2Map(rs));
	    }
	    return ret;
	}
public static  Map resultSet2Map(ResultSet rs) throws Exception {
	if(rs==null)return null;
    ResultSetMetaData meta = rs.getMetaData();
    int count = meta.getColumnCount();       
        Map map = new HashMap(count);
        for (int i = 1; i <= count; i++) {
            map.put(meta.getColumnName(i),rs.getObject(i));
        }
       return map;
}


public static void setQueryParam(Object obj,int column,PreparedStatement ps)
	{   
	
	 try{	
     if (obj instanceof java.lang.String) {
         String keyStrs = (String) obj;       
             ps.setString(column, keyStrs);
     } else if (obj instanceof Integer) {
         ps.setInt(column, ((Integer) obj).intValue());      
     } else if (obj instanceof Float) {
         ps.setFloat(column, ((Float) obj).floatValue());
     } else if (obj instanceof Long) {
         ps.setLong(column, ((Long) obj).longValue());
     }   
     else if(obj instanceof Date)
     {
    	 ps.setTimestamp(column,new Timestamp(((Date)obj).getTime()));    	
     }
     else if(obj instanceof BigDecimal)
     {
    	ps.setBigDecimal(column,(BigDecimal)obj);
     }    
     else
     {
    	 logger.error("不支持的参数类型!");
     }
	 }
	 catch(Exception e)
	 {
		 logger.error("参数设置出错："+e);
	 }
	}
}