daohelpertest.java

基于java的组号查询模块

package com.lily.dap.dao.support;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

import junit.framework.TestCase;

public class DaoHelperTest extends TestCase {
	public DaoHelperTest(String arg0) {
		super(arg0);
	}

	protected void setUp() throws Exception {
		super.setUp();
	}

	protected void tearDown() throws Exception {
		super.tearDown();
	}

	public void testExpressionValue2String() throws ParseException {
		assertEquals("", DaoHelper.expressionValue2String(null));

		assertEquals("value1", DaoHelper.expressionValue2String("value1"));
		
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		assertEquals("2006-12-31 00:00:00", DaoHelper.expressionValue2String(sdf.parse("2006-12-31")));
		
		assertEquals("1,2,3", DaoHelper.expressionValue2String(new long[]{1,2,3}));
		
		assertEquals("100,200,300", DaoHelper.expressionValue2String(new int[]{100,200,300}));
		
		assertEquals("aa,bb,cc", DaoHelper.expressionValue2String(new String[]{"aa", "bb", "cc"}));
		
		List list = new ArrayList();
		list.add("aaa");
		list.add(new Long(1234));
		assertEquals("aaa,1234", DaoHelper.expressionValue2String(list));
		
		assertEquals("123", DaoHelper.expressionValue2String(new Long(123)));
		
		assertEquals("true", DaoHelper.expressionValue2String(new Boolean(true)));
		
		assertEquals("33.3333", DaoHelper.expressionValue2String(new Float(33.3333f)));
	}

}