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");
}
}
}
} |
