救一条sql语句

[zzm76]

String sql="insert table1 (id) values ('4')";
可能被插入的表是个变量，可能是table1也可能是table2或者table3

如果是查找的话可以用String sql="select * from "+tableName;处理
插入怎么搞好呢？

[curry913]

???
String sql="insert "+ tableName +" (id) values ('4')";

[topbit]

private static final String SQL_SELECT_TABLE1 = "select * from Table1";
private static final String SQL_SELECT_TABLE2 = "select * from Table2";
private static final String SQL_SELECT_TABLE3 = "select * from Table3";

public ResultSet query(int tableIndex)
{
switch(tableIndex)
{
case 1:
return getConnection().prepareStatement(SQL_SELECT_TABLE1).execute();
case 2:
return getConnection().prepareStatement(SQL_SELECT_TABLE2).execute();
case 3:
return getConnection().prepareStatement(SQL_SELECT_TABLE3).execute();
}
}

[ticlej]

如果字段都是一致的,那就用String sql="insert "+ tableName +" (id) values ('4')";
但如果不一定是"id",就看你的需求了.