问题就是:查询时候报错了，不多说，直接贴代码和错误吧！
这个是Email实体类：package com.alan.easyoa.entity;import java.util.ArrayList;
import java.util.List;import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.SequenceGenerator;
@Entity
@SequenceGenerator(name="emailSe",sequenceName="emailSequence")
public class Email {
private Integer id; //id
private List<Employee> employees = new ArrayList<Employee>(); //发送给那些员工
private List<Department> Departments = new ArrayList<Department>(); //发送给那些部门
private String title; //邮件标题
private String content; //邮件内容
private String sendTime; //邮件发送时间
private boolean isSend; //true代表发送，false代表接收
/*********getter 和 setter 方法********************/
@Id
@GeneratedValue(generator="emailSe")
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@ManyToMany
public List<Employee> getEmployees() {
return employees;
}
public void setEmployees(List<Employee> employees) {
this.employees = employees;
}
@ManyToMany
public List<Department> getDepartments() {
return Departments;
}
public void setDepartments(List<Department> departments) {
Departments = departments;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getSendTime() {
return sendTime;
}
public void setSendTime(String sendTime) {
this.sendTime = sendTime;
}
public boolean isSend() {
return isSend;
}
public void setSend(boolean isSend) {
this.isSend = isSend;
}
}Employee实体代码：package com.alan.easyoa.entity;import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
/**
*
* 员工实体类
* @author Alan
*
*/
@Entity
public class Employee implements Serializable { private static final long serialVersionUID = 760623822991124471L;
private String email; //Email也就是登录账号
private String password; //密码
private String name; //姓名
private Integer age; //年龄
private String sex; //性别
private String contactInfo; //联系方式
private Department department; //部门
private List<Email> emails = new ArrayList<Email>(); //该员工发送的所有邮件，这个基本没用，如果用它的话一次性全取出来服务器受不了
public Employee(){}
/*********getter 和 setter 方法********************/
@Id
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getContactInfo() {
return contactInfo;
}
public void setContactInfo(String contactInfo) {
this.contactInfo = contactInfo;
}
@ManyToOne
public Department getDepartment() {
return department;
}
public void setDepartment(Department department) {
this.department = department;
}
@ManyToMany(mappedBy="employees")
public List<Email> getEmails() {
return emails;
}
public void setEmails(List<Email> emails) {
this.emails = emails;
}
}下面是查询方法：
Employee 这个是实体类，PageUtil 这个是帮助类，具体代码就不贴出来了啦。
private HibernateTemplate hibernateTemplate = new HibernateTemplate(); @SuppressWarnings("unchecked")
public List<Email> getEmailsByEmployee(final Employee e, final boolean isInbox,final PageUtil pageUtil) {
hibernateTemplate.setSessionFactory(new AnnotationConfiguration().configure().buildSessionFactory());
return (List<Email>)hibernateTemplate.execute(new HibernateCallback(){
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
session.beginTransaction();
//最多读取多少条记录
int max = (pageUtil.getCurrentPage()+1)*pageUtil.getPageSize();
//从那一条开始读取
int fister = pageUtil.getCurrentPage()*pageUtil.getPageSize();
pageUtil.setCurrentPage(pageUtil.getCurrentPage()+1);
//pageUtil.setAllRow((Integer)session.createQuery("count(*)from Email e ").uniqueResult());
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list();
session.getTransaction().commit();
return object;
}});
}
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list(); 这句话报错
错误如下：Exception in thread "main" org.springframework.orm.hibernate3.HibernateQueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]; nested exception is org.hibernate.QueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.alan.easyoa.dao.impl.EmailDaoImpl.getEmailsByEmployee(EmailDaoImpl.java:25)
at com.alan.easyoa.test.insertDate.testList(insertDate.java:78)
at com.alan.easyoa.test.insertDate.main(insertDate.java:83)
Caused by: org.hibernate.QueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
at $Proxy9.createQuery(Unknown Source)
at com.alan.easyoa.dao.impl.EmailDaoImpl$1.doInHibernate(EmailDaoImpl.java:35)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 4 more
junit测试代码如下：
@Test
public void testList(){
PageUtil pageUtil = new PageUtil();
pageUtil.setCurrentPage(1);
pageUtil.setFirstPage(true);
pageUtil.setPageSize(4);
EmailDaoImpl empl = new EmailDaoImpl();
Employee employee = new Employee();
employee.setEmail("[email protected]");
List<Email> emails = empl.getEmailsByEmployee(employee, true, pageUtil);
System.out.println(emails.size());
}各位前辈能帮忙看看嘛？先谢谢了？小弟为这个东西困扰一整天了哦。我总是觉得是这个段hsql语句写得有问题但是又不知道问题出在哪里：
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list();
我把我的需求简单将一下吧，那个Email实体类对应一个email表，那个Employee也对应一个表employee，由于email和employee是多对多关系，所以hibernate自动给他们添加了一个中间表email_employee，其中有两个列，一个是email表的id一个是employee的email那个字段，假如这里面都有相应的数据，那么我现在想取employee表中的某个员工发送的邮件，每次只取固定的条数，那么此时我应该怎么写hsql语句呢？不知道我表达清楚了没有。
谢谢了。
这个是Email实体类：package com.alan.easyoa.entity;import java.util.ArrayList;
import java.util.List;import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.SequenceGenerator;
@Entity
@SequenceGenerator(name="emailSe",sequenceName="emailSequence")
public class Email {
private Integer id; //id
private List<Employee> employees = new ArrayList<Employee>(); //发送给那些员工
private List<Department> Departments = new ArrayList<Department>(); //发送给那些部门
private String title; //邮件标题
private String content; //邮件内容
private String sendTime; //邮件发送时间
private boolean isSend; //true代表发送，false代表接收
/*********getter 和 setter 方法********************/
@Id
@GeneratedValue(generator="emailSe")
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@ManyToMany
public List<Employee> getEmployees() {
return employees;
}
public void setEmployees(List<Employee> employees) {
this.employees = employees;
}
@ManyToMany
public List<Department> getDepartments() {
return Departments;
}
public void setDepartments(List<Department> departments) {
Departments = departments;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getSendTime() {
return sendTime;
}
public void setSendTime(String sendTime) {
this.sendTime = sendTime;
}
public boolean isSend() {
return isSend;
}
public void setSend(boolean isSend) {
this.isSend = isSend;
}
}Employee实体代码：package com.alan.easyoa.entity;import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
/**
*
* 员工实体类
* @author Alan
*
*/
@Entity
public class Employee implements Serializable { private static final long serialVersionUID = 760623822991124471L;
private String email; //Email也就是登录账号
private String password; //密码
private String name; //姓名
private Integer age; //年龄
private String sex; //性别
private String contactInfo; //联系方式
private Department department; //部门
private List<Email> emails = new ArrayList<Email>(); //该员工发送的所有邮件，这个基本没用，如果用它的话一次性全取出来服务器受不了
public Employee(){}
/*********getter 和 setter 方法********************/
@Id
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getContactInfo() {
return contactInfo;
}
public void setContactInfo(String contactInfo) {
this.contactInfo = contactInfo;
}
@ManyToOne
public Department getDepartment() {
return department;
}
public void setDepartment(Department department) {
this.department = department;
}
@ManyToMany(mappedBy="employees")
public List<Email> getEmails() {
return emails;
}
public void setEmails(List<Email> emails) {
this.emails = emails;
}
}下面是查询方法：
Employee 这个是实体类，PageUtil 这个是帮助类，具体代码就不贴出来了啦。
private HibernateTemplate hibernateTemplate = new HibernateTemplate(); @SuppressWarnings("unchecked")
public List<Email> getEmailsByEmployee(final Employee e, final boolean isInbox,final PageUtil pageUtil) {
hibernateTemplate.setSessionFactory(new AnnotationConfiguration().configure().buildSessionFactory());
return (List<Email>)hibernateTemplate.execute(new HibernateCallback(){
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
session.beginTransaction();
//最多读取多少条记录
int max = (pageUtil.getCurrentPage()+1)*pageUtil.getPageSize();
//从那一条开始读取
int fister = pageUtil.getCurrentPage()*pageUtil.getPageSize();
pageUtil.setCurrentPage(pageUtil.getCurrentPage()+1);
//pageUtil.setAllRow((Integer)session.createQuery("count(*)from Email e ").uniqueResult());
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list();
session.getTransaction().commit();
return object;
}});
}
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list(); 这句话报错
错误如下：Exception in thread "main" org.springframework.orm.hibernate3.HibernateQueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]; nested exception is org.hibernate.QueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:657)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.alan.easyoa.dao.impl.EmailDaoImpl.getEmailsByEmployee(EmailDaoImpl.java:25)
at com.alan.easyoa.test.insertDate.testList(insertDate.java:78)
at com.alan.easyoa.test.insertDate.main(insertDate.java:83)
Caused by: org.hibernate.QueryException: unexpected char: '@' [from com.alan.easyoa.entity.Email e where e.employees = com.alan.easyoa.entity.Employee@134eb84]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
at $Proxy9.createQuery(Unknown Source)
at com.alan.easyoa.dao.impl.EmailDaoImpl$1.doInHibernate(EmailDaoImpl.java:35)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 4 more
junit测试代码如下：
@Test
public void testList(){
PageUtil pageUtil = new PageUtil();
pageUtil.setCurrentPage(1);
pageUtil.setFirstPage(true);
pageUtil.setPageSize(4);
EmailDaoImpl empl = new EmailDaoImpl();
Employee employee = new Employee();
employee.setEmail("[email protected]");
List<Email> emails = empl.getEmailsByEmployee(employee, true, pageUtil);
System.out.println(emails.size());
}各位前辈能帮忙看看嘛？先谢谢了？小弟为这个东西困扰一整天了哦。我总是觉得是这个段hsql语句写得有问题但是又不知道问题出在哪里：
Object object = session.createQuery("from Email e where e.employees = "+e).setFirstResult(fister).setMaxResults(max).list();
我把我的需求简单将一下吧，那个Email实体类对应一个email表，那个Employee也对应一个表employee，由于email和employee是多对多关系，所以hibernate自动给他们添加了一个中间表email_employee，其中有两个列，一个是email表的id一个是employee的email那个字段，假如这里面都有相应的数据，那么我现在想取employee表中的某个员工发送的邮件，每次只取固定的条数，那么此时我应该怎么写hsql语句呢？不知道我表达清楚了没有。
谢谢了。
解决方案 »
- struts2和spring结合，action需要create()方法？
- struts2中的There is no Action mapped for namespace / and action name LoginRegist.
- 探讨总结WEB打印！！！
- jsp 页面中如何设计上下滚动的页面？还有就是一个固定表格中的数据能否放到上下滚动页中进行滚动显示呢？
- 请教高手：填写标签库描述文件错在哪？？
- 新人问一个关于访问优化的问题
- sql Server2k怎么读取text字段
- 高分求解linux下的中文问题（在线等待)
- el 表达是为什么获取到的url多个值都是一样的？
- 500错误求解决
- map的使用
- JDK有免安装？
private HibernateTemplate hibernateTemplate = new HibernateTemplate(); @SuppressWarnings("unchecked")
public List<Email> getEmailsByEmployee(final Employee e, final boolean isInbox,final PageUtil pageUtil) {
hibernateTemplate.setSessionFactory(new AnnotationConfiguration().configure().buildSessionFactory());
return (List<Email>)hibernateTemplate.execute(new HibernateCallback(){
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
session.beginTransaction();
//最多读取多少条记录
int max = (pageUtil.getCurrentPage()+1)*pageUtil.getPageSize();
//从那一条开始读取
int fister = pageUtil.getCurrentPage()*pageUtil.getPageSize();
pageUtil.setCurrentPage(pageUtil.getCurrentPage()+1);
//pageUtil.setAllRow((Integer)session.createQuery("count(*)from Email e ").uniqueResult());
Object object = session.createQuery("from Email e where e.employees = :em").setString("em", e.getEmail()).setFirstResult(fister).setMaxResults(max).list();
session.getTransaction().commit();
return object;
}});
}
sql语句打印出来了，但是。
Hibernate:
select
*
from
( select
row_.*,
rownum rownum_
from
( select
email0_.id as id2_,
email0_.content as content2_,
email0_.send as send2_,
email0_.sendTime as sendTime2_,
email0_.title as title2_
from
Email email0_,
Email_Employee employees1_,
Employee employee2_
where
email0_.id=employees1_.emails_id
and employees1_.employees_email=employee2_.email
and .=? ) row_ )
where
rownum_ <= ?
and rownum_ > ?
Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.alan.easyoa.dao.impl.EmailDaoImpl.getEmailsByEmployee(EmailDaoImpl.java:25)
at com.alan.easyoa.test.insertDate.testList(insertDate.java:78)
at com.alan.easyoa.test.insertDate.main(insertDate.java:83)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2235)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at com.alan.easyoa.dao.impl.EmailDaoImpl$1.doInHibernate(EmailDaoImpl.java:35)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
... 4 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式 at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
... 13 more我检查了没错呀，可是却报错了，而且sql语句结尾的部分确实有点奇怪：
where
email0_.id=employees1_.emails_id
and employees1_.employees_email=employee2_.email
and .=? ) row_ )
，搞不懂，彻底蒙，求前辈们指教：
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式谢谢了
Employee epl=session.createQuery("from Employee e where e.email=:eml").uniqueResult();
List<Email> list= epl.getEmails();//返回该员工所对应发送的email集合
//可以选择操作集合 如果直接写hsql语句这样不知道可不可行没试过
createQuery("select e.emails from Employy e where e.email=:eml").setString("eml",值)
.setFirstResult(start).setMaxResult(end);没有带电脑，只是个人想法，不知道可不可行，不过可以去试试
所以后台就报错了。
unexpected char: '@'
怎么回事。