Advertisement
chris5855

game

May 8th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.65 KB | None | 0 0
  1.  
  2. package finalproyect;
  3.  
  4. import java.awt.Color;
  5. import java.awt.HeadlessException;
  6. import java.awt.event.ActionEvent;
  7. import java.awt.event.ActionListener;
  8. import java.sql.DriverManager;
  9. import java.sql.Connection;
  10. import java.sql.SQLException;
  11. import java.sql.ResultSet;
  12. import java.sql.Statement;
  13. import java.sql.PreparedStatement;
  14. import java.util.logging.Level;
  15. import java.util.logging.Logger;
  16. import javax.swing.JButton;
  17. import javax.swing.JFrame;
  18. import javax.swing.JLabel;
  19. import javax.swing.JOptionPane;
  20. import javax.swing.JPanel;
  21. import javax.swing.JTextField;
  22. import javax.swing.UIManager;
  23.  
  24.  
  25. /**
  26.  *
  27.  * @author chris
  28.  */
  29. public class BattleshipDataBase {
  30.     public  void registration(String playerOne,String playerTwo){
  31.    
  32.        
  33.         try {
  34.             String url= "jdbc:derby://localhost:1527/battleshipDataBase";
  35.             String username="malcom";
  36.             String password="Malcom";
  37.             Connection connection =DriverManager.getConnection(url, username, password);
  38.             Statement statement= connection.createStatement();
  39.            
  40.             String query= "INSERT INTO DATABASE(PLAYERONE, PLAYERTWO) VALUES('"+playerOne+"', '"+playerTwo+"')";
  41.             statement.execute(query);
  42.            
  43.             JOptionPane.showMessageDialog(null,"Registration Done!!");
  44.         } catch (SQLException ex) {
  45.             Logger.getLogger(BattleshipDataBase.class.getName()).log(Level.SEVERE, null, ex);
  46.         }
  47.     }
  48.    
  49.     public  void resultsInfo(String playerOne,int playerOneVictory,int playerOneDefeat,
  50.                             String playerTwo,int playerTwoVictory,int playerTwoDefeat) {
  51.        
  52.        
  53.          
  54.         try {
  55.             String url= "jdbc:derby://localhost:1527/battleshipDataBase";
  56.             String username="malcom";
  57.             String password="Malcom";
  58.             Connection connection =DriverManager.getConnection(url, username, password);
  59.             Statement statement= connection.createStatement();
  60.            
  61.             String query= "INSERT INTO DATABASE(PLAYERONE, VICTORYPLAYERONE, DEFEATPLAYERONE, PLAYERTWO, VICTORYPLAYERTWO, DEFEATPLAYERTWO) "
  62.                         +  "VALUES('"+playerOne+"','"+playerOneVictory+"', '"+playerOneDefeat+"', '"+playerTwo+"','"+playerTwoVictory+"', '"+playerTwoDefeat+"')";
  63.            
  64.             statement.executeUpdate(query);
  65.            
  66.             JOptionPane.showMessageDialog(null,"The final result of each player has been added to te database.");
  67.         } catch (SQLException ex) {
  68.             Logger.getLogger(BattleshipDataBase.class.getName()).log(Level.SEVERE, null, ex);
  69.         }
  70.     }
  71.        
  72. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement