Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class TabortLarareFranSystemet extends javax.swing.JFrame {
- private InfDB db;
- public TabortLarareFranSystemet(InfDB idb) {
- initComponents();
- db = idb;
- }
- private void lararInfo() {
- String lararNamnId = "SELECT LARAR_ID, FORNAMN FROM LARARE";
- try {
- ArrayList<HashMap<String, String>> lararLista = db.fetchRows(lararNamnId);
- for(int i = 0; i < lararLista.size(); i++){
- infoOmAnvandare.addItem(lararLista.get(i).get("LARAR_ID") + " " + lararLista.get(i).get("FORNAMN"));
- }
- } catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- public void kursInfo() {
- String kursNamnId = "SELECT KURS_ID, KURSNAMN FROM KURS";
- try {
- ArrayList<HashMap<String, String>> kursLista = db.fetchRows(kursNamnId);
- for(int i = 0; i < kursLista.size(); i++) {
- infoOmAnvandare.addItem(kursLista.get(i).get("KURS_ID") + " " + kursLista.get(i).get("KURSNAMN"));
- }
- } catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- public void elevInfo() {
- String elevNamnId = "SELECT ELEV_ID, FORNAMN FROM ELEV";
- try {
- ArrayList<HashMap<String, String>> elevLista = db.fetchRows(elevNamnId);
- for(int i = 0; i < elevLista.size(); i++) {
- infoOmAnvandare.addItem(elevLista.get(i).get("ELEV_ID") + " " + elevLista.get(i).get("FORNAMN"));
- }
- } catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- buttonDelete = new javax.swing.JButton();
- valjAnvandare = new javax.swing.JComboBox<>();
- infoOmAnvandare = new javax.swing.JComboBox<>();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- buttonDelete.setText("Ta bort");
- buttonDelete.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- buttonDeleteActionPerformed(evt);
- }
- });
- valjAnvandare.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Välj", "Larare", "Elev", "Kurs" }));
- valjAnvandare.addItemListener(new java.awt.event.ItemListener() {
- public void itemStateChanged(java.awt.event.ItemEvent evt) {
- valjAnvandareItemStateChanged(evt);
- }
- });
- infoOmAnvandare.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Välj användare" }));
- 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.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGap(135, 135, 135)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(valjAnvandare, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(infoOmAnvandare, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
- .addGroup(layout.createSequentialGroup()
- .addGap(146, 146, 146)
- .addComponent(buttonDelete)))
- .addContainerGap(129, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
- .addGap(27, 27, 27)
- .addComponent(valjAnvandare, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 24, Short.MAX_VALUE)
- .addComponent(infoOmAnvandare, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(53, 53, 53)
- .addComponent(buttonDelete)
- .addGap(115, 115, 115))
- );
- pack();
- }// </editor-fold>
- private void buttonDeleteActionPerformed(java.awt.event.ActionEvent evt) {
- String option = valjAnvandare.getSelectedItem().toString();
- String secondOption = infoOmAnvandare.getSelectedItem().toString();
- String[] splittedName = secondOption.split(" ");
- String partOne = splittedName[0];
- String partTwo = splittedName[1];
- int userID = Integer.parseInt(partOne);
- if(option.equals("Larare")) {
- try{
- String sql = "SELECT LARAR_ID FROM LARARE WHERE LARAR_ID = " + userID;
- String id = db.fetchSingle(sql);
- ArrayList<String> forestandsLista = db.fetchColumn("SELECT FORESTANDARE FROM ELEVHEM");
- for (String enForestandare : forestandsLista) {
- if (enForestandare != null) {
- if (enForestandare.equals(id)) {
- db.update("UPDATE ELEVHEM SET FORESTANDARE = NULL WHERE FORESTANDARE = " + id);
- }
- }
- }
- ArrayList<String> kurslararLista = db.fetchColumn("SELECT KURSLARARE FROM KURS");
- for(String enKurslarare : kurslararLista) {
- if(enKurslarare !=null) {
- if(enKurslarare.equals(id)){
- db.update("UPDATE KURS SET KURSLARARE = NULL WHERE KURSLARARE = " + id);
- }
- }
- }
- ArrayList<String> lararListan = db.fetchColumn("SELECT LARAR_ID FROM LARARE");
- for(String enLarare : lararListan) {
- if(enLarare != null) {
- if(enLarare.equals(id)) {
- db.delete("DELETE FROM HAR_KOMPETENS_I WHERE LARAR_ID =" + id);
- db.delete("DELETE FROM LARARE WHERE LARAR_ID =" + id);
- JOptionPane.showMessageDialog(null, "Deleted");
- }
- }
- }
- } catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- if(option.equals("Elev")) {
- try{
- String sqlForElev = "SELECT ELEV_ID FROM ELEV WHERE ELEV_ID = " + userID;
- String idForElev = db.fetchSingle(sqlForElev);
- ArrayList<String> perfektLista = db.fetchColumn("SELECT PREFEKT FROM ELEVHEM");
- for (String enPerfekt : perfektLista) {
- if (enPerfekt != null) {
- if (enPerfekt.equals(idForElev)) {
- db.update("UPDATE ELEVHEM SET PREFEKT = NULL WHERE PREFEKT = " + idForElev);
- }
- }
- }
- ArrayList<String> elevBetygLista = db.fetchColumn("SELECT ELEV_ID FROM HAR_BETYG_I");
- for(String enElevBetyg : elevBetygLista) {
- if(enElevBetyg !=null) {
- if(enElevBetyg.equals(idForElev)){
- db.delete("DELETE FROM HAR_BETYG_I WHERE ELEV_ID = " + idForElev);
- }
- }
- }
- ArrayList<String> elevListan = db.fetchColumn("SELECT ELEV_ID FROM ELEV");
- for(String enElev : elevListan) {
- if(enElev != null) {
- if(enElev.equals(idForElev)) {
- db.delete("DELETE FROM REGISTRERAD_PA WHERE ELEV_ID =" + idForElev);
- db.delete("DELETE FROM ELEV WHERE ELEV_ID =" + idForElev);
- JOptionPane.showMessageDialog(null, "Deleted");
- }
- }
- }
- }catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- if(option.equals("Kurs")) {
- try{
- String sqlForKurs = "SELECT KURS_ID FROM KURS WHERE KURS_ID = " + userID;
- String idForKurs = db.fetchSingle(sqlForKurs);
- ArrayList<String> elevHarBetygLista = db.fetchColumn("SELECT KURS_ID FROM HAR_BETYG_I");
- for(String enBetyg : elevHarBetygLista) {
- if(enBetyg !=null) {
- if(enBetyg.equals(idForKurs)){
- db.delete("DELETE FROM HAR_BETYG_I WHERE KURS_ID = " + idForKurs);
- }
- }
- }
- ArrayList<String> kursListan = db.fetchColumn("SELECT KURS_ID FROM KURS");
- for(String enKurs : kursListan) {
- if(enKurs != null) {
- if(enKurs.equals(idForKurs)) {
- db.delete("DELETE FROM REGISTRERAD_PA WHERE KURS_ID =" + idForKurs);
- db.delete("DELETE FROM KURS WHERE KURS_ID =" + idForKurs);
- JOptionPane.showMessageDialog(null, "Deleted");
- }
- }
- }
- } catch (InfException ex) {
- Logger.getLogger(TabortLarareFranSystemet.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- }
- private void valjAnvandareItemStateChanged(java.awt.event.ItemEvent evt) {
- infoOmAnvandare.removeAllItems();
- if(valjAnvandare.getSelectedItem().equals("Larare")){
- lararInfo();
- }
- if(valjAnvandare.getSelectedItem().equals("Elev")) {
- elevInfo();
- }
- if(valjAnvandare.getSelectedItem().equals("Kurs")) {
- kursInfo();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement