java导出sql文件

public List<Object> getTableInsertSql(Connection conn,String tableName, String where) throws Exception{
ResultSet rs = null;
Statement statement = null;
List<Object> list=null;
try {
DatabaseMetaData metadata = conn.getMetaData();
rs = metadata.getColumns(null, null, tableName, "%"); //得到表的字段列表
String sql = "select 'insert into " + tableName + " values ( '";
int count=0;
int counts=0;
//获得列的总数
while (rs.next()) {
count++;
}
//重新获得列数据 整理成sql
rs = metadata.getColumns(null, null, tableName, "%"); //得到表的字段列表
while (rs.next()) {
counts++;
if(counts<=count)
{
Object colName = rs.getObject("column_name");
sql += " ||'''' ||" + colName + "|| ''','";
}
}
sql=sql.substring(0,sql.length()-2)+"'";
sql += " || ' );' from " + tableName+ where;
rs.close();

// System.out.println("DEBUG: SQL="+sql);
//执行
statement = conn.createStatement();
rs = statement.executeQuery(sql);

//将SQL语句放到List中
list=new ArrayList<Object>();
while (rs.next())
list.add(rs.getObject(1));
rs.close();

//System.out.println(list.size());
} finally {
if (rs != null)
rs.close();
if (statement != null)
statement.close();
conn.close();
}
return list;
}

参考：http://blog.csdn.net/bcqtt/article/details/51670586

转载于:https://www.cnblogs.com/seeusmile-cnblog/p/7976939.html