java类实现导出各种数据库insert语句

《java类实现导出各种数据库insert语句》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、导出insertsql语句importjava.io.BufferedWriter;importjava.io.File;importjava.io.FileWriter;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLException;importjava.sql.Statemen

2、t;importjava.sql.Types;importjava.util.ArrayList;importjava.util.List;publicclassTest{privatestaticConnectionconn=null;privatestaticStatementsm=null;privatestaticStringschema="FJSTL";//模式名privatestaticStringselect="SELECT*FROM";//查询sqlprivatestaticStringinsert="INSERTINTO";//

3、插入sqlprivatestaticStringvalues="VALUES";//values关键字privatestaticString[]table={"T_USER"};//table数组privatestaticListinsertList=newArrayList();//全局存放insertsql文件的数据privatestaticStringfilePath="E://insertSQL.txt";//绝对路径导出数据的文件/***导出数据库表*@paramargs*@throwsSQLExcept

4、ion*/publicstaticvoidmain(String[]args)throwsSQLException{ListlistSQL=newArrayList();connectSQL("oracle.jdbc.driver.OracleDriver","xxx.xxx.xxx","xxx","xxx");//连接数据库listSQL=createSQL();//创建查询语句executeSQL(conn,sm,listSQL);//执行sql并拼装createFile();//创建文件}/***创建inse

5、rtsql.txt并导出数据*/privatestaticvoidcreateFile(){Filefile=newFile(filePath);if(!file.exists()){try{file.createNewFile();}catch(IOExceptione){System.out.println("创建文件名失败！！");e.printStackTrace();}}FileWriterfw=null;BufferedWriterbw=null;try{fw=newFileWriter(file);bw=newBufferedWri

6、ter(fw);if(insertList.size()>0){for(inti=0;i

7、icListcreateSQL(){ListlistSQL=newArrayList();for(inti=0;i

8、amdriver*@paramurl*@paramUserName*@paramPassword*/publicstaticvoidco