Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package MYSQL_GUI;
- import java.awt.Dimension;
- import java.awt.Toolkit;
- import java.sql.DriverManager;
- import com.mysql.jdbc.*;
- import com.mysql.jdbc.Connection;
- import java.sql.ResultSet;
- import java.util.Scanner;
- import javax.swing.JOptionPane;
- public class Frame1 extends javax.swing.JFrame {
- public static String k;
- public static String j;
- public Frame1() {
- initComponents();
- Dimension dim = Toolkit.getDefaultToolkit().getScreenSize();
- this.setLocation(dim.width/2-this.getSize().width/2, dim.height/2-this.getSize().height/2);
- jButton1.setVisible(false);jButton3.setVisible(false);
- GlobalParams.usedb=false;
- }
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- user = new javax.swing.JTextField();
- pass = new javax.swing.JTextField();
- jTextField3 = new javax.swing.JTextField();
- jLabel1 = new javax.swing.JLabel();
- jComboBox1 = new javax.swing.JComboBox();
- jButton1 = new javax.swing.JButton();
- jTextField1 = new javax.swing.JTextField();
- jButton2 = new javax.swing.JButton();
- jButton3 = new javax.swing.JButton();
- jLabel2 = new javax.swing.JLabel();
- jSeparator1 = new javax.swing.JSeparator();
- jLabel3 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jLabel4 = new javax.swing.JLabel();
- jButton4 = new javax.swing.JButton();
- jButton5 = new javax.swing.JButton();
- jButton6 = new javax.swing.JButton();
- jButton7 = new javax.swing.JButton();
- jButton8 = new javax.swing.JButton();
- user.setText("jTextField3");
- pass.setText("jTextField4");
- jTextField3.setText("jTextField3");
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- setTitle("MySQL Database Selection");
- addWindowListener(new java.awt.event.WindowAdapter() {
- public void windowActivated(java.awt.event.WindowEvent evt) {
- formWindowActivated(evt);
- }
- });
- jLabel1.setFont(new java.awt.Font("Tahoma", 0, 18)); // NOI18N
- jLabel1.setText("Select a Database Task to Continue");
- jComboBox1.setMaximumRowCount(1000);
- jButton1.setText("Create Database");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jTextField1.setFont(new java.awt.Font("Tahoma", 0, 10)); // NOI18N
- jTextField1.addCaretListener(new javax.swing.event.CaretListener() {
- public void caretUpdate(javax.swing.event.CaretEvent evt) {
- jTextField1CaretUpdate(evt);
- }
- });
- jButton2.setText("Delete Selected Database");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jButton3.setText("SelectCustom database");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- jLabel2.setText("Select a Database:");
- jLabel3.setText("Create New Database:");
- jTextField2.setFont(new java.awt.Font("Tahoma", 0, 10)); // NOI18N
- jTextField2.addCaretListener(new javax.swing.event.CaretListener() {
- public void caretUpdate(javax.swing.event.CaretEvent evt) {
- jTextField2CaretUpdate(evt);
- }
- });
- jLabel4.setText("Enter Database Name Directly:");
- jButton4.setText("Back to Login");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- jButton5.setText("Exit");
- jButton5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton5ActionPerformed(evt);
- }
- });
- jButton6.setText("Proceed with Selected Database");
- jButton6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton6ActionPerformed(evt);
- }
- });
- jButton7.setText("Enter Custom Command(s)");
- jButton7.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton7ActionPerformed(evt);
- }
- });
- jButton8.setText("Rename Database");
- jButton8.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton8ActionPerformed(evt);
- }
- });
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jSeparator1)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(jLabel2)
- .addGap(108, 108, 108))
- .addGroup(layout.createSequentialGroup()
- .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(23, 23, 23))
- .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
- .addGap(10, 10, 10)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(jButton7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 162, Short.MAX_VALUE)
- .addGroup(layout.createSequentialGroup()
- .addGap(26, 26, 26)
- .addComponent(jButton1))
- .addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addComponent(jButton6)
- .addGap(18, 18, 18)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(10, 10, 10)
- .addComponent(jButton3))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 162, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel4))
- .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addComponent(jButton5, javax.swing.GroupLayout.Alignment.TRAILING))))
- .addContainerGap())
- .addGroup(layout.createSequentialGroup()
- .addGap(49, 49, 49)
- .addComponent(jLabel1)
- .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(12, 12, 12)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGap(8, 8, 8)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton1)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 8, Short.MAX_VALUE)
- .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(layout.createSequentialGroup()
- .addGap(14, 14, 14)
- .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jButton7)
- .addGap(0, 0, Short.MAX_VALUE)))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jButton3)
- .addComponent(jButton8))
- .addGap(29, 29, 29)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jButton5)
- .addComponent(jButton4)
- .addComponent(jButton6))
- .addContainerGap())
- );
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- String datab = jTextField1.getText();
- if(datab.equals("")){
- jComboBox1.removeAllItems();
- JOptionPane.showMessageDialog(this,"Please Enter Database Name");
- 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 = "show databases";
- ResultSet rs = stmnt.executeQuery(query);
- while (rs.next()){
- String db = rs.getString("Database");
- jComboBox1.removeAllItems();
- jComboBox1.addItem(db);}
- jTextField1.setText("");}
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- }
- else{
- 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 = "create database "+datab;
- stmnt.executeUpdate(query);
- jComboBox1.removeAll();
- jTextField1.setText("");
- jComboBox1.setSelectedItem(datab);
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- jComboBox1.removeAllItems();
- 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 = "show databases";
- ResultSet rs = stmnt.executeQuery(query);
- while (rs.next()){
- String db = rs.getString("Database");
- jComboBox1.addItem(db);}
- jTextField1.setText("");}
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- jTextField1.setText("");
- jComboBox1.setSelectedItem(datab);}
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- String x = (String) jComboBox1.getSelectedItem();
- 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 = "drop database "+x;
- stmnt.executeUpdate(query);
- }
- catch(Exception e){
- if(e.getMessage().equals("Access denied for user 'root'@'localhost' to database '"+x+"'")){
- JOptionPane.showMessageDialog(this,"Cannot delete default sample databases. Access Denied.");
- }
- else{JOptionPane.showMessageDialog(this,e.getMessage());}
- }
- jComboBox1.removeAllItems();
- 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 = "show databases";
- ResultSet rs = stmnt.executeQuery(query);
- while (rs.next()){
- String db = rs.getString("Database");
- jComboBox1.addItem(db);}
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- String datab = jTextField2.getText();
- 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 "+datab;
- stmnt.executeQuery(query);
- jComboBox1.setSelectedItem(datab);
- }
- catch(Exception e){
- if(e.getMessage().equals("Unknown database '"+datab+"'")){
- JOptionPane.showMessageDialog(this,"Database with name '"+datab+"' does not Exist");
- }
- else{
- JOptionPane.showMessageDialog(this,e.getMessage());
- }}
- jComboBox1.removeAll();
- jComboBox1.removeAllItems();
- 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 = "show databases";
- ResultSet rs = stmnt.executeQuery(query);
- while (rs.next()){
- String db = rs.getString("Database");
- jComboBox1.addItem(db);}
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- jComboBox1.setSelectedItem(datab);
- }
- private void jTextField1CaretUpdate(javax.swing.event.CaretEvent evt) {
- if(jTextField1.getText().equals("")){
- jButton1.setVisible(false);
- }
- else{
- jButton1.setVisible(true);
- }
- }
- private void jTextField2CaretUpdate(javax.swing.event.CaretEvent evt) {
- if(jTextField2.getText().equals("")){
- jButton3.setVisible(false);
- }
- else{
- jButton3.setVisible(true);
- }
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- int dialogResult = JOptionPane.showConfirmDialog (this, "Would you like to return to Login Screen? You won't loose your data.");
- if(dialogResult == JOptionPane.YES_OPTION){new MYSQL_Login().setVisible(true);
- dispose();}
- else{};
- }
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- int dialogResult = JOptionPane.showConfirmDialog (this, "Are you sure you want to Exit?");
- if(dialogResult == JOptionPane.YES_OPTION){System.exit(0);}
- else{};
- }
- private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
- String dbname= (String) jComboBox1.getSelectedItem();
- GlobalParams.dbvar=dbname;
- GlobalParams.usedb=true;
- new Frame2().setVisible(true);
- this.dispose();
- }
- private void formWindowActivated(java.awt.event.WindowEvent evt) {
- jComboBox1.removeAllItems();
- 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 = "show databases";
- ResultSet rs = stmnt.executeQuery(query);
- while (rs.next()){
- String db = rs.getString("Database");
- jComboBox1.addItem(db);}
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- GlobalParams.usedb=false;
- }
- private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
- new CustComm().setVisible(true);
- }
- private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
- 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";
- ResultSet rs = stmnt.executeQuery(query2);
- while (rs.next()){
- String dname = rs.getString("Tables_in_"+x);
- CustComm.jTextArea1.setText(dname);
- new CustComm().setVisible(true);
- String y = CustComm.jTextArea1.getText();
- Scanner scanner = new Scanner(y);
- while (scanner.hasNextLine()) {
- String line = scanner.nextLine();
- //alter table my_old_db.mytable rename my_new_db.mytable
- String query3 = "RENAME TABLE "+x+"."+line+" TO "+z+"."+line;
- }}}
- catch(Exception e){
- JOptionPane.showMessageDialog(this,e.getMessage());
- }
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- /* Set the Nimbus look and feel */
- //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
- /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
- * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
- */
- try {
- for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
- if ("Nimbus".equals(info.getName())) {
- javax.swing.UIManager.setLookAndFeel(info.getClassName());
- break;
- }
- }
- } catch (ClassNotFoundException ex) {
- java.util.logging.Logger.getLogger(Frame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(Frame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(Frame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(Frame1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new Frame1().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JButton jButton5;
- private javax.swing.JButton jButton6;
- private javax.swing.JButton jButton7;
- private javax.swing.JButton jButton8;
- public static javax.swing.JComboBox jComboBox1;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JSeparator jSeparator1;
- private javax.swing.JTextField jTextField1;
- private javax.swing.JTextField jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField pass;
- private javax.swing.JTextField user;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement