hibernate内部实现的探讨

1.新疆测试表stu（使用oracle数据库）

-- Create table
create table STU
(
  id   NUMBER not null,
  name VARCHAR2(20),
  age  NUMBER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table STU
  add constraint PJ primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

2.创建实体类Student

package com.baosight.model;

/**
 * <p>Title: </p>
 * <p>Description:Student </p>
 * <p>Company: </p> 
 * @author yuan 
 * @date 2016-4-10 下午12:32:46*/
public class Student {
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
}

3.模拟hibernate中的session创建session类SessionIn

import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.HashMap;
import java.util.Map;

import com.baosight.model.Student;


/**
 * <p>Title: </p>
 * <p>Description:SessionIn </p>
 * <p>Company: </p> 
 * @author yuan 
 * @date 2016-4-10 下午6:33:43*/
public class SessionIn {
	private String tableName = "stu";//表名
	private Map<String,String> map;//存放实体类属性名和对应的表里字段名的对应关系
	private String MethodName[];//存放实体类属性的get方法
/** 
	 * @Title:  构造方法
	 * @Description: TODO
	 * @param  
	 * @return 
	 * @throws 
	 */ 
	public SessionIn() {
		map = new HashMap<String, String>();
		map.put("id", "id");
		map.put("name", "name");
		map.put("age", "age");
		MethodName = new String[map.size()];
	}

public void save(Student s) throws Exception{
	Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
	String sql = createSql();
	PreparedStatement ps = con.prepareStatement(sql);
	for(int i=0;i<MethodName.length;i++){
		Method m = s.getClass().getMethod(MethodName[i]);
		Class returnType = m.getReturnType();
		if(returnType.getName().equals("java.lang.String")){
			String v = (String) m.invoke(s);
			ps.setString(i+1, v);
		}
		if(returnType.getName().equals("int")){
			Integer v = (Integer) m.invoke(s);
			ps.setInt(i+1, v);
		}
	}
//	ps.setInt(1, s.getId());
	ps.executeUpdate();
	ps.close();
	con.close();
}

/** 拼接sql
 * @Title: createSql 
 * @Description: TODO
 * @return 
 * @return String  
 * @throws 
 */ 
private String createSql() {
	// TODO Auto-generated method stub
	String str1 = "";
	String str2 = "";
	int index = 0;
	for(String s:map.keySet()){
		String m = map.get(s);
		m = "get"+Character.toUpperCase(m.charAt(0))+m.substring(1);
		MethodName[index] = m;
		str1+=s+",";
		str2+="?,";
		index++;
	}
	str1 = str1.substring(0,str1.length()-1);
	str2 = str2.substring(0,str2.length()-1);
	
	String sql = "insert into "+tableName+"("+str1+") values("+str2+")";
	System.out.println(sql);
	return sql;
}
}

4.新建测试类TestStudent，进行插入测试

import com.baosight.model.Student;


/**
 * <p>Title: </p>
 * <p>Description:TestStu </p>
 * <p>Company: </p> 
 * @author yuan 
 * @date 2016-4-10 下午3:16:01*/
public class TestStudent {

	/**
	 * @throws Exception  
	 * @Title: main 
	 * @Description: TODO
	 * @param args 
	 * @return void  
	 * @throws 
	 */
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		//学生测试类
		Student s = new Student();
		s.setId(2);
		s.setName("s2");
		s.setAge(40);
		SessionIn session = new SessionIn();
		session.save(s);
	}

}

5.查询数据库，显示插入成功

结果：1 2 s2 40

上例模拟了hibernate内部实现的对sql的封装、传参和执行的过程，主要用到了反射机制。