SQL ignore part of WHERE if parameter is null

-

 

SQL ignore part of WHERE if parameter is null




Comments

Post a Comment

Popular posts from this blog

Hibernate (Java) -- by jps sasadara

-
Image
HQL & JPAQuery for Springboot =>   https://drive.google.com/drive/u/1/folders/18KA0A0EKYmn6Z7auazNquPDaweqPQvHI               https://www.baeldung.com/jpa-join-types   (only if we want to write join query, but in HQL no need of using join  key word , if we can correctly implement the mapping classes ) Native SQL for Springboot => https://drive.google.com/drive/u/1/folders/17vdDhEXBKtbWpTkYUy5UcF_n_r2G-YDy      projects =>  https://drive.google.com/drive/folders/14x_9TeE5SZq6ECZqCmoBaGTgOUSssuqm?usp=sharing We can write plan SQL Query in hibernate using   session.createSQLQuery(sqlSearch); Eg-::  String sqlSearch = SQLVarList.MSSQL_DEVICEOPERATIONREPORT_SQL2 + where + orderBy;             Query querySearch = session.createSQLQuery(sqlSearch);             querySearch = setD...
Read more

JavaBeans vs Spring beans vs POJOs

-
JavaBeans vs Spring beans vs POJOs JavaBeans : At a basic level, JavaBeans are simply Java classes which adhere to certain coding conventions. Specifically, classes that 1) have  public  default (no argument) constructors 2) allow access to their properties using accessor (getter and setter) methods 3) implement  java.io.Serializable Spring Beans : A Spring bean is basically an object managed by Spring. More specifically, it is an object that is instantiated, configured and otherwise managed by a  Spring Framework  container. Spring beans are defined in Spring configuration files (or, more recently, with annotations), instantiated by Spring containers, and then injected into applications.     Note that Spring beans need not always be JavaBeans. Spring beans might not implement the  java.io.Serializable  interface,  can have arguments in their constructors , etc. This is the very basic difference between JavaBeans and Spring beans. For m...
Read more

Design Patterns

-
Image
  Best  =>  https://refactoring.guru/design-patterns/catalog Cheat sheets => designpatterns.pdf                                                                   designpatternscard.pdf
Read more