CODEWITHSUNDEEP
javahibernate
dante
dante

Reputation: 403

Hibernate - how can I check if user exists?

I got weird problem, I'm trying to use Hibernate in JavaFX app and I want in order to Hibernate will check if entered values exist in database, but... when I will enter these values then Hibernate deletes all records from my USER table instead of check if entered values exist there...why? here is a code:

EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("clinic");
    EntityManager entityManager = entityManagerFactory.createEntityManager();

    User user = new User();

    user.setUsername(loginField.getText());
    user.setPassword(passwordField.getText());


    Query query = entityManager.createQuery("FROM User WHERE username= :username AND password= :password", User.class);
    query.setParameter("username", user.getUsername());
    query.setParameter("password", user.getPassword());

    String result = query.getResultList().toString();

    System.out.println(result);

    // if user exist then main window will appear:
  //root = FXMLLoader.load(getClass().getResource("/view/Main.fxml"));
    //stage = (Stage) logInButton.getScene().getWindow();
    //stage.setTitle("Przychodnia");
    //stage.setScene(new Scene(root, 750, 530));
    //stage.show();
    //return;


    entityManager.close();
    entityManagerFactory.close();

persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence  http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
version="2.0">
<persistence-unit name="clinic" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
        <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
        <property name="javax.persistence.jdbc.user" value="root" />
        <property name="javax.persistence.jdbc.password" value="root" />
        <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3307/przychodniadb" />
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
        <property name="hibernate.hbm2ddl.auto" value="create"/>
    </properties>
</persistence-unit>

Upvotes: 0

Views: 1147

Answers (1)

Scary Wombat
Scary Wombat

Reputation: 44844

Get rid of <property name="hibernate.hbm2ddl.auto" value="create"/> as it will recreate your db each time it starts

Upvotes: 2

Related Questions