Java Doc for HSqlListSqlHelper.java in  » Web-Framework » aranea-mvc-1.1.1 » org » araneaframework » backend » list » helper » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Web Framework » aranea mvc 1.1.1 » org.araneaframework.backend.list.helper   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.araneaframework.backend.list.helper.BaseListSqlHelper       org.araneaframework.backend.list.helper.ListSqlHelper          org.araneaframework.backend.list.helper.HSqlListSqlHelper HSqlListSqlHelper public class HSqlListSqlHelper extends ListSqlHelper (Code) author:    Rein Raudjärv Field Summary protected  String countSqlQuery      protected  SqlStatement statement      Constructor Summary public   HSqlListSqlHelper(DataSource dataSource, ListQuery query)      public   HSqlListSqlHelper(DataSource dataSource)      public   HSqlListSqlHelper(ListQuery query)      public   HSqlListSqlHelper()      Method Summary public  void addNullParam(int valueType)      Adds a NULL PreparedStatement parameter for later setting. public  void addStatementParam(Object param)      Adds a PreparedStatement parameter for later setting. public  void addStatementParams(List params)      Adds PreparedStatement parameters for later setting. protected  SqlStatement getCountSqlStatement()      protected  SqlStatement getRangeSqlStatement()      protected  boolean isShowAll()      public  void setCountSqlQuery(String countSqlQuery)      Sets the SQL query used to count the items in the database. public  void setSqlQuery(String sqlQuery)      Sets the SQL query that will be used to retrieve the item range from the list and count the items. Field Detail countSqlQuery protected String countSqlQuery(Code) statement protected SqlStatement statement(Code) Constructor Detail HSqlListSqlHelper public HSqlListSqlHelper(DataSource dataSource, ListQuery query)(Code) HSqlListSqlHelper public HSqlListSqlHelper(DataSource dataSource)(Code) HSqlListSqlHelper public HSqlListSqlHelper(ListQuery query)(Code) HSqlListSqlHelper public HSqlListSqlHelper()(Code) Method Detail addNullParam public void addNullParam(int valueType)(Code) Adds a NULL PreparedStatement parameter for later setting. Parameters:   valueType - the type of the NULL value. addStatementParam public void addStatementParam(Object param)(Code) Adds a PreparedStatement parameter for later setting. Parameters:   param - a PreparedStatement parameter. addStatementParams public void addStatementParams(List params)(Code) Adds PreparedStatement parameters for later setting. Parameters:   params - PreparedStatement parameters. getCountSqlStatement protected SqlStatement getCountSqlStatement()(Code) getRangeSqlStatement protected SqlStatement getRangeSqlStatement()(Code) isShowAll protected boolean isShowAll()(Code) setCountSqlQuery public void setCountSqlQuery(String countSqlQuery)(Code) Sets the SQL query used to count the items in the database. Parameters:   countSqlQuery - the SQL query used to count the items in the database. setSqlQuery public void setSqlQuery(String sqlQuery)(Code) Sets the SQL query that will be used to retrieve the item range from the list and count the items. The SQL query must start with SELECT expression withoud the word "SELECT". Parameters:   sqlQuery - the SQL query that will be used to retrieve the item rangefrom the list and count the items. Fields inherited from org.araneaframework.backend.list.helper.ListSqlHelper protected ConverterBasedColumnReader converterBasedColumnReader(Code)(Java Doc) final protected static Log log(Code)(Java Doc) protected MappingNamingStrategyAndFields mappingNamingStrategyAndFields(Code)(Java Doc) protected PrefixMapNamingStrategy prefixMapNamingStrategy(Code)(Java Doc) protected StandardFields standardFields(Code)(Java Doc) protected StandardValueConverter standardValueConverter(Code)(Java Doc) Methods inherited from org.araneaframework.backend.list.helper.ListSqlHelper public void addDatabaseFieldConverter(String valueName, Converter converter)(Code)(Java Doc) public void addDatabaseFieldMapping(String fieldName, String columnName, String columnAlias)(Code)(Java Doc) public void addDatabaseFieldMapping(String fieldName, String columnName)(Code)(Java Doc) public void addFields(Fields newFields)(Code)(Java Doc) public void addMapping(String fieldName, String columnName, String columnAlias)(Code)(Java Doc) public void addMapping(String fieldName, String columnName)(Code)(Java Doc) public void addNamingStrategy(NamingStrategy namingStrategy)(Code)(Java Doc) protected void addNamingStrategy(NamingStrategy newNamingStrategy, boolean first)(Code)(Java Doc) public void addNamingStrategyAsFirst(NamingStrategy namingStrategy)(Code)(Java Doc) public void addResultSetDeconverterForBeanField(String beanField, Converter converter)(Code)(Java Doc) public void addResultSetDeconverterForColumn(String columnName, Converter converter)(Code)(Java Doc) public void addResultSetMapping(String fieldName, String columnAlias)(Code)(Java Doc) public ConverterBasedColumnReader getConverterBasedColumnReader()(Code)(Java Doc) public MappingNamingStrategyAndFields getMappingNamingStrategyAndFields()(Code)(Java Doc) public PrefixMapNamingStrategy getPrefixMapNamingStrategy()(Code)(Java Doc) public StandardFields getStandardFields()(Code)(Java Doc) public StandardValueConverter getStandardValueConverter()(Code)(Java Doc) protected void init()(Code)(Java Doc) public void setConverterBasedColumnReader(ConverterBasedColumnReader converterBasedColumnReader)(Code)(Java Doc) public void setMappingNamingStrategyAndFields(MappingNamingStrategyAndFields mappingNamingStrategyAndFields)(Code)(Java Doc) public void setPrefixMapNamingStrategy(PrefixMapNamingStrategy prefixMapNamingStrategy)(Code)(Java Doc) public void setStandardFields(StandardFields standardFields)(Code)(Java Doc) public void setStandardValueConverter(StandardValueConverter standardValueConverter)(Code)(Java Doc) Fields inherited from org.araneaframework.backend.list.helper.BaseListSqlHelper final protected static Long DEFAULT_RANGE_START(Code)(Java Doc) protected DataSource ds(Code)(Java Doc) protected Fields fields(Code)(Java Doc) protected Expression filterExpr(Code)(Java Doc) protected SqlExpression filterSqlExpr(Code)(Java Doc) protected Long itemRangeCount(Code)(Java Doc) protected Long itemRangeStart(Code)(Java Doc) protected NamingStrategy namingStrategy(Code)(Java Doc) protected ComparatorExpression orderExpr(Code)(Java Doc) protected SqlExpression orderSqlExpr(Code)(Java Doc) protected ResultSetColumnReader resultSetColumnReader(Code)(Java Doc) protected ValueConverter valueConverter(Code)(Java Doc) protected VariableResolver variableResolver(Code)(Java Doc) Methods inherited from org.araneaframework.backend.list.helper.BaseListSqlHelper abstract public void addNullParam(int valueType)(Code)(Java Doc) abstract public void addStatementParam(Object param)(Code)(Java Doc) abstract public void addStatementParams(List params)(Code)(Java Doc) public ResultReader createBeanResultReader(Class itemClass)(Code)(Java Doc) protected VariableResolver createExpressionBuilderResolver()(Code)(Java Doc) protected StandardExpressionToSqlExprBuilder createFilterSqlExpressionBuilder()(Code)(Java Doc) protected StandardCompExprToSqlExprBuilder createOrderSqlExpressionBuilder()(Code)(Java Doc) protected static RuntimeException createQueryFailedException(String QueryString, List queryParams, SQLException nestedException)(Code)(Java Doc) public Object execute(ConnectionCallback action)(Code)(Java Doc) public ListItemsData execute(ResultReader reader)(Code)(Java Doc) public ListItemsData execute(Class itemClass)(Code)(Java Doc) public Long executeCountSql()(Code)(Java Doc) public List executeItemRangeSql(ResultReader reader)(Code)(Java Doc) public List executeItemRangeSql(Class itemClass)(Code)(Java Doc) public ConnectionCallback getCountSqlCallback()(Code)(Java Doc) abstract protected SqlStatement getCountSqlStatement()(Code)(Java Doc) public String getDatabaseFields()(Code)(Java Doc) public String getDatabaseFilter()(Code)(Java Doc) public List getDatabaseFilterParams()(Code)(Java Doc) public String getDatabaseFilterWith(String prefix, String suffix)(Code)(Java Doc) public String getDatabaseOrder()(Code)(Java Doc) public List getDatabaseOrderParams()(Code)(Java Doc) public String getDatabaseOrderWith(String prefix, String suffix)(Code)(Java Doc) public Fields getFields()(Code)(Java Doc) protected SqlExpression getFieldsSqlExpression()(Code)(Java Doc) protected SqlExpression getFilterSqlExpression()(Code)(Java Doc) public ConnectionCallback getItemRangeSqlCallback(ResultReader reader)(Code)(Java Doc) public ConnectionCallback getListItemsDataCallback(ResultReader reader)(Code)(Java Doc) public NamingStrategy getNamingStrategy()(Code)(Java Doc) protected SqlExpression getOrderSqlExpression()(Code)(Java Doc) abstract protected SqlStatement getRangeSqlStatement()(Code)(Java Doc) public ResultSetColumnReader getResultSetColumnReader()(Code)(Java Doc) public ValueConverter getValueConverter()(Code)(Java Doc) protected void init()(Code)(Java Doc) abstract public void setCountSqlQuery(String countSqlQuery)(Code)(Java Doc) public void setDataSource(DataSource ds)(Code)(Java Doc) public void setFields(Fields fields)(Code)(Java Doc) public void setFilterExpression(Expression filterExpr)(Code)(Java Doc) public void setItemRangeCount(Long itemRangeCount)(Code)(Java Doc) public void setItemRangeStart(Long itemRangeStart)(Code)(Java Doc) public void setListQuery(ListQuery query)(Code)(Java Doc) public void setNamingStrategy(NamingStrategy namingStrategy)(Code)(Java Doc) public void setOrderExpression(ComparatorExpression orderExpr)(Code)(Java Doc) public void setResultSetColumnReader(ResultSetColumnReader resultSetColumnReader)(Code)(Java Doc) public void setSimpleSqlQuery(String fromSql)(Code)(Java Doc) public void setSimpleSqlQuery(String fromSql, String customWhereSql, Object[] customWhereArgs)(Code)(Java Doc) public void setSimpleSqlQuery(String fromSql, String customWhereSql, Object[] customWhereArgs, String customOrderbySql, Object[] customOrderbyArgs)(Code)(Java Doc) abstract public void setSqlQuery(String sqlQuery)(Code)(Java Doc) public void setValueConverter(ValueConverter valueConverter)(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)