CRUD operation workflow

1. Create Database table.

  CREATE TABLE user (
      id INT,
      name VARCHAR(50),
      email VARCHAR(50)
  );

2. Create Entity class

@Entity(name = "user")
public class User {

    @Id
    @Column(name = "uid")
    private int id;

    @Column
    private String name;

    @Column
    private String email;

    //Getters and Setters
}

3. Create JPA Repository

public interface UserRepository extends JpaRepository<User,Integer> {} 

4. Perform Operation - Create a Bean class - Inject repository into bean class. - Repository having pre-defiend method to do DB operations.

@Component
public class Crud {

    @Autowired
    private UserRepository userRepository;

    public void insertUser() {
        User u = new User();
        u.setId(12);
        u.setName("Alamgir");
        u.setEmail("alamgir.ahosain@gmail.com");
        userRepository.save(u);
    }
}

5. Call the method

@SpringBootApplication
public class ECrudOpeationApplication {

    public static void main(String[] args) {
        ConfigurableApplicationContext context = SpringApplication.run(ECrudOpeationApplication.class, args);
        Crud c = context.getBean(Crud.class);
        c.insertUser();
    }
}

↑ Back to top