如何使用Java工具类更新数据库中的数据连接?

更新于
2026-10-05 13:38:25
2阅读来源:SEO教程
  • 内容介绍
  • 文章标签
  • 相关推荐

本文共计259个文字,预计阅读时间需要2分钟。

javapublic static int updateObject(T t) { int i=0; Class c=t.getClass(); List columns=new ArrayList(); List values=new ArrayList(); StringBuilder sb=new StringBuilder(); for (Field fi : c.getDeclaredFields()) { if (isAccessible(fi)) { fi.setAccessible(true); Object value=fi.get(t); columns.add(fi.getName()); values.add(value); sb.append(fi.getName()).append(=?, ); } } String sql=UPDATE + c.getSimpleName() + SET + sb.toString().substring(0, sb.length() - 2) + WHERE id=?; // Assume 'PreparedStatement ps' is already created and initialized with 'columns' and 'values' return executeUpdate(sql, values);}

gistfile1.txt

/**修改对象*/ public static int updateObject(T t){ int i=0; Class c=t.getClass(); List columns=new ArrayList (); List values=new ArrayList(); StringBuffer sb=new StringBuffer(); for (Field fi : c.getDeclaredFields()) { if (isBasicType(fi.getType())) columns.add(fi.getName()); } sb.append("update "); sb.append(c.getSimpleName()); sb.append(" set "); for (String string : columns) { sb.append(string); sb.append("=?,"); } sb.delete(sb.length()-1, sb.length()); sb.append("where id=?"); for (String s:columns) { for (Method mt: c.getMethods()) { if (mt.getName().equalsIgnoreCase("get"+s)) { try { System.out.println(mt.getName()); values.add(mt.invoke(t, null)); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (IllegalArgumentException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } } } } try { //最后添加ID values.add(c.getMethod("getId", null).invoke(t, null)); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (IllegalArgumentException e) { } catch (InvocationTargetException e) { e.printStackTrace(); } catch (NoSuchMethodException e) { e.printStackTrace(); } catch (SecurityException e) { e.printStackTrace(); } i=executeUpdate(sb.toString(), values); return i; }

本文共计259个文字,预计阅读时间需要2分钟。

javapublic static int updateObject(T t) { int i=0; Class c=t.getClass(); List columns=new ArrayList(); List values=new ArrayList(); StringBuilder sb=new StringBuilder(); for (Field fi : c.getDeclaredFields()) { if (isAccessible(fi)) { fi.setAccessible(true); Object value=fi.get(t); columns.add(fi.getName()); values.add(value); sb.append(fi.getName()).append(=?, ); } } String sql=UPDATE + c.getSimpleName() + SET + sb.toString().substring(0, sb.length() - 2) + WHERE id=?; // Assume 'PreparedStatement ps' is already created and initialized with 'columns' and 'values' return executeUpdate(sql, values);}

gistfile1.txt

/**修改对象*/ public static int updateObject(T t){ int i=0; Class c=t.getClass(); List columns=new ArrayList (); List values=new ArrayList(); StringBuffer sb=new StringBuffer(); for (Field fi : c.getDeclaredFields()) { if (isBasicType(fi.getType())) columns.add(fi.getName()); } sb.append("update "); sb.append(c.getSimpleName()); sb.append(" set "); for (String string : columns) { sb.append(string); sb.append("=?,"); } sb.delete(sb.length()-1, sb.length()); sb.append("where id=?"); for (String s:columns) { for (Method mt: c.getMethods()) { if (mt.getName().equalsIgnoreCase("get"+s)) { try { System.out.println(mt.getName()); values.add(mt.invoke(t, null)); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (IllegalArgumentException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } } } } try { //最后添加ID values.add(c.getMethod("getId", null).invoke(t, null)); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (IllegalArgumentException e) { } catch (InvocationTargetException e) { e.printStackTrace(); } catch (NoSuchMethodException e) { e.printStackTrace(); } catch (SecurityException e) { e.printStackTrace(); } i=executeUpdate(sb.toString(), values); return i; }