ORM2Test.java

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

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


import com.jqmobile.core.orm.ORM;
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;

public class ORM2Test {
	public void timetest() throws ORMNotDBTableException, SQLException, ORMException{
		long start=System.currentTimeMillis();
		//insertest();
		//updatetest();
		//deletetest();
		findtest();
		querytest();
		System.out.println("用时"+(System.currentTimeMillis()-start));
	}
	public void delete2test() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		orm.delete("recid=?",UUID.fromString("31e65179-459c-4b93-adb0-0d8bac05aa5b"));
		conn.commit();
		conn.close();
	}
	public void update2test() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		orm.update("name=? where recid=?","lisi",UUID.fromString("d4a306ba-2aa2-4ef1-a92f-a6b991f29fef"));
		conn.commit();
		conn.close();
	}
	public void querytest() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		List<NewBean> nbs=orm.getAll();
		System.out.println("---------------------------------------------getall-----------------------------------------------");
		for(NewBean nb:nbs){
			System.out.println(nb);
		}
		System.out.println("---------------------------------------------querypage-----------------------------------------------");
		nbs=orm.queryPage("", 0, 2);
		for(NewBean nb:nbs){
			System.out.println(nb);
		}
		System.out.println("-------------------------------------------query-------------------------------------------------");
		nbs=orm.query("name=?;","zhangsan");
		for(NewBean nb:nbs){
			System.out.println(nb);
		}
		System.out.println("--------------------------------------------------------------------------------------------");
		conn.commit();
		conn.close();
	}
	public void queryrowtest() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		System.out.println(orm.queryRow(""));
		conn.commit();
		conn.close();
	}
	public void findtest() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		NewBean nb=orm.find("861c7f62-caf7-4dc2-8fed-342c2798aaef");
		System.out.println(nb);
		conn.commit();
		conn.close();
	}
	public void deletetest() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		orm.delete("e68dff78-ac9c-4d8e-a94c-dabb47f0fae0");
		conn.commit();
		conn.close();
	}
	public void updatetest() throws SQLException, ORMNotDBTableException, ORMException{
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		NewBean nb = orm.find("4eaeee85-e625-4c49-b5c5-1a79386ea218");
		Toy toy=nb.getToy();
		toy.setName("变形金刚");
		nb.setToy(toy);
		System.out.println(nb);
		
		
		
//		nb.setAge(20);
//		nb.setName("zhaoliu");
//		nb.setRecid("02b5def6-5792-4d19-b510-ee30789a8e5e");
//		nb.setBirthday(new Date().getTime());
//		nb.setVersion(10000);
//		Toy toy=new Toy(UUID.randomUUID().toString(), "bianxingjingang");
//		nb.setToy(toy);
		orm.update(nb);
		conn.commit();
		conn.close();
	}
	
	public void insertest() throws SQLException, ORMNotDBTableException, ORMException {
		Connection conn = DBPool.getInstance().getConnection();
		ORM<NewBean> orm = ORMFactory.instance(conn, NewBean.class);
		NewBean nb = new NewBean();
		nb.setAge(10);
		nb.setName("zhangsan");
		String recid=UUID.randomUUID().toString();
		System.out.println(recid);
		nb.setRecid(recid);
		nb.setBirthday(new Date().getTime());
		nb.setVersion(10000);
		Toy toy=new Toy(UUID.randomUUID().toString(), "bianxingjingang");
		nb.setToy(toy);
		List<Book> books=new ArrayList<Book>();
		for (int i = 0; i < 3; i++) {
			Book book=new Book(UUID.randomUUID().toString(), "lishi");
			books.add(book);
		}
		nb.setBooks(books);
		orm.insert(nb);
		conn.commit();
		conn.close();
	}
}