VereORM 之 原生 SQL

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

1. 安装见  VereORM 之 入门安装 

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

package com.test.orm;

import java.sql.ResultSet;
import java.util.ArrayList;
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;
import com.vere.orm.util.CDate;

public class Test6 {

	public static void main(String[] args) {
		testAdd();
		
		testFindOne();
		
		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());

			String sql="insert into user(id,name,age,salary,birthday)values(?,?,?,?,?)";
			Object[] params=new Object[]{user.getId(),user.getName(),user.getAge(),user.getSalary(),user.getBirthday()};
			
			session.executeUpdate(sql, params);
			
		}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
		User user=null;
		try
		{
			String sql="select * from user where id=1";
			ResultSet rs=session.executeQuery(sql);
			
			/*String sql="select * from user where id=?";
			Object[] params=new Object[]{1};
			ResultSet rs=session.executeQuery(sql,params);*/
			
			if(rs.next())
			{
				user=new User();
				user.setId(rs.getInt("id"));
				user.setName(rs.getString("name"));
				user.setAge(rs.getInt("age"));
				user.setSalary(rs.getFloat("salary"));
				user.setBirthday(CDate.formatDateTime(rs.getString("birthday")));
				
				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());

			String sql="update user set name=?,age=?,salary=?,birthday=? where id=?";
			Object[] params=new Object[]{user.getName(),user.getAge(),user.getSalary(),user.getBirthday(),user.getId()};
			
			session.executeUpdate(sql, params);
			
		}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
		List<User> userList=new ArrayList<User>();
		try
		{
			String sql="select * from user ";
			ResultSet rs=session.executeQuery(sql);
			
			
			while(rs.next())
			{
				User user=new User();
				user.setId(rs.getInt("id"));
				user.setName(rs.getString("name"));
				user.setAge(rs.getInt("age"));
				user.setSalary(rs.getFloat("salary"));
				user.setBirthday(CDate.formatDateTime(rs.getString("birthday")));
				
				userList.add(user);
			}
			
			for(int i=0;i<userList.size();i++)
			{
				User user=(User)userList.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
		{
			
			String sql="delete from user  where id=1";
			Object[] params=new Object[]{1};

			/*String sql="delete from user  where id=?";
			Object[] params=new Object[]{1};*/
			
			session.executeUpdate(sql);
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session!=null)
			{
				session.close();//关闭session
			}
		}
	}
	
	
}



9.运行 com.test.orm.Test6 类 

将会看到结果

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