Insert Data using Object and Delete row using Id

 Step 1:

public class Course {

private long id;

private String name;

private String author;

public Course() {

super();

}

public Course(long id, String name, String author) {

super();

this.id = id;

this.name = name;

this.author = author;

}

public long getId() {

return id;

}

public String getName() {

return name;

}

public String getAuthor() {

return author;

}

@Override

public String toString() {

return "Course [id=" + id + ", name=" + name + ", author=" + author + "]";

}


}


Step 2:

public class CourseJdbcRepository {


@Autowired

private JdbcTemplate springjdbcTemplate;

//""" will be known as text block

//(this allows us to retain the formatting for your queries which allow to easy to understand)

private static String INSERT_QUERY_WITH_PARAM=

"""

insert into course (id,name,author)

values(?,?,?)

""";

public void insertFromObject(Course course) {

springjdbcTemplate.update(INSERT_QUERY_WITH_PARAM, course.getId(), course.getName(), course.getAuthor());

}

}


Step 3

@Component

public class CourseJdbcCommandLineRunner implements CommandLineRunner {

@Autowired

CourseJdbcRepository courseJdbcRepository;


@Override

public void run(String... args) throws Exception {

courseJdbcRepository.insertFromObject(new Course(2, "Learn Spring Boot", "Irfan Khan"));

}


}


DELETE Row using ID


@Component

public class CourseJdbcCommandLineRunner implements CommandLineRunner {

@Autowired

CourseJdbcRepository courseJdbcRepository;


@Override

public void run(String... args) throws Exception {

courseJdbcRepository.insert();

courseJdbcRepository.insertFromObject(new Course(2, "Learn Spring Boot", "Irfan Khan"));

courseJdbcRepository.insertFromObject(new Course(3, "Learn Hibernate Boot", "Irfan Khan"));

courseJdbcRepository.deleteById(1);

}


}


index 1 value got deleted



@Repository

public class CourseJdbcRepository {


@Autowired

private JdbcTemplate springjdbcTemplate;

//""" will be known as text block

//(this allows us to retain the formatting for your queries which allow to easy to understand)

private static String INSERT_QUERY=

"""

insert into course (id,name,author)

values(1,'Learn Java', 'khanDev')

""";

private static String INSERT_QUERY_WITH_PARAM=

"""

insert into course (id,name,author)

values(?,?,?)

""";

private static String DELETE_QUERY =

"""

delete from course where id = ?

""";


public void insert() {

springjdbcTemplate.update(INSERT_QUERY);

}

public void insertFromObject(Course course) {

springjdbcTemplate.update(INSERT_QUERY_WITH_PARAM, course.getId(), course.getName(), course.getAuthor());

}

public void deleteById(long id) {

springjdbcTemplate.update(DELETE_QUERY,id);

}

}


Previous
Next

Comments

Post a Comment

Popular posts from this blog

Introduction of RESTful Web Service

Image
Rest Web Service It Stands for Representational State Transfer who coined Rest ?  Roy Fielding, who is developed HTTP as well Rest is make Best use of HTTP: Key Abstraction - Resources: 1. A Resource has an URI (Uniform Resource Identifier)     /user/Khan/todos/1     /user/Khan/todos     /user/Khan Note: It shows we  assign a URI to Each Resource           Rest does not worry about how you are representing your  resource            is it JSON,XML or HTML 2. A Resource can have different representations     JSON     XML     HTML Methods for Resources: 1. Create Resource   : POST 2. Update Resource  : PUT 3. Get Resource        : GET 4. Delete Resource   : DELETE REST Data Exchange Format No Restriction.(But JSON format is popular in restful) Transport Only HTTP (Restricted) Service Definition No Standard (but Swagg...
Read more

Learn JPA and Hibernate

Image
https://start.spring.io/ in given above URL can   User Given Below Configuration to Create Spring Boot Project with given dependencies to enable JPA and Hibernate Spring Web Spring Data JDBC Spring Data JPA H2 Database < dependencies >      < dependency > < groupId >org.springframework.boot</ groupId > < artifactId >spring-boot-starter-data-jdbc</ artifactId >      </ dependency >      < dependency > < groupId >org.springframework.boot</ groupId > < artifactId >spring-boot-starter-data-jpa</ artifactId >      </ dependency >      < dependency > < groupId >org.springframework.boot</ groupId > < artifactId >spring-boot-starter-web</ artifactId >      </ dependency >      < dependency > < groupId >com.h2database</ groupId > < artifactId...
Read more

Implementing Dynamic Filtering for Rest API

 Implementing Static Filtering for Rest API Dynamic Filtring: Customize filtering for a bean for specific REST Api @Jsonfilter with filter Provider At Conroller class //********************** DYNAMIC FILTERING***********// @ GetMapping ( "/Dyfiltering" ) public MappingJacksonValue dynamicFiltering() { SomeBean someBean = new SomeBean( "val1" , "val2" , "val3" ); MappingJacksonValue mappingJacksonValue = new MappingJacksonValue( someBean ); SimpleBeanPropertyFilter filter = SimpleBeanPropertyFilter. filterOutAllExcept ( "field1" , "field2" ); SimpleFilterProvider filters = new SimpleFilterProvider().addFilter( "SomeBeanFilter" , filter ); mappingJacksonValue .setFilters( filters ); return mappingJacksonValue ; } //********************** DYNAMIC FILTERING***********// At Pojo Entity Class @JsonFilter ( "SomeBeanFilter" ) public class SomeBean { private String field...
Read more