public void editShift(Shift s) throws SQLException{
        Connection con = null;
        int id = 0;
        int typeId = 0;
        
        try{
            con = getConnection();
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT id FROM role WHERE role = '" + s.getRolle() + "'");
            while(rs.next()){
                id = rs.getInt("id");
            }
            
            ResultSet rs2 = stmt.executeQuery("SELECT id FROM type_arbejde WHERE type = '" + s.getType() + "'");
            while(rs2.next()){
                typeId = rs2.getInt("id");
            }
            
            stmt.executeUpdate("UPDATE midlertidig_løn "
                    + "JOIN role ON midlertidig_løn.role = role.id "
                    + "JOIN type_arbejde ON midlertidig_løn.type_arbejde = type_arbejde.id"
                    + "SET brandmand = '" + s.getCpr() + "', role = " + id + ", type_arbejde = " + typeId + ", ferie_dag = " + s.getFerie() + ", timer = " + s.getTimer() + " " 
                    + "WHERE tid_logind = '" + s.getLogind() + "' AND tid_logud = '" + s.getLogud()+ "'");
        } finally{
            if(con!=null) con.close();
        }
    }