ORMTest2.java

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

import java.security.NoSuchAlgorithmException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;

import org.junit.Test;

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;
import com.jqmobile.core.utils.json.base64.Base64DecodingException;

public class ORMTest2 {
	public void testListDelete() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
		orm.delete("4e122777-f6a0-40e8-a6af-447fb3066374");
		connection.commit();
		connection.close();
	}
	public void testListUpdate() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
		Student s=orm.find("76882544-0439-4276-bf3b-fe0637df8e68");
//		Student s=orm.find("4e2d6bfb-51c8-42f1-a10b-cf5831bbb31c");
		Book book=new Book();
		book.setName("heiheihei");
		book.setId(UUID.randomUUID().toString());
		s.setBook(book);
		s.setAge(20);
		List<Toy> toys=new ArrayList<Toy>();
		for(int i= 0;i<3;i++){
			Toy toy=new Toy(UUID.randomUUID().toString(),"hahaha"+i);
			toys.add(toy);
		}
		s.setToys(toys);
		s.setBook(book);
		
		orm.update(s);
		
		
		connection.commit();
		connection.close();
	}
	public void testListGetAll() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
		List<Student> list = orm.getAll();
		for(Student s:list){
			System.out.println(s);
			if(s.getBook()!=null){
			}
		}
		
		
//		Student s=orm.find("90c0116c-6458-4923-adde-49d5116218fc");
//		System.out.println(s);
		
		connection.commit();
		connection.close();
	}
	public void testListInsert() throws SQLException, ORMNotDBTableException, ORMException, Base64DecodingException, NoSuchAlgorithmException{
		
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
		Book book=new Book(UUID.randomUUID().toString(),"shuxue");
		List<Toy> toys=new ArrayList<Toy>();
		for(int i= 0;i<3;i++){
			Toy toy=new Toy(UUID.randomUUID().toString(),"aiqinggongyu"+i);
			toys.add(toy);
		}
		
		Student student=new Student(UUID.randomUUID().toString(),10,book,toys);
		orm.insert(student);
		
		
		
		connection.commit();
		connection.close();
	}
	public void testUpdate() throws ORMNotDBTableException, ORMException, SQLException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
//		Student s=orm.find("968ce6e9-b3cf-48e3-95fe-be328547b030");
		Student s=new Student();
		s.setId("4e122777-f6a0-40e8-a6af-447fb3066374");
		Book book=new Book();
		book.setId(UUID.randomUUID().toString());
		book.setName("asddasdas");
		s.setBook(book);
		s.setAge(100);
		orm.update(s);
		
		
		connection.commit();
		connection.close();
	}
	
	public void testDelete() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
		connection.commit();
		connection.close();
	}
	public void testInsert() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
		ORM<Student> orm = ORMFactory.instance(connection, Student.class);
//		Book book=new Book(UUID.randomUUID().toString(),"yingyu");
		String id=UUID.randomUUID().toString();
		System.out.println(id);
		Student student=new Student(id,10);
		orm.insert(student);
		connection.commit();
		connection.close();
	}
	
	public void testGetAll() throws SQLException, ORMNotDBTableException, ORMException{
		Connection connection = DBPool.getInstance().getConnection();
//		ORM<Book> orms = ORMFactory.instance(connection, Book.class);
		ORM<Student> orms = ORMFactory.instance(connection, Student.class);
		List<Student> list = orms.getAll();
		System.out.println(list);
//		System.out.println(list.size());
//		for(Student s:list){
//			System.out.println(s);
//			if(s.getBook()!=null){
//			}
//		}
		
//		List<Book> list = orms.getAll();
//		for(Book b:list){
//			System.out.println(b);
//		}
		
//		Student s=orms.find(UUID.fromString("bb56ba78-2d47-4786-aca2-bb7bbb130f65"));
//		System.out.println(s);
		connection.commit();
		connection.close();
	}
}