String hql = "from MarkAssociation ma where (SELECT DISTINCT SUBSTRING('"+className+"', 0, 3))<=(SELECT DISTINCT SUBSTRING(ma.examTime, 3, 5))";
报语句错误...
但是这个我在数据库里是正确的:
SELECT * from Mark_Association where (SELECT DISTINCT SUBSTRING('09wb1', 0, 3))<=(SELECT DISTINCT SUBSTRING(examTime, 3, 5))
报语句错误...
但是这个我在数据库里是正确的:
SELECT * from Mark_Association where (SELECT DISTINCT SUBSTRING('09wb1', 0, 3))<=(SELECT DISTINCT SUBSTRING(examTime, 3, 5))
getSession().createSQLQuery("select * from dbo.Student").list();希望能帮到你!