String sql2="from WtgooProductdetal wp,WtgooCompany wc where " +
"wp.companyId=wc.comId and wp.ptGsid =:dsj";
//sql+="and wp.ptTitle =?";
Query query =getSession().createQuery(sql2);
query.setParameter("dsj",530);错误提示:Not all named parameters have been set: [dsj]帮解决一下
"wp.companyId=wc.comId and wp.ptGsid =:dsj";
//sql+="and wp.ptTitle =?";
Query query =getSession().createQuery(sql2);
query.setParameter("dsj",530);错误提示:Not all named parameters have been set: [dsj]帮解决一下
query.setParameter("dsj",530,Hibernate.INTEGER);
//Hibernate.INTEGER为参数类型;这样相对于setInteger()这种形式的好处是没有局限性.
如用hibernate,最好在配置文件中设置
<property name="hibernate.show_sql">true</property>
这样的话把控制台输出的sql在数据库中执行一下,看看有什么问题
这种形式是指定参数名称的...
如:
一:
query.setParameter("dsj",530,Hibernate.INTEGER);
二(带问号形式):
query.setParameter(0,530,Hibernate.INTEGER);