Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- updateMYSQL callDatabaseUpdate = new updateMYSQL(firstName , surname);
- callDatabaseUpdate.viewTable(firstName,surname);
- import java.awt.event.*;
- import javax.swing.*;
- import javax.swing.JOptionPane;
- import javax.swing.JFrame;
- import java.sql.*;
- import javax.swing.JPanel;
- import javax.swing.ImageIcon;
- import java.io.File;
- public class FrontScreen implements ActionListener
- {
- private static JRadioButton rb1, rb2, rb3;
- private static JFrame f = new JFrame("Welcome to Ballon d'or , created by Darren Estcourt");
- private static JButton b;
- private static JPanel myFirstPanel;
- public FrontScreen()
- {
- }
- public void CreateAndShowFrontScreen()
- {
- rb1 = new JRadioButton("Start New Game");
- rb2 = new JRadioButton("Load Game");
- rb3 = new JRadioButton("Quit");
- f.setExtendedState(JFrame.MAXIMIZED_BOTH);
- f.setDefaultCloseOperation(WindowConstants.DO_NOTHING_ON_CLOSE);
- myFirstPanel = new JPanel();
- f.add(myFirstPanel);
- b = new JButton("OK");
- myFirstPanel.add(rb1);
- myFirstPanel.add(rb2);
- myFirstPanel.add(rb3);
- ButtonGroup bg=new ButtonGroup();
- bg.add(rb1);
- bg.add(rb2);
- bg.add(rb3);
- myFirstPanel.add(b);
- b.addActionListener(this);
- f.addWindowListener(new WindowAdapter()
- {
- @Override public void windowClosing(WindowEvent e)
- {
- if(JOptionPane.showConfirmDialog(f, "Are you sure ?") == JOptionPane.YES_NO_OPTION)
- {
- f.setVisible(false);
- f.dispose();
- }
- }
- });
- }
- @Override public void actionPerformed(ActionEvent e)
- {
- if(rb1.isSelected())
- {
- f.dispose();
- ManagerName startNewGame = new ManagerName();
- startNewGame.getFrame().setVisible(true);
- }
- if(rb2.isSelected())
- {
- JOptionPane.showMessageDialog(null,"Plesae select a saved game" , "Load game" , JOptionPane.QUESTION_MESSAGE);
- }
- if(rb3.isSelected())
- {
- System.exit(0);
- }
- }
- public static void main(String[] args)
- {
- String dirname = "/home/cabox/workspace/savedgames";
- String dirname2 = "/home/cabox/workspace/drivers";
- File d = new File(dirname);
- File d2 = new File(dirname2);
- // Create directory now.
- d.mkdirs();
- d2.mkdirs();
- SwingUtilities.invokeLater(new Runnable()
- {
- public void run()
- {
- FrontScreen test = new FrontScreen();
- test.CreateAndShowFrontScreen();
- }
- });
- ManagerName test = new ManagerName();
- test.getManagerFirstName();
- ManagerName test2 = new ManagerName();
- test.getManagerSurName();
- updateMYSQL callDatabaseUpdate = new updateMYSQL(firstName , surname);
- callDatabaseUpdate.viewTable(firstName,surname);
- f.pack();
- f.setVisible(true);
- } // end main
- }
- import java.awt.event.*;
- import javax.swing.*;
- import javax.swing.JOptionPane;
- import javax.swing.JFrame;
- import java.sql.*;
- import javax.swing.JPanel;
- import javax.swing.ImageIcon;
- public class updateMYSQL
- {
- public updateMYSQL(ManagerName firstName , ManagerName surname)
- {
- String myDriver = "org.gjt.mm.mysql.Driver";
- String myUrl = "jdbc:mysql://localhost:3306/ballondor?autoReconnect=true&useSSL=false";
- Connection conn = DriverManager.getConnection(myUrl, "root", "Lucia290907");
- String query = "SELECT * FROM clubInfo";
- try(Statement st = conn.createStatement())
- {
- Class.forName(myDriver).newInstance();
- ResultSet rs = st.executeQuery(query);
- st.executeQuery("insert into name (first,last) values('"+firstName+"' , '"+surname+"')"); // UPDATING MYSQL DATABASE
- while (rs.next())
- {
- int TeamID = rs.getInt("TeamID");
- String TeamName = rs.getString("TeamName");
- // print the results
- JOptionPane.showMessageDialog(null,"List of team names" ,TeamName, JOptionPane.QUESTION_MESSAGE);
- System.out.format("%s, n", TeamName);
- } // end while loop
- st.close();
- } // end try
- catch (Exception e)
- {
- System.err.println("Got an exception! ");
- System.err.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement