java insert into_JAVA 中执行insert into语句

确定了需求，数据库会设计死的，不可能有数据库的列不固定吧，你是不是意思说错了？

如果你想添加一个条的空记录也行，必须拿到主键(下面的表主键是自增的)

| Field | Type | Null | Key | Default | Extra |

+------------+--------------+------+-----+---------+----------------+

| id | bigint(20) | NO | PRI | NULL | auto_increment |

| filename | varchar(200) | YES | | NULL | |

| filesize | varchar(50) | YES | | NULL | |

| filepath | varchar(100) | YES | | NULL | |

| createby | varchar(50) | YES | | NULL | |

| createtime | datetime | YES | | NULL | |

+------------+--------------+------+-----+---------+----------------+

insert into ar_importfile(filename) value(null);

mysql> select * from ar_importfile;

+----+----------+----------+----------+----------+------------+

| id | filename | filesize | filepath | createby | createtime |

+----+----------+----------+----------+----------+------------+

| 1 | aa | NULL | NULL | NULL | NULL |

| 2 | NULL | NULL | NULL | NULL | NULL |

+----+----------+----------+----------+----------+------------+

想办法拿到主键，你就可以执行你的update语句了，代价有点大，不如之间在插入时候就只插入你想插的数据， insert into ar_importfile (filename,filesize)values('aa',100);

mysql> select * from ar_importfile;

+----+----------+----------+----------+----------+------------+

| id | filename | filesize | filepath | createby | createtime |

+----+----------+----------+----------+----------+------------+

| 1 | aa | NULL | NULL | NULL | NULL |

| 2 | NULL | NULL | NULL | NULL | NULL |

| 3 | aa | 100 | NULL | NULL | NULL |

+----+----------+----------+----------+----------+------------+