TableTest.java

package com.jiuqi.mobile.core.service.db;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Date;
import java.util.UUID;

import org.junit.Assert;
import org.junit.Test;

import com.jqmobile.core.orm.ORM;
import com.jqmobile.core.orm.TableUtil;
import com.jqmobile.core.orm.exception.ORMException;
import com.jqmobile.core.orm.exception.ORMNotDBTableException;
import com.jqmobile.core.server.db.DBPool;
import com.jqmobile.core.server.db.orm.ORMFactory;
import com.jqmobile.core.server.db.orm.TableUtilFactory;

public class TableTest extends Assert{
	
	public void createTable() throws SQLException, ORMException{
		test1();
//		test2();
	}

	private void test2() throws SQLException, ORMNotDBTableException, ORMException {
		Connection conn=DBPool.getInstance().getConnection();
		ORM<Toy> orm=ORMFactory.instance(conn, Toy.class);
//		Toy t=new Toy(UUID.randomUUID().toString(), "张三",new Date().getTime());
		for (int i = 0; i < 1000; i++) {
			Toy t=new Toy(UUID.randomUUID().toString(), "张三",new Date().getTime(),new Date().getTime());
			orm.insert(t);
		}
		conn.commit();
	}
	@Test
	public void test1() throws SQLException, ORMException {
		Connection connection = DBPool.getInstance().getConnection();
		TableUtil tu = TableUtilFactory.instance(connection);
		tu.createTable(TableCreatTest.class);
		//assertTrue(tu.valiTableExist("T_DateTest"));
		connection.commit();
		connection.close();
	}
	
	public static void main(String[] args) throws SQLException, ORMException {
		Connection connection = DBPool.getInstance().getConnection();
		TableUtil tu = TableUtilFactory.instance(connection);
		tu.createTable(TableCreatTest.class);
		//assertTrue(tu.valiTableExist("T_DateTest"));
		connection.commit();
		connection.close();
	}
}