e.f.solution Wiki
Brought to you by:
factooor
Menu
▾
▴
MenuPrincipal.java
/
* licence GPL V2
* Copyleft : Pinel Stéphane - Paris - France
* mail : stpinel@infonie.fr
* To change this template, choose Tools | Templates
* and open the template in the editor.
/
/
* MenuPrincipal.java
* Created on 14 févr. 2010, 18:21:20
*/
package efs.ui;
import efs.SourceDonnees;
import efs.SourceDonnees.*;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
/
* @author Pinel Stéphane
/
public class MenuPrincipal extends javax.swing.JFrame{
private String requete = "";
private String Urequete= "";
public static Connection con;
/** Creates new form MenuPrincipal */
public MenuPrincipal() {
initComponents();
// jFrame.setLocationRelativeTo(jFrame.getParent());
//jFrame.show();
this.setLocationRelativeTo(null);
// this.setBounds(150, 85, 925, 600);
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jTabPrinc = new javax.swing.JTabbedPane();
jLayeredPane1 = new javax.swing.JLayeredPane();
jLayFac = new javax.swing.JLayeredPane();
jLabel1 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
jLayPaie = new javax.swing.JLayeredPane();
jLayGest = new javax.swing.JLayeredPane();
jLayCompta = new javax.swing.JLayeredPane();
jSeparator3 = new javax.swing.JSeparator();
jTabbedPane1 = new javax.swing.JTabbedPane();
jLayeredPane2 = new javax.swing.JLayeredPane();
jLayeredPane3 = new javax.swing.JLayeredPane();
jLayprefs = new javax.swing.JLayeredPane();
jLabel4 = new javax.swing.JLabel();
jTRaisSoc = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
jTAdress = new javax.swing.JTextField();
jBEnvoyer = new javax.swing.JButton();
jLabel6 = new javax.swing.JLabel();
jTAdresseSui = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jTCP = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jTVille = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
jTTel = new javax.swing.JTextField();
jLabel11 = new javax.swing.JLabel();
jTFax = new javax.swing.JTextField();
jLabel12 = new javax.swing.JLabel();
jTWeb = new javax.swing.JTextField();
jLabel13 = new javax.swing.JLabel();
jTCour = new javax.swing.JTextField();
jLabel14 = new javax.swing.JLabel();
JTRlegal = new javax.swing.JTextField();
jLabel15 = new javax.swing.JLabel();
jTSiret = new javax.swing.JTextField();
jLabel16 = new javax.swing.JLabel();
jComboEntre = new javax.swing.JComboBox();
jLabel17 = new javax.swing.JLabel();
jTTvaIntra = new javax.swing.JTextField();
jLabel18 = new javax.swing.JLabel();
jLabel19 = new javax.swing.JLabel();
jTNom = new javax.swing.JTextField();
jTPrenom = new javax.swing.JTextField();
jCombpays = new javax.swing.JComboBox();
jBGauche = new javax.swing.JButton();
jBDroite = new javax.swing.JButton();
jTModification = new javax.swing.JToggleButton();
jBoutGau = new javax.swing.JPanel();
ButtonFacture = new javax.swing.JToggleButton();
ButtonPaie = new javax.swing.JToggleButton();
BouDroit = new javax.swing.JPanel();
jToggleButton4 = new javax.swing.JToggleButton();
jToggleButton3 = new javax.swing.JToggleButton();
piedDePage = new javax.swing.JPanel();
jBQuitter = new javax.swing.JButton();
jLabel20 = new javax.swing.JLabel();
enTete = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jSeparator2 = new javax.swing.JSeparator();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("Menu Application");
setBounds(new java.awt.Rectangle(0, 0, 950, 650));
setResizable(false);
jTabPrinc.addTab("Resumé", jLayeredPane1);
jLabel1.setText("C-A :");
jLabel1.setBounds(10, 20, 70, 15);
jLayFac.add(jLabel1, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel3.setText("15420€");
jLabel3.setBounds(70, 20, 48, 15);
jLayFac.add(jLabel3, javax.swing.JLayeredPane.DEFAULT_LAYER);
jSeparator1.setBounds(0, 220, 450, 2);
jLayFac.add(jSeparator1, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTabPrinc.addTab("Facture", jLayFac);
jTabPrinc.addTab("Paie", jLayPaie);
jTabPrinc.addTab("Gestion", jLayGest);
jSeparator3.setBounds(0, 242, 440, 0);
jLayCompta.add(jSeparator3, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTabbedPane1.addTab("Section", jLayeredPane2);
jTabbedPane1.addTab("Plan comptable", jLayeredPane3);
jTabbedPane1.setBounds(10, 0, 420, 360);
jLayCompta.add(jTabbedPane1, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTabPrinc.addTab("Compta", jLayCompta);
jLabel4.setText("Raison sociale :");
jLabel4.setBounds(20, 10, 120, 15);
jLayprefs.add(jLabel4, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTRaisSoc.setBounds(160, 10, 290, 19);
jLayprefs.add(jTRaisSoc, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel5.setText("Adresse :");
jLabel5.setBounds(20, 70, 100, 15);
jLayprefs.add(jLabel5, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTAdress.setBounds(160, 70, 290, 19);
jLayprefs.add(jTAdress, javax.swing.JLayeredPane.DEFAULT_LAYER);
jBEnvoyer.setBackground(new java.awt.Color(51, 102, 255));
jBEnvoyer.setForeground(new java.awt.Color(255, 255, 255));
jBEnvoyer.setText("Sauvegarder");
jBEnvoyer.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBEnvoyerActionPerformed(evt);
}
});
jBEnvoyer.setBounds(20, 330, 130, 25);
jLayprefs.add(jBEnvoyer, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel6.setText("Adresse suite :");
jLabel6.setBounds(20, 90, 110, 15);
jLayprefs.add(jLabel6, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTAdresseSui.setBounds(160, 90, 290, 19);
jLayprefs.add(jTAdresseSui, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel7.setText("Code postal");
jLabel7.setBounds(20, 110, 100, 15);
jLayprefs.add(jLabel7, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTCP.setBounds(20, 125, 90, 19);
jLayprefs.add(jTCP, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel8.setText("Ville");
jLabel8.setBounds(170, 110, 50, 15);
jLayprefs.add(jLabel8, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTVille.setBounds(130, 125, 120, 19);
jLayprefs.add(jTVille, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel9.setText("Pays");
jLabel9.setBounds(320, 110, 51, 15);
jLayprefs.add(jLabel9, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel10.setText("Télephone :");
jLabel10.setBounds(20, 150, 90, 15);
jLayprefs.add(jLabel10, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTTel.setBounds(110, 150, 120, 19);
jLayprefs.add(jTTel, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel11.setText("Fax :");
jLabel11.setBounds(245, 150, 40, 15);
jLayprefs.add(jLabel11, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTFax.setBounds(300, 150, 150, 19);
jLayprefs.add(jTFax, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel12.setText("Site Web :");
jLabel12.setBounds(20, 180, 80, 15);
jLayprefs.add(jLabel12, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTWeb.setMargin(new java.awt.Insets(0, 10, 3, 0));
jTWeb.setBounds(120, 175, 330, 19);
jLayprefs.add(jTWeb, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel13.setText("Courriel :");
jLabel13.setBounds(20, 200, 70, 15);
jLayprefs.add(jLabel13, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTCour.setBounds(120, 200, 330, 19);
jLayprefs.add(jTCour, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel14.setText("Représentant légal :");
jLabel14.setBounds(20, 230, 150, 15);
jLayprefs.add(jLabel14, javax.swing.JLayeredPane.DEFAULT_LAYER);
JTRlegal.setBounds(190, 230, 260, 19);
jLayprefs.add(JTRlegal, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel15.setText("SIRET/SIREN");
jLabel15.setBounds(20, 280, 90, 15);
jLayprefs.add(jLabel15, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTSiret.setBounds(20, 300, 140, 19);
jLayprefs.add(jTSiret, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel16.setText("Type d'entreprise :");
jLabel16.setBounds(20, 255, 140, 15);
jLayprefs.add(jLabel16, javax.swing.JLayeredPane.DEFAULT_LAYER);
jComboEntre.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Travailleur Indépendant", "EURL", "SASU", "SNC", "SC", "SARL", "SARL CV", "SA", "SAS", "Auto-Entrepreneur" }));
jComboEntre.setBounds(220, 260, 200, 18);
jLayprefs.add(jComboEntre, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel17.setText("TVA intracommunautaire");
jLabel17.setBounds(220, 280, 180, 15);
jLayprefs.add(jLabel17, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTTvaIntra.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTTvaIntraActionPerformed(evt);
}
});
jTTvaIntra.setBounds(190, 300, 260, 19);
jLayprefs.add(jTTvaIntra, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel18.setText("Nom :");
jLabel18.setBounds(20, 30, 44, 15);
jLayprefs.add(jLabel18, javax.swing.JLayeredPane.DEFAULT_LAYER);
jLabel19.setText("Prénom :");
jLabel19.setBounds(20, 50, 70, 15);
jLayprefs.add(jLabel19, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTNom.setBounds(160, 30, 160, 19);
jLayprefs.add(jTNom, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTPrenom.setBounds(160, 50, 160, 19);
jLayprefs.add(jTPrenom, javax.swing.JLayeredPane.DEFAULT_LAYER);
jCombpays.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Voitre choix ?", "Afghanistan", "Afrique du Sud", "Albanie", "Algérie", "Allemagne", "Andorre", "Angola", "Anguilla", "Antarctique", "Antigua-et-Barbuda", "Antilles néerlandaises", "Arabie saoudite", "Argentine", "Arménie", "Aruba", "Australie", "Autriche", "Azerbaïdjan", "Bénin", "Bahamas", "Bahreïn", "Bangladesh", "Barbade", "Belau", "Belgique", "Belize", "Bermudes", "Bhoutan", "Biélorussie", "Birmanie", "Bolivie", "Bosnie-Herzégovine", "Botswana", "Brésil", "Brunei", "Bulgarie", "Burkina Faso", "Burundi", "Côte d", "Cambodge", "Cameroun", "Canada", "Cap-Vert", "Chili", "Chine", "Chypre", "Colombie", "Comores", "Congo", "Corée du Nord", "Corée du Sud", "Costa Rica", "Croatie", "Cuba", "Danemark", "Djibouti", "Dominique", "Égypte", "Émirats arabes unis", "Équateur", "Érythrée", "Espagne", "Estonie", "États-Unis", "Éthiopie", "Finlande", "France", "Géorgie", "Gabon", "Gambie", "Ghana", "Gibraltar", "Grèce", "Grenade", "Groenland", "Guadeloupe", "Guam", "Guatemala", "Guinée", "Guinée équatoriale", "Guinée-Bissao", "Guyana", "Guyane française", "Haïti", "Honduras", "Hong Kong", "Hongrie", "Ile Bouvet", "Ile Christmas", "Ile Norfolk", "Iles Cayman", "Iles Cook", "Iles Féroé", "Iles Falkland", "Iles Fidji", "Iles Géorgie du Sud et Sandwich du Sud", "Iles Heard et McDonald", "Iles Marshall", "Iles Pitcairn", "Iles Salomon", "Iles Svalbard et Jan Mayen", "Iles Turks-et-Caicos", "Iles Vierges américaines", "Iles Vierges britanniques", "Iles des Cocos (Keeling)", "Iles mineures éloignées des États-Unis", "Inde", "Indonésie", "Iran", "Iraq", "Irlande", "Islande", "Israël", "Italie", "Jamaïque", "Japon", "Jordanie", "Kazakhstan", "Kenya", "Kirghizistan", "Kiribati", "Koweït", "Laos", "Lesotho", "Lettonie", "Liban", "Liberia", "Libye", "Liechtenstein", "Lituanie", "Luxembourg", "Macao", "Madagascar", "Malaisie", "Malawi", "Maldives", "Mali", "Malte", "Mariannes du Nord", "Maroc", "Martinique", "Maurice", "Mauritanie", "Mayotte", "Mexique", "Micronésie", "Moldavie", "Monaco", "Mongolie", "Montserrat", "Mozambique", "Népal", "Namibie", "Nauru", "Nicaragua", "Niger", "Nigeria", "Nioué", "Norvège", "Nouvelle-Calédonie", "Nouvelle-Zélande", "Oman", "Ouganda", "Ouzbékistan", "Pérou", "Pakistan", "Panama", "Papouasie-Nouvelle-Guinée", "Paraguay", "Pays-Bas", "Philippines", "Pologne", "Polynésie française", "Porto Rico", "Portugal", "Qatar", "République centrafricaine", "République démocratique du Congo", "République dominicaine", "République tchèque", "Réunion", "Roumanie", "Royaume-Uni", "Russie", "Rwanda", "Sénégal", "Sahara occidental", "Saint-Christophe-et-Niévès", "Saint-Marin", "Saint-Pierre-et-Miquelon", "Saint-Siège ", "Saint-Vincent-et-les-Grenadines", "Sainte-Hélène", "Sainte-Lucie", "Salvador", "Samoa", "Samoa américaines", "Sao Tomé-et-Principe", "Seychelles", "Sierra Leone", "Singapour", "Slovénie", "Slovaquie", "Somalie", "Soudan", "Sri Lanka", "Suède", "Suisse", "Suriname", "Swaziland", "Syrie", "Taïwan", "Tadjikistan", "Tanzanie", "Tchad", "Terres australes françaises", "Territoire britannique de l", "Thaïlande", "Timor Oriental", "Togo", "Tokélaou", "Tonga", "Trinité-et-Tobago", "Tunisie", "Turkménistan", "Turquie", "Tuvalu", "Ukraine", "Uruguay", "Vanuatu", "Venezuela", "Viet-Nam", "Wallis-et-Futuna", "Yémen", "Yougoslavie", "Zambie", "Zimbabwe", "ex-République yougoslave de Macédoine" }));
jCombpays.setSelectedIndex(67);
jCombpays.setToolTipText("Faite votre choix ?");
jCombpays.setBounds(270, 125, 180, 18);
jLayprefs.add(jCombpays, javax.swing.JLayeredPane.DEFAULT_LAYER);
jBGauche.setText("<=");
jBGauche.setEnabled(false);
jBGauche.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBGaucheActionPerformed(evt);
}
});
jBGauche.setBounds(190, 330, 60, 25);
jLayprefs.add(jBGauche, javax.swing.JLayeredPane.DEFAULT_LAYER);
jBDroite.setText("=>");
jBDroite.setEnabled(false);
jBDroite.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBDroiteActionPerformed(evt);
}
});
jBDroite.setBounds(390, 330, 60, 25);
jLayprefs.add(jBDroite, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTModification.setText("Modification");
jTModification.setToolTipText("Valider les changements.");
jTModification.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jTModificationActionPerformed(evt);
}
});
jTModification.setBounds(250, 330, 140, 25);
jLayprefs.add(jTModification, javax.swing.JLayeredPane.DEFAULT_LAYER);
jTabPrinc.addTab("Config", jLayprefs);
ButtonFacture.setIcon(new javax.swing.ImageIcon(getClass().getResource("/efs/ui/logoEFSfacture.png"))); // NOI18N
ButtonFacture.setText("Facturier");
ButtonFacture.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ButtonFactureActionPerformed(evt);
}
});
ButtonPaie.setText("Paie");
ButtonPaie.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
ButtonPaieActionPerformed(evt);
}
});
javax.swing.GroupLayout jBoutGauLayout = new javax.swing.GroupLayout(jBoutGau);
jBoutGau.setLayout(jBoutGauLayout);
jBoutGauLayout.setHorizontalGroup(
jBoutGauLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jBoutGauLayout.createSequentialGroup()
.addGroup(jBoutGauLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(ButtonPaie, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(ButtonFacture, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 194, Short.MAX_VALUE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jBoutGauLayout.setVerticalGroup(
jBoutGauLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jBoutGauLayout.createSequentialGroup()
.addGap(28, 28, 28)
.addComponent(ButtonFacture, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(49, 49, 49)
.addComponent(ButtonPaie, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(36, Short.MAX_VALUE))
);
jToggleButton4.setText("Comptabilité");
jToggleButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jToggleButton4ActionPerformed(evt);
}
});
jToggleButton3.setText("Gestion");
jToggleButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jToggleButton3ActionPerformed(evt);
}
});
javax.swing.GroupLayout BouDroitLayout = new javax.swing.GroupLayout(BouDroit);
BouDroit.setLayout(BouDroitLayout);
BouDroitLayout.setHorizontalGroup(
BouDroitLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(BouDroitLayout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(BouDroitLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jToggleButton3, javax.swing.GroupLayout.DEFAULT_SIZE, 194, Short.MAX_VALUE)
.addComponent(jToggleButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 205, javax.swing.GroupLayout.PREFERRED_SIZE)))
);
BouDroitLayout.setVerticalGroup(
BouDroitLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(BouDroitLayout.createSequentialGroup()
.addGap(21, 21, 21)
.addComponent(jToggleButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(52, 52, 52)
.addComponent(jToggleButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(48, Short.MAX_VALUE))
);
jBQuitter.setText("Quitter");
jBQuitter.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBQuitterActionPerformed(evt);
}
});
jLabel20.setText("GNU-GPL.V2");
javax.swing.GroupLayout piedDePageLayout = new javax.swing.GroupLayout(piedDePage);
piedDePage.setLayout(piedDePageLayout);
piedDePageLayout.setHorizontalGroup(
piedDePageLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(piedDePageLayout.createSequentialGroup()
.addGap(279, 279, 279)
.addComponent(jBQuitter, javax.swing.GroupLayout.PREFERRED_SIZE, 341, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 145, Short.MAX_VALUE)
.addComponent(jLabel20)
.addGap(55, 55, 55))
);
piedDePageLayout.setVerticalGroup(
piedDePageLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(piedDePageLayout.createSequentialGroup()
.addContainerGap()
.addGroup(piedDePageLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel20)
.addComponent(jBQuitter, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jLabel2.setFont(new java.awt.Font("Verdana", 3, 24)); // NOI18N
jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel2.setText("E.F.SOLUTION");
jLabel2.setCursor(new java.awt.Cursor(java.awt.Cursor.CROSSHAIR_CURSOR));
jLabel2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
javax.swing.GroupLayout enTeteLayout = new javax.swing.GroupLayout(enTete);
enTete.setLayout(enTeteLayout);
enTeteLayout.setHorizontalGroup(
enTeteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(enTeteLayout.createSequentialGroup()
.addGap(288, 288, 288)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 348, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(292, Short.MAX_VALUE))
.addGroup(enTeteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(enTeteLayout.createSequentialGroup()
.addGap(95, 95, 95)
.addComponent(jSeparator2, javax.swing.GroupLayout.DEFAULT_SIZE, 724, Short.MAX_VALUE)
.addGap(109, 109, 109)))
);
enTeteLayout.setVerticalGroup(
enTeteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(enTeteLayout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel2)
.addContainerGap(34, Short.MAX_VALUE))
.addGroup(enTeteLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, enTeteLayout.createSequentialGroup()
.addContainerGap(49, Short.MAX_VALUE)
.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(25, 25, 25)))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
.addContainerGap()
.addComponent(piedDePage, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
.addGap(14, 14, 14)
.addComponent(jBoutGau, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTabPrinc, javax.swing.GroupLayout.PREFERRED_SIZE, 467, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(BouDroit, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
.addComponent(enTete, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(enTete, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addComponent(BouDroit, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(10, 10, 10)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jTabPrinc, javax.swing.GroupLayout.PREFERRED_SIZE, 391, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jBoutGau, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(12, 12, 12)
.addComponent(piedDePage, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void ButtonFactureActionPerformed(java.awt.event.ActionEvent evt) {
Facturier facturier = new Facturier();
}
private void ButtonPaieActionPerformed(java.awt.event.ActionEvent evt) {
Paie paie = new Paie();
}
private void jToggleButton3ActionPerformed(java.awt.event.ActionEvent evt) {
Gestion gestion = new Gestion();
}
private void jToggleButton4ActionPerformed(java.awt.event.ActionEvent evt) {
Comptabilite comptabilite = new Comptabilite(); // TODO add your handling code here:
}
private void jBQuitterActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0); }
private void jBEnvoyerActionPerformed(java.awt.event.ActionEvent evt) { //creation et execution de la requête Connection con = SourceDonnees.getConnection(); String test = jBEnvoyer.getText(); if(test.equals("Sauvegarder")){ requete = "INSERT INTO menuConf(RaisonSociale, Nom, Prenom, Adresse, AdresseSuite, Cp, Ville, Pays, TelephoneFixe, GSM, Fax, SiteWeb, Courriel, RepresentantLegal, TypeEntreprise, SiretSiren, TvaIntra)" + " VALUES ('"+jTRaisSoc.getText()+"','"+jTNom.getText()+"','"+jTPrenom.getText()+"','"+jTAdress.getText()+"','"+jTAdresseSui.getText()+"','"+jTCP.getText()+"','"+jTVille.getText()+"'," + "'"+jCombpays.getSelectedItem()+"','"+jTTel.getText()+"', '', '"+jTFax.getText()+"','"+jTWeb.getText()+"','"+jTCour.getText()+"','"+JTRlegal.getText()+"','"+jComboEntre.getSelectedItem()+"','"+jTSiret.getText()+"','"+jTTvaIntra.getText()+"')"; try { Statement stmt = con.createStatement(); //resultats = stmt.executeQuery(requete); int maj = stmt.executeUpdate(requete); System.out.println(maj); } catch (SQLException e) { System.out.println("Erreur:Anomalie lors de l'execution de la requête : "+e); // arret("Anomalie lors de l'execution de la requête"); } } else if(test.equals("Mise à jour")){ Urequete = "UPDATE menuConf(RaisonSociale, Nom, Prenom, Adresse, AdresseSuite, Cp, Ville, Pays, TelephoneFixe, GSM, Fax, SiteWeb, Courriel, RepresentantLegal, TypeEntreprise, SiretSiren, TvaIntra)" + " VALUES ('"+jTRaisSoc.getText()+"','"+jTNom.getText()+"','"+jTPrenom.getText()+"','"+jTAdress.getText()+"','"+jTAdresseSui.getText()+"','"+jTCP.getText()+"','"+jTVille.getText()+"'," + "'"+jCombpays.getSelectedItem()+"','"+jTTel.getText()+"', '', '"+jTFax.getText()+"','"+jTWeb.getText()+"','"+jTCour.getText()+"','"+JTRlegal.getText()+"','"+jComboEntre.getSelectedItem()+"','"+jTSiret.getText()+"','"+jTTvaIntra.getText()+"')"; try { Statement stmt = con.createStatement(); //resultats = stmt.executeQuery(requete); int maj = stmt.executeUpdate(Urequete); System.out.println(maj); } catch (SQLException e) { System.out.println("Erreur:Anomalie lors de l'execution de la requête : "+e); // arret("Anomalie lors de l'execution de la requête"); } System.out.println("Mise à jour effectué !"); } } private void jTModificationActionPerformed(java.awt.event.ActionEvent evt) { if (jTModification.isSelected()) { jTModification.setText("Fin modif"); System.out.println(jTModification.getAction()); // jBGauche.setEnabled(!jBGauche.isEnabled()); jBGauche.setEnabled(true); jBDroite.setEnabled(true); //jBDroite.setEnabled(!jBDroite.isEnabled()); //jBEnvoyer.setEnabled(!jBDroite.isEnabled()); jBEnvoyer.setEnabled(true); jBEnvoyer.setText("Mise à jour"); } if (!this.jTModification.isSelected()) { jTModification.setText("Modifier"); jBDroite.setEnabled(false); jBGauche.setEnabled(false); jBEnvoyer.setEnabled(true); jBEnvoyer.setText("Sauvegarder"); } } private void jBDroiteActionPerformed(java.awt.event.ActionEvent evt) { jBDroite.isVisible(); } private void jBGaucheActionPerformed(java.awt.event.ActionEvent evt) { jBDroite.isVisible(); } private void jTTvaIntraActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: } /** * @param args the command line arguments */ public static void main(String args[]) { java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new MenuPrincipal().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JPanel BouDroit; private javax.swing.JToggleButton ButtonFacture; private javax.swing.JToggleButton ButtonPaie; private javax.swing.JTextField JTRlegal; private javax.swing.JPanel enTete; private javax.swing.JButton jBDroite; private javax.swing.JButton jBEnvoyer; private javax.swing.JButton jBGauche; private javax.swing.JButton jBQuitter; private javax.swing.JPanel jBoutGau; private javax.swing.JComboBox jComboEntre; private javax.swing.JComboBox jCombpays; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel16; private javax.swing.JLabel jLabel17; private javax.swing.JLabel jLabel18; private javax.swing.JLabel jLabel19; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel20; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JLabel jLabel9; private javax.swing.JLayeredPane jLayCompta; private javax.swing.JLayeredPane jLayFac; private javax.swing.JLayeredPane jLayGest; private javax.swing.JLayeredPane jLayPaie; private javax.swing.JLayeredPane jLayeredPane1; private javax.swing.JLayeredPane jLayeredPane2; private javax.swing.JLayeredPane jLayeredPane3; private javax.swing.JLayeredPane jLayprefs; private javax.swing.JSeparator jSeparator1; private javax.swing.JSeparator jSeparator2; private javax.swing.JSeparator jSeparator3; private javax.swing.JTextField jTAdress; private javax.swing.JTextField jTAdresseSui; private javax.swing.JTextField jTCP; private javax.swing.JTextField jTCour; private javax.swing.JTextField jTFax; private javax.swing.JToggleButton jTModification; private javax.swing.JTextField jTNom; private javax.swing.JTextField jTPrenom; private javax.swing.JTextField jTRaisSoc; private javax.swing.JTextField jTSiret; private javax.swing.JTextField jTTel; private javax.swing.JTextField jTTvaIntra; private javax.swing.JTextField jTVille; private javax.swing.JTextField jTWeb; private javax.swing.JTabbedPane jTabPrinc; private javax.swing.JTabbedPane jTabbedPane1; private javax.swing.JToggleButton jToggleButton3; private javax.swing.JToggleButton jToggleButton4; private javax.swing.JPanel piedDePage; // End of variables declaration
}
