1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142
| package projet;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import com.mysql.jdbc.PreparedStatement;
import java.sql.*;
public class Nouvproj extends JFrame implements ActionListener {
// private JPanel panlabel = new JPanel();
// private JPanel panbouton = new JPanel();
private JPanel panbas = new JPanel();
private JPanel pan = new JPanel();
private JPanel panhaut = new JPanel();
private JPanel panest = new JPanel();
private JPanel panouest = new JPanel();
private JFrame fenetre = new JFrame();
//Tableau stockant les éléments à afficher dans la calculatrice
//Un bouton par élément à afficher
//JButton jbnp = new JButton("Créer un projet"); //bouton nouveau projet
//JButton jbcp = new JButton("Projet en cours"); //bouton projet en cours
//JButton jbct = new JButton("Tâche en cours"); //bouton tâche en cours
JLabel jl1 = new JLabel("Nom");
JLabel jl0 = new JLabel("Bienvenuev ...");
JLabel jl24 = new JLabel("Bienvenuev ...");
JLabel jl21 = new JLabel("");
JLabel jl22 = new JLabel("");
JTextField jtnom = new JTextField();
JLabel jl2 = new JLabel("Date Début");
JTextField jtdatedeb = new JTextField();
JLabel jl3 = new JLabel("Date Fin");
JTextField jtdatefin = new JTextField();
JLabel jl4 = new JLabel("Budget");
JTextField jtbudget = new JTextField();
JLabel jl5 = new JLabel("Client");
JTextField jtdetail = new JTextField();
//JLabel jl6 = new JLabel("Durée");
//JTextField jtduree = new JTextField();
JButton jb1 = new JButton();
JButton jbnp = new JButton("Créer un projet");
//private JLabel ecran = new JLabel();
// private Container c =getContentPane();
public Nouvproj(){
setSize(240, 260);
// fenetre.add(panbas);
fenetre.setTitle("Menu");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setLocationRelativeTo(null);
setResizable(true);
//jl1.setPreferredSize(new Dimension(1, 2));
panbas.setLayout(new GridLayout(7,2));
// panhaut.setLayout(new GridLayout(1,1));
panbas.add(jl1);
panbas.add(jtnom);
panbas.add(jl2);
panbas.add(jtdatedeb);
panbas.add(jl3);
panbas.add(jtdatefin);
panbas.add(jl4);
panbas.add(jtbudget);
panbas.add(jl5);
panbas.add(jtdetail);
//panbas.add(jl6);
//panbas.add(jt6);
panhaut.add(jl0);
pan.add(jl24);
panest.add(jl21);
panouest.add(jl22);
panbas.add(jb1);
jb1.addActionListener(this);
jl0.setPreferredSize(new Dimension(100, 100));
jl2.setPreferredSize(new Dimension(100, 100));
jl21.setPreferredSize(new Dimension(500, 500));
jl22.setPreferredSize(new Dimension(500, 500));
//jt5.setPreferredSize(new Dimension(100, 100));
//c.add(BorderLayout.NORTH, panhaut);
//c.add(BorderLayout.CENTER, panbas);
fenetre.getContentPane().add(panbas, BorderLayout.CENTER);
fenetre.getContentPane().add(panest, BorderLayout.EAST);
fenetre.getContentPane().add(panouest, BorderLayout.WEST);
fenetre.getContentPane().add(panhaut, BorderLayout.NORTH);
fenetre.getContentPane().add(pan, BorderLayout.SOUTH);
fenetre.setVisible(true);
}
@Override
public void actionPerformed(ActionEvent event) {
if(event.getSource() == jb1){
try
{
Connection c = Conn.Conng();
try
{
Statement st = c.createStatement();
String sqlInsert = "INSERT INTO `dm`.`projet` (`noprojet`, `nomprojet`, `datedebut`, `datefin`, `budgetprevisonnel`,`detail`,`nosecurite`,`nosiret`,`parent`) VALUES (NULL,'"+jtnom.getText()+"','"+jtdatedeb.getText()+"','"+jtdatefin.getText()+"','"+jtbudget.getText()+"',NULL, NULL, NULL)";
System.out.println(sqlInsert);
int val = st.executeUpdate(sqlInsert);
st.close();
c.close();
}
catch(SQLException s){
System.out.println("SQL statement is not executed !");
}
}catch(Exception e){
e.printStackTrace();
System.out.println("Error on Bulding Data");
}
}
}
} |
Partager