|
|
| Line 41: |
Line 41: |
| | | | |
| | [[Image:stock-result.png]] | | [[Image:stock-result.png]] |
| − |
| |
| − | ==When Value of Java Bean Changes==
| |
| − | Will ZK Spreadsheet update the cells if the value of the Java bean changes? Well, if you notify it.
| |
| − | <source lang="java">
| |
| − | bsheet.getBook().notifyChange(new String[] {"dataBean"});
| |
| − | </source>
| |
| − | When you notify the ZK Spreadsheet work book model that beans with the specified names have changed, it will collect which cells are affected (i.e. those dependent cells with the specified bean names), and publish data change event accordingly. The ZK Spreadsheet UI or any other components that have subscribed to the work book's event queue and are interested in the event will then retrieve the new cells' data from the beans and update themselves.
| |
| − |
| |
| − | =Integrate ZK Spreadsheet with Spring=
| |
| − | As we have mentioned in [[#How ZK Spreadsheet Resolve my Java Beans]], ZK Spreadsheet follows ZK's EL expression variable resolving mechanism. When trying to resolve a variable, it will finally ask variable resolvers declared in the ZUML page to retrieve the bean of the named variable. So simply declare the <tt>variable-resolver</tt> with <tt>org.zkoss.zkplus.spring.DelegatingVariableResolver</tt> on top of your ZUML page, you are now data-binding your ZK Spreadsheet with your Spring-Managed beans directly. Following we demonstrate the example that use the same bsheet.xls template file as in [[#Template Excel File with Proper Name Expressions]] but data-binding to Spring-Managed bean.
| |
| − |
| |
| − | ===ZUML Example===
| |
| − | In ZUML page, we declare the variable resolver for retrieving Spring-Managed beans so ZK Spreadsheet can find them and show the evaluated value in the spreadsheet's cells.
| |
| − |
| |
| − | <source lang="xml" high="1">
| |
| − | <?variable-resolver class="org.zkoss.zkplus.spring.DelegatingVariableResolver"?>
| |
| − | <spreadsheet id="bsheet"
| |
| − | src="/bsheet.xls"
| |
| − | maxrows="200"
| |
| − | maxcolumns="40"
| |
| − | vflex="1"
| |
| − | width="100%">
| |
| − | </spreadsheet>
| |
| − | </source>
| |
| − |
| |
| − | ===Spring Configuration File===
| |
| − | Define bean definitions in <tt>applicationContext.xml</tt> file, and put it into your <tt>WEB-INF</tt> directory.
| |
| − |
| |
| − | <source lang="xml" high="5">
| |
| − | <?xml version="1.0" encoding="UTF-8"?>
| |
| − | <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
| |
| − |
| |
| − | <beans>
| |
| − | <bean id="dataBean" class="demo.springbean.DataBeanImpl"/>
| |
| − | </beans>
| |
| − | </source>
| |
| − |
| |
| − | ===Spring Bean Class===
| |
| − | Define DataBean interface and its implementation. Mainly getters and setters for various attributes for a balance sheet.
| |
| − |
| |
| − | <tt>''DataBean.java''</tt>
| |
| − |
| |
| − | <source lang="java" high="3">
| |
| − | package demo.springbean;
| |
| − | public interface DataBean {
| |
| − | public double getLiquidAssets();
| |
| − |
| |
| − | public void setLiquidAssets(double liquidAssets);
| |
| − |
| |
| − | //...other getters and setters
| |
| − | }
| |
| − | </source>
| |
| − |
| |
| − | <tt>''DataBeanImpl.java''</tt>
| |
| − |
| |
| − | <source lang="java" high="17">
| |
| − | package demo.springbean;
| |
| − | public class DataBeanImpl implements DataBean {
| |
| − | private double liquidAssets;
| |
| − | private double fundInvestment;
| |
| − | private double fixedAssets;
| |
| − | private double intangibleAsset;
| |
| − | private double otherAssets;
| |
| − | private double currentLiabilities;
| |
| − | private double longTermLiabilities;
| |
| − | private double otherLiabilities;
| |
| − | private double capitalStock;
| |
| − | private double capitalSurplus;
| |
| − | private double retainedEarnings;
| |
| − | private double otherEquity;
| |
| − | private double treasuryStock;
| |
| − |
| |
| − | public double getLiquidAssets() {
| |
| − | return liquidAssets;
| |
| − | }
| |
| − |
| |
| − | public void setLiquidAssets(double liquidAssets) {
| |
| − | this.liquidAssets = liquidAssets;
| |
| − | }
| |
| − |
| |
| − | //...other getters and setters implementation
| |
| − | }
| |
| − | </source>
| |
| | | | |
| | =Version History= | | =Version History= |
Here is a Stock Price monitoring system that uses the ZK Spreadsheet's onCellChange event and data push mechanism.
Purpose
Automatically place buy or sell command whenever the price of a selected stock reach some preset point.
Template Excel File with Proper Name Expressions
Here is an Excel template file with monitorSheet and dataSheet. monitorSheet shows the selected stocks that refer to the dataSheet with formulas. dataSheet is a sheet that list all available stocks.
File:Stock-template.png
How ZK Spreadsheet Do the Job
Assume a stock price service will keep on pumping in updated stock price into the dataSheet on a separate thread. Whenever a new price is updated into dataSheet, ZK Spreadsheet will trigger the cell change event on monitorSheet that refer to the dataSheet. The onCellChange event listener registered on the ZK Spreadsheet will be called and check the prices . It compairs new price with preset selling price and buying price then notify buying or selling via another Web service.
ZUML Example
<spreadsheet apply="demo.stock.StockComposer"
src="/stock.xls"
maxrows="200"
maxcolumns="40"
vflex="1"
width="100%">
</spreadsheet>
Stock Composer
This is the controller that handle the onCellChange event.
package demo.stock;
public class StockComposer extends GenericForwardComposer {
}
Result
Version History
All source code listed in this book is at Github.
