sqlutil.java

java数据库操作工具类

package com.baosight.util;

import java.util.*;


public class SqlUtil {

	public static String makeSimpleSql(String sql,HashMap paras){
		   String result=sql;
		   Iterator it = paras.keySet().iterator();
		   while(it.hasNext()){
			   String key = it.next().toString();
			   Object value = paras.get(key);
			   String tv = null;
			   if(value==null ){
				   tv = "null";
			   }else{
//				    if( value.toString().indexOf("'") <0 ) {
//				    	tv = "'" + value.toString() + "'";
//				    }else{
				    	tv = value.toString();
//				    }
			   }
			   result =result.replaceAll("#"+key+"#",tv);
		   }
		   return result;
	   } 
	public static void main(String[] args){
		System.out.println("test");
	}
}