testdb.java

java数据库操作工具类

package com.baosight.util;


import java.util.HashMap;
import java.util.List;

public class TestDB {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
	   	//testCount();
		String sql = "select * from CURRENCY where CID='#abc#' #abc2#";
		HashMap pa = new HashMap();
		pa.put("abc","test");
		pa.put("abc2","and CNAME='test'");
		sql = SqlUtil.makeSimpleSql(sql,pa);
		System.out.println(sql);
		
		List list = DBUtil.query(sql);
		
//		testUpdate();
		
		Logger.log( list.size() );
		for( int i=0;i< list.size();i++){
			HashMap map= (HashMap)list.get(i);
			Logger.log(map.get("ccode") + ":"+ map.get("cid"));
		}
	}

	/**
	 * 
	 */
	private static void testUpdate() {
		String sql2 = "insert into CURRENCY(CCODE,CID,CNAME,CRATE,BEGIN_DATE) values(#CCODE#,#CID#,#CNAME#,#CRATE:float#,#BEGIN_DATE:date#)";
		HashMap pa = new HashMap();
		pa.put("CCODE","test2");
		pa.put("CID","test");
		pa.put("CNAME","test");
		pa.put("CRATE","10");
		pa.put("BEGIN_DATE", new java.util.Date());
		DBUtil.executeUpdate(sql2,pa);
	}

	/**
	 * 
	 */
	private static void testCount() {
		String countSql = "select * from T_COM_CLIENT_RELATION";
        int count= DBUtil.getCount(countSql);
        System.out.println( count );
	}

}