如何编写Java工具类实现连接数据库并修改数据的操作?

2026-04-10 13:541阅读0评论SEO基础
  • 内容介绍
  • 文章标签
  • 相关推荐

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

如何编写Java工具类实现连接数据库并修改数据的操作?

javagistfile1.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 (id.equals(fi.getName())) { continue; } columns.add(fi.getName()); values.add(fi.get(t)); sb.append(fi.getName()).append(=?, ); } String sql=UPDATE table_name SET + sb.toString().substring(0, sb.length() - 2) + WHERE id=?; // Assume connection and statement are already set up // PreparedStatement pstmt=connection.prepareStatement(sql); // pstmt.setObject(1, values.get(0)); // for (int j=1; j

如何编写Java工具类实现连接数据库并修改数据的操作?

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; }

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

如何编写Java工具类实现连接数据库并修改数据的操作?

javagistfile1.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 (id.equals(fi.getName())) { continue; } columns.add(fi.getName()); values.add(fi.get(t)); sb.append(fi.getName()).append(=?, ); } String sql=UPDATE table_name SET + sb.toString().substring(0, sb.length() - 2) + WHERE id=?; // Assume connection and statement are already set up // PreparedStatement pstmt=connection.prepareStatement(sql); // pstmt.setObject(1, values.get(0)); // for (int j=1; j

如何编写Java工具类实现连接数据库并修改数据的操作?

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; }