java dao修改语句_一个通用的DAO模型实现增删改查

首先三个架包：

mysql-connector-java-jar

commons-dbcp-1.4jar

commons-pool-1.5.5jar

导进去；

(从上往下一次调用，实现功能)

--------------------------------------------------------------------------------------

Customer类：

package com.lanqioa.javatest;

import java.sql.Date;

public class Customer {

private int id;

private String name;

private String email;

private Date birth;

public Customer() {

super();

// TODO Auto-generated constructor stub

}

public Customer(int id, String name, String email, Date birth) {

super();

this.id = id;

this.name = name;

this.email = email;

this.birth = birth;

}

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 getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public Date getBirth() {

return birth;

}

public void setBirth(Date birth) {

this.birth = birth;

}

@Override

public String toString() {

return "Customer [id=" + id + ", name=" + name + ", email=" + email + ", birth=" + birth + "]";

}

}

-------------------------------------------------------------------------------------

反射方法获取数据(供调用)

/**

* 反射的 Utils 函数集合

* 提供访问私有变量, 获取泛型类型 Class, 提取集合中元素属性等 Utils 函数

* @author Administrator

*

*/

public class ReflectionUtils {

/**

* 通过反射, 获得定义 Class 时声明的父类的泛型参数的类型

* 如: public EmployeeDao extends BaseDao

* @param clazz

* @param index

* @return

*/

@SuppressWarnings("unchecked")

public static Class getSuperClassGenricType(Class clazz, int index){

Type genType = clazz.getGenericSuper