开发用的工具
diff --git a/tools/hqlbuilder/pom.xml b/tools/hqlbuilder/pom.xml
new file mode 100755
index 0000000..ab5ad47
--- /dev/null
+++ b/tools/hqlbuilder/pom.xml
@@ -0,0 +1,171 @@
+<?xml version="1.0"?>
+<project
+ xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
+ xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
+ <modelVersion>4.0.0</modelVersion>
+ <groupId>com.ekingstar.hibernate</groupId>
+ <artifactId>hql-builder</artifactId>
+ <version>1.0.0</version>
+ <name>HQL Builder</name>
+ <properties>
+ <mockito.version>1.9.5</mockito.version>
+ <testng.version>6.5.2</testng.version>
+ <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+ <downloadJavadocs>true</downloadJavadocs>
+ <logback.version>1.0.7</logback.version>
+ <slf4j.version>1.6.6</slf4j.version>
+ </properties>
+ <distributionManagement>
+ <repository>
+ <id>ekingstar-releases</id>
+ <name>internal release</name>
+ <url>http://app.supwisdom.com:81/artifactory/libs-release-local</url>
+ </repository>
+ <snapshotRepository>
+ <id>ekingstar-snapshots</id>
+ <name>internal Snapshots</name>
+ <url>http://app.supwisdom.com:81/artifactory/libs-snapshot-local</url>
+ </snapshotRepository>
+ <downloadUrl>http://app.supwisdom.com:81/artifactory</downloadUrl>
+ </distributionManagement>
+ <dependencyManagement>
+ <dependencies>
+ <dependency>
+ <groupId>org.slf4j</groupId>
+ <artifactId>slf4j-api</artifactId>
+ <version>1.6.6</version>
+ </dependency>
+ <dependency>
+ <groupId>ch.qos.logback</groupId>
+ <artifactId>logback-core</artifactId>
+ <version>1.0.7</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>ch.qos.logback</groupId>
+ <artifactId>logback-classic</artifactId>
+ <version>1.0.7</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>org.mockito</groupId>
+ <artifactId>mockito-all</artifactId>
+ <version>1.9.5</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>org.testng</groupId>
+ <artifactId>testng</artifactId>
+ <version>6.5.2</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>com.ekingstar.commons</groupId>
+ <artifactId>commons</artifactId>
+ <version>1.0.0</version>
+ </dependency>
+ </dependencies>
+ </dependencyManagement>
+ <dependencies>
+ <dependency>
+ <groupId>com.ekingstar.commons</groupId>
+ <artifactId>commons</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>net.sf.jxls</groupId>
+ <artifactId>jxls-core</artifactId>
+ <version>1.0.3</version>
+ <scope>compile</scope>
+ <optional>true</optional>
+ </dependency>
+ <dependency>
+ <groupId>org.slf4j</groupId>
+ <artifactId>slf4j-api</artifactId>
+ <version>1.6.6</version>
+ <scope>compile</scope>
+ </dependency>
+ <dependency>
+ <groupId>org.testng</groupId>
+ <artifactId>testng</artifactId>
+ <version>6.5.2</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>org.mockito</groupId>
+ <artifactId>mockito-all</artifactId>
+ <version>1.9.5</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>ch.qos.logback</groupId>
+ <artifactId>logback-core</artifactId>
+ <version>1.0.7</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>ch.qos.logback</groupId>
+ <artifactId>logback-classic</artifactId>
+ <version>1.0.7</version>
+ <scope>test</scope>
+ </dependency>
+ <dependency>
+ <groupId>org.hibernate</groupId>
+ <artifactId>hibernate-core</artifactId>
+ <version>4.2.4.Final</version>
+ <scope>provided</scope>
+ </dependency>
+ </dependencies>
+ <build>
+ <plugins>
+ <plugin>
+ <artifactId>maven-compiler-plugin</artifactId>
+ <version>3.0</version>
+ <configuration>
+ <source>1.6</source>
+ <target>1.6</target>
+ <encoding>UTF-8</encoding>
+ </configuration>
+ </plugin>
+ <plugin>
+ <artifactId>maven-source-plugin</artifactId>
+ <executions>
+ <execution>
+ <id>attach-sources</id>
+ <phase>deploy</phase>
+ <goals>
+ <goal>jar-no-fork</goal>
+ </goals>
+ </execution>
+ </executions>
+ </plugin>
+ <plugin>
+ <artifactId>maven-javadoc-plugin</artifactId>
+ <executions>
+ <execution>
+ <id>attach-javadocs</id>
+ <phase>deploy</phase>
+ <goals>
+ <goal>jar</goal>
+ </goals>
+ </execution>
+ </executions>
+ </plugin>
+ <plugin>
+ <!-- explicitly define maven-deploy-plugin after other to force exec
+ order -->
+ <artifactId>maven-deploy-plugin</artifactId>
+ <executions>
+ <execution>
+ <id>deploy</id>
+ <phase>deploy</phase>
+ <goals>
+ <goal>deploy</goal>
+ </goals>
+ </execution>
+ </executions>
+ </plugin>
+ </plugins>
+ </build>
+
+</project>
+
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/QuerySupport.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/QuerySupport.java
new file mode 100644
index 0000000..97ec96a
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/QuerySupport.java
@@ -0,0 +1,159 @@
+package com.ekingstar.hibernate;
+import java.util.Collection;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+
+import org.hibernate.Query;
+import org.hibernate.Session;
+
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.LimitQuery;
+import com.ekingstar.hibernate.query.builder.Condition;
+
+ public final class QuerySupport {
+ private QuerySupport() {
+ super();
+ }
+
+ private static Query buildHibernateQuery(com.ekingstar.hibernate.query.Query<?> bquery,
+ final Session session) {
+ Query hibernateQuery = null;
+ if (bquery.getLang().equals(com.ekingstar.hibernate.query.Lang.HQL)) {
+ hibernateQuery = session.createQuery(bquery.getStatement());
+ } else {
+ hibernateQuery = session.createSQLQuery(bquery.getStatement());
+ }
+ if (bquery.isCacheable()) hibernateQuery.setCacheable(bquery.isCacheable());
+ setParameter(hibernateQuery, bquery.getParams());
+ return hibernateQuery;
+ }
+
+ /**
+ * 统计该查询的记录数
+ *
+ * @param limitQuery
+ * @param hibernateSession
+ * @return data count
+ */
+ public static int count(final com.ekingstar.hibernate.query.LimitQuery<?> limitQuery,
+ final Session hibernateSession) {
+ final com.ekingstar.hibernate.query.Query<?> cntQuery = limitQuery.getCountQuery();
+ if (null == cntQuery) {
+ Query hibernateQuery = buildHibernateQuery(limitQuery, hibernateSession);
+ return hibernateQuery.list().size();
+ } else {
+ Query hibernateQuery = buildHibernateQuery(cntQuery, hibernateSession);
+ final Number count = (Number) (hibernateQuery.uniqueResult());
+ if (null == count) {
+ return 0;
+ } else {
+ return count.intValue();
+ }
+ }
+ }
+
+ /**
+ * 查询结果集
+ *
+ * @param query
+ * @param session
+ * @return result list
+ */
+ @SuppressWarnings("unchecked")
+ public static <T> List<T> find(final com.ekingstar.hibernate.query.Query<T> query, final Session session) {
+ if (query instanceof LimitQuery<?>) {
+ LimitQuery<T> limitQuery = (LimitQuery<T>) query;
+ Query hibernateQuery = buildHibernateQuery(limitQuery, session);
+ if (null == limitQuery.getLimit()) {
+ return hibernateQuery.list();
+ } else {
+ final PageLimit limit = limitQuery.getLimit();
+ hibernateQuery.setFirstResult((limit.getPageNo() - 1) * limit.getPageSize()).setMaxResults(
+ limit.getPageSize());
+ return hibernateQuery.list();
+ }
+ } else {
+ return buildHibernateQuery(query, session).list();
+ }
+ }
+
+ /**
+ * 为query设置JPA style参数
+ *
+ * @param query
+ * @param argument
+ */
+ public static Query setParameter(final Query query, final Object[] argument) {
+ if (argument != null && argument.length > 0) {
+ for (int i = 0; i < argument.length; i++)
+ query.setParameter(String.valueOf(i + 1), argument[i]);
+ }
+ return query;
+ }
+
+ /**
+ * 为query设置参数
+ *
+ * @param query
+ * @param parameterMap
+ * @return query
+ */
+ public static Query setParameter(final Query query, final Map<String, Object> parameterMap) {
+ if (parameterMap != null && !parameterMap.isEmpty()) {
+ for (final Iterator<String> ite = parameterMap.keySet().iterator(); ite.hasNext();) {
+ final String parameterName = ite.next();
+ if (null == parameterName) {
+ break;
+ }
+ final Object parameterValue = parameterMap.get(parameterName);
+ if (null == parameterValue) {
+ query.setParameter(parameterName, (Object) null);
+ } else if (parameterValue.getClass().isArray()) {
+ query.setParameterList(parameterName, (Object[]) parameterValue);
+ } else if (parameterValue instanceof Collection<?>) {
+ query.setParameterList(parameterName, (Collection<?>) parameterValue);
+ } else {
+ query.setParameter(parameterName, parameterValue);
+ }
+ }
+ }
+ return query;
+ }
+
+ /**
+ * 针对查询条件绑定查询的值
+ *
+ * @param query
+ * @param conditions
+ */
+ public static void bindValues(final Query query, final List<Condition> conditions) {
+ int position = 0;
+ boolean hasInterrogation = false; // 含有问号
+ for (final Iterator<Condition> iter = conditions.iterator(); iter.hasNext();) {
+ final Condition condition = (Condition) iter.next();
+ if (Strings.contains(condition.getContent(), "?")) {
+ hasInterrogation = true;
+ }
+ if (hasInterrogation) {
+ for (final Iterator<?> iterator = condition.getParams().iterator(); iterator.hasNext();) {
+ query.setParameter(position++, iterator.next());
+ }
+ } else {
+ final List<String> paramNames = condition.getParamNames();
+ for (int i = 0; i < paramNames.size(); i++) {
+ final String name = paramNames.get(i);
+ final Object value = condition.getParams().get(i);
+ if (value.getClass().isArray()) {
+ query.setParameterList(name, (Object[]) value);
+ } else if (value instanceof Collection<?>) {
+ query.setParameterList(name, (Collection<?>) value);
+ } else {
+ query.setParameter(name, value);
+ }
+ }
+ }
+ }
+ }
+ }
\ No newline at end of file
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EmptyKeyPredicate.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EmptyKeyPredicate.java
new file mode 100755
index 0000000..d3b6eb3
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EmptyKeyPredicate.java
@@ -0,0 +1,48 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.entity;
+
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.lang.functor.Predicate;
+
+/**
+ * <p>
+ * EmptyKeyPredicate class.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class EmptyKeyPredicate implements Predicate<Object> {
+
+ public Boolean apply(final Object value) {
+ boolean success = false;
+ if (null != value) {
+ if (value instanceof String) {
+ success = Strings.isEmpty((String) value);
+ } else if (value instanceof Number) {
+ success = (0 == ((Number) value).intValue());
+ } else {
+ throw new RuntimeException("unsupported key type");
+ }
+ }
+ return success;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EntityUtils.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EntityUtils.java
new file mode 100644
index 0000000..421269c
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/EntityUtils.java
@@ -0,0 +1,99 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.entity;
+
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import com.ekingstar.commons.lang.Strings;
+
+/**
+ * 实体类辅助工具箱
+ *
+ * @author chaostone 2005-10-31
+ * @version $Id: $
+ */
+public final class EntityUtils {
+
+ private static final Logger logger = LoggerFactory.getLogger(EntityUtils.class);
+
+ private EntityUtils() {
+ }
+
+ /**
+ * <p>
+ * getCommandName.
+ * </p>
+ *
+ * @param clazz a {@link java.lang.Class} object.
+ * @return a {@link java.lang.String} object.
+ */
+ public static String getCommandName(Class<?> clazz) {
+ String name = clazz.getName();
+ return Strings.uncapitalize(name.substring(name.lastIndexOf('.') + 1));
+ }
+
+ /**
+ * <p>
+ * getCommandName.
+ * </p>
+ *
+ * @param entityName a {@link java.lang.String} object.
+ * @return a {@link java.lang.String} object.
+ */
+ public static String getCommandName(String entityName) {
+ return Strings.uncapitalize(Strings.substringAfterLast(entityName, "."));
+ }
+
+ /**
+ * <p>
+ * getCommandName.
+ * </p>
+ *
+ * @param obj a {@link java.lang.Object} object.
+ * @return a {@link java.lang.String} object.
+ */
+ public static String getCommandName(Object obj) {
+ String name = obj.getClass().getName();
+ int dollar = name.indexOf('$');
+ if (-1 == dollar) {
+ name = name.substring(name.lastIndexOf('.') + 1);
+ } else {
+ name = name.substring(name.lastIndexOf('.') + 1, dollar);
+ }
+ return Strings.uncapitalize(name);
+ }
+
+ /**
+ * 为了取出CGLIB代来的代理命名
+ *
+ * @param clazz a {@link java.lang.Class} object.
+ * @return a {@link java.lang.String} object.
+ */
+ public static String getEntityClassName(Class<?> clazz) {
+ String name = clazz.getName();
+ int dollar = name.indexOf('$');
+ if (-1 == dollar) {
+ return name;
+ } else {
+ return name.substring(0, dollar);
+ }
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityKeyPredicate.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityKeyPredicate.java
new file mode 100755
index 0000000..69d6866
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityKeyPredicate.java
@@ -0,0 +1,40 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.entity;
+
+import com.ekingstar.commons.lang.functor.NotEmptyStringPredicate;
+import com.ekingstar.commons.lang.functor.NotZeroNumberPredicate;
+import com.ekingstar.commons.lang.functor.Predicate;
+
+/**
+ * 判断实体类中的主键是否是有效主键
+ *
+ * @author chaostone
+ */
+public class ValidEntityKeyPredicate implements Predicate<Object> {
+
+ public Boolean apply(Object value) {
+ if (null == value) return Boolean.FALSE;
+ if (value instanceof Number) return NotZeroNumberPredicate.Instance.apply((Number) value);
+ return NotEmptyStringPredicate.Instance.apply(value.toString());
+ }
+
+ public static final ValidEntityKeyPredicate Instance = new ValidEntityKeyPredicate();
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityPredicate.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityPredicate.java
new file mode 100755
index 0000000..0c307da
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/entity/ValidEntityPredicate.java
@@ -0,0 +1,57 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.entity;
+
+import java.io.Serializable;
+
+import com.ekingstar.commons.bean.PropertyUtils;
+import com.ekingstar.commons.lang.functor.Predicate;
+
+/**
+ * 有效实体判断谓词
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class ValidEntityPredicate implements Predicate<Object> {
+
+ public Boolean apply(final Object value) {
+ if (null == value) { return false; }
+ try {
+ Serializable key = PropertyUtils.getProperty(value, "id");
+ return ValidEntityKeyPredicate.Instance.apply(key);
+ } catch (Exception e) {
+ return false;
+ }
+ }
+
+ /** Constant <code>INSTANCE</code> */
+ public static final ValidEntityPredicate Instance = new ValidEntityPredicate();
+
+ /**
+ * <p>
+ * getInstance.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.entity.ValidEntityPredicate} object.
+ */
+ public static ValidEntityPredicate getInstance() {
+ return Instance;
+ }
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Lang.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Lang.java
new file mode 100755
index 0000000..fc14f24
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Lang.java
@@ -0,0 +1,48 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query;
+
+/**
+ * <p>
+ * Lang class.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public enum Lang {
+ SQL("sql"), HQL("hql");
+ private final String lang;
+
+ private Lang(String name) {
+ this.lang = name;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>lang</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getLang() {
+ return lang;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/LimitQuery.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/LimitQuery.java
new file mode 100755
index 0000000..0f982cd
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/LimitQuery.java
@@ -0,0 +1,60 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query;
+
+import com.ekingstar.commons.page.PageLimit;
+
+/**
+ * <p>
+ * LimitQuery interface.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public interface LimitQuery<T> extends Query<T> {
+
+ /**
+ * <p>
+ * getLimit.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.commons.page.PageLimit} object.
+ */
+ PageLimit getLimit();
+
+ /**
+ * <p>
+ * limit.
+ * </p>
+ *
+ * @param limit a {@link com.ekingstar.commons.page.PageLimit} object.
+ * @return a {@link com.ekingstar.hibernate.query.LimitQuery} object.
+ */
+ LimitQuery<T> limit(final PageLimit limit);
+
+ /**
+ * <p>
+ * getCountQuery.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Query} object.
+ */
+ Query<T> getCountQuery();
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Query.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Query.java
new file mode 100755
index 0000000..16e53cb
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/Query.java
@@ -0,0 +1,62 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query;
+
+import java.util.Map;
+
+/**
+ * 数据查询接口
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public interface Query<T> {
+
+ /**
+ * Returns query statement.
+ */
+ String getStatement();
+
+ /**
+ * <p>
+ * getParams.
+ * </p>
+ *
+ * @return a {@link java.util.Map} object.
+ */
+ Map<String, Object> getParams();
+
+ /**
+ * <p>
+ * isCacheable.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ boolean isCacheable();
+
+ /**
+ * <p>
+ * getLang.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Lang} object.
+ */
+ Lang getLang();
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/QueryBuilder.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/QueryBuilder.java
new file mode 100755
index 0000000..d65ba0f
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/QueryBuilder.java
@@ -0,0 +1,72 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query;
+
+import java.util.Map;
+
+import com.ekingstar.commons.page.PageLimit;
+
+/**
+ * <p>
+ * QueryBuilder interface.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public interface QueryBuilder<T> {
+
+ /**
+ * <p>
+ * build.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Query} object.
+ */
+ Query<T> build();
+
+ /**
+ * <p>
+ * limit.
+ * </p>
+ *
+ * @param limit a {@link com.ekingstar.commons.page.PageLimit} object.
+ * @return a {@link com.ekingstar.hibernate.query.QueryBuilder} object.
+ */
+ QueryBuilder<T> limit(PageLimit limit);
+
+ /**
+ * <p>
+ * getParams.
+ * </p>
+ *
+ * @return a {@link java.util.Map} object.
+ */
+ Map<String, Object> getParams();
+
+ /**
+ * <p>
+ * params.
+ * </p>
+ *
+ * @param newParams a {@link java.util.Map} object.
+ * @return a {@link com.ekingstar.hibernate.query.QueryBuilder} object.
+ */
+ QueryBuilder<T> params(Map<String, Object> newParams);
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQuery.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQuery.java
new file mode 100755
index 0000000..4986430
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQuery.java
@@ -0,0 +1,174 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.Map;
+
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.QueryBuilder;
+
+/**
+ * 抽象查询
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public abstract class AbstractQuery<T> implements QueryBuilder<T> {
+ /** query 查询语句 */
+ protected String queryStr;
+
+ /** count 计数语句 */
+ protected String countStr;
+
+ /** 分页 */
+ protected PageLimit limit;
+
+ /** 参数 */
+ protected Map<String, Object> params;
+
+ /** 缓存查询结果 */
+ protected boolean cacheable = false;
+
+ /**
+ * Returns limit
+ */
+ public PageLimit getLimit() {
+ return limit;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>limit</code>.
+ * </p>
+ *
+ * @param limit a {@link com.ekingstar.commons.page.PageLimit} object.
+ */
+ public void setLimit(final PageLimit limit) {
+ this.limit = limit;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>params</code>.
+ * </p>
+ *
+ * @return a {@link java.util.Map} object.
+ */
+ public Map<String, Object> getParams() {
+ return params;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>countStr</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getCountStr() {
+ return countStr;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>countStr</code>.
+ * </p>
+ *
+ * @param countStr a {@link java.lang.String} object.
+ */
+ public void setCountStr(final String countStr) {
+ this.countStr = countStr;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>queryStr</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getQueryStr() {
+ return queryStr;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>queryStr</code>.
+ * </p>
+ *
+ * @param queryStr a {@link java.lang.String} object.
+ */
+ public void setQueryStr(final String queryStr) {
+ this.queryStr = queryStr;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>params</code>.
+ * </p>
+ *
+ * @param params a {@link java.util.Map} object.
+ */
+ public void setParams(final Map<String, Object> params) {
+ this.params = params;
+ }
+
+ /**
+ * <p>
+ * toQueryString.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public abstract String toQueryString();
+
+ /**
+ * <p>
+ * toCountString.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String toCountString() {
+ return countStr;
+ }
+
+ /**
+ * <p>
+ * isCacheable.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean isCacheable() {
+ return cacheable;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>cacheable</code>.
+ * </p>
+ *
+ * @param cacheable a boolean.
+ */
+ public void setCacheable(final boolean cacheable) {
+ this.cacheable = cacheable;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQueryBuilder.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQueryBuilder.java
new file mode 100755
index 0000000..7a66f9c
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/AbstractQueryBuilder.java
@@ -0,0 +1,193 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.List;
+import java.util.Map;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.commons.collection.Order;
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.Lang;
+import com.ekingstar.hibernate.query.Query;
+import com.ekingstar.hibernate.query.QueryBuilder;
+
+/**
+ * <p>
+ * Abstract AbstractQueryBuilder class.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public abstract class AbstractQueryBuilder<T> implements QueryBuilder<T> {
+
+ /** Constant <code>INNER_JOIN=" left join "</code> */
+ public static final String INNER_JOIN = " left join ";
+
+ /** Constant <code>OUTER_JOIN=" outer join "</code> */
+ public static final String OUTER_JOIN = " outer join ";
+
+ /** Constant <code>LEFT_OUTER_JOIN=" left outer join "</code> */
+ public static final String LEFT_OUTER_JOIN = " left outer join ";
+
+ /** Constant <code>RIGHT_OUTER_JOIN=" right outer join "</code> */
+ public static final String RIGHT_OUTER_JOIN = " right outer join ";
+
+ /** query 查询语句 */
+ protected String statement;
+
+ /** 分页 */
+ protected PageLimit limit;
+
+ /** 参数 */
+ protected Map<String, Object> params;
+
+ protected String select;
+
+ protected String from;
+
+ /** 别名 */
+ protected String alias;
+
+ protected List<Condition> conditions = CollectUtils.newArrayList();
+
+ protected List<Order> orders = CollectUtils.newArrayList();
+
+ protected List<String> groups = CollectUtils.newArrayList();
+
+ protected String having;
+
+ /** 缓存查询结果 */
+ protected boolean cacheable = false;
+
+ /**
+ * Returns params.
+ */
+ public Map<String, Object> getParams() {
+ return (null == params) ? Conditions.getParamMap(conditions) : CollectUtils.newHashMap(params);
+ }
+
+ /**
+ * Return entity's alias
+ */
+ public String getAlias() {
+ return alias;
+ }
+
+ /**
+ * <p>
+ * isCacheable.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean isCacheable() {
+ return cacheable;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>limit</code>.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.commons.page.PageLimit} object.
+ */
+ public PageLimit getLimit() {
+ return limit;
+ }
+
+ /**
+ * <p>
+ * build.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Query} object.
+ */
+ public Query<T> build() {
+ QueryBean<T> queryBean = new QueryBean<T>();
+ queryBean.setStatement(genStatement());
+ queryBean.setParams(getParams());
+ if (null != limit) {
+ queryBean.setLimit(new PageLimit(limit.getPageNo(), limit.getPageSize()));
+ }
+ queryBean.setCountStatement(genCountStatement());
+ queryBean.setCacheable(cacheable);
+ queryBean.setLang(getLang());
+ return queryBean;
+ }
+
+ /**
+ * <p>
+ * getLang.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Lang} object.
+ */
+ abstract protected Lang getLang();
+
+ /**
+ * 生成查询语句（如果查询语句已经存在则不进行生成）
+ */
+ protected String genStatement() {
+ if (Strings.isNotEmpty(statement)) return statement;
+ else return genQueryStatement(true);
+ }
+
+ /**
+ * <p>
+ * genCountStatement.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ abstract protected String genCountStatement();
+
+ /**
+ * <p>
+ * genQueryStatement.
+ * </p>
+ *
+ * @param hasOrder a boolean.
+ * @return a {@link java.lang.String} object.
+ */
+ protected String genQueryStatement(final boolean hasOrder) {
+ if (null == from) return statement;
+ final StringBuilder buf = new StringBuilder(50);
+ buf.append((select == null) ? "" : (select + " ")).append(from);
+ if (!conditions.isEmpty()) buf.append(" where ").append(Conditions.toQueryString(conditions));
+
+ if (!groups.isEmpty()) {
+ buf.append(" group by ");
+ for (final String groupBy : groups)
+ buf.append(groupBy).append(',');
+ buf.deleteCharAt(buf.length() - 1);
+ }
+ if (hasOrder && !CollectUtils.isEmpty(orders)) buf.append(' ').append(Order.toSortString(orders));
+
+ if (null != having) buf.append(" having ").append(having);
+ return buf.toString();
+ }
+
+ public List<Condition> getConditions() {
+ return conditions;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Condition.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Condition.java
new file mode 100755
index 0000000..35f44f9
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Condition.java
@@ -0,0 +1,324 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.ArrayList;
+import java.util.Collections;
+import java.util.List;
+
+import com.ekingstar.commons.lang.Strings;
+
+/**
+ * 查询条件 使用例子如下
+ * <p>
+ * <blockquote>
+ *
+ * <pre>
+ * new Condition("std.id=?",new Long(2));
+ * 或者 Condition("std.id=:std_id",new Long(2));
+ * ?绑定单值.命名参数允许绑定多值.但是只能由字母,数组和下划线组成
+ * 一组condition只能采取上面一种形式
+ * </pre>
+ *
+ * </blockquote>
+ * <p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class Condition {
+
+ private final String content;
+
+ private final List<Object> params = new ArrayList<Object>(1);
+
+ /**
+ * <p>
+ * Constructor for Condition.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ */
+ public Condition(final String content) {
+ this.content = content;
+ }
+
+ /**
+ * <p>
+ * Constructor for Condition.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ */
+ public Condition(final String content, Object param1) {
+ this.content = content;
+ params.add(param1);
+ }
+
+ /**
+ * <p>
+ * Constructor for Condition.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ */
+ public Condition(final String content, Object param1, Object param2) {
+ this(content, param1, param2, null);
+ }
+
+ /**
+ * <p>
+ * Constructor for Condition.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ * @param param3 a {@link java.lang.Object} object.
+ */
+ public Condition(final String content, Object param1, Object param2, Object param3) {
+ this.content = content;
+ if (null != param1) {
+ params.add(param1);
+ }
+ if (null != param2) {
+ params.add(param2);
+ }
+ if (null != param3) {
+ params.add(param3);
+ }
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>content</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getContent() {
+ return content;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>params</code>.
+ * </p>
+ *
+ * @return a {@link java.util.List} object.
+ */
+ public List<Object> getParams() {
+ return params;
+ }
+
+ /**
+ * <p>
+ * isNamed.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean isNamed() {
+ return !Strings.contains(content, "?");
+ }
+
+ /**
+ * 得到查询条件中所有的命名参数.
+ *
+ * @return a {@link java.util.List} object.
+ */
+ public List<String> getParamNames() {
+ if (!Strings.contains(content, ":")) { return Collections.emptyList(); }
+ final List<String> params = new ArrayList<String>();
+ int index = 0;
+ do {
+ final int colonIndex = content.indexOf(':', index);
+ if (-1 == colonIndex) {
+ break;
+ }
+ index = colonIndex + 1;
+ while (index < content.length()) {
+ final char c = content.charAt(index);
+ if (isValidIdentifierStarter(c)) {
+ index++;
+ } else {
+ break;
+ }
+ }
+ final String paramName = content.substring(colonIndex + 1, index);
+ if (!params.contains(paramName)) {
+ params.add(paramName);
+ }
+ } while (index < content.length());
+ return params;
+ }
+
+ private static boolean isValidIdentifierStarter(final char ch) {
+ return (('a' <= ch && ch <= 'z') || ('A' <= ch && ch <= 'Z') || (ch == '_') || ('0' <= ch && ch <= '9'));
+ }
+
+ /**
+ * <p>
+ * param.
+ * </p>
+ *
+ * @param value a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public Condition param(final Object value) {
+ params.add(value);
+ return this;
+ }
+
+ /**
+ * <p>
+ * params.
+ * </p>
+ *
+ * @param values a {@link java.util.List} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public Condition params(final List<?> values) {
+ params.clear();
+ params.addAll(values);
+ return this;
+ }
+
+ /**
+ * <p>
+ * toString.
+ * </p>
+ *
+ * @see java.lang.Object#toString()
+ * @return a {@link java.lang.String} object.
+ */
+ public String toString() {
+ final StringBuilder str = new StringBuilder(content).append(" ");
+ for (final Object value : params) {
+ str.append(value);
+ }
+ return str.toString();
+ }
+
+ /** {@inheritDoc} */
+ public boolean equals(final Object obj) {
+ if (null == getContent() || !(obj instanceof Condition)) {
+ return false;
+ } else {
+ return getContent().equals(((Condition) obj).getContent());
+ }
+ }
+
+ /**
+ * <p>
+ * hashCode.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int hashCode() {
+ if (null == content) {
+ return 0;
+ } else {
+ return content.hashCode();
+ }
+ }
+
+ // 以下是几个方便的方法
+ /**
+ * <p>
+ * eq.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Number} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition eq(final String content, final Number value) {
+ return new Condition(content + " = " + value);
+ }
+
+ /**
+ * <p>
+ * eq.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition eq(final String content, final String value) {
+ return new Condition(content + " = '" + value + "'");
+ }
+
+ /**
+ * <p>
+ * le.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Number} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition le(final String content, final Number value) {
+ return new Condition(content + " <= " + value);
+ }
+
+ /**
+ * <p>
+ * ge.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Number} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition ge(final String content, final Number value) {
+ return new Condition(content + " >= " + value);
+ }
+
+ /**
+ * <p>
+ * ne.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Number} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition ne(final String content, final Number value) {
+ return new Condition(content + " <> " + value);
+ }
+
+ /**
+ * <p>
+ * like.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param value a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ */
+ public static Condition like(final String content, final String value) {
+ return new Condition(content + " like '%" + value + "%'");
+ }
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Conditions.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Conditions.java
new file mode 100755
index 0000000..75603ec
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/Conditions.java
@@ -0,0 +1,123 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.Arrays;
+import java.util.HashMap;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.commons.lang.Assert;
+import com.ekingstar.commons.lang.Strings;
+
+/**
+ * 条件提取辅助类
+ *
+ * @author chaostone
+ */
+public final class Conditions {
+ private static final Logger logger = LoggerFactory.getLogger(Conditions.class);
+
+ private Conditions() {
+ super();
+ }
+
+ public static Condition and(Condition... conditions) {
+ return concat(Arrays.asList(conditions), "and");
+ }
+
+ public static Condition and(List<Condition> conditions) {
+ return concat(conditions, "and");
+ }
+
+ public static Condition or(Condition... conditions) {
+ return concat(Arrays.asList(conditions), "or");
+ }
+
+ public static Condition or(List<Condition> conditions) {
+ return concat(conditions, "or");
+ }
+
+ static Condition concat(List<Condition> conditions, String andor) {
+ Assert.isTrue(!conditions.isEmpty(), "conditions shouldn't be empty!");
+ if (conditions.size() == 1) return conditions.get(0);
+ StringBuffer sb = new StringBuffer();
+ List<Object> params = CollectUtils.newArrayList();
+ sb.append("(");
+ for (Condition con : conditions) {
+ sb.append(" " + andor + " (");
+ sb.append(con.getContent());
+ sb.append(')');
+ params.addAll(con.getParams());
+ }
+ sb.append(")");
+ sb.replace(0, (" " + andor + " ").length() + 1, "(");
+ return new Condition(sb.toString()).params(params);
+ }
+
+ public static String toQueryString(final List<Condition> conditions) {
+ if (null == conditions || conditions.isEmpty()) { return ""; }
+ final StringBuilder buf = new StringBuilder("");
+ for (final Iterator<Condition> iter = conditions.iterator(); iter.hasNext();) {
+ final Condition con = iter.next();
+ buf.append('(').append(con.getContent()).append(')');
+ if (iter.hasNext()) {
+ buf.append(" and ");
+ }
+ }
+ return buf.toString();
+ }
+
+ /**
+ * 获得条件的绑定参数映射
+ *
+ * @param conditions
+ */
+ public static Map<String, Object> getParamMap(final List<Condition> conditions) {
+ final Map<String, Object> params = new HashMap<String, Object>();
+ for (final Condition con : conditions) {
+ params.putAll(getParamMap(con));
+ }
+ return params;
+ }
+
+ /**
+ * 获得条件的绑定参数映射
+ *
+ * @param condition
+ */
+ public static Map<String, Object> getParamMap(final Condition condition) {
+ final Map<String, Object> params = new HashMap<String, Object>();
+ if (!Strings.contains(condition.getContent(), "?")) {
+ final List<String> paramNames = condition.getParamNames();
+ if (paramNames.size() > condition.getParams().size()) { throw new RuntimeException(
+ "condition params not set [" + condition.getContent() + "] with value:" + condition.getParams()); }
+ for (int i = 0; i < paramNames.size(); i++) {
+ params.put(paramNames.get(i), condition.getParams().get(i));
+ }
+ }
+ return params;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/OqlBuilder.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/OqlBuilder.java
new file mode 100755
index 0000000..5e11130
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/OqlBuilder.java
@@ -0,0 +1,561 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import static com.ekingstar.commons.lang.Strings.concat;
+
+import java.util.Collection;
+import java.util.Collections;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.commons.collection.Order;
+import com.ekingstar.commons.lang.Assert;
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.entity.EntityUtils;
+import com.ekingstar.hibernate.query.Lang;
+
+/**
+ * 实体类查询 Object Query Language Builder
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class OqlBuilder<T> extends AbstractQueryBuilder<T> {
+
+ /** 查询实体类 */
+ protected Class<T> entityClass;
+
+ /**
+ * <p>
+ * Constructor for OqlBuilder.
+ * </p>
+ */
+ protected OqlBuilder() {
+ super();
+ }
+
+ /**
+ * <p>
+ * hql.
+ * </p>
+ *
+ * @param hql a {@link java.lang.String} object.
+ * @param <E> a E object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public static <E> OqlBuilder<E> hql(final String hql) {
+ OqlBuilder<E> query = new OqlBuilder<E>();
+ query.statement = hql;
+ return query;
+ }
+
+ /**
+ * <p>
+ * from.
+ * </p>
+ *
+ * @param from a {@link java.lang.String} object.
+ * @param <E> a E object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public static <E> OqlBuilder<E> from(final String from) {
+ OqlBuilder<E> query = new OqlBuilder<E>();
+ query.newFrom(from);
+ return query;
+ }
+
+ /**
+ * <p>
+ * from.
+ * </p>
+ *
+ * @param entityName a {@link java.lang.String} object.
+ * @param alias a {@link java.lang.String} object.
+ * @param <E> a E object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ @SuppressWarnings("unchecked")
+ public static <E> OqlBuilder<E> from(final String entityName, final String alias) {
+ OqlBuilder<E> query = new OqlBuilder<E>();
+ query.alias = alias;
+ query.select = "select " + alias;
+ query.from = concat("from ", entityName, " ", alias);
+ return query;
+ }
+
+ /**
+ * <p>
+ * from.
+ * </p>
+ *
+ * @param entityClass a {@link java.lang.Class} object.
+ * @param <E> a E object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public static <E> OqlBuilder<E> from(final Class<E> entityClass) {
+ return from(entityClass, EntityUtils.getCommandName(entityClass.getName()));
+ }
+
+ /**
+ * <p>
+ * from.
+ * </p>
+ *
+ * @param entityClass a {@link java.lang.Class} object.
+ * @param alias a {@link java.lang.String} object.
+ * @param <E> a E object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ @SuppressWarnings("unchecked")
+ public static <E> OqlBuilder<E> from(final Class<E> entityClass, final String alias) {
+ OqlBuilder<E> query = new OqlBuilder<E>();
+ query.entityClass = entityClass;
+ query.alias = alias;
+ query.select = "select " + alias;
+ query.from = concat("from ", entityClass.getName(), " ", alias);
+ return query;
+ }
+
+ /**
+ * <p>
+ * alias.
+ * </p>
+ *
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> alias(final String alias) {
+ this.alias = alias;
+ return this;
+ }
+
+ /**
+ * <p>
+ * join.
+ * </p>
+ *
+ * @param path a {@link java.lang.String} object.
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> join(final String path, final String alias) {
+ from = concat(from, " join ", path, " ", alias);
+ return this;
+ }
+
+ /**
+ * <p>
+ * join.
+ * </p>
+ *
+ * @param joinMode a {@link java.lang.String} object.
+ * @param path a {@link java.lang.String} object.
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> join(final String joinMode, final String path, final String alias) {
+ from = concat(from, " ", joinMode, " join ", path, " ", alias);
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ public OqlBuilder<T> params(final Map<String, Object> params) {
+ this.params = CollectUtils.newHashMap(params);
+ return this;
+ }
+
+ /**
+ * <p>
+ * param.
+ * </p>
+ *
+ * @param name a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> param(String name, Object value) {
+ if (null == this.params) {
+ params = new HashMap<String, Object>();
+ }
+ params.put(name, value);
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ public OqlBuilder<T> limit(final PageLimit limit) {
+ this.limit = limit;
+ return this;
+ }
+
+ /**
+ * <p>
+ * limit.
+ * </p>
+ *
+ * @param pageNo a int.
+ * @param pageSize a int.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> limit(final int pageNo, final int pageSize) {
+ this.limit = new PageLimit(pageNo, pageSize);
+ return this;
+ }
+
+ /**
+ * <p>
+ * cacheable.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> cacheable() {
+ this.cacheable = true;
+ return this;
+ }
+
+ /**
+ * <p>
+ * cacheable.
+ * </p>
+ *
+ * @param cacheable a boolean.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> cacheable(final boolean cacheable) {
+ this.cacheable = cacheable;
+ return this;
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param condition a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final Condition condition) {
+ if (Strings.isNotEmpty(statement)) { throw new RuntimeException(
+ "cannot add condition to a exists statement"); }
+ conditions.add(condition);
+ return this;
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final String content) {
+ return where(new Condition(content));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final String content, Object param1) {
+ return where(new Condition(content, param1));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final String content, Object param1, Object param2) {
+ return where(new Condition(content, param1, param2, null));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ * @param param3 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final String content, Object param1, Object param2, Object param3) {
+ return where(new Condition(content, param1, param2, param3));
+ }
+
+ /**
+ * 添加一组条件<br>
+ * query中不能添加条件集合作为一个条件,因此这里命名没有采用有区别性的addAll
+ *
+ * @param cons a {@link java.util.Collection} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> where(final Collection<Condition> cons) {
+ conditions.addAll(cons);
+ return this;
+ }
+
+ /**
+ * 声明排序字符串
+ *
+ * @param orderBy 排序字符串
+ * @return 查询构建器
+ */
+ public OqlBuilder<T> orderBy(final String orderBy) {
+ return orderBy(Order.parse(orderBy));
+ }
+
+ /**
+ * 指定排序字符串的位置
+ *
+ * @param index 从0开始
+ * @param orderBy 排序字符串
+ * @return 查询构建器
+ */
+ public OqlBuilder<T> orderBy(final int index, final String orderBy) {
+ if (null != orders) {
+ if (Strings.isNotEmpty(statement)) { throw new RuntimeException(
+ "cannot add order by to a exists statement."); }
+ this.orders.addAll(index, Order.parse(orderBy));
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * orderBy.
+ * </p>
+ *
+ * @param order a {@link com.ekingstar.commons.collection.Order} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> orderBy(final Order order) {
+ if (null != order) { return orderBy(Collections.singletonList(order)); }
+ return this;
+ }
+
+ /**
+ * <p>
+ * cleanOrders.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> clearOrders() {
+ this.orders.clear();
+ return this;
+ }
+
+ /**
+ * <p>
+ * orderBy.
+ * </p>
+ *
+ * @param orders a {@link java.util.List} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> orderBy(final List<Order> orders) {
+ if (null != orders) {
+ if (Strings.isNotEmpty(statement)) { throw new RuntimeException(
+ "cannot add order by to a exists statement."); }
+ this.orders.addAll(orders);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * select.
+ * </p>
+ *
+ * @param what a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> select(final String what) {
+ if (null == what) {
+ this.select = null;
+ } else {
+ if (what.toLowerCase().trim().startsWith("select")) {
+ this.select = what;
+ } else {
+ this.select = "select " + what;
+ }
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * newFrom.
+ * </p>
+ *
+ * @param from a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> newFrom(final String from) {
+ if (null == from) {
+ this.from = null;
+ } else {
+ if (Strings.contains(from.toLowerCase(), "from")) {
+ this.from = from;
+ } else {
+ this.from = "from " + from;
+ }
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * groupBy.
+ * </p>
+ *
+ * @param what a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> groupBy(final String what) {
+ if (Strings.isNotEmpty(what)) {
+ groups.add(what);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * Having subclause.
+ * </p>
+ *
+ * @param what having subclause
+ * @return this
+ */
+ public OqlBuilder<T> having(final String what) {
+ Assert.isTrue(null != groups && !groups.isEmpty());
+ if (Strings.isNotEmpty(what)) having = what;
+ return this;
+ }
+
+ /**
+ * 形成计数查询语句，如果不能形成，则返回""
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ protected String genCountStatement() {
+ StringBuilder countString = new StringBuilder("select count(*) ");
+ // 原始查询语句
+ final String genQueryStr = genQueryStatement(false);
+ if (Strings.isEmpty(genQueryStr)) { return ""; }
+ final String lowerCaseQueryStr = genQueryStr.toLowerCase();
+
+ if (Strings.contains(lowerCaseQueryStr, " group ")) { return ""; }
+ if (Strings.contains(lowerCaseQueryStr, " union ")) { return ""; }
+
+ final int indexOfFrom = findIndexOfFrom(lowerCaseQueryStr);
+ final String selectWhat = lowerCaseQueryStr.substring(0, indexOfFrom);
+ final int indexOfDistinct = selectWhat.indexOf("distinct");
+ // select distinct a from table;
+ if (-1 != indexOfDistinct) {
+ if (Strings.contains(selectWhat, ",")) {
+ return "";
+ } else {
+ countString = new StringBuilder("select count(");
+ countString.append(genQueryStr.substring(indexOfDistinct, indexOfFrom)).append(") ");
+ }
+ }
+
+ int orderIdx = genQueryStr.lastIndexOf(" order ");
+ if (-1 == orderIdx) orderIdx = genQueryStr.length();
+ countString.append(genQueryStr.substring(indexOfFrom, orderIdx));
+ return countString.toString();
+ }
+
+ /**
+ * Find index of from
+ *
+ * @param query
+ * @return -1 or from index
+ */
+ private int findIndexOfFrom(String query) {
+ if (query.startsWith("from")) return 0;
+ int fromIdx = query.indexOf(" from ");
+ if (-1 == fromIdx) return -1;
+ final int first = query.substring(0, fromIdx).indexOf("(");
+ if (first > 0) {
+ int leftCnt = 1;
+ int i = first + 1;
+ while (leftCnt != 0 && i < query.length()) {
+ if (query.charAt(i) == '(') leftCnt++;
+ else if (query.charAt(i) == ')') leftCnt--;
+ i++;
+ }
+ if (leftCnt > 0) return -1;
+ else {
+ fromIdx = query.indexOf(" from ", i);
+ return (fromIdx == -1) ? -1 : fromIdx + 1;
+ }
+ } else {
+ return fromIdx + 1;
+ }
+ }
+
+ /**
+ * <p>
+ * forEntity.
+ * </p>
+ *
+ * @param entityClass a {@link java.lang.Class} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public OqlBuilder<T> forEntity(final Class<T> entityClass) {
+ this.entityClass = entityClass;
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ @Override
+ protected Lang getLang() {
+ return Lang.HQL;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>entityClass</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.Class} object.
+ */
+ public Class<T> getEntityClass() {
+ return entityClass;
+ }
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/QueryBean.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/QueryBean.java
new file mode 100755
index 0000000..5dda29d
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/QueryBean.java
@@ -0,0 +1,198 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.Map;
+
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.Lang;
+import com.ekingstar.hibernate.query.LimitQuery;
+import com.ekingstar.hibernate.query.Query;
+
+/**
+ * <p>
+ * QueryBean class.
+ * </p>
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class QueryBean<T> implements LimitQuery<T> {
+
+ private Lang lang;
+
+ private String statement;
+
+ private String countStatement;
+
+ private PageLimit limit;
+
+ private boolean cacheable;
+
+ private Map<String, Object> params;
+
+ /**
+ * Returns count query {@link com.ekingstar.hibernate.query.Query}.
+ */
+ public Query<T> getCountQuery() {
+ if (Strings.isEmpty(countStatement)) { return null; }
+ QueryBean<T> bean = new QueryBean<T>();
+ bean.setStatement(countStatement);
+ bean.setLang(lang);
+ bean.setParams(params);
+ bean.setCacheable(cacheable);
+ return bean;
+ }
+
+ /**
+ * Returns statement.
+ */
+ public String getStatement() {
+ return statement;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>countStatement</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getCountStatement() {
+ return countStatement;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>limit</code>.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.commons.page.PageLimit} object.
+ */
+ public PageLimit getLimit() {
+ return limit;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>params</code>.
+ * </p>
+ *
+ * @return a {@link java.util.Map} object.
+ */
+ public Map<String, Object> getParams() {
+ return params;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>statement</code>.
+ * </p>
+ *
+ * @param statement a {@link java.lang.String} object.
+ */
+ public void setStatement(String statement) {
+ this.statement = statement;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>countStatement</code>.
+ * </p>
+ *
+ * @param countStatement a {@link java.lang.String} object.
+ */
+ public void setCountStatement(String countStatement) {
+ this.countStatement = countStatement;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>limit</code>.
+ * </p>
+ *
+ * @param limit a {@link com.ekingstar.commons.page.PageLimit} object.
+ */
+ public void setLimit(PageLimit limit) {
+ this.limit = limit;
+ }
+
+ /** {@inheritDoc} */
+ public LimitQuery<T> limit(PageLimit limit) {
+ this.limit = new PageLimit(limit.getPageNo(), limit.getPageSize());
+ return this;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>cacheable</code>.
+ * </p>
+ *
+ * @param cacheable a boolean.
+ */
+ public void setCacheable(boolean cacheable) {
+ this.cacheable = cacheable;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>params</code>.
+ * </p>
+ *
+ * @param params a {@link java.util.Map} object.
+ */
+ public void setParams(Map<String, Object> params) {
+ this.params = params;
+ }
+
+ /**
+ * <p>
+ * isCacheable.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean isCacheable() {
+ return cacheable;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>lang</code>.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Lang} object.
+ */
+ public Lang getLang() {
+ return lang;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>lang</code>.
+ * </p>
+ *
+ * @param lang a {@link com.ekingstar.hibernate.query.Lang} object.
+ */
+ public void setLang(Lang lang) {
+ this.lang = lang;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlBuilder.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlBuilder.java
new file mode 100755
index 0000000..42d8bf0
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlBuilder.java
@@ -0,0 +1,384 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.Collection;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.commons.collection.Order;
+import com.ekingstar.commons.lang.Assert;
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.Lang;
+
+/**
+ * sql查询
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class SqlBuilder extends AbstractQueryBuilder<Object[]> {
+ /**
+ * <p>
+ * sql.
+ * </p>
+ *
+ * @param queryStr a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public static SqlBuilder sql(final String queryStr) {
+ SqlBuilder sqlQuery = new SqlBuilder();
+ sqlQuery.statement = queryStr;
+ return sqlQuery;
+ }
+
+ /**
+ * <p>
+ * genCountStatement.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ protected String genCountStatement() {
+ return "select count(*) from (" + genQueryStatement(false) + ")";
+ }
+
+ /** {@inheritDoc} */
+ @Override
+ protected Lang getLang() {
+ return Lang.SQL;
+ }
+
+ /**
+ * <p>
+ * alias.
+ * </p>
+ *
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder alias(final String alias) {
+ this.alias = alias;
+ return this;
+ }
+
+ /**
+ * <p>
+ * join.
+ * </p>
+ *
+ * @param path a {@link java.lang.String} object.
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder join(final String path, final String alias) {
+ from += " join " + path + " " + alias;
+ return this;
+ }
+
+ /**
+ * <p>
+ * join.
+ * </p>
+ *
+ * @param joinMode a {@link java.lang.String} object.
+ * @param path a {@link java.lang.String} object.
+ * @param alias a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder join(final String joinMode, final String path, final String alias) {
+ from += " " + joinMode + " join " + path + " " + alias;
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ public SqlBuilder params(final Map<String, Object> params) {
+ this.params = CollectUtils.newHashMap(params);
+ ;
+ return this;
+ }
+
+ /**
+ * <p>
+ * param.
+ * </p>
+ *
+ * @param name a {@link java.lang.String} object.
+ * @param value a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder param(String name, Object value) {
+ if (null == this.params) {
+ params = new HashMap<String, Object>();
+ }
+ params.put(name, value);
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ public SqlBuilder limit(final PageLimit limit) {
+ this.limit = limit;
+ return this;
+ }
+
+ /**
+ * <p>
+ * limit.
+ * </p>
+ *
+ * @param pageNo a int.
+ * @param pageSize a int.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder limit(final int pageNo, final int pageSize) {
+ this.limit = new PageLimit(pageNo, pageSize);
+ return this;
+ }
+
+ /**
+ * <p>
+ * cacheable.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder cacheable() {
+ this.cacheable = true;
+ return this;
+ }
+
+ /**
+ * <p>
+ * cacheable.
+ * </p>
+ *
+ * @param cacheable a boolean.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder cacheable(final boolean cacheable) {
+ this.cacheable = cacheable;
+ return this;
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param condition a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final Condition condition) {
+ conditions.add(condition);
+ return this;
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final String content) {
+ return where(new Condition(content));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final String content, Object param1) {
+ return where(new Condition(content, param1));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final String content, Object param1, Object param2) {
+ return where(new Condition(content, param1, param2, null));
+ }
+
+ /**
+ * <p>
+ * where.
+ * </p>
+ *
+ * @param content a {@link java.lang.String} object.
+ * @param param1 a {@link java.lang.Object} object.
+ * @param param2 a {@link java.lang.Object} object.
+ * @param param3 a {@link java.lang.Object} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final String content, Object param1, Object param2, Object param3) {
+ return where(new Condition(content, param1, param2, param3));
+ }
+
+ /**
+ * 添加一组条件<br>
+ * query中不能添加条件集合作为一个条件,因此这里命名没有采用有区别性的addAll
+ *
+ * @param cons a {@link java.util.Collection} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder where(final Collection<Condition> cons) {
+ conditions.addAll(cons);
+ return this;
+ }
+
+ /**
+ * <p>
+ * orderBy.
+ * </p>
+ *
+ * @param orderBy a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder orderBy(final String orderBy) {
+ this.orders.addAll(Order.parse(orderBy));
+ return this;
+ }
+
+ /**
+ * <p>
+ * orderBy.
+ * </p>
+ *
+ * @param order a {@link com.ekingstar.commons.collection.Order} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder orderBy(final Order order) {
+ if (null != order) {
+ this.orders.add(order);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * cleanOrders.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder clearOrders() {
+ this.orders.clear();
+ return this;
+ }
+
+ /**
+ * <p>
+ * orderBy.
+ * </p>
+ *
+ * @param orders a {@link java.util.List} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder orderBy(final List<Order> orders) {
+ if (null != orders) {
+ this.orders.addAll(orders);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * select.
+ * </p>
+ *
+ * @param what a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder select(final String what) {
+ if (null == what) {
+ this.select = null;
+ } else {
+ if (Strings.contains(what.toLowerCase(), "select")) {
+ this.select = what;
+ } else {
+ this.select = "select " + what;
+ }
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * newFrom.
+ * </p>
+ *
+ * @param from a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder newFrom(final String from) {
+ if (null == from) {
+ this.from = null;
+ } else {
+ if (Strings.contains(from.toLowerCase(), "from")) {
+ this.from = from;
+ } else {
+ this.from = " from " + from;
+ }
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * groupBy.
+ * </p>
+ *
+ * @param what a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlBuilder} object.
+ */
+ public SqlBuilder groupBy(final String what) {
+ if (Strings.isNotEmpty(what)) groups.add(what);
+ return this;
+ }
+
+ /**
+ * <p>
+ * Having subclause.
+ * </p>
+ *
+ * @param what having subclause
+ * @return a {@link com.ekingstar.hibernate.query.builder.OqlBuilder} object.
+ */
+ public SqlBuilder having(final String what) {
+ Assert.isTrue(null != groups && !groups.isEmpty());
+ if (Strings.isNotEmpty(what)) having = what;
+ return this;
+ }
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlQuery.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlQuery.java
new file mode 100755
index 0000000..bc632c3
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/builder/SqlQuery.java
@@ -0,0 +1,389 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.builder;
+
+import java.util.Collection;
+import java.util.List;
+import java.util.Map;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.commons.collection.Order;
+import com.ekingstar.commons.lang.Strings;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.Lang;
+import com.ekingstar.hibernate.query.Query;
+
+/**
+ * sql查询
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public class SqlQuery extends AbstractQuery<Object> {
+
+ /** Constant <code>INNER_JOIN=" left join "</code> */
+ public static final String INNER_JOIN = " left join ";
+
+ /** Constant <code>OUTER_JOIN=" outer join "</code> */
+ public static final String OUTER_JOIN = " outer join ";
+
+ /** Constant <code>LEFT_OUTER_JOIN=" left outer join "</code> */
+ public static final String LEFT_OUTER_JOIN = " left outer join ";
+
+ /** Constant <code>RIGHT_OUTER_JOIN=" right outer join "</code> */
+ public static final String RIGHT_OUTER_JOIN = " right outer join ";
+
+ protected String select;
+
+ protected String from;
+
+ protected List<Condition> conditions = CollectUtils.newArrayList();
+
+ protected List<Order> orders = CollectUtils.newArrayList();
+
+ protected List<String> groups = CollectUtils.newArrayList();
+
+ /**
+ * <p>
+ * Constructor for SqlQuery.
+ * </p>
+ */
+ public SqlQuery() {
+ super();
+ }
+
+ /**
+ * <p>
+ * Constructor for SqlQuery.
+ * </p>
+ *
+ * @param queryStr a {@link java.lang.String} object.
+ */
+ public SqlQuery(final String queryStr) {
+ super();
+ this.queryStr = queryStr;
+ }
+
+ /**
+ * <p>
+ * add.
+ * </p>
+ *
+ * @param condition a {@link com.ekingstar.hibernate.query.builder.Condition} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlQuery} object.
+ */
+ public SqlQuery add(final Condition condition) {
+ conditions.add(condition);
+ return this;
+ }
+
+ /**
+ * 添加一组条件<br>
+ * query中不能添加条件集合作为一个条件,因此这里命名没有采用有区别性的addAll
+ *
+ * @param cons a {@link java.util.Collection} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlQuery} object.
+ */
+ public SqlQuery add(final Collection<Condition> cons) {
+ conditions.addAll(cons);
+ return this;
+ }
+
+ /**
+ * <p>
+ * addOrder.
+ * </p>
+ *
+ * @param order a {@link com.ekingstar.commons.collection.Order} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlQuery} object.
+ */
+ public SqlQuery addOrder(final Order order) {
+ if (null != order) {
+ this.orders.add(order);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * addOrder.
+ * </p>
+ *
+ * @param orders a {@link java.util.List} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlQuery} object.
+ */
+ public SqlQuery addOrder(final List<Order> orders) {
+ if (null != orders) {
+ this.orders.addAll(orders);
+ }
+ return this;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>select</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getSelect() {
+ return select;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>select</code>.
+ * </p>
+ *
+ * @param select a {@link java.lang.String} object.
+ */
+ public void setSelect(final String select) {
+ if (null == select) {
+ this.select = null;
+ } else {
+ if (Strings.contains(select.toLowerCase(), "select")) {
+ this.select = select;
+ } else {
+ this.select = "select " + select;
+ }
+ }
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>conditions</code>.
+ * </p>
+ *
+ * @return a {@link java.util.List} object.
+ */
+ public List<Condition> getConditions() {
+ return conditions;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>conditions</code>.
+ * </p>
+ *
+ * @param conditions a {@link java.util.List} object.
+ */
+ public void setConditions(final List<Condition> conditions) {
+ this.conditions = conditions;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>from</code>.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String getFrom() {
+ return from;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>from</code>.
+ * </p>
+ *
+ * @param from a {@link java.lang.String} object.
+ */
+ public void setFrom(final String from) {
+ if (null == from) {
+ this.from = null;
+ } else {
+ if (Strings.contains(from.toLowerCase(), "from")) {
+ this.from = from;
+ } else {
+ this.from = " from " + from;
+ }
+ }
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>orders</code>.
+ * </p>
+ *
+ * @return a {@link java.util.List} object.
+ */
+ public List<Order> getOrders() {
+ return orders;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>orders</code>.
+ * </p>
+ *
+ * @param orders a {@link java.util.List} object.
+ */
+ public void setOrders(final List<Order> orders) {
+ this.orders = orders;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>groups</code>.
+ * </p>
+ *
+ * @return a {@link java.util.List} object.
+ */
+ public List<String> getGroups() {
+ return groups;
+ }
+
+ /**
+ * <p>
+ * Setter for the field <code>groups</code>.
+ * </p>
+ *
+ * @param groups a {@link java.util.List} object.
+ */
+ public void setGroups(final List<String> groups) {
+ this.groups = groups;
+ }
+
+ /**
+ * <p>
+ * groupBy.
+ * </p>
+ *
+ * @param what a {@link java.lang.String} object.
+ * @return a {@link com.ekingstar.hibernate.query.builder.SqlQuery} object.
+ */
+ public SqlQuery groupBy(final String what) {
+ if (Strings.isNotEmpty(what)) {
+ groups.add(what);
+ }
+ return this;
+ }
+
+ /**
+ * 生成查询语句（如果查询语句已经存在则不进行生成）
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String toQueryString() {
+ if (Strings.isNotEmpty(queryStr)) {
+ return queryStr;
+ } else {
+ return genQueryString(true);
+ }
+ }
+
+ /**
+ * <p>
+ * toCountString.
+ * </p>
+ *
+ * @return a {@link java.lang.String} object.
+ */
+ public String toCountString() {
+ if (Strings.isNotEmpty(countStr)) {
+ return countStr;
+ } else {
+ return "select count(*) from (" + genQueryString(false) + ")";
+ }
+ }
+
+ /**
+ * <p>
+ * genQueryString.
+ * </p>
+ *
+ * @param hasOrder a boolean.
+ * @return a {@link java.lang.String} object.
+ */
+ protected String genQueryString(final boolean hasOrder) {
+ if (null == from) { return queryStr; }
+ final StringBuilder buf = new StringBuilder(50);
+ buf.append((select == null) ? "" : select).append(' ').append(from);
+ if (!conditions.isEmpty()) {
+ buf.append(" where ").append(Conditions.toQueryString(conditions));
+ }
+ if (!groups.isEmpty()) {
+ buf.append(" group by ");
+ for (final String groupBy : groups) {
+ buf.append(groupBy).append(',');
+ }
+ buf.deleteCharAt(buf.length() - 1);
+ }
+ if (hasOrder && !CollectUtils.isEmpty(orders)) {
+ buf.append(' ').append(Order.toSortString(orders));
+ }
+ return buf.toString();
+ }
+
+ /**
+ * <p>
+ * getParams.
+ * </p>
+ *
+ * @return a {@link java.util.Map} object.
+ */
+ public Map<String, Object> getParams() {
+ return (null == params) ? Conditions.getParamMap(conditions) : CollectUtils.newHashMap(params);
+ }
+
+ /**
+ * <p>
+ * build.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Query} object.
+ */
+ public Query<Object> build() {
+ QueryBean<Object> queryBean = new QueryBean<Object>();
+ queryBean.setStatement(toQueryString());
+ queryBean.setParams(CollectUtils.newHashMap(getParams()));
+ if (null != limit) {
+ queryBean.setLimit(new PageLimit(limit.getPageNo(), limit.getPageSize()));
+ }
+ queryBean.setCountStatement(toCountString());
+ queryBean.setCacheable(cacheable);
+ queryBean.setLang(getLang());
+ return queryBean;
+ }
+
+ /**
+ * <p>
+ * getLang.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.hibernate.query.Lang} object.
+ */
+ protected Lang getLang() {
+ return Lang.SQL;
+ }
+
+ /** {@inheritDoc} */
+ public SqlQuery limit(PageLimit limit) {
+ this.limit = limit;
+ return this;
+ }
+
+ /** {@inheritDoc} */
+ public SqlQuery params(Map<String, Object> newParams) {
+ this.params = CollectUtils.newHashMap(newParams);
+ return this;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/limit/AbstractQueryPage.java b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/limit/AbstractQueryPage.java
new file mode 100755
index 0000000..cea01b4
--- /dev/null
+++ b/tools/hqlbuilder/src/main/java/com/ekingstar/hibernate/query/limit/AbstractQueryPage.java
@@ -0,0 +1,249 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.query.limit;
+
+import java.util.Iterator;
+
+import com.ekingstar.commons.page.Page;
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.commons.page.PageWapper;
+import com.ekingstar.commons.page.SinglePage;
+import com.ekingstar.hibernate.query.LimitQuery;
+
+/**
+ * 基于查询的分页。<br>
+ * 当使用或导出大批量数据时，使用者仍以List的方式进行迭代。<br>
+ * 该实现则是内部采用分页方式。
+ *
+ * @author chaostone
+ * @version $Id: $
+ */
+public abstract class AbstractQueryPage<T> extends PageWapper<T> {
+
+ protected int pageNo = 0;
+
+ protected int maxPageNo = 0;
+
+ protected LimitQuery<T> query;
+
+ /** {@inheritDoc} */
+ abstract public Page<T> moveTo(int pageNo);
+
+ /**
+ * <p>
+ * Constructor for AbstractQueryPage.
+ * </p>
+ */
+ public AbstractQueryPage() {
+ super();
+ }
+
+ /**
+ * <p>
+ * Constructor for AbstractQueryPage.
+ * </p>
+ *
+ * @param query a {@link com.ekingstar.hibernate.query.LimitQuery} object.
+ */
+ public AbstractQueryPage(LimitQuery<T> query) {
+ this.query = query;
+ if (null != query) {
+ if (null == query.getLimit()) {
+ query.limit(new PageLimit(pageNo, Page.DEFAULT_PAGE_SIZE));
+ } else {
+ pageNo = query.getLimit().getPageNo() - 1;
+ }
+ }
+ }
+
+ /**
+ * 按照单个分页数据设置.
+ *
+ * @param page a {@link com.ekingstar.commons.collection.page.SinglePage} object.
+ */
+ protected void setPageData(SinglePage<T> page) {
+ setPage(page);
+ this.pageNo = page.getPageNo();
+ this.maxPageNo = page.getMaxPageNo();
+ }
+
+ /**
+ * <p>
+ * next.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.commons.collection.page.Page} object.
+ */
+ public Page<T> next() {
+ return moveTo(pageNo + 1);
+ }
+
+ /**
+ * <p>
+ * previous.
+ * </p>
+ *
+ * @return a {@link com.ekingstar.commons.collection.page.Page} object.
+ */
+ public Page<T> previous() {
+ return moveTo(pageNo - 1);
+ }
+
+ /**
+ * <p>
+ * hasNext.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean hasNext() {
+ return maxPageNo > pageNo;
+ }
+
+ /**
+ * <p>
+ * hasPrevious.
+ * </p>
+ *
+ * @return a boolean.
+ */
+ public boolean hasPrevious() {
+ return pageNo > 1;
+ }
+
+ /**
+ * <p>
+ * getFirstPageNo.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getFirstPageNo() {
+ return 1;
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>maxPageNo</code>.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getMaxPageNo() {
+ return maxPageNo;
+ }
+
+ /**
+ * <p>
+ * getNextPageNo.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getNextPageNo() {
+ return getPage().getNextPageNo();
+ }
+
+ /**
+ * <p>
+ * Getter for the field <code>pageNo</code>.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getPageNo() {
+ return pageNo;
+ }
+
+ /**
+ * <p>
+ * getPageSize.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getPageSize() {
+ return query.getLimit().getPageSize();
+ }
+
+ /**
+ * <p>
+ * getPreviousPageNo.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getPreviousPageNo() {
+ return getPage().getPreviousPageNo();
+ }
+
+ /**
+ * <p>
+ * getTotal.
+ * </p>
+ *
+ * @return a int.
+ */
+ public int getTotal() {
+ return getPage().getTotal();
+ }
+
+ /**
+ * <p>
+ * iterator.
+ * </p>
+ *
+ * @return a {@link java.util.Iterator} object.
+ */
+ public Iterator<T> iterator() {
+ return new PageIterator<T>(this);
+ }
+
+}
+
+class PageIterator<T> implements Iterator<T> {
+
+ private final AbstractQueryPage<T> queryPage;
+
+ private int dataIndex;
+
+ public PageIterator(AbstractQueryPage<T> queryPage) {
+ this.queryPage = queryPage;
+ this.dataIndex = 0;
+ }
+
+ public boolean hasNext() {
+ return (dataIndex < queryPage.getPage().getItems().size()) || (queryPage.hasNext());
+ }
+
+ public T next() {
+ if (dataIndex < queryPage.getPage().size()) {
+ return queryPage.getPage().getItems().get(dataIndex++);
+ } else {
+ queryPage.next();
+ dataIndex = 0;
+ return queryPage.getPage().getItems().get(dataIndex++);
+ }
+ }
+
+ public void remove() {
+
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/TestModel.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/TestModel.java
new file mode 100755
index 0000000..e583d2f
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/TestModel.java
@@ -0,0 +1,33 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate;
+
+public class TestModel {
+
+ private String name;
+
+ public String getName() {
+ return name;
+ }
+
+ public void setName(String name) {
+ this.name = name;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionTest.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionTest.java
new file mode 100755
index 0000000..d7e34db
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionTest.java
@@ -0,0 +1,51 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.builder;
+
+import static org.testng.Assert.assertEquals;
+import static org.testng.Assert.assertTrue;
+
+import java.util.List;
+
+import org.testng.annotations.Test;
+
+import com.ekingstar.hibernate.query.builder.Condition;
+import com.ekingstar.hibernate.query.builder.Conditions;
+
+@Test
+public class ConditionTest {
+
+ public void testGetNamedParams() {
+ Condition condition = new Condition("std.id =:stAd_id1 and std.name like :name");
+ List<String> names = condition.getParamNames();
+ assertEquals(names.size(), 2);
+ assertEquals(names.get(0), "stAd_id1");
+ assertEquals(names.get(1), "name");
+ }
+
+ public void testVarArgs() {
+ Condition c = new Condition("entity.code =:code entity.id in (:ids)", "aa", new Long[] { 1L });
+ assertEquals(2, Conditions.getParamMap(c).size());
+
+ Condition c1 = new Condition("entity.id in (:ids)", new Long[] { 1L, 2L });
+ assertEquals(1, Conditions.getParamMap(c1).size());
+ assertTrue((Conditions.getParamMap(c1).get("ids").getClass().isArray()));
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionsTest.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionsTest.java
new file mode 100755
index 0000000..8b9ca02
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/ConditionsTest.java
@@ -0,0 +1,64 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.builder;
+
+import static org.testng.Assert.assertEquals;
+
+import java.util.List;
+import java.util.Map;
+
+import org.testng.annotations.BeforeClass;
+import org.testng.annotations.Test;
+
+import com.ekingstar.commons.collection.CollectUtils;
+import com.ekingstar.hibernate.query.builder.Condition;
+import com.ekingstar.hibernate.query.builder.Conditions;
+
+@Test
+public class ConditionsTest {
+
+ @BeforeClass
+ protected void setUp() throws Exception {
+
+ }
+
+ public void testGetParamMap() throws Exception {
+ List<Condition> conditions = CollectUtils.newArrayList();
+ conditions.add(new Condition("std.id=:std_id", 1L));
+ Map<String, Object> params = Conditions.getParamMap(conditions);
+ assertEquals(params.size(), 1);
+ assertEquals(params.get("std_id"), 1L);
+ }
+
+ public void testToQueryString() {
+ List<Condition> conditions = CollectUtils.newArrayList();
+ conditions.add(new Condition("user.id=:user_id", 1L));
+ conditions.add(new Condition("user.name=:std_name", "name"));
+ assertEquals(Conditions.toQueryString(conditions), "(user.id=:user_id) and (user.name=:std_name)");
+ }
+
+ public void testConcat() {
+ List<Condition> conditions = CollectUtils.newArrayList();
+ conditions.add(new Condition("user.id=:user_id", 1L));
+ conditions.add(new Condition("user.name=:std_name", "name"));
+ Condition rs = Conditions.or(conditions);
+ assertEquals(rs.getContent(), "((user.id=:user_id) or (user.name=:std_name))");
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/OqlBuilderTest.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/OqlBuilderTest.java
new file mode 100755
index 0000000..f5f75d2
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/builder/OqlBuilderTest.java
@@ -0,0 +1,88 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.builder;
+
+import static org.testng.Assert.assertEquals;
+import static org.testng.Assert.assertNull;
+import static org.testng.Assert.assertTrue;
+
+import org.testng.Assert;
+import org.testng.annotations.Test;
+
+import com.ekingstar.hibernate.TestModel;
+import com.ekingstar.hibernate.query.LimitQuery;
+import com.ekingstar.hibernate.query.builder.Condition;
+import com.ekingstar.hibernate.query.builder.OqlBuilder;
+
+@Test
+public class OqlBuilderTest {
+
+ public void testToCountString1() throws Exception {
+ OqlBuilder<TestModel> queryBuilder = OqlBuilder.from(TestModel.class, "model");
+ LimitQuery<?> query = (LimitQuery<?>) queryBuilder.build();
+ assertEquals("select count(*) from com.ekingstar.hibernate.TestModel model", query.getCountQuery()
+ .getStatement());
+ queryBuilder.where(new Condition("name like :name", "testName"));
+ query = (LimitQuery<?>) queryBuilder.build();
+ assertTrue(query.getCountQuery().getStatement().endsWith("(name like :name)"));
+ }
+
+ public void testToCountString2() throws Exception {
+ OqlBuilder<Object> queryBuilder = OqlBuilder
+ .hql("from Ware where price is not null order by releaseDate desc "
+ + " union all from Ware where price is null order by releaseDate desc");
+ LimitQuery<Object> query = (LimitQuery<Object>) queryBuilder.build();
+ assertNull(query.getCountQuery());
+ }
+
+ public void testToCountString3() throws Exception {
+ OqlBuilder<Object> queryBuilder = OqlBuilder.from("Ware", "w");
+ queryBuilder.select("(select count(*) from Product p where p.ware=w) pcount,w.id");
+ queryBuilder.where("w.price is not null and exists (select * from Orders o where o.product=p)").orderBy(
+ "w.releaseDate desc");
+ LimitQuery<Object> query = (LimitQuery<Object>) queryBuilder.build();
+ assertEquals(
+ query.getStatement(),
+ "select (select count(*) from Product p where p.ware=w) pcount,w.id from Ware w "
+ + "where (w.price is not null and exists (select * from Orders o where o.product=p)) order by w.releaseDate desc");
+ assertEquals(
+ query.getCountQuery().getStatement(),
+ "select count(*) from Ware w where (w.price is not null and exists (select * from Orders o where o.product=p))");
+ }
+
+ public void testToCountString4() throws Exception {
+ OqlBuilder<Object> queryBuilder = OqlBuilder
+ .hql("from Ware where price is not null order by releaseDate desc ");
+ LimitQuery<Object> query = (LimitQuery<Object>) queryBuilder.build();
+ assertEquals("select count(*) from Ware where price is not null", query.getCountQuery().getStatement());
+ }
+
+ public void testToCountString5() throws Exception {
+ OqlBuilder<Object> queryBuilder = OqlBuilder.hql("from Ware where price is not null");
+ LimitQuery<Object> query = (LimitQuery<Object>) queryBuilder.build();
+ assertEquals("select count(*) from Ware where price is not null", query.getCountQuery().getStatement());
+ }
+
+ public void testHaving() throws Exception {
+ OqlBuilder<Object> queryBuilder = OqlBuilder.from("SomeClass a ").groupBy("a.name").having("sum(a.id)>0");
+ Assert.assertEquals(queryBuilder.build().getStatement(),
+ "from SomeClass a group by a.name having sum(a.id)>0");
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/MockQueryPage.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/MockQueryPage.java
new file mode 100755
index 0000000..88ef7ff
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/MockQueryPage.java
@@ -0,0 +1,54 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.limit;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import com.ekingstar.commons.page.Page;
+import com.ekingstar.commons.page.SinglePage;
+import com.ekingstar.hibernate.query.LimitQuery;
+import com.ekingstar.hibernate.query.limit.AbstractQueryPage;
+
+public class MockQueryPage extends AbstractQueryPage<String> {
+
+ public MockQueryPage() {
+
+ }
+
+ public MockQueryPage(LimitQuery<String> query) {
+ super(query);
+ next();
+ }
+
+ public Page<String> moveTo(int pageNo) {
+ SinglePage<String> page = new SinglePage<String>();
+ page.setPageNo(pageNo);
+ page.setPageSize(super.getPageSize());
+ List<String> datas = new ArrayList<String>(getPageSize());
+ for (int i = 0; i < getPageSize(); i++) {
+ datas.add(String.valueOf(i) + " of " + pageNo);
+ }
+ page.setItems(datas);
+ page.setTotal(100);
+ setPageData(page);
+ return this;
+ }
+
+}
diff --git a/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/QueryPageTest.java b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/QueryPageTest.java
new file mode 100755
index 0000000..ea3672a
--- /dev/null
+++ b/tools/hqlbuilder/src/test/java/com/ekingstar/hibernate/limit/QueryPageTest.java
@@ -0,0 +1,43 @@
+/*
+ * Beangle, Agile Java/Scala Development Scaffold and Toolkit
+ *
+ * Copyright (c) 2005-2013, Beangle Software.
+ *
+ * Beangle is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * Beangle is distributed in the hope that it will be useful.
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with Beangle. If not, see <http://www.gnu.org/licenses/>.
+ */
+package com.ekingstar.hibernate.limit;
+
+import static org.testng.Assert.assertNotNull;
+
+import java.util.Iterator;
+
+import org.testng.annotations.Test;
+
+import com.ekingstar.commons.page.PageLimit;
+import com.ekingstar.hibernate.query.LimitQuery;
+import com.ekingstar.hibernate.query.builder.OqlBuilder;
+
+@Test
+public class QueryPageTest {
+
+ public void testMove() throws Exception {
+ OqlBuilder<String> query = OqlBuilder.from(String.class, "dd");
+ query.limit(new PageLimit(1, 2));
+ MockQueryPage page = new MockQueryPage((LimitQuery<String>) query.build());
+ for (Iterator<String> iterator = page.iterator(); iterator.hasNext();) {
+ String data = iterator.next();
+ assertNotNull(data);
+ }
+ }
+}