最近閒暇時萌發寫一寫dao的封裝的例子，就將以前寫的整理一下。
public class BaseDao<T> {Connection conn;PreparedStatement st;ResultSet rs;JdbcUtil jdbcUtil = new JdbcUtil();int result = 0;private Class<T> persistentClass;@SuppressWarnings("unchecked")public BaseDaoUtil(){conn = jdbcUtil.getConnection();ParameterizedType type = (ParameterizedType) getClass().getGenericSuperclass();persistentClass = (Class<T>) type.getActualTypeArguments()[0];} /** * 保存* @param entity * @return */public int save(T entity) throws Exception{String sql = "INSERT INTO "+ entity.getClass().getSimpleName().toLowerCase() +" (";List<Method> list = this.matchPojoMethods(entity,"get");Iterator<Method> iter = list.iterator();Object obj[] = new Object[list.size()];int i = 0;//拼接字段順序insert into table name(id,name,email, while(iter.hasNext()) { Method method = iter.next(); sql += method.getName().substring(3).toLowerCase() + ","; if (method.getReturnType().getSimpleName().indexOf("Date") !=-1) {SimpleDateFormat sbf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");obj[i] = sbf.format(method.invoke(entity, new Object[]{})); }else {obj[i] = method.invoke(entity, new Object[]{}); } i++; } //去掉最後一個,符號insert insert into table name(id,name,email) values( sql = sql.substring(0, sql.lastIndexOf(",")) + ") values("; //拼裝預編譯SQL語句insert insert into table name(id,name,email) values(?,?,?, for(int j = 0; j < list.size(); j++) { sql += "?,"; } //去掉SQL語句最後一個,符號insert insert into table name(id,name,email) values(?,?,?); sql = sql.substring(0, sql.lastIndexOf(",")) + ")"; //到此SQL語句拼接完成,打印SQL語句System.out.println(sql); try { st = conn.prepareStatement(sql); for (int j = 0; j < obj.length; j++) {st.setObject(j+1, obj[j]);}result = st.executeUpdate();} catch (SQLException e) {e.printStackTrace();} jdbcUtil.getClose(rs, st, conn);return result;}/** * 刪除* @param object * @return * @throws SQLException */public int deleteId(Object object) throws Exception{String sql = "delete from "+ persistentClass.getSimpleName().toLowerCase() +" where ";//通過子類的構造函數,獲得參數化類型的具體類型.比如BaseDAO<T>也就是獲得T的具體類型T entity = persistentClass.newInstance(); //存放Pojo(或被操作表)主鍵的方法對象Method idMethod = null; List<Method> list = this.matchPojoMethods(entity, "set"); Iterator<Method> iter = list.iterator(); //過濾取得Method對象while(iter.hasNext()) { Method tempMethod = iter.next(); if(tempMethod.getName().indexOf("Id") != -1 && tempMethod.getName().substring(3).length() == 2) { idMethod = tempMethod; } else if((entity.getClass().getSimpleName() + "Id").equalsIgnoreCase(tempMethod.getName().substring(3))){ idMethod = tempMethod; } } //第一個字母轉為小寫sql += idMethod.getName().substring(3,4).toLowerCase()+idMethod.getName().substring(4) + " = ?"; System.out.println(sql);st = conn.prepareStatement(sql);//判斷id的類型if(object instanceof Integer) { st.setInt(1, (Integer)object); } else if(object instanceof String){ st.setString(1, (String)object); }result = st.executeUpdate();jdbcUtil.getClose(rs, st, conn);return result;}/** * 修改* @param entity * @return * @throws Exception */public int update(T entity) throws Exception{String sql = "update "+ entity.getClass().getSimpleName().toLowerCase() +" set ";List<Method> list = this.matchPojoMethods(entity, "get");//裝載參數Object obj[] = new Object[list.size()];int i = 0;//臨時Method對象,負責迭代時裝method對象. Method tempMethod = null; //由於修改時不需要修改ID,所以按順序加參數則應該把Id移到最後. Method idMethod = null; Iterator<Method> iter = list.iterator(); while(iter.hasNext()) { tempMethod = iter.next(); //如果方法名中帶有ID字符串並且長度為2,則視為ID. if(tempMethod.getName().lastIndexOf("Id") != -1 && tempMethod.getName().substring(3).length() == 2) { obj[list.size()-1] = tempMethod.invoke(entity, new Object[]{}); //把ID字段的對象存放到一個變量中,然後在集合中刪掉. idMethod = tempMethod; iter.remove(); //如果方法名去掉set/get字符串以後與pojo + "id"想符合(大小寫不敏感),則視為ID } else if((entity.getClass().getSimpleName() + "Id").equalsIgnoreCase(tempMethod.getName().substring(3))) { obj[list.size()-1] = tempMethod.invoke(entity, new Object[]{}); idMethod = tempMethod; iter.remove(); } } //把迭代指針移到第一位iter = list.iterator(); while(iter.hasNext()) { tempMethod = iter.next(); sql += tempMethod.getName().substring(3).toLowerCase() + "= ?,"; obj[i] = tempMethod.invoke(entity, new Object[]{}); i++; } //去掉最後一個,符號sql = sql.substring(0,sql.lastIndexOf(",")); //添加條件sql += " where " + idMethod.getName().substring(3).toLowerCase() + " = ?"; //SQL拼接完成,打印SQL語句System.out.println(sql); st = conn.prepareStatement(sql); for (int j = 0; j < obj.length; j++) {st.setObject(j+1, obj[j]);} result = st.executeUpdate(); jdbcUtil.getClose(rs, st, conn); return result;}public T findById(Object object) throws Exception{String sql = "select * from "+ persistentClass.getSimpleName().toLowerCase() +" where ";//通過子類的構造函數,獲得參數化類型的具體類型.比如BaseDAO<T>也就是獲得T的具體類型T entity = persistentClass.newInstance(); //存放Pojo(或被操作表)主鍵的方法對象Method idMethod = null; List<Method> list = this.matchPojoMethods(entity, "set"); Iterator<Method> iter = list.iterator(); //過濾取得Method對象while(iter.hasNext()) { Method tempMethod = iter.next(); if(tempMethod.getName().indexOf("Id") != -1 && tempMethod.getName().substring(3).length() == 2) { idMethod = tempMethod; } else if((entity.getClass().getSimpleName() + "Id").equalsIgnoreCase(tempMethod.getName().substring(3))){ idMethod = tempMethod; } } //第一個字母轉為小寫sql += idMethod.getName().substring(3,4).toLowerCase()+idMethod.getName().substring(4) + " = ?"; System.out.println(sql);st = conn.prepareStatement(sql);//判斷id的類型if(object instanceof Integer) { st.setInt(1, (Integer)object); } else if(object instanceof String){ st.setString(1, (String)object); } rs = st.executeQuery(); //把指針指向迭代器第一行iter = list.iterator(); //封裝while(rs.next()) { while(iter.hasNext()) { Method method = iter.next(); if(method.getParameterTypes()[0].getSimpleName().indexOf("String") != -1) { //由於list集合中,method對象取出的方法順序與數據庫字段順序不一致(比如:list的第一個方法是setDate,而數據庫按順序取的是"123"值) //所以數據庫字段採用名字對應的方式取. this.setString(method, entity, rs.getString(method.getName().substring(3).toLowerCase())); } else if(method.getParameterTypes()[0].getSimpleName().indexOf("Date") != -1){ this.setDate(method, entity, rs.getDate(method.getName().substring(3).toLowerCase())); }else { this.setInt(method, entity, rs.getInt(method.getName().substring(3).toLowerCase())); } } } jdbcUtil.getClose(rs, st, conn); return entity;}/** * 過濾當前Pojo類所有帶傳入字符串的Method對象,返回List集合. */ private List<Method> matchPojoMethods(T entity,String methodName) { //獲得當前Pojo所有方法對象Method[] methods = entity.getClass().getDeclaredMethods(); //List容器存放所有帶get字符串的Method對象List<Method> list = new ArrayList<Method>(); //過濾當前Pojo類所有帶get字符串的Method對象,存入List容器for(int index = 0; index < methods.length; index++) { if(methods[index].getName().indexOf(methodName) != -1) { list.add(methods[index]); } } return list; } /** * 參數類型為String時,為entity字段設置參數,對應set */ public String setString(Method method, T entity, String arg) throws Exception{ return (String)method.invoke(entity, new Object[]{arg}); } /** * 參數類型為Date時,為entity字段設置參數,對應set */ public Date setDate(Method method, T entity, Date arg) throws Exception{ return (Date)method.invoke(entity, new Object[]{arg}); } /** * 參數類型為Integer或int時,為entity字段設置參數,對應set */ public Integer setInt(Method method, T entity, Integer arg) throws Exception{ return (Integer)method.invoke(entity, new Object[]{arg}); } }以上這篇基於JDBC封裝的BaseDao(實例代碼)就是小編分享給大家的全部內容了，希望能給大家一個參考，也希望大家多多支持武林網。