| /**export table data in Sybase database to Corel Paradox
7.x Table |
| *@param schemaName |
assign the source data table's schema, null means that
table is owned by current user |
| *@param tableName |
assign the source table name |
| *@param targetDirectory |
assign the destination directory, in general, you want
to export table data to a file.But in fact, you can assign any legal
jdbc url not contains the prefix part(jdbc:paradox:/), so, c:/tmp,
c:/tmp/xx.zip, ////192.168.10.2/sharedir, //domain.com:3099/c:/data
all can assigned to this parameter, more about this information,
please see the document. |
| *@param targetTableName |
assign the destination table name which you want to
exported to it |
| *@param targetConnProps |
assign the conntion properties, please split multi
properties by ';' ,for example, username=abc;password=abc |
| */ |
|
| public static void exportTableToParadox7(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Corel Paradox 8.x Table*/ |
| public static void exportTableToParadox8(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Corel Paradox 9.x Table
*/ |
| public static void exportTableToParadox9(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Corel Paradox 10.x Table */ |
| public static void exportTableToParadox10(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Corel Paradox 11.x Table */ |
| public static void exportTableToParadox11(String
schemaName, String tableName, String targetDirectory, String targetTableName,String
targetConnProps) |
| |
| /**export table data to Paradox 3 Table */ |
| public static void exportTableToParadox3(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Paradox 3.5 Table */ |
| public static void exportTableToParadox3_5(String
schemaName, String tableName, String targetDirectory, String targetTableName,
String targetConnProps) |
| |
| /**export table data to Paradox 4.x Table */ |
| public static void exportTableToParadox4(String
schemaName, String tableName, String targetDirectory,String targetTableName,
String targetConnProps) |
| |
| /**export table data to Paradox 5.x Table */ |
| public static void exportTableToParadox5(String
schemaName, String tableName, String targetDirectory,String targetTableName,
String targetConnProps) |
| |
| |
| /**export SQL query result to Corel Paradox 7.x Table |
| *@param querySql |
assign the SQL query sentence |
| *@param targetDirectory |
assign the destination directory, in general, you want
to export table data to a file, so this parameter name is targetDirectory,
but in fact, you can assign any legal jdbc url not contains the prefix
part(jdbc:dbf:/), so, c:/tmp, c:/tmp/xx.zip, ////192.168.10.2/sharedir
all can assigned to this parameter, more about this information, please
see the document. |
| *@param targetTableName |
assign the destination table name which you want to
exported to it |
| *@param targetConnProps |
assign the conntion properties for build destination
database connectiion, please split multi properties by ';' ,for example,
username=abc;password=abc |
| */ |
|
| public static void exportQueryToParadox7(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Corel Paradox 8.x
Table*/ |
| public static void exportQueryToParadox9(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Corel Paradox 9.x
Table */ |
| public static void exportQueryToFoxpro8(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps)
|
| |
| /**export SQL query result to Corel Paradox 10.x
Table */ |
| public static void exportQueryToParadox10(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Corel Paradox 11.x
Table */ |
| public static void exportQueryToParadox11(String
querySQL, String targetDirectory, String targetTableName,String targetConnProps) |
| |
| /**export SQL query result to Paradox 3 Table */ |
| public static void exportQueryToParadox3(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Paradox 3.5 Table */ |
| public static void exportQueryToParadox3_5(String
querySQL, String targetDirectory, String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Paradox 4.x Table
*/ |
| public static void exportQueryToParadox4(String
querySQL, String targetDirectory,String targetTableName, String targetConnProps) |
| |
| /**export SQL query result to Paradox 5.x Table
*/ |
| public static void exportQueryToParadox5(String
querySQL, String targetDirectory,String targetTableName, String targetConnProps) |
| |
| |
You should supply a Sybase database connection , and
then call the method. We will release this connection after complete
a export operation for we want to avoid holding a reference to the
connection . So, if you want continue execute other export operation,
you should recall the setConnection method, for example, this code
execute two operations. com.hxtt.data.export.advance.ConnectionGetter.setConnection(yourConnection);
com.hxtt.data.export.advance.Sybase2Paradox.exportTableToParadox7(null,"ATABLE","c:/tmp","BTABLE",null);
com.hxtt.data.export.advance.ConnectionGetter.setConnection(yourConnection);
com.hxtt.data.export.advance.Sybase2Paradox.exportQueryToParadox7("select
* from ATABLE A,BTABLE B WHERE A.ID=B.ID","c:/tmp","NEWTABLE",null); |