samshi

structs2 的 if标签怎么做判断???请各位帮帮看看!!!谢谢了.
我在jsp里写

 <s:label label="中文名" value="${artistVO.chineseName}"/>

我要在页面输出"中文名"的时候,做一个判断,就是中文名不是 "无"或"缺" 的时候再输出.
用<s:if test="">该怎么写?
structs2文档里有一段关于<s:if test="">的例子

<s:if test="'foo' in {'foo','bar'}">
   muhahaha
</s:if>
于是我照葫芦画瓢
 <s:if test="${'artistVO.chineseName' not in {'null','','无','缺','未知'}}">
 <s:label label="中文名" value="${artistVO.chineseName}"/>
</s:if>

没有中文的时候还都正确,遇到中文的时候就不对了.这难道是中文问题吗?

我在用hibernate对mysql进行分页的方法
/**
  * 函数说明：获得所有的信息
  * 参数说明：
  * 返回值：信息的集合
  */
 public List getProducts(final int pageSize, final int startRow) throws HibernateException { 
     return this.getHibernateTemplate().executeFind(new HibernateCallback(){

         public Object doInHibernate(Session session) throws HibernateException, SQLException {
        
             Query query=session.createQuery("FROM Products as p");
             query.setMaxResults(pageSize);
             query.setFirstResult(startRow);    
    
             List list = query.list();
       
             return list;
         }
        });

 }

运行时怎么老给出异常阿？请帮帮我看看好吗？
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
java.sql.SQLException: Syntax error or access violation,  message from server: "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 '40 products0_.game_id as game1_0_, products0_.game_name_en as game2_0_, products' at line 1"