JdbcTemplate and Config datasource

PHOTO

Fri Jan 26 2024 06:44:32 GMT+0000 (Coordinated Universal Time)

// an application that accesses a relational database with JDBC, you’ve probably configured Spring’s JdbcTemplate as a bean in the Spring application context
@Bean
public JdbcTemplate jdbcTemplate(DataSource dataSource) {
  return new JdbcTemplate(dataSource);
}

// configure a DataSource bean so that the dependency will be met
@Bean
public DataSource dataSource() {
  return new EmbeddedDatabaseBuilder()
          .setType(EmbeddedDatabaseType.H2)
          .addScripts('schema.sql', 'data.sql')
          .build();
}

COPY

Save snippets that work from anywhere online with our extensions

Comments

More like this

#kotlin #springframework

Ping Controller actions

@RequestMapping(produces = [MediaType.TEXT_HTML_VALUE, CustomMediaType.TURBO_STREAM_VALUE])
suspend fun pinger(model: Model): String {
    model.addAttribute("pingTime", pingService.ping(hostname, port))
    return "ping.turbo-stream"
}

#springframework

Spring-postgure

undefined

#springframework #spring #boot

▷ Configuración de CORS en un proyecto Spring Boot - Yo Androide

	@Bean
	public WebMvcConfigurer corsConfigurer() {
		return new WebMvcConfigurer() {
			@Override
			public void addCorsMappings(CorsRegistry registry) {
				registry.addMapping("/**").allowedOrigins("http://localhost:4200").allowedMethods("*").allowedHeaders("*");
			}
		};
	}
	
}

#springframework

FACE

https://www.facebook.com/profile.php?id=100010247581084

#java #springframework

SpringBoot配置devtools实现热部署

#热部署生效
spring.devtools.restart.enabled: true
#设置重启的目录
#spring.devtools.restart.additional-paths: src/main/java
#classpath目录下的WEB-INF文件夹内容修改不重启
spring.devtools.restart.exclude: WEB-INF/**

#springframework

Model class

@Data
@AllArgsConstructor
@NoArgsConstructor
@Entity
@Table(name = "post_blog")
public class Posts {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id" , nullable = false)
    private Long id;

    @Column(name="title" , nullable = false)
    private String title;

    @Column(name="content" , nullable = false)
    private String content;

    @Column(name="description" , nullable = false)
    private String description;

    @OneToMany(mappedBy = "posts" , cascade = CascadeType.ALL , orphanRemoval = true)
    private Set<Comments> comments = new HashSet<>();

#springframework

Repository

@Repository
public interface PostsRepository extends PagingAndSortingRepository<Posts, Long> {

}

#springframework

Controller

@GetMapping({"/get-all-posts"})
    public PostResponse getAllPosts(@RequestParam(value = "pageNo", defaultValue=AppConstants.DEFAULT_PAGE_NUMBER, required = false) Integer pageNo,
                                    @RequestParam(value = "pageSize", defaultValue = AppConstants.DEFAULT_PAGE_SIZE, required = false) Integer pageSize
) {
        return postsService.getAllPosts(pageNo, pageSize);
    }

#springframework

App Constants

public class AppConstants {
    public static final String DEFAULT_PAGE_NUMBER = "0";
    public static final String DEFAULT_PAGE_SIZE = "10";
}

#springframework

Posts Service

public interface PostsService {
  
    PostResponse getAllPosts(Integer pageNo , Integer pageSize,String sortBy, String sortDir);

}

#springframework

Includes sorting controller

    @GetMapping({"/get-all-posts"})
    public PostResponse getAllPosts(@RequestParam(value = "pageNo", defaultValue = AppConstants.DEFAULT_PAGE_NUMBER, required = false) Integer pageNo,
                                    @RequestParam(value = "pageSize", defaultValue = AppConstants.DEFAULT_PAGE_SIZE, required = false) Integer pageSize,
                                    @RequestParam(value = "sortBy", defaultValue = AppConstants.DEFAULT_SORT_BY, required = false) String sortBy,
                                    @RequestParam(value = "sortDir", defaultValue = AppConstants.DEFAULT_SORT_DIR, required = false) String sortDir) {
        return postsService.getAllPosts(pageNo, pageSize);
    }

#springframework

Service with Sorting Param

 PostResponse getAllPosts(Integer pageNo , Integer pageSize,String sortBy, String sortDir);

#springframework

Service with Sorting params

 PostResponse getAllPosts(Integer pageNo , Integer pageSize,String sortBy, String sortDir);

#springframework

App constants with sorting params

public class AppConstants {
    public static final String DEFAULT_PAGE_NUMBER = "0";
    public static final String DEFAULT_PAGE_SIZE = "10";
    public static final String DEFAULT_SORT_BY = "id";
    public static final String DEFAULT_SORT_DIR = "asc";

}

#springframework

PostServiceImpl

@Service
public class PostsServiceImpl implements PostsService {
    @Autowired
    private PostsRepository postsRepository;

    @Override
    public PostResponse getAllPosts(Integer pageNo , Integer pageSize, String sortBy , String sortDir){
        Sort sort = sortDir.equalsIgnoreCase(Sort.Direction.ASC.name())? Sort.by(sortBy).ascending():Sort.by(sortBy).descending();
        Pageable pg = PageRequest.of(pageNo , pageSize , sort);
        Page<Posts> posts = postsRepository.findAll(pg);
        List<Posts> postsList = posts.getContent();
        List<PostDto> data =    postsList.stream().map(this::mapToDTO).collect(Collectors.toList());
        PostResponse postResponse = new PostResponse();
        postResponse.setData(data);
        postResponse.setPageNo(posts.getNumber() + 1);
        postResponse.setPageSize(posts.getSize());
        postResponse.setTotalElement(posts.getTotalElements());
        postResponse.setLast(posts.isLast());
        postResponse.setTotalPages(posts.getTotalPages());
        return  postResponse;

    }
}

JdbcTemplate and Config datasource

Save snippets that work from anywhere online with our extensions

Comments

More like this

Browse more snippets >>

Embed code snippet