I have a database named "Clients" and i want to get only "contacts" table without taking other database tables as a backup. I want to do this in my java swing application and please help me with this problem.
2
-
1this has nothing at all to do with Swing. Swing is just a framework that can be used to provide the user with a GUI. Select the table to backup, store it in memory, write it to another destination (file, other table, ... )Stultuske– Stultuske2018-12-05 11:15:03 +00:00Commented Dec 5, 2018 at 11:15
-
Here is a post (and answer) about MySQL: Backing up single table. I guess rest of the Swing GUI can take care of the application. Link to Java's Swing Tutorials. I think you should Google little bit and look for specific questions and answers.prasad_– prasad_2018-12-05 11:27:53 +00:00Commented Dec 5, 2018 at 11:27
Add a comment
|
1 Answer
Here is a way it can be done.
In the Swing application there can be a function for backup database. This function can be triggered from a menu option or a button. Let us take a button click as an example.
Create a JButton with name "Backup Database" in the application.
Add an ActionListener to the button. The actionPerformed method has the function's logic: This opens a JDialog with a status JTextArea, JButtons to select a target folder/file name of the backup, start the process, close the dialog, etc. The status area can display the selected folder, the output file name, success/error messages, etc. The process:
- Select the destination folder
- May be, there is an option to select the table name to be backed up
- Build the target filename (probably has a timestamp included in the filename)
- Click the start button: Run a SQL DDL using JDBC's
Statementobject'sexecuteUpdatemethod. This runs the SQL to create the backup and updates the status area with the backup file name -or- in case of an exception displays an appropriate message (and followup actions).
The dialog can look like this:
Also, see these posts:
