//通用表插入
public static int insertTableList(Connection connection, String tableName, T t){
int flag = -1;
QueryRunner queryRunner = new QueryRunner();
Class c=t.getClass();
String sql = "insert into "+tableName+" (";
String sql2 = " values (";
//获取该类的成员变量
Field[] declaredFields = c.getDeclaredFields();
for (Field field : declaredFields) {
try {//获取成员变量的类型field.getType().getName() //获取成员变量的名称
sql = sql + field.getName()+",";
if (BeanUtils.getProperty(t,field.getName())==null){
sql2 = sql2 + BeanUtils.getProperty(t,field.getName()) +",";
}
else {
sql2 = sql2 + "\"" + BeanUtils.getProperty(t,field.getName()) + "\"" +",";
}
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
} catch (NoSuchMethodException e) {
e.printStackTrace();
}
}
sql = sql.substring(0,sql.length()-1);
sql2 = sql2.substring(0,sql2.length()-1);
sql = sql+")"+sql2+")";
System.out.println(sql);
try {
flag = queryRunner.update(connection,sql);
} catch (SQLException e) {
e.printStackTrace();
}
return flag;
}