用java反射技术创建通用的JDBC连接

/**   
 * @Title: TestJDBC.java 
 * @Package com.java.jdbc.mvn_jdbc2 
 * @Description: 用反射的方法完成JDBC的数据库连接操作 
 * @author   
 * @date 2016年7月4日 下午4:46:26 
 * @version V1.0   
 */
package com.java.jdbc.mvn_jdbc2;

import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

/**
 * @ClassName: TestJDBC
 * @Description: 通用的JDBC类
 * @author 
 * @date 2016年7月4日 下午4:46:26
 * 
 */
public class TestJDBC<T> {
	public List<T> selectResult(String Driver, String Url, String Name,
			String Password, String Sql, Class<T> cla) throws Exception {
		// 实例化list
		List<T> list = new ArrayList<T>();
		// 加载数据库驱动
		Class.forName(Driver);
		// 连接数据库
		Connection conn = DriverManager.getConnection(Url, Name, Password);
		// 操作数据库并执行sql
		Statement stmt = conn.createStatement();
		// ResultSet接收返回值
		ResultSet rs = stmt.executeQuery(Sql);
		// 对结果集进行遍历
		while (rs.next()) {
			// 实例化class类
			T t = cla.newInstance();
			Field[] fields = cla.getDeclaredFields();
			//循环出数组中的结果集
			for (Field field : fields) {
				Object obj = rs.getObject(field.getName());
				field.setAccessible(true);
				field.set(t, obj);
			}
			//将结果架到List中
			list.add(t);
		}

		rs.close();
		stmt.close();
		conn.close();
		return list;

	}

	/**
	 * 
	 * @Title: main
	 * @Description: 主函数
	 * @param @param args
	 * @param @throws Exception
	 * @return void
	 * @throws
	 */
	public static void main(String[] args) throws Exception {
		//对变量初始化并赋值
		String Driver = "com.mysql.jdbc.Driver";
		String Url = "jdbc:mysql://localhost:3306/test";
		String Name = "root";
		String Password = "123456";
		String Sql = "SELECT ID,NAME,GRADE,AGE FROM STUDENT";
		//实例化TestJDBC类
		TestJDBC<Bean> te = new TestJDBC<Bean>();
		//调用TestJDBC类中的selectResult方法，输出结果
		System.out.println(te.selectResult(Driver, Url, Name, Password, Sql, Bean.class));

	}

}

package com.java.jdbc.mvn_jdbc2;
/**
 * 
 * @ClassName: Bean 
 * @Description: TODO 
 * @author 
 * @date 2016年7月4日 下午4:42:32 
 *
 */
public class Bean {
	private String id;
	private String name;
	private String grade;
	private String age;
	/**
	 * @return the id
	 */
	public String getId() {
		return id;
	}
	/**
	 * @param id the id to set
	 */
	public void setId(String id) {
		this.id = id;
	}
	/**
	 * @return the name
	 */
	public String getName() {
		return name;
	}
	/**
	 * @param name the name to set
	 */
	public void setName(String name) {
		this.name = name;
	}
	/**
	 * @return the grade
	 */
	public String getGrade() {
		return grade;
	}
	/**
	 * @param grade the grade to set
	 */
	public void setGrade(String grade) {
		this.grade = grade;
	}
	/**
	 * @return the age
	 */
	public String getAge() {
		return age;
	}
	/**
	 * @param age the age to set
	 */
	public void setAge(String age) {
		this.age = age;
	}
	/* (non-Javadoc)
	 * @see java.lang.Object#hashCode()
	 */
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((age == null) ? 0 : age.hashCode());
		result = prime * result + ((grade == null) ? 0 : grade.hashCode());
		result = prime * result + ((id == null) ? 0 : id.hashCode());
		result = prime * result + ((name == null) ? 0 : name.hashCode());
		return result;
	}
	/* (non-Javadoc)
	 * @see java.lang.Object#equals(java.lang.Object)
	 */
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Bean other = (Bean) obj;
		if (age == null) {
			if (other.age != null)
				return false;
		} else if (!age.equals(other.age))
			return false;
		if (grade == null) {
			if (other.grade != null)
				return false;
		} else if (!grade.equals(other.grade))
			return false;
		if (id == null) {
			if (other.id != null)
				return false;
		} else if (!id.equals(other.id))
			return false;
		if (name == null) {
			if (other.name != null)
				return false;
		} else if (!name.equals(other.name))
			return false;
		return true;
	}
	/* (non-Javadoc)
	 * @see java.lang.Object#toString()
	 */
	@Override
	public String toString() {
		return "Bean [id=" + id + ", name=" + name + ", grade=" + grade
				+ ", age=" + age + "]";
	}
	

}