Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package exampleTabs;
- import java.awt.BorderLayout;
- import java.awt.Choice;
- import java.awt.Color;
- import java.awt.Label;
- import java.awt.TextField;
- import java.awt.event.ActionEvent;
- import java.awt.event.ActionListener;
- import java.awt.event.ItemEvent;
- import java.awt.event.ItemListener;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import javax.swing.JButton;
- import javax.swing.JFrame;
- import javax.swing.JPanel;
- import miniproject_CallDB.Connectie;
- public class PanelTab2 extends JFrame implements ItemListener, ActionListener {
- //PanelTab2 bevat oefening 10
- public PanelTab2(){}
- private JPanel middenPaneel, bovenPaneel;
- private Choice chc_select;
- private Label lbl_studentA, lbl_lastName, lbl_firstName, lbl_geb, lbl_stageCode, lbl_persoon, lbl_record;
- private TextField txtF_studentT, txtF_lastT, txtF_firstT, txtF_gebT, txtF_stageT;
- private JButton btn_Update;
- private Color bovenC = new Color(204, 251, 93);
- private Color middenC = new Color(135, 247, 23);
- private Color tekstM = new Color(0, 0, 255);
- private Color tekstVak = new Color(128, 128, 128);
- Object[][] data;
- private String studentS, lastS, firstS, gebS, stageS;
- public void maakGui(){
- //Opmaak van de GUI
- //nieuwe connectie openen
- Connectie myDB = new Connectie("opgavek", "studenten");
- //controleren op connectie
- if ( myDB.maakConnectie() ){
- System.out.println("Connectie met de database gelukt");
- }
- data = myDB.haalGegevensOp();
- //BOVEN Paneel
- bovenPaneel = new JPanel();
- bovenPaneel.setBackground(bovenC);
- lbl_persoon = new Label("zoek student");
- chc_select = new Choice();
- chc_select.addItemListener(this);
- int teller = myDB.haalGegevensOp().length;
- for (int i = 0; i < teller; i++) {
- chc_select.add(Integer.toString(i + 1));
- }
- bovenPaneel.add(lbl_persoon);
- bovenPaneel.add(chc_select);
- add(bovenPaneel, BorderLayout.NORTH);
- //MIDDEN Paneel
- middenPaneel = new JPanel();
- middenPaneel.setBackground(middenC);
- lbl_studentA = new Label("Student Nummer");
- lbl_lastName = new Label("Last Name");
- lbl_firstName = new Label("First Name");
- lbl_geb = new Label("Geboorte Datum");
- lbl_stageCode = new Label("Stage Code");
- lbl_record = new Label("opgehaalde record");
- txtF_studentT = new TextField(data[chc_select.getSelectedIndex()][0].toString());
- txtF_lastT = new TextField(data[chc_select.getSelectedIndex()][1].toString());
- txtF_firstT = new TextField(data[chc_select.getSelectedIndex()][2].toString());
- txtF_gebT = new TextField(data[chc_select.getSelectedIndex()][3].toString());
- txtF_stageT = new TextField(data[chc_select.getSelectedIndex()][4].toString());
- middenPaneel.add(lbl_studentA);
- middenPaneel.add(lbl_lastName);
- middenPaneel.add(lbl_firstName);
- middenPaneel.add(lbl_geb);
- middenPaneel.add(lbl_stageCode);
- middenPaneel.add(txtF_studentT);
- middenPaneel.add(txtF_lastT);
- middenPaneel.add(txtF_firstT);
- middenPaneel.add(txtF_gebT);
- middenPaneel.add(txtF_stageT);
- middenPaneel.add(lbl_record);
- add(middenPaneel, BorderLayout.CENTER);
- // Layout midden paneel
- middenPaneel.setLayout(null);
- lbl_studentA.setBounds(80, 50, 100, 20);
- lbl_lastName.setBounds(80, 90, 100, 20);
- lbl_firstName.setBounds(80, 130, 100, 20);
- lbl_geb.setBounds(80, 170, 100, 20);
- lbl_stageCode.setBounds(80, 210, 100, 20);
- lbl_record.setBounds(5, 3, 300, 20);
- txtF_studentT.setBounds(500, 50, 200, 20);
- txtF_lastT.setBounds(500, 90, 200, 20);
- txtF_firstT.setBounds(500, 130, 200, 20);
- txtF_gebT.setBounds(500, 170, 200, 20);
- txtF_stageT.setBounds(500, 210, 200, 20);
- lbl_studentA.setForeground(tekstM);
- lbl_lastName.setForeground(tekstM);
- lbl_firstName.setForeground(tekstM);
- lbl_geb.setForeground(tekstM);
- lbl_stageCode.setForeground(tekstM);
- txtF_studentT.setForeground(tekstM);
- txtF_lastT.setForeground(tekstM);
- txtF_firstT.setForeground(tekstM);
- txtF_gebT.setForeground(tekstM);
- txtF_stageT.setForeground(tekstM);
- txtF_studentT.setBackground(tekstVak);
- //ONDER Paneel
- btn_Update = new JButton("Update");
- btn_Update.addActionListener(this);
- add(btn_Update, BorderLayout.SOUTH);
- setSize(800, 350);
- setLocation(100, 100);
- setVisible(true);
- myDB.sluitConnectie();
- }
- public void updateGeg(){
- //Gegevens aanpassen
- //String uit TextField halen
- studentS = txtF_studentT.getText();
- lastS = txtF_lastT.getText();
- firstS = txtF_firstT.getText();
- gebS = txtF_gebT.getText();
- stageS = txtF_stageT.getText();
- try{
- // Eigen connectie omdat met de Connectie klasse geen statement kan worden uitgevoerd
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost/opgavek","root","");
- try{
- Statement st = con.createStatement();
- st.executeUpdate("UPDATE studenten set StudentNaam = '" + lastS + "', StudentVoorNaam = '" + firstS + "', StudentGebDatum = '" + gebS + "', StageCode = '" + stageS + "' WHERE StudentNummer = " + studentS);
- System.out.println("Gegevens aangepast");
- con.close();
- }
- catch (SQLException s){
- System.out.println("SQL statement is niet uitgevoerd");
- }
- }
- catch (Exception e){
- e.printStackTrace();
- }
- data[chc_select.getSelectedIndex()][1] = lastS;
- data[chc_select.getSelectedIndex()][2] = firstS;
- data[chc_select.getSelectedIndex()][3] = gebS;
- data[chc_select.getSelectedIndex()][4] = stageS;
- }
- public static void main(String[] args) {
- //Main programma
- PanelTab2 start = new PanelTab2();
- start.maakGui();
- }
- @Override
- public void actionPerformed(ActionEvent e) {
- //Wordt er op de button geklikt?
- if (e.getSource() == btn_Update){
- updateGeg();
- }
- }
- @Override
- public void itemStateChanged(ItemEvent e) {
- //Switchen tussen studenten in de choice
- if (e.getSource() == chc_select)
- {
- int nummer = chc_select.getSelectedIndex();
- txtF_studentT.setText(data[nummer][0].toString());
- txtF_lastT.setText(data[nummer][1].toString());
- txtF_firstT.setText(data[nummer][2].toString());
- txtF_gebT.setText(data[nummer][3].toString());
- txtF_stageT.setText(data[nummer][4].toString());
- }
- }
- }
Add Comment
Please, Sign In to add comment