Bryan Romero's questions

I have this graphical interface:

Where the label "Weight: 70 kg" shows the weight that has been selected in the slider below the label by the user.

Is there a way so that when you activate the switch, the label that shows the weight changes from kg to lbs and vice versa?

• Active switch shows weight in pounds.
• Inactive switch shows weight in kilos.

Example in the image is "Weight: 70kg" once the switch is activated "Weight: 155 lbs" will be displayed .

    <Label  x:Name="Imperial_System_Label"
                    Grid.Row="3"
                    Grid.ColumnSpan="3"
                    Text="Imperial System" 
                    TextColor="Black"
                    FontSize="22"
                    HorizontalOptions="Center"/>

            <Switch x:Name="Switch"
                    Grid.Row="4"
                    Grid.ColumnSpan="3"
                    HorizontalOptions="Center"
                    Toggled="Handle_Toggled"/>

            <Label x:Name="Height_Label"
                   Grid.Row="5" 
                   Grid.ColumnSpan="3"
                   BindingContext="{x:Reference Height_Slider}"
                   Text="{Binding Value, StringFormat='Height: {0:F0} cm'}" 
                   TextColor="Black"
                   FontSize="22"
                   HorizontalOptions="Center"/>

            <Slider Grid.Row="6" 
                    Grid.ColumnSpan="3"
                    x:Name="Height_Slider" 
                    Maximum="240" 
                    Minimum="135" 
                    Value="170"/>

            <Label x:Name="Weight_Label"
                   Grid.Row="7" 
                   Grid.ColumnSpan="3"
                   BindingContext="{x:Reference Weight_Slider}"
                   Text="{Binding Value, StringFormat='Weight: {0:F0} kg'}" 
                   TextColor="Black"
                   FontSize="22"
                   HorizontalOptions="Center"
                   VerticalOptions="Center"/>

            <Slider Grid.Row="8" 
                    Grid.ColumnSpan="3"
                    x:Name="Weight_Slider" 
                    Maximum="400" 
                    Minimum="35" 
                    Value="70"/>

The label has a binding Text="{Binding Value, StringFormat='Weight: {0:F0} kg'}" , is there any way to change it when the switch is activated?

 namespace FitnessCalculatorApp
{
    [XamlCompilation(XamlCompilationOptions.Compile)]
    public partial class BMICalculatorPage : ContentPage
    {
        public BMICalculatorPage()
        {
            InitializeComponent();
        }
        void Handle_Toggled(object sender, Xamarin.Forms.ToggledEventArgs e)
        {
            String WeightLabelText = Weight_Label.Text;

            if (e.Value.Equals(false))
            {
                Weight_Slider.Maximum = 900;
                Weight_Slider.Minimum = 75;
                Weight_Slider.Value = 65;
                Weight_Label.Text = "Weight: " + Weight_Slider.Value + " lbs";
            }       

        } 
    }
}

UPDATE:

Try to create a viewmodel:

namespace FitnessCalculatorApp.Models
{
    class BMICalculatorPageViewModel : INotifyPropertyChanged
    {
        string weight = string.Empty;

        public string Weight
        {
            get => weight;
            set
            {
                if (weight == value)
                {
                    return;
                }

                onActivateSwitch(nameof(weight));
            }
        }


        public event PropertyChangedEventHandler PropertyChanged;

        void onActivateSwitch(string weight)
        {
            weight = "new weight";
            PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(weight));
        }
    }
}

And modify the binding of the weight tag:

  <Label x:Name="Weight_Label"
         Text="{Binding Weight}"/>

But I can't change the label text to "new weight" when activating the switch.

I have this table:

+----+------------+-----------+
| ID | VALID_FROM | VALID_TO  |
+----+------------+-----------+
| A  | 28-JUN-19  | 28-JUN-19 |
+----+------------+-----------+
| A  | 28-JUN-19  | 29-JUN-19 | //penultimo de A
+----+------------+-----------+
| A  | 28-JUN-19  | 30-JUN-19 | //ultimo de A
+----+------------+-----------+
| B  | 28-JUN-19  | 30-JUN-19 | // lo ignoramos
+----+------------+-----------+
| C  | 27-JUN-19  | 28-JUN-19 |
+----+------------+-----------+
| C  | 28-JUN-19  | 28-JUN-19 |
+----+------------+-----------+
| C  | 28-JUN-19  | 29-JUN-19 |
+----+------------+-----------+
| C  | 29-JUN-19  | 30-JUN-19 | //penultimo de C
+----+------------+-----------+
| C  | 29-JUN-19  | 01-JUL-19 | //ultimo de C
+----+------------+-----------+

I need a query that for each present group A,B,Creturns me the records in which the VALID_FROMlast element of a group is GREATER VALID_TOthan the penultimate element of that same group`.

If a group has only one row then the comparison is not made (AS IN THE CASE OF B).

The query I created is this:

SELECT *
FROM
    myTabla g1
INNER JOIN
    myTabla g2 ON g2.valid_from > g1.valid_to 
WHERE
    g1.ID = g2.ID;

I don't know if the logic is correct, and I don't know how to make the comparison only between the last and penultimate of each group.

I'm trying to create a query to interrogate this table:

|---------------------|------------------|
|      Column1        |     Column2      |
|---------------------|------------------|
|          A          |        1         |
|---------------------|------------------|
|---------------------|------------------|
|          A          |        1         |
|---------------------|------------------|
|---------------------|------------------|
|          B          |        2         |
|---------------------|------------------|
|---------------------|------------------|
|          B          |        3         |
|---------------------|------------------|
|---------------------|------------------|
|          B          |        2         |
|---------------------|------------------|
|---------------------|------------------|
|          A          |        1         |
|---------------------|------------------|

The query in question has to return all the queries letrasthat column1contain a number with a different value:

in this case it has to regresarme la B, ya que esta tiene como valor 3, si B tuviera solo 2sas numbers it would not have to return anything. The A does not return since it has only 1S as numbers, that is, they are all the same.

This is what I've done so far:

SELECT distinct (column1)
FROM (SELECT b.numero_contratto FROM table b) column1
WHERE column1.periodo_date = to_date('2019-04-01', 'yyyy-mm-dd');

In my Java project with Eclipse, I have noticed that next to the icon of each class there is an icon in the shape of a cylinder? I would like to know what is the meaning of this icon:

I have this simple method:

public void setComboBoxItems(List<User> users, List<Client> clients) {
    for (User user : users) {
        usersIds.addItem(user.getId());
    }

    for (Client client : clients) {
        clientsIds.addItem(client.getId());
    }
}

What it does is add items to 2 JComboBox , the items added are the IDs of the Users and Clients contained in the 2 lists named users-clients .

Is there a way to simplify this method, perhaps by calling users.forEach()?

I have several JOptionPanes that display messages, example:

JOptionPane.showMessageDialog(loginFrame, "          Login Successful");

When I write the message like in the example, I have to put a space before Login Successful so that it looks aligned in the middle of the dialog if I don't the message looks like this:

And I don't like it aesthetically.

Is there a way to align the text/message without having to do it manually with whitespace?

EDIT:

Try this:

JOptionPane.showMessageDialog(loginFrame, new JLabel("Login Successful", JLabel.CENTER));

And it doesn't work, the result:

I'm relatively new to Java, I'm making a desktop application with swing based on the MVC pattern, and I need advice on how to improve the view controller.

The application will perform the CRUD of the User entity .

The UserView looks like this:

The buttons: Search... , Edit... , Add... will open dialogs that allow you to perform the operations in question. (Ignore the free space as I will put other components there in the future).

And the Navigation buttons: First,Previous,Next,Last will allow browsing through the User records present in the database.

Example: when clicking on next the labels of the view will make a setText with the data of the next user present in a list and so on.

This is the UserViewController class :

public class UserViewController {

    private UserView userView;

    private final UserService userService;
    private List<User> users;

    private int index = 0;

    public UserViewController(UserView userView) {
        this.userView = userView;
        this.userService = new UserService();
        users = userService.getAllUsers();
        addListeners();
        initUserView();
    }

    protected void initUserView() {
        initUserInUserView(getUserFromList(index));
    }

    public void addListeners() {
        userView.addButtonsListener(new CrudButtonsListener());
        userView.addNavigationListener(new NavigationButtonsListener());
        userView.addCancelListener(new DialogsCancelButtonsListener());
        userView.addAddUserOkListener(new DialgosSubmitButtonsListener(0));
        userView.addEditUserOkListener(new DialgosSubmitButtonsListener(1));
    }

    private class CrudButtonsListener implements ActionListener {
        @Override
        public void actionPerformed(ActionEvent e) {

            switch (e.getActionCommand()) {

            case "Clients":
                userView.getUserClients().show();
                break;

            case "Search...":
                userView.getSearchUser().show();
                break;

            case "Edit...":
                userView.getEditUser().setInputFieldData(getUserFromList(index));
                userView.getEditUser().show();
                break;

            case "Add...":
                userView.getAddUser().show();
                break;

            case "Delete":
                int userId = userView.getUserId();
                int option = JOptionPane.showConfirmDialog(userView.getMainPanel(), "Do you want to delete this User?",
                        "Delete Warning", JOptionPane.YES_NO_OPTION);

                deleteUser(userId, option);
                break;
            }
        }
    }

    private class NavigationButtonsListener implements ActionListener {

        @Override
        public void actionPerformed(ActionEvent e) {

            switch (e.getActionCommand()) {

            case "First":
                index = 0;
                initUserInUserView(getUserFromList(index));
                break;

            case "Previous":
                index--;
                if (index < 0) {
                    index = 0;
                    JOptionPane.showMessageDialog(userView.getMainPanel(), "You have reached the beginning");
                    return;
                }
                initUserInUserView(getUserFromList(index));
                break;

            case "Next":
                index++;
                if (index >= users.size()) {
                    index = users.size() - 1;
                    JOptionPane.showMessageDialog(userView.getMainPanel(), "The are not more records to show");
                    return;
                }
                initUserInUserView(getUserFromList(index));
                break;

            case "Last":
                index = users.size() - 1;
                initUserInUserView(getUserFromList(index));
                break;
            }
        }
    }

    private class DialgosSubmitButtonsListener implements ActionListener {

        private final int actionListenerNum;

        public DialgosSubmitButtonsListener(int actionListenerNum) {
            this.actionListenerNum = actionListenerNum;
        }

        @Override
        public void actionPerformed(ActionEvent e) {

            switch (actionListenerNum) {
            case 0:
                if (userView.getAddUser().isEmptyFixedAttributes()) {
                    JOptionPane.showMessageDialog(userView.getAddUser().getDialog(), "       Some Data is Empty");
                } else {
                    User user = userView.getAddUser().getNewUser();
                    user.setPassword("123");
                    createNewUser(user);
                }
                break;

            case 1:
                if (userView.getEditUser().isEmptyFixedAttributes()) {
                    JOptionPane.showMessageDialog(userView.getEditUser().getDialog(),
                            "Fixed attributes can't be empty");
                } else {
                    User newUser = userView.getEditUser().getNewUser();
                    User oldUser = userView.getUser();
                    updateUser(oldUser, newUser);
                }
                break;
            }
        }
    }

    private class DialogsCancelButtonsListener implements ActionListener {

        @Override
        public void actionPerformed(ActionEvent e) {
            userView.getAddUser().dispose();
            userView.getEditUser().dispose();
            userView.getSearchUser().dispose();
            userView.getUserClients().dispose();
        }
    }

    private void initUserInUserView(User user) {
        userView.setFieldData(user);
        userView.setUser(user);
    }

    private void createNewUser(User newUser) {
        userService.createUser(newUser);
        users.add(newUser);
        JOptionPane.showMessageDialog(userView.getAddUser().getDialog(),
                "User *** " + newUser.getId() + " *** created with success");
        userView.getAddUser().clear();
    }

    private void updateUser(User oldUser, User newUser) {
        newUser.setPassword(oldUser.getPassword());
        userService.updateUser(newUser, oldUser.getId());
        updateUserFromList();
        JOptionPane.showMessageDialog(userView.getEditUser().getDialog(),
                "User *** " + oldUser.getId() + " *** updated successfully");
    }

    private void deleteUser(int userId, int option) {
        if (option == 0) {
            userService.deleteUser(userId);
            deleteUserFromList(userId);
            JOptionPane.showMessageDialog(userView.getMainPanel(), "User *** " + userId + " *** deleted with success");
        }
    }

    private User getUserFromList(int index) {
        return users.get(index);
    }

    private void updateUserFromList() {
        users.clear();
        users = userService.getAllUsers();
    }

    private void deleteUserFromList(int userId) {
        Iterator<User> iter = users.iterator();
        while (iter.hasNext()) {
            User user = iter.next();
            if (user.getId() == userId) {
                iter.remove();
            }
        }
    }
}

The UserService class is in charge of performing the CRUD operations and obtaining the necessary data from the database.

• CrudButtonsListener() takes care of opening the dialogs.
• NavigationButtonsListener() allows you to view and navigate through all the user records present by iterating through the users list that contains those records. I would like to improve the number of lines of code, should I separate the last methods of the class and put them in another class called utils?
• DialogsSubmitButtonsListener() Dialogs contain buttons to submit and perform crud.
• DialogsCancelButtonsListener() each dialog has a cancel/quit button, this class is in charge of closing the dialogs when these buttons are clicked.

Should I separate the methods at the end of the class and put them in another class "ControllersUtils" ?

Tips to improve this controller.

I am new to database projection.

I have 3 tables:

users:

+--------+--------+---------+----------+--------+
| userid |  name  | surname | password | admin  |
+--------+--------+---------+----------+--------+
| value1 | value2 | value3  | value4   | value5 |
+--------+--------+---------+----------+--------+

users_attributes:

+--------+--------+--------+
|   id   |  name  |  type  |  
+--------+--------+--------+
| value1 | value2 | value3 |  
+--------+--------+--------+

users_attributes_values(with foreign key userid and attributeid):

+--------+-------------+----------------+
| userid | attributeid | attributevalue |
+--------+-------------+----------------+
| value1 | value2      | value3         |
+--------+-------------+----------------+

The relationship of the users with the attributes is one to many , example: If there are 5 users, and I create 3 attributes:

1. Age :20 with type integer
2. Date of birth : 12/23/1992 with date type
3. Religion : Muslim with string type

so each of the 5 will have these 3 attributes.

When a new attribute is inserted in the users_attributes table , I want the references to that attribute to be automatically inserted in the users_attributes_values ​​table for each user present. I create/Insert 2 attributes:

INSERT INTO users_attributes(
            id, name, type)
    VALUES ('1', 'Peso', 'Int');

INSERT INTO users_attributes(
            id, name, type)
    VALUES ('2', 'Estatura', 'Int');

When inserting them, the trigger will insert in users_attributes_value the id of the users present and the id of the attributes just created, Example, there are 3 users present:

+--------+-------------+----------------+
| userid | attributeid | attributevalue |
+--------+-------------+----------------+
|      1 |           1 |                |
|      1 |           2 |                |
|      2 |           1 |                |
|      2 |           2 |                |
|      3 |           1 |                |
|      3 |           2 |                |
|        |             |                |
+--------+-------------+----------------+

This is the expected result after creating new attributes, how could I get this result using triggers ?

This question arose when creating multiple classes and having to create the same array several times in these classes:

private final static String[] types = { String.class.getSimpleName(), Integer.class.getSimpleName(),
            Date.class.getSimpleName(), Boolean.class.getSimpleName() };

This Array contains the values: "String", "Int", "Date", "Boolean" , the purpose of the array is to contain the items of a JComboBox that will be used in these 2 classes:

Class 1:

public class Clase1 extends JPanel {

private final static String[] types = { String.class.getSimpleName(), Integer.class.getSimpleName(),
                Date.class.getSimpleName(), Boolean.class.getSimpleName() };

JComboBox box = new JComboBox(types);
//codigo
}

Class2:

 public class Clase2 extends JPanel {

        private final static String[] types = { String.class.getSimpleName(), Integer.class.getSimpleName(),
                        Date.class.getSimpleName(), Boolean.class.getSimpleName() };

        JComboBox box = new JComboBox(types);
        //codigo
        }

How can I avoid creating/recreating this object in multiple classes, are there any Best Practices for this?

I am creating a method to obtain the records of clients that have a certain userid , the client table contains the columns: clientid,name,userid also the Client class contains the 3 parameters clientid,name,userid .

But the query that I created to obtain said data seems to have some error and I don't know what it is.

The method:

@SuppressWarnings({ "unchecked", "rawtypes" })
    public Set getClientsByUserID(String userid) {
        Set clients = new HashSet();
        try {
            String queryString = "SELECT * FROM clients WHERE=?";
            connection = getConnection();
            ptmt = connection.prepareStatement(queryString);
            ptmt.setString(1, userid);
            resultSet = ptmt.executeQuery();
            while (resultSet.next()) {
                Client client = extractClientFromResultSet(resultSet);
                clients.add(client);
            }
            return clients;
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (resultSet != null)
                    resultSet.close();
                if (ptmt != null)
                    ptmt.close();
                if (connection != null)
                    connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return null;
    }

The error I get:

org.postgresql.util.PSQLException: ERRORE: errore di sintassi a o presso "="
  Posizione: 28
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
    at db.dao.ClientDAO.getClientsByUserID(ClientDAO.java:48)

I am creating a method to extract values ​​from a Client Set , the values ​​in question are the IDs of all clients present in the Set, the ID is obtained by calling getClientID() .

My method:

public String[] extractIDsFromClientSet(Set<Client> clients) {
    Client[] arrayClients = (Client[]) clients.toArray();
    String[] clientIDs = new String[clients.size()];

    for (int i = 0; i < arrayClients.length; i++) {
        clientIDs[i] = arrayClients[i].getClientID();
    }
    return clientIDs;
} 

When using my method I get the following exception:

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to [Lmodels.Client;
at view.userPanes.UserView.extractIDsFromClientSet(UserView.java:128)
at view.userPanes.UserView.setFieldData(UserView.java:82)

How do I correct my method?

I have an exception when calling an update() method of the UserService class, in order to update a user's data saved in the db.

UserService class:

import java.util.List;

import db.hibernate.dao.UserDao;
import models.User;

public class UserService {
    private static UserDao userDao;

    public UserService() {
        userDao = new UserDao();
    }

    public void persist(User entity) {
        userDao.openCurrentSessionwithTransaction();
        userDao.persist(entity);
        userDao.closeCurrentSessionwithTransaction();
    }

    public void update(User entity) {
        userDao.openCurrentSessionwithTransaction();
        userDao.update(entity);
        userDao.closeCurrentSessionwithTransaction();
    }

/*otros metodos*/

The class is called from the PaneUser view controller when clicking the "Delete" button:

PaneUserController class:

public class PaneUserController {

    private UserService userService = new UserService();

    List<User> allUsers = userService.findAll();

    public PaneUserController(PaneUser paneUser) {

        //codigo

        paneUser.addCrudListener(new CrudListener());
        initUserView();

    }

    public void initUserView() {

        theUserView.setFieldData(allUsers.get(0));
    }

    class CrudListener implements ActionListener {

        @Override
        public void actionPerformed(ActionEvent e) {

    //crea un user con los datos de input
            User user = theUserView.getFieldData();

            switch (e.getActionCommand()) {
            case "Search":
                // opens the searchUI

                break;
            case "New...":

                CardLayout cardLayout = (CardLayout) pUser.getLayout();
                cardLayout.show(pUser, "Pane attributeSet");

                break;
            case "Update":

                userService.update(user); // lanza el error en cuestion
                break;
            case "Delete":

                userService.delete(user.getUserID());
                break;

            }

        }
    }

UserDao class:

import models.User;

public class UserDao implements UserDaoInterface<User, String> {

    private Session currentSession;

    private Transaction currentTransaction;

    public UserDao() {
    }

    public Session openCurrentSession() {
        currentSession = getSessionFactory().openSession();
        return currentSession;
    }

    public Session openCurrentSessionwithTransaction() {
        currentSession = getSessionFactory().openSession();
        currentTransaction = currentSession.beginTransaction();
        return currentSession;
    }

    public void closeCurrentSession() {
        currentSession.close();
    }

    public void closeCurrentSessionwithTransaction() {
        currentTransaction.commit();
        currentSession.close();
    }

    private static SessionFactory getSessionFactory() {
        Configuration configuration = new Configuration()
                .addAnnotatedClass(models.User.class)
                .addAnnotatedClass(models.Client.class).configure();

        StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties());
        SessionFactory sessionFactory = configuration.buildSessionFactory(builder.build());
        return sessionFactory;
    }

    public Session getCurrentSession() {
        return currentSession;
    }

    public void setCurrentSession(Session currentSession) {
        this.currentSession = currentSession;
    }

    public Transaction getCurrentTransaction() {
        return currentTransaction;
    }

    public void setCurrentTransaction(Transaction currentTransaction) {
        this.currentTransaction = currentTransaction;
    }

    public void persist(User entity) {
        getCurrentSession().save(entity);
    }

    public void update(User entity) {
        getCurrentSession().update(entity);
    }

    public User findById(String id) {
        User book = (User) getCurrentSession().get(User.class, id);
        return book;
    }

    public void delete(User entity) {
        getCurrentSession().delete(entity);
    }

    @SuppressWarnings("unchecked")
    public List<User> findAll() {
        List<User> users = (List<User>) getCurrentSession().createQuery("from User order by userid").list();
        return users;
    }

    public void deleteAll() {
        List<User> entityList = findAll();
        for (User entity : entityList) {
            delete(entity);
        }
    }
}

The StackTrace:

ERROR: HHH000346: Error during managed flush [Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [models.User#1]]
Exception in thread "AWT-EventQueue-0" javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [models.User#1]
    at org.hibernate.internal.ExceptionConverterImpl.wrapStaleStateException(ExceptionConverterImpl.java:226)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:93)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)
    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)
    at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)
    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:178)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$300(JdbcResourceLocalTransactionCoordinatorImpl.java:39)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:271)
    at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:98)
    at db.hibernate.dao.UserDao.closeCurrentSessionwithTransaction(UserDao.java:38)
    at db.hibernate.service.UserService.update(UserService.java:24)
    at controllers.users.PaneUserController$CrudListener.actionPerformed(PaneUserController.java:63)
    at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.awt.EventQueue.access$500(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.awt.EventQueue$3.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.awt.EventQueue$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [models.User#1]
    at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:2522)
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3355)
    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3229)
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3630)
    at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)
    ... 47 more

I'm sorry if I've written a lot of code, but I see it as necessary, what could be the cause of this error?

I did the deployment of a web app, and I realized that the background image that I put in the body makes it difficult to read the content, so I want to change it, I already tried to do the publish and rebuild again but it has not worked that way .

<body background="~/Content/fit-gif.gif">

fit-gif would be the new background image or gif in the _Layout.cshtml

I need to save the ID of the user who has logged in in the "CreatedBy" name column, but I can't write the correct query.

Each time a "FitnessGoal" entity is created , the data of said identity plus the User ID will be saved in the DB:

[HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Create([Bind(Include = "ID,Name,Goal,StartDate,FinishDate,Weight")] FitnessGoals fitnessGoals)
        {

            var user = UserManager.FindById(User.Identity.GetUserId());

            if (ModelState.IsValid)
            {
                db.FitnessGoals.Add(fitnessGoals);

                db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(fitnessGoals);
        }

Fitness Goal class :

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace FitnessWebApplication.Models
{
    [Table("FitnessGoals")]
    public class FitnessGoals
    {
        /*public List<string> Goals ;

        public FitnessGoals() { this.Goals.Add("Bulk"); this.Goals.Add("Cut"); }*/

        [Key]
        public int ID { get; set; }

        public string CreatedBy { get; set; }

        public string Name { get; set; }

        public string Goal { get; set; }


        [DataType(DataType.Date)]
        [Column(TypeName = "DateTime2")]
        public DateTime StartDate { get; set; }

        [Column(TypeName = "DateTime2")]
        [DataType(DataType.Date)]
        public DateTime FinishDate { get; set; }

        public int Weight { get; set; }

        public enum Goals
        {
            Bulk,
            Cut
        }
    }
}

Hello, I am trying to create a method that returns me String[]data from 2 different tables, in this case it is the table userand the table geolocation, the user data with their respective geolocation (city, neighborhood, latitude, longitude).

But I can't create a "correct" query.

static String[] getUserDataFromDb(JTextField id, JPasswordField pass) throws SQLException {

    String[] data = new String[9];

    Connection c = connectDB();

    Statement stmt = null;

    String query1 = "SELECT * FROM users INNER JOIN geolocation ON user.userid = geolocation.userid" ;

    stmt = c.createStatement();

    ResultSet rs = stmt.executeQuery(query1);

    while (rs.next()) {

        data[0] = rs.getString("userid").trim();
        data[1] = rs.getString("name").trim();
        data[2] = rs.getString("surname").trim();
        data[3] = rs.getString("email").trim();
        data[4] = rs.getString("password").trim();          
        data[5] = rs.getString("city").trim();
        data[6] = rs.getString("district").trim();
        data[7] = rs.getString("latitude").trim();
        data[8] = rs.getString("longitudes").trim();    

    }

    stmt.close();
    c.close();

    return data;

}

It always returns me a errorsince the query is not well written.

The tables are:

users:

+-------+-------------+------+-----+---------------------+
| name  | surname     |     email        |password|userid|   
+-------+-------------+------+-----+---------------------+
| jose  | aguilar     | [email protected] | 123    |jose23|
+-------+-------------+------+-----+---------------------+

geolocation:

    +-----------+-------------+-----------+---------+----------+
    | city      | district    | latitude  |longitude|   userid |
    +-------+-------------+-------------------------+----------+
    | su ciudad | su barrio   | 1.2       | -1.3    |   jose23 |
    +-----------+-------------+-----------+---------+----------+

I have created a method in Java that allows me to "check" several JTextFields, the idea is that a user enters his personal data (name, surname, email, password etc)

and that this method allows me to check if JTextfieldsthey are not NULL, the format of the Email is correct and finally that the password is not NULL.

public boolean checkRegistrationData(ArrayList<JTextField> jTxts, JPasswordField pass, JTextField theEmail) {

    if (isJtextNotNull(jTxts) && isJPasswordNotNull(pass) && isValidEmailAddress(theEmail)) {
        JOptionPane.showMessageDialog(null, "A confirmation Code has been sent to your Email adress");
        return true;

    } else if (isJtextNotNull(jTxts) && !isJPasswordNotNull(pass) && isValidEmailAddress(theEmail)) {
        JOptionPane.showMessageDialog(null, "The password field is empty");
        return false;

    } else if (isJtextNotNull(jTxts) && isJPasswordNotNull(pass) && !isValidEmailAddress(theEmail)) {
        JOptionPane.showMessageDialog(null, "The email address is not valid");
        return false;
    }

    else {

        JOptionPane.showMessageDialog(null, "Some data is empty");
        return false;
    }
}

it ArrayList<JTextField> jTxtsis where most of the JTextFields with the user data are "stored".

Is there any way to improve this method ? would it be better to use switch?

I am trying to load an Image of any map in a JLabel and when clicking on this map a "pointer" is drawn exactly where I clicked and this image is edited with the new pointer, for this I am using a MouseListener , but my program does not draw nothing on click.

package mapa;

import java.awt.EventQueue;
import java.awt.Graphics2D;

import javax.imageio.ImageIO;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;

public class Signal {

private JFrame frame;

/**
 * Launch the application.
 */
public static void main(String[] args) {
    EventQueue.invokeLater(new Runnable() {
        public void run() {
            try {
                Signal window = new Signal();
                window.frame.setVisible(true);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    });
}

/**
 * Create the application.
 * 
 * @throws IOException
 */
public Signal() throws IOException {
    initialize();
}

/**
 * Initialize the contents of the frame.
 * 
 * @throws IOException
 */
private void initialize() throws IOException {

    BufferedImage image1 = ImageIO.read(new File("C:\\Users\\BryanPC\\Desktop\\SanFierro.jpg"));
    Graphics2D map = image1.createGraphics();

    frame = new JFrame();
    frame.setBounds(100, 100, 477, 450);
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.getContentPane().setLayout(null);

    JPanel panel = new JPanel();
    panel.setBounds(0, 0, 461, 400);
    frame.getContentPane().add(panel);
    panel.setLayout(null);

    JLabel containerImg = new JLabel(new ImageIcon(image1));
    containerImg.addMouseListener(new MouseAdapter() {
        @Override
        public void mouseClicked(MouseEvent e) {

            BufferedImage pointer = null;

            try {

                pointer = ImageIO.read(new File("C:\\Users\\BryanPC\\Desktop\\smallPointer.png"));

                map.drawImage(pointer, e.getX(), e.getY(), null);

                map.drawOval(e.getX(), e.getY(), 50, 50);

            } catch (IOException e1) {

                System.out.println("The url is invalid");

            }

        }
    });
    panel.add(containerImg);
    containerImg.setBounds(10, 11, 441, 318);
    ;
}

}

I have to create a Java application with a graphical interface, which when clicking on a "Create signal" button, which allows me to visualize in a JPanel the image of any map, and with the mouse to be able to position several "Pointers" or " Points" on said map and save information related to that point for example "street, avenue etc"

When clicking on each "Point" it shows me in a JLabel or JText the information saved from that "Point".

• How could it be done?

I am trying to modify the data of a CSV file from Java.

In my file CSVI have saved the following data:

"Nombre","Apellido","Intereses","Descripcion"
jose,guerra,algo,algo
pedro,perez,algo,algo
manuel,aguirre,algo,algo

class Persona:

public class Persona {

        String Nombre;
        String Apellido;
        String Intereses;
        String Descripcion;

        public Persona(String Nombre,String Apellido,String Intereses,String Descripcion)
        {        
                this.Nombre = Nombre;
                this.Apellido= Apellido;
                this.Intereses = Intereses;
                this.Descripcion = Descripcion;

        }

        //respectivos métodos get y set 

        public void setNome(String nombre){
            this.Nombre = nombre;

        }
    }

and another class métodos:

import java.util.ArrayList;
import java.util.Scanner;
import java.io.IOException;
import java.io.FileNotFoundException;
import java.io.FileWriter;

import com.opencsv.*;

import java.io.File;

public class métodos {

    static ArrayList<Persona> personas = new ArrayList<Persona>();
    static String directory = "C:\\Users\\BryanPC\\Desktop\\personas.txt";

    public métodos() {

    }
    // escribe los datos salvados en el ArrayList Personas (hay un error se
    // imprimen 4 comillas de mas)

    public static void escribeCSV() throws FileNotFoundException, IOException {

        ArrayList<String[]> datos = personasToArrayListOfString();

        CSVWriter csvOutput = new CSVWriter(new FileWriter(directory, true), ',', '"', "\r\n");

        csvOutput.writeAll(datos, false);
        csvOutput.close();

    }

    // lee los datos del CSV y los salva en el ArrayList Personas
    public static void leeCSV() throws FileNotFoundException, IOException {

        File file = new File(directory);
        Scanner input = new Scanner(file);
        input.next();

        while (input.hasNext()) {

            String s = input.next();
            String[] data = s.split(",");
            Persona p = arrayOfStringsToPersona(data);

            personas.add(p);
        }

    }

    // cambia el nombre de la primera persona salvada en el ArrayList Personas
    // por Juan
    public static void modificaCSV() {

        for (Persona p : personas) {

            p.setNome("juan");
            break;
        }

    }

    // transforma un objeto de tipo Persona a un ArrayList<String[]> para
    // poder imprimirlo

    public static ArrayList<String[]> personasToArrayListOfString() {

        ArrayList<String[]> datos = new ArrayList<String[]>();

        for (Persona p : personas) {

            String[] s = new String[10];

            String nombre = p.getNombre();
            String apellido = p.getApellido();
            String intereses = p.geIntereses();
            String descripcion = p.getDescripcion();

            s[0] = nombre;
            s[1] = apellido;
            s[2] = intereses;
            s[3] = descripcion;

            datos.add(s);
        }
        return datos;

    }
    // transforma un objeto de tipo String[] a uno de tipo Persona para asi
    // poder añadirlo al ArrayList Personas

    public static Persona arrayOfStringsToPersona(String[] a) {

        String nombre = a[0];
        String apellido = a[1];
        String intereses = a[2];
        String descripcion = a[3];

        Persona p = new Persona(nombre, apellido, intereses, descripcion);

        return p;
    }

    public static void main(String[] args) throws FileNotFoundException, IOException {

        leeCSV();
        // borra o sobreescribe el csv con nuevo nombre "juan"
        modificaCSV();
        metodoFaltante();
        escribeCSV();

    }

}

I guess once you use the readCSV method you will have to create another method that deletes the data in the CSV file.

Or overwrite everything that is written in the CSV file.

I am creating an application where each user has their respective profile. These profiles are stored in a ArrayList. I have problems when creating a method to search for users registered or present in ArrayListit and I have to do it with 2 parameters Nombreand Apellido.

I have the following class:

import java.util.*;

public class Profilo {

    static String Nombre;
    static String Apellido;
    String Intereses;
    boolean visible;

    //contructor   
    public Profilo(String nombre, String apellido,String intereses,
            boolean visibilidad) {  
        this.Nombre= nombre;
        this.Apellido= apellido;
        this.Intereses= intereses;
        this.visible = visibilidad;

    }                  
    public String getNombre() {  
        return this.Nome;
    }            
    public String getApellido() {
        return this.Cognome;
    }

And another class that will contain the methods to login, register and search for users:

import java.util.ArrayList;
import java.util.Scanner;


public class PerfilManager {

    static ArrayList<Profilo> Users = new ArrayList();
    static Scanner sc = new Scanner(System.in);


     public static void Login() {
         //codigo
     }

     public static void Registrarse() {
        //codigo
     }

     public static void InizializaDati(){
         String nombre;
         String apellido;
         String intereses;
         boolean visibile;

         System.out.println("nombre:");
         nombre= sc.next();

         System.out.println("apellido:");
         apellido = sc.next();

         System.out.println("intereses:");
         intereses= sc.next();

         System.out.println("visible?(true/false)");  
         visibile = sc.nextBoolean();

         Perfil perfil= new Perfil(nombre,apellido,intereses,visibile);

         Users.add(perfil);
         System.out.println("peril creado!");

         ShowPerfil();
    }   

    public static void BuscaPerfil(String nome , String cognome) {
        for(int i = 0 ; i < Users.size();i++) {
            if(Users.get(i).visibile != false) {
                //muestra perfil
            } else {
                System.out.println("Este perfil es privado");    
            }
        }
    }
}