How to write pure SQL statements using JPQL

With JPQL, SQL statements need to be modified to resemble HQL statements. SQL queries the database, and JPQL queries for objects and properties , which are somewhat different in syntax. For some queries that cannot be written by JPQL, it is easier to write them out using native SQL

Here is an example of the differences in syntax:

JPQL Query

@PersistenceContext
protected Entitymanager em;

Public list<video> FindVideoList1 () {
String hql = "fromVideo ORDER by id desc";
Query query = em. CreateQuery (HQL);
list<video> result = Query.getresultlist ();
Em.clear ();
return result;
}

SQL query

Query data for the last 7 days

Public list<video> FindVideoList2 () {
list<video> result = (list<video>) em. Createnativequery
("select * from Db_video where Date_sub (Curdate (), Interval 6 day) <= the date (date) Order BY date desc", video.cl )
. Getresultlist ();
return result;
}

Original articles, welcome reprint, reproduced please indicate the source!

How to write pure SQL statements using JPQL