- /**
- * 插入表数据
- * @param tableName 表名
- * @param obj 实例
- * @param sqlUtility
- */
- public void insert(String tableName, Object obj, SQLUtility sqlUtility) throws
- GeneralException {
- Field fields[] = obj.getClass().getDeclaredFields();
- StringBuffer insertSql = new StringBuffer();
- insertSql.append(" INSERT INTO "+tableName+"(");
- StringBuffer valueSql = new StringBuffer();
- valueSql.append(" VALUES (");
- try {
- for (int i = 0; i < fields.length; i++) {
- fields[i].setAccessible(true);
- insertSql.append(fields[i].getName());
- if (fields[i].getType().getName().endsWith("Double") ||
- fields[i].getType().getName().endsWith("Integer") ||
- fields[i].getType().getName().endsWith("int")) {
- valueSql.append(fields[i].get(obj));
- }
- else {
- valueSql.append("'" + fields[i].get(obj) + "'");
- }
- if (i != fields.length - 1) {
- insertSql.append(",");
- valueSql.append(",");
- }
- else {
- insertSql.append(")");
- valueSql.append(")");
- }
- }
- sqlUtility.executeUpdate(insertSql.toString() + valueSql.toString());
- sqlUtility.checkSqlCode();
- }
- catch (IllegalAccessException ex1) {
- ex1.printStackTrace();
- }
- catch (IllegalArgumentException ex1) {
- ex1.printStackTrace();
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/080820135046.html
来源: http://www.codesnippet.cn/detail/080820135046.html