有没有这种的SQL 深查寻。
select ruler.* from t_iot_rulers ruler
INNER JOIN t_iot_grades grade on ruler.grade_id = grade.id
INNER JOIN t_iot_normals normal on grade.normal_id = normal.id
where normal.driver_id = "68790bab08de4a129c0b50414854025c"
如果我想写 SQL 生成器
如何入手。
级连查寻：
SimpleCriteria simpleCriteria = new SimpleCriteria(
"INNER JOIN t_iot_grades grade on grade_id = grade.id "
+"INNER JOIN t_iot_normals normal on grade.normal_id = normal.id "
);
simpleCriteria.where().and("driver_id","=",driver.getId());
return dao.query(Ruler.class,simpleCriteria);