Insert a new row using JpaRepository in java

Question

I am very new to spring JPA. I have following entity class which I want to insert in table:

@Entity
@Table(name = "test")
public class Test {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private int id;

    @Column(name = "user")
    private String user;
}

I have an empty table named test. I have multiple objects of Test and I want to insert it to the table. For this I have created a repo class:

@Repository("testRepo")
public interface TestRepo extends JpaRepository<Test, String> {
//write insert query    
    @Modifying
    @Query(//What insert query I should write)
    void insertData(@Param("id") String id);

}

I have searched but getting only options for update query.

This is Spring Data JPA (!= JPA API)

user8558216
– user8558216

2017-10-06 06:58:04 +00:00
Commented Oct 6, 2017 at 6:58 — user8558216
– user8558216, Commented Oct 6, 2017 at 6:58

blue note · Accepted Answer · 2017-10-05 17:56:53Z

6

The method .save(Entity entity), inherited from the Parent interface CrudRepository can be used to both update an existing entity or create a new one.

answered Oct 5, 2017 at 17:56

blue note

29.5k10 gold badges83 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ahmetcetin · Accepted Answer · 2017-10-05 19:46:24Z

4

Your repository interface extends from JpaRepository which extends from CrudRepository. save and saveAndFlush methods can be used as default to insert new rows.

save: Inserts new rows. You can give row list as parameter to this method. In your example it should be used like this:

testRepo.save(testEntity);

or

testRepo.save(testEntities);

saveAndFlush: Inserts only a new row and commit the changes immediately. In your example it should be used like this:

testRepo.saveAndFlush(testEntity);

answered Oct 5, 2017 at 19:46

ahmetcetin

3,0201 gold badge26 silver badges39 bronze badges

Comments

Community · Accepted Answer · 2019-04-02 10:22:07Z

1

In your service class do something similar to below. You don't have to write a separate method to save the entity. save method of the repository can be used to save the entity.

class TestDAO{

@Autowired
TestRepo testRepo;

public void saveTest(Test test) {
testRepo.save(test);
}

edited Apr 2, 2019 at 10:22

CommunityBot

11 silver badge

answered Oct 5, 2017 at 19:21

Madhu Reddy

3811 gold badge4 silver badges14 bronze badges

Comments

BeatrizGomes · Accepted Answer · 2022-11-26 00:47:15Z

1

Using spring boot 2.7.5 I'm using JPA Repository with this for instance:

    @Query("INSERT INTO Planeta p (nome, clima, terreno) VALUES (:nome, :clima, :terreno)")
    Integer insertPlaneta(String nome, String clima, String terreno);

Parameters are passed with :name_of_parameter according with parameters method.

answered Nov 26, 2022 at 0:47

BeatrizGomes

551 silver badge11 bronze badges

Comments

Andres Navarro · Accepted Answer · 2021-07-02 17:08:54Z

0

("insert into table values (?1)",nativeQuery = true)

edited Jul 2, 2021 at 17:08

answered Jul 1, 2021 at 23:07

Andres Navarro

1372 bronze badges

Collectives™ on Stack Overflow

Insert a new row using JpaRepository in java

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related