mysql语句错误求教。
ssh框架做了一个信息管理系统，遇到了一个数据库语句错误，一直改不出来，求教！！！dao层：
public List findAllChuyuan()
{
log.debug("finding all TChuzhuanYuan instances");
try
{
String queryString = "from TChuzhuanYuan where chuzhuanYuanOne5= ?";
return getHibernateTemplate().find(queryString, 1);
} catch (RuntimeException re)
{
log.error("find all failed", re);
throw re;
}
}
错误代码：
SEVERE: Servlet.service() for servlet default threw exception
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.t_chuzhuanYuan tchuzhuany0_ where tchuzhuany0_.chuzhuanYuan_one5=1' at line 1
求各位高手帮帮忙，能留个qq详细交流就更好了~~~ --------------------编程问答-------------------- 你的SQL语句是什么？
String queryString = "select * from TChuzhuanYuan where chuzhuanYuanOne5= ?"; --------------------编程问答-------------------- 语法错误。
String queryString = "select * from TChuzhuanYuan where chuzhuanYuanOne5= ?"; --------------------编程问答-------------------- 楼上正解
String queryString = "select * from TChuzhuanYuan where chuzhuanYuanOne5= ?"; --------------------编程问答-------------------- String queryString = "select * from TChuzhuanYuan where chuzhuanYuanOne5= ?";
--------------------编程问答-------------------- 這樣修改是錯誤的，因為我用了HibernateTemplate這個類
return getHibernateTemplate().find(queryString, 1);
數據庫語句是可以用 from TChuzhuanYuan where chuzhuanYuanOne5= ?的。
如果按照你們說的改會出現
unexpected token: * near line 1, column 8 [select * from com.model.TChuzhuanYuan where chuzhuanYuanOne5= ?]
--------------------编程问答--------------------
--------------------编程问答--------------------
这样试试。 --------------------编程问答-------------------- HQL查询是这样的，加个别名试试
String queryString = "from TChuzhuanYuan where chuzhuanYuanOne5= ?";
Query query = hf.createSQLQuery(queryString );
query.setString(0, ？的参数值);
return query.list();
from TChuzhuanYuan t where t.chuzhuanYuanOne5= ?
另外，想看看lz的TChuzhuanYuan 对应的表 --------------------编程问答-------------------- 是不是你的这个字段是字符串类型！ 你给他传的是int型啊？
补充：Java , Java相关
