Advertisement
JKaysss

Untitled

Oct 4th, 2013
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.52 KB | None | 0 0
  1. String x = (String) jComboBox1.getSelectedItem();
  2. String z = JOptionPane.showInputDialog("Please enter new name for Database");
  3.         try{
  4.         Class.forName("java.sql.DriverManager");
  5.         Connection con = (Connection)
  6.         DriverManager.getConnection("jdbc:mysql://localhost:"+GlobalParams.portvar+"/",""+k,""+j);
  7.         Statement stmnt = (Statement) con.createStatement();
  8.         String query = "use "+x;
  9.         stmnt.executeQuery(query);
  10.         String query2 = "show tables";
  11.         Statement stmnt2 = (Statement) con.createStatement();
  12.         ResultSet rs = stmnt2.executeQuery(query2);
  13.         while (rs.next()){
  14.         String dname = rs.getString("Tables_in_"+x);
  15.         if(jTextArea1.getText().equals("")){
  16.         jTextArea1.setText(jTextArea1.getText()+dname);
  17.         }
  18.         else{
  19.             jTextArea1.setText(jTextArea1.getText()+"\n"+dname);
  20.         }
  21.         String y = jTextArea1.getText();
  22.         Scanner scanner = new Scanner(y);
  23.         while (scanner.hasNextLine()) {
  24.         String line = scanner.nextLine();
  25.         String query3 = "Create database "+z;
  26.         Statement stmnt3 = (Statement) con.createStatement();
  27.         stmnt3.executeUpdate(query3);
  28.         String query4 =  "RENAME TABLE "+x+"."+line+" TO "+z+"."+line;
  29.         stmnt.executeUpdate(query4);
  30.         Statement stmnt5 = (Statement) con.createStatement();
  31.         String query5 = "drop database "+x;
  32.         stmnt5.executeUpdate(query5);
  33. }}}
  34.  
  35.     catch(Exception e){
  36.         e.printStackTrace();
  37.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement