Advertisement
GuilhermeRamalho

Classe Cadastrar Campeonato

Sep 22nd, 2015
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 20.25 KB | None | 0 0
  1. //Classe da interface que cadastra campeonatos no banco.
  2.  
  3. package com.nanothings.ProjetoEGD.views;
  4.  
  5. import com.nanothings.ProjetoEGD.models.Championship;
  6. import com.nanothings.ProjetoEGD.models.champSqlOperations;
  7. import javax.swing.JOptionPane;
  8.  
  9. /**
  10.  *
  11.  * @author guilh
  12.  */
  13. public class championchipScreen extends javax.swing.JInternalFrame {
  14.  
  15.     /**
  16.      * Creates new form insertChampionship
  17.      */
  18.     public championchipScreen() {
  19.         initComponents();
  20.     }
  21.  
  22.     /**
  23.      * This method is called from within the constructor to initialize the form.
  24.      * WARNING: Do NOT modify this code. The content of this method is always
  25.      * regenerated by the Form Editor.
  26.      */
  27.     @SuppressWarnings("unchecked")
  28.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  29.     private void initComponents() {
  30.  
  31.         jScrollPane1 = new javax.swing.JScrollPane();
  32.         champTable = new javax.swing.JTable();
  33.         insertChampPane = new javax.swing.JPanel();
  34.         coutryLabel = new javax.swing.JLabel();
  35.         champNameLabel = new javax.swing.JLabel();
  36.         coutryCombo = new javax.swing.JComboBox();
  37.         champNameField = new javax.swing.JTextField();
  38.         insertButton = new javax.swing.JButton();
  39.         editButton = new javax.swing.JButton();
  40.         deleteButton = new javax.swing.JButton();
  41.         saveButton = new javax.swing.JButton();
  42.  
  43.         setClosable(true);
  44.         setIconifiable(true);
  45.         setMaximizable(true);
  46.         setTitle("Campeonato - EGD Sports");
  47.         addInternalFrameListener(new javax.swing.event.InternalFrameListener() {
  48.             public void internalFrameActivated(javax.swing.event.InternalFrameEvent evt) {
  49.             }
  50.             public void internalFrameClosed(javax.swing.event.InternalFrameEvent evt) {
  51.             }
  52.             public void internalFrameClosing(javax.swing.event.InternalFrameEvent evt) {
  53.             }
  54.             public void internalFrameDeactivated(javax.swing.event.InternalFrameEvent evt) {
  55.             }
  56.             public void internalFrameDeiconified(javax.swing.event.InternalFrameEvent evt) {
  57.             }
  58.             public void internalFrameIconified(javax.swing.event.InternalFrameEvent evt) {
  59.             }
  60.             public void internalFrameOpened(javax.swing.event.InternalFrameEvent evt) {
  61.                 formInternalFrameOpened(evt);
  62.             }
  63.         });
  64.  
  65.         champTable.setModel(new javax.swing.table.DefaultTableModel(
  66.             new Object [][] {
  67.  
  68.             },
  69.             new String [] {
  70.                 "ID Campeonato", "Nome Campeonato", "País"
  71.             }
  72.         ));
  73.         champTable.addMouseListener(new java.awt.event.MouseAdapter() {
  74.             public void mouseClicked(java.awt.event.MouseEvent evt) {
  75.                 champTableMouseClicked(evt);
  76.             }
  77.         });
  78.         jScrollPane1.setViewportView(champTable);
  79.  
  80.         insertChampPane.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Cadastrar Campeonato", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 1, 12))); // NOI18N
  81.  
  82.         coutryLabel.setText("País do campeonato");
  83.  
  84.         champNameLabel.setText("Campeonato");
  85.  
  86.         coutryCombo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Afeganistão", "África do Sul", "Akrotiri", "Albânia", "Alemanha", "Andorra", "Angola", "Anguila", "Antárctida", "Antígua e Barbuda", "Antilhas Neerlandesas", "Arábia Saudita", "Arctic Ocean", "Argélia", "Argentina", "Arménia", "Aruba", "Ashmore and Cartier Islands", "Atlantic Ocean", "Austrália", "Áustria", "Azerbaijão", "Baamas", "Bangladeche", "Barbados", "Barém", "Bélgica", "Belize", "Benim", "Bermudas", "Bielorrússia", "Birmânia", "Bolívia", "Bósnia e Herzegovina", "Botsuana", "Brasil", "Brunei", "Bulgária", "Burquina Faso", "Burúndi", "Butão", "Cabo Verde", "Camarões", "Camboja", "Canadá", "Catar", "Cazaquistão", "Chade", "Chile", "China", "Chipre", "Clipperton Island", "Colômbia", "Comores", "Congo-Brazzaville", "Congo-Kinshasa", "Coral Sea Islands", "Coreia do Norte", "Coreia do Sul", "Costa do Marfim", "Costa Rica", "Croácia", "Cuba", "Dhekelia", "Dinamarca", "Domínica", "Egipto", "Emiratos Árabes Unidos", "Equador", "Eritreia", "Eslováquia", "Eslovénia", "Espanha", "Estados Unidos", "Estónia", "Etiópia", "Faroé", "Fiji", "Filipinas", "Finlândia", "França", "Gabão", "Gâmbia", "Gana", "Gaza Strip", "Geórgia", "Geórgia do Sul e Sandwich do Sul", "Gibraltar", "Granada", "Grécia", "Gronelândia", "Guame", "Guatemala", "Guernsey", "Guiana", "Guiné", "Guiné Equatorial", "Guiné-Bissau", "Haiti", "Honduras", "Hungria", "Iémen", "Ilha Bouvet", "Ilha do Natal", "Ilha Norfolk", "Ilhas Caimão", "Ilhas Cook", "Ilhas dos Cocos", "Ilhas Falkland", "Ilhas Heard e McDonald", "Ilhas Marshall", "Ilhas Salomão", "Ilhas Turcas e Caicos", "Ilhas Virgens Americanas", "Ilhas Virgens Britânicas", "Índia", "Indian Ocean", "Indonésia", "Irã", "Iraque", "Irlanda", "Islândia", "Israel", "Itália", "Jamaica", "Jan Mayen", "Japão", "Jersey", "Jibuti", "Jordânia", "Kuwait", "Laos", "Lesoto", "Letónia", "Líbano", "Libéria", "Líbia", "Listenstaine", "Lituânia", "Luxemburgo", "Macau", "Macedónia", "Madagáscar", "Malásia", "Malávi", "Maldivas", "Mali", "Malta", "Man, Isle of", "Marianas do Norte", "Marrocos", "Maurícia", "Mauritânia", "Mayotte", "México", "Micronésia", "Moçambique", "Moldávia", "Mónaco", "Mongólia", "Monserrate", "Montenegro", "Mundo", "Namíbia", "Nauru", "Navassa Island", "Nepal", "Nicarágua", "Níger", "Nigéria", "Niue", "Noruega", "Nova Caledónia", "Nova Zelândia", "Omã", "Pacific Ocean", "Países Baixos", "Palau", "Panamá", "Papua-Nova Guiné", "Paquistão", "Paracel Islands", "Paraguai", "Peru", "Pitcairn", "Polinésia Francesa", "Polónia", "Porto Rico", "Portugal", "Quénia", "Quirguizistão", "Quiribáti", "Reino Unido", "República Centro-Africana", "República Checa", "República Dominicana", "Roménia", "Ruanda", "Rússia", "Salvador", "Samoa", "Samoa Americana", "Santa Helena", "Santa Lúcia", "São Cristóvão e Neves", "São Marinho", "São Pedro e Miquelon", "São Tomé e Príncipe", "São Vicente e Granadinas", "Sara Ocidental", "Seicheles", "Senegal", "Serra Leoa", "Sérvia", "Singapura", "Síria", "Somália", "Southern Ocean", "Spratly Islands", "Sri Lanca", "Suazilândia", "Sudão", "Suécia", "Suíça", "Suriname", "Svalbard e Jan Mayen", "Tailândia", "Taiwan", "Tajiquistão", "Tanzânia", "Território Britânico do Oceano Índico", "Territórios Austrais Franceses", "Timor Leste", "Togo", "Tokelau", "Tonga", "Trindade e Tobago", "Tunísia", "Turquemenistão", "Turquia", "Tuvalu", "Ucrânia", "Uganda", "União Europeia", "Uruguai", "Usbequistão", "Vanuatu", "Vaticano", "Venezuela", "Vietname", "Wake Island", "Wallis e Futuna", "West Bank", "Zâmbia", "Zimbabué", "Europa", "América", "Ásia", "África", "Mundo" }));
  87.         coutryCombo.addActionListener(new java.awt.event.ActionListener() {
  88.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  89.                 coutryComboActionPerformed(evt);
  90.             }
  91.         });
  92.  
  93.         insertButton.setIcon(new javax.swing.ImageIcon(getClass().getResource("/com/nanothings/ProjetoEGD/views/Icons/IconsPackage1/Create.png"))); // NOI18N
  94.         insertButton.setText("Cadastrar");
  95.         insertButton.addActionListener(new java.awt.event.ActionListener() {
  96.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  97.                 insertButtonActionPerformed(evt);
  98.             }
  99.         });
  100.  
  101.         editButton.setIcon(new javax.swing.ImageIcon(getClass().getResource("/com/nanothings/ProjetoEGD/views/Icons/IconsPackage1/Modify.png"))); // NOI18N
  102.         editButton.setText("Editar");
  103.         editButton.setEnabled(false);
  104.         editButton.addActionListener(new java.awt.event.ActionListener() {
  105.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  106.                 editButtonActionPerformed(evt);
  107.             }
  108.         });
  109.  
  110.         deleteButton.setIcon(new javax.swing.ImageIcon(getClass().getResource("/com/nanothings/ProjetoEGD/views/Icons/IconsPackage1/Delete.png"))); // NOI18N
  111.         deleteButton.setText("Excluir");
  112.         deleteButton.addActionListener(new java.awt.event.ActionListener() {
  113.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  114.                 deleteButtonActionPerformed(evt);
  115.             }
  116.         });
  117.  
  118.         saveButton.setIcon(new javax.swing.ImageIcon(getClass().getResource("/com/nanothings/ProjetoEGD/views/Icons/IconsPackage1/Save.png"))); // NOI18N
  119.         saveButton.setText("Salvar");
  120.         saveButton.setEnabled(false);
  121.         saveButton.addActionListener(new java.awt.event.ActionListener() {
  122.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  123.                 saveButtonActionPerformed(evt);
  124.             }
  125.         });
  126.  
  127.         javax.swing.GroupLayout insertChampPaneLayout = new javax.swing.GroupLayout(insertChampPane);
  128.         insertChampPane.setLayout(insertChampPaneLayout);
  129.         insertChampPaneLayout.setHorizontalGroup(
  130.             insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  131.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, insertChampPaneLayout.createSequentialGroup()
  132.                 .addContainerGap()
  133.                 .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  134.                     .addComponent(champNameLabel)
  135.                     .addGroup(insertChampPaneLayout.createSequentialGroup()
  136.                         .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  137.                             .addComponent(champNameField, javax.swing.GroupLayout.PREFERRED_SIZE, 273, javax.swing.GroupLayout.PREFERRED_SIZE)
  138.                             .addComponent(coutryLabel)
  139.                             .addComponent(coutryCombo, javax.swing.GroupLayout.PREFERRED_SIZE, 136, javax.swing.GroupLayout.PREFERRED_SIZE))
  140.                         .addGap(18, 18, 18)
  141.                         .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  142.                             .addComponent(insertButton, javax.swing.GroupLayout.Alignment.TRAILING)
  143.                             .addComponent(editButton, javax.swing.GroupLayout.Alignment.TRAILING))
  144.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  145.                         .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  146.                             .addComponent(deleteButton)
  147.                             .addComponent(saveButton))))
  148.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  149.         );
  150.  
  151.         insertChampPaneLayout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {deleteButton, editButton, insertButton, saveButton});
  152.  
  153.         insertChampPaneLayout.setVerticalGroup(
  154.             insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  155.             .addGroup(insertChampPaneLayout.createSequentialGroup()
  156.                 .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  157.                     .addGroup(insertChampPaneLayout.createSequentialGroup()
  158.                         .addComponent(champNameLabel)
  159.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  160.                         .addComponent(champNameField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  161.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  162.                         .addComponent(coutryLabel)
  163.                         .addGap(7, 7, 7)
  164.                         .addComponent(coutryCombo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  165.                         .addGap(0, 2, Short.MAX_VALUE))
  166.                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, insertChampPaneLayout.createSequentialGroup()
  167.                         .addGap(0, 0, Short.MAX_VALUE)
  168.                         .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  169.                             .addComponent(saveButton)
  170.                             .addComponent(insertButton))
  171.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  172.                         .addGroup(insertChampPaneLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  173.                             .addComponent(editButton)
  174.                             .addComponent(deleteButton))))
  175.                 .addContainerGap())
  176.         );
  177.  
  178.         insertChampPaneLayout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {deleteButton, editButton, insertButton, saveButton});
  179.  
  180.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  181.         getContentPane().setLayout(layout);
  182.         layout.setHorizontalGroup(
  183.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  184.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  185.                 .addContainerGap()
  186.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  187.                     .addComponent(jScrollPane1)
  188.                     .addComponent(insertChampPane, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  189.                 .addContainerGap())
  190.         );
  191.         layout.setVerticalGroup(
  192.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  193.             .addGroup(layout.createSequentialGroup()
  194.                 .addContainerGap()
  195.                 .addComponent(insertChampPane, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  196.                 .addGap(18, 18, 18)
  197.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 217, Short.MAX_VALUE)
  198.                 .addContainerGap())
  199.         );
  200.  
  201.         pack();
  202.     }// </editor-fold>                        
  203.  
  204.     Championship champ = new Championship();
  205.    
  206.     //*********************************
  207.     //*********************************
  208.     //CONCERTAR AS FUNÇÕES EDITAR A SALVAR
  209.     //*********************************
  210.     //*********************************
  211.    
  212.     private void coutryComboActionPerformed(java.awt.event.ActionEvent evt) {                                            
  213.         // TODO add your handling code here:
  214.     }                                          
  215.  
  216.     private void insertButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            
  217.         // TODO add your handling code here:
  218.         String champName = champNameField.getText();
  219.         String champCoutry = (String) coutryCombo.getSelectedItem();
  220.        
  221.         champ.setName(champName);
  222.         champ.setCountry(champCoutry);
  223.        
  224.         champSqlOperations op = new champSqlOperations();
  225.         op.insertChampionship(champ);
  226.         op.updateChampJTable(champTable);
  227.         champNameField.setText(null);
  228.         coutryCombo.setSelectedIndex(0);
  229.         System.out.println("Campo de texto limpo!");
  230.         System.out.println("Combo do país restaurada ao padrão!");
  231.         System.out.println("Registro inserido com sucesso!");
  232.         System.out.println("Tabela atualizada!");
  233.     }                                            
  234.  
  235.     private void formInternalFrameOpened(javax.swing.event.InternalFrameEvent evt) {                                        
  236.         // TODO add your handling code here:
  237.         champSqlOperations op = new champSqlOperations();
  238.         op.updateChampJTable(champTable);
  239.         System.out.println("Dados carregados do banco de dados para a tabela.");
  240.     }                                        
  241.  
  242.     private void deleteButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            
  243.         // TODO add your handling code here:
  244.         //int lineToDelete = champTable.getSelectedRow();
  245.        if(champTable.getSelectedRow() != -1)
  246.        {
  247.             champSqlOperations op = new champSqlOperations();
  248.             op.deleteChampJTableRowOnDB(champTable);
  249.        }
  250.        else
  251.        {
  252.             JOptionPane.showMessageDialog(null, "Nemhum registro da tabela foi "
  253.                    + "selecionado para exclusão!");
  254.        }
  255.  
  256. //TESTES COM OS VALORES SELECIONADOS NA TABELA
  257. //        System.out.println("Sel Row"+champTable.getSelectedRow());
  258. //        System.out.println("Sel Col"+champTable.getSelectedColumn());
  259. //        System.out.println("Row Count"+champTable.getSelectedRowCount());
  260. //        System.out.println("Col Count"+champTable.getSelectedColumnCount());
  261. //        System.out.println("Rows"+champTable.getSelectedRows());
  262. //        System.out.println("Columns"+champTable.getSelectedColumns());
  263. //        System.out.println("ID "+champTable.getValueAt(champTable.getSelectedRow(),
  264. //                champTable.getSelectedColumn()));
  265.        
  266.     }                                            
  267.  
  268.     private void editButtonActionPerformed(java.awt.event.ActionEvent evt) {                                          
  269.         // TODO add your handling code here:
  270.         if(champTable.getSelectedRow() != -1)
  271.         {
  272.             champSqlOperations op = new champSqlOperations();
  273.  
  274.             op.getChampSelectedRowInfo(champTable, champNameField, coutryCombo);
  275.            
  276.            
  277.            
  278. //            String champName = champNameField.getText();
  279. //            String champCoutry = (String) coutryCombo.getSelectedItem();
  280. //        
  281. //            champ.setName(champName);
  282. //            champ.setCountry(champCoutry);
  283. //            op.updateChampJTableRowOnDb(champTable, champ);
  284.            
  285.             //Ativa o botão salvar
  286.             saveButton.setEnabled(true);
  287.         }
  288.         else
  289.         {
  290.             JOptionPane.showMessageDialog(null, "Nemhum registro da tabela foi "
  291.                    + "selecionado para edição!");
  292.         }
  293.     }                                          
  294.  
  295.     private void saveButtonActionPerformed(java.awt.event.ActionEvent evt) {                                          
  296.        // TODO add your handling code here:
  297.         String champName = champNameField.getText();
  298.         String champCoutry = (String) coutryCombo.getSelectedItem();
  299.        
  300.         champ.setName(champName);
  301.         champ.setCountry(champCoutry);
  302.        
  303.         champSqlOperations op = new champSqlOperations();
  304.         op.updateChampionship(champTable, champ);
  305.         op.updateChampJTable(champTable);
  306.        
  307.         champNameField.setText(null);
  308.         coutryCombo.setSelectedIndex(0);
  309.        
  310.         System.out.println("Campo de texto limpo!");
  311.         System.out.println("Combo do país restaurada ao padrão!");
  312.         System.out.println("Registro inserido com sucesso!");
  313.         System.out.println("Tabela atualizada!");
  314.     }                                          
  315.  
  316.     private void champTableMouseClicked(java.awt.event.MouseEvent evt) {                                        
  317.         // TODO add your handling code here:
  318. //        if(champTable.getSelectedRow() != -1)
  319. //        {
  320. //            editButton.setEnabled(true);
  321. //        }
  322.     }                                      
  323.  
  324.  
  325.     // Variables declaration - do not modify                    
  326.     private javax.swing.JTextField champNameField;
  327.     private javax.swing.JLabel champNameLabel;
  328.     private javax.swing.JTable champTable;
  329.     private javax.swing.JComboBox coutryCombo;
  330.     private javax.swing.JLabel coutryLabel;
  331.     private javax.swing.JButton deleteButton;
  332.     private javax.swing.JButton editButton;
  333.     private javax.swing.JButton insertButton;
  334.     private javax.swing.JPanel insertChampPane;
  335.     private javax.swing.JScrollPane jScrollPane1;
  336.     private javax.swing.JButton saveButton;
  337.     // End of variables declaration                  
  338. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement