Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package finalproyect;
- import java.awt.Color;
- import java.awt.HeadlessException;
- import java.awt.event.ActionEvent;
- import java.awt.event.ActionListener;
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.SQLException;
- import java.sql.ResultSet;
- import java.sql.Statement;
- import java.sql.PreparedStatement;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import javax.swing.JButton;
- import javax.swing.JFrame;
- import javax.swing.JLabel;
- import javax.swing.JOptionPane;
- import javax.swing.JPanel;
- import javax.swing.JTextField;
- import javax.swing.UIManager;
- /**
- *
- * @author chris
- */
- public class BattleshipDataBase {
- public void registration(String playerOne,String playerTwo){
- try {
- String url= "jdbc:derby://localhost:1527/battleshipDataBase";
- String username="malcom";
- String password="Malcom";
- Connection connection =DriverManager.getConnection(url, username, password);
- Statement statement= connection.createStatement();
- String query= "INSERT INTO DATABASE(PLAYERONE, PLAYERTWO) VALUES('"+playerOne+"', '"+playerTwo+"')";
- statement.execute(query);
- JOptionPane.showMessageDialog(null,"Registration Done!!");
- } catch (SQLException ex) {
- Logger.getLogger(BattleshipDataBase.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- public void resultsInfo(String playerOne,int playerOneVictory,int playerOneDefeat,
- String playerTwo,int playerTwoVictory,int playerTwoDefeat) {
- try {
- String url= "jdbc:derby://localhost:1527/battleshipDataBase";
- String username="malcom";
- String password="Malcom";
- Connection connection =DriverManager.getConnection(url, username, password);
- Statement statement= connection.createStatement();
- String query= "INSERT INTO DATABASE(PLAYERONE, VICTORYPLAYERONE, DEFEATPLAYERONE, PLAYERTWO, VICTORYPLAYERTWO, DEFEATPLAYERTWO) "
- + "VALUES('"+playerOne+"','"+playerOneVictory+"', '"+playerOneDefeat+"', '"+playerTwo+"','"+playerTwoVictory+"', '"+playerTwoDefeat+"')";
- statement.executeUpdate(query);
- JOptionPane.showMessageDialog(null,"The final result of each player has been added to te database.");
- } catch (SQLException ex) {
- Logger.getLogger(BattleshipDataBase.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement