Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String x = (String) jComboBox1.getSelectedItem();
- String z = JOptionPane.showInputDialog("Please enter new name for Database");
- try{
- Class.forName("java.sql.DriverManager");
- Connection con = (Connection)
- DriverManager.getConnection("jdbc:mysql://localhost:"+GlobalParams.portvar+"/",""+k,""+j);
- Statement stmnt = (Statement) con.createStatement();
- String query = "use "+x;
- stmnt.executeQuery(query);
- String query2 = "show tables";
- Statement stmnt2 = (Statement) con.createStatement();
- ResultSet rs = stmnt2.executeQuery(query2);
- while (rs.next()){
- String dname = rs.getString("Tables_in_"+x);
- if(jTextArea1.getText().equals("")){
- jTextArea1.setText(jTextArea1.getText()+dname);
- }
- else{
- jTextArea1.setText(jTextArea1.getText()+"\n"+dname);
- }
- String y = jTextArea1.getText();
- Scanner scanner = new Scanner(y);
- while (scanner.hasNextLine()) {
- String line = scanner.nextLine();
- String query3 = "Create database "+z;
- Statement stmnt3 = (Statement) con.createStatement();
- stmnt3.executeUpdate(query3);
- String query4 = "RENAME TABLE "+x+"."+line+" TO "+z+"."+line;
- stmnt.executeUpdate(query4);
- Statement stmnt5 = (Statement) con.createStatement();
- String query5 = "drop database "+x;
- stmnt5.executeUpdate(query5);
- }}}
- catch(Exception e){
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement