VereORM 之 添加 删除 修改 查询

http://www.verejava.com/?id=17045378790683

1. 安装见  VereORM 之 入门安装 

2.在 test/src 中新建一个 测试类  com.test.orm.Test2   

package com.test.orm;

import java.util.Calendar;
import java.util.List;

import com.test.entity.User;
import com.vere.orm.db.Session;
import com.vere.orm.db.SessionManager;

public class Test2 {

	public static void main(String[] args) {
		testAdd();
		
		testUpdate();
		
		testFind();
		
		//testDelete();
	}
	
	public static void testAdd()
	{
		SessionManager sessionManager=new SessionManager();//创建session 工厂
		Session session= sessionManager.openSesstion();  //打开一个session
		try
		{
			User user=new User();
			user.setId(2);
			user.setName("lijun");
			user.setAge(30);
			user.setSalary(20000);
			user.setBirthday(Calendar.getInstance());
			session.save(user);
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
	}
	
	public static void testFindOne()
	{
		SessionManager sessionManager=new SessionManager();//创建session 工厂
		Session session= sessionManager.openSesstion();  //打开一个session
		try
		{
			Object obj=session.findOne(User.class, "select * from user where id=1");
			//Object obj=session.findOne(User.class, "select id,name,age from user where id=1");
			
			if(obj!=null)
			{
				User user=(User)obj;
				System.out.println(user.getId()+" | "+user.getName()+" | "+user.getAge()+" | "+user.getSalary());
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
		
	}
	
	public static void testUpdate()
	{
		SessionManager sessionManager=new SessionManager();//创建session 工厂
		Session session= sessionManager.openSesstion();  //打开一个session
		try
		{
			User user=new User();
			user.setId(2);
			user.setName("lijun");
			user.setAge(30);
			user.setSalary(25000);
			user.setBirthday(Calendar.getInstance());
			session.update(user);
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
	}
	
	public static void testFind()
	{
		SessionManager sessionManager=new SessionManager();//创建session 工厂
		Session session= sessionManager.openSesstion();  //打开一个session
		try
		{
			List list=session.find(User.class, "select * from user");
			//List list=session.find(User.class, "select id,name,age from user");
			
			if(list!=null)
			{
				for(int i=0;i<list.size();i++)
				{
					User user=(User)list.get(i);
					System.out.println(user.getId()+" | "+user.getName()+" | "+user.getAge()+" | "+user.getSalary());
				}
				
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
		
	}
	
	public static void testDelete()
	{
		SessionManager sessionManager=new SessionManager();//创建session 工厂
		Session session= sessionManager.openSesstion();  //打开一个session
		try
		{
			User user=new User();
			user.setId(2);
			session.delete(user);
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
	}
	
	
}




3.运行 com.test.orm.Test2 类 

将会看到结果

http://www.verejava.com/?id=17045378790683