尝试手写模拟mybatis(未加入xml版)

<pre name="code" class="java"><span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">mybatis是使用了解析xml，反射等技术的对原生jdbc进行的轻量级封装，今天我尝试来模拟下简单的实现原理（此版时间有限未加入xml解析）</span>

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">1、首先我们去数据库建个简单表单：</span>

<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);"></span><pre name="code" class="sql">/*
Navicat MySQL Data Transfer

Source Server         : ds
Source Server Version : 50022
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50022
File Encoding         : 65001

Date: 2016-03-26 12:01:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for yuangong
-- ----------------------------
DROP TABLE IF EXISTS `yuangong`;
CREATE TABLE `yuangong` (
  `id` int(11) default NULL,
  `name` varchar(60) default NULL,
  `banji` varchar(60) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of yuangong
-- ----------------------------
INSERT INTO `yuangong` VALUES ('1', '李明', '二班');
INSERT INTO `yuangong` VALUES ('2', '王二小', '三班');
INSERT INTO `yuangong` VALUES ('3', '小红', '四班');

2、然后我们去写一个对应的实体类（这里没做xml映射，最好名字取和字段名字一样）

public class Student {
	private int id;
	private String name;
	private String banji;
	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 String getBanji() {
		return banji;
	}
	public void setBanji(String banji) {
		this.banji = banji;
	}
}

3、然后我们在写个jdbc连接（） ：

public class Cf {
	static Connection con;
	static{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static Connection getCon(){
		try {
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "1234");
			return con;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
	}
}

4、写个带泛型的模拟mybatis的工具类：

public class Ibatis<T> {
	public List<T> select(String string,Object obj){
		Connection con;
		String sql;
		Object obj2 = null;
		sql = string;
		con = Cf.getCon();
		List<T> list = new ArrayList<T>();
		try {
			PreparedStatement ps = con.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();
			Class cls = obj.getClass();
			Field[] fields = cls.getDeclaredFields();
			while(rs.next()){
				obj2 = cls.newInstance();
				for(int i = 0;i<fields.length;i++){
					Field fl = fields[i];
					String n = fl.getName();
					fl.setAccessible(true);
					fl.set(obj2, rs.getObject(n));
				}
				list.add((T)obj2);
			}
			return list;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		
	}
}

5、大功告成我们测试下：

public class Test {
	public static void main(String[]args){
		Ibatis<Student> i = new Ibatis<Student>();
		String sql = "select * from yuangong";
		List<Student> list  = i.select(sql, new Student());
		for(Student stu:list){
			System.out.println(stu.getName()+""+""+stu.getBanji());
		}
	}
}

6、输出结果：

7、有时间再把xml映射加进去。。