Suggested case list:
Using timer to refresh a grid
383guest172.69.33.12125nk0uiMay 7, 2020 7:23:47 AMlinkuser model to move item to another listbox
120guest162.158.193.148d0n3krApr 2, 2020 5:28:28 AMlinkDisabled list item row passed to VM-1981
296fatih123160.83.36.13025nk0uiFeb 13, 2018 4:25:44 PMlinkDisabled list item row passed to VM-1981
295fatih123160.83.36.13025nk0uiFeb 13, 2018 4:25:16 PMlinkDisabled list item row passed to VM-1981
294fatih123160.83.36.13225nk0uiFeb 13, 2018 3:30:44 PMlinkgrid sample with ListModel/RowRenderer
816guest80.82.2.1312vah9ajFeb 21, 2017 11:42:21 AMlinkgrid sample with ListModel/RowRenderer
809guest175.98.113.1622vah9ajJan 26, 2017 9:19:33 AMlinkgrid sample with ListModel/RowRenderer
196guest79.185.142.402vah9ajApr 26, 2014 10:53:57 PMlinkgrid sample with ListModel/RowRenderer
195guest79.185.142.402vah9ajApr 26, 2014 10:53:54 PMlinkgrid sample with ListModel/RowRenderer
194guest79.185.142.402vah9ajApr 26, 2014 10:53:51 PMlinkgrid sample with ListModel/RowRenderer
193guest79.185.142.402vah9ajApr 26, 2014 10:53:48 PMlinkgrid sample with ListModel/RowRenderer
192guest79.185.142.402vah9ajApr 26, 2014 10:53:44 PMlinkgrid sample with ListModel/RowRenderer
191guest79.185.142.402vah9ajApr 26, 2014 10:53:40 PMlinkHierarchy table without using ZK PE/EE
1aaknai151.28.135.2131s871daJul 29, 2013 11:02:46 PMlinkgrid sample with ListModel/RowRenderer
128aaknai151.28.135.2132vah9ajJul 29, 2013 7:20:00 PMlinkuser model to move item to another listbox
1TonyQ114.25.109.94d0n3krApr 21, 2012 10:43:27 AMlinkUsing timer to refresh a grid
1TonyQ220.133.44.3725nk0uiFeb 17, 2012 3:17:34 AMlinkFire a event from child iframe
1TonyQ220.133.44.372eupjotFeb 3, 2012 5:04:52 AMlinkTextbox input restriction sample
1TonyQ72.21.245.2431b3nlr0Dec 20, 2011 10:09:10 AMlinkTest web core taglib in ZUL
1TonyQ198.203.175.175ofqkemDec 17, 2011 3:36:08 AMlinkLatest 10 Fiddles :
constraint binding textbox
3guest172.68.151.16220peldaDec 5, 2025 5:08:19 PMlinkAnother new ZK fiddle
2guest172.68.151.16320peldaDec 5, 2025 5:07:51 PMlinkAnother new ZK fiddle
1guest172.68.151.16220peldaDec 5, 2025 5:07:32 PMlinkAnother new ZK fiddle
1peggypeng172.71.154.99364f4neDec 5, 2025 9:24:31 AMlinktooltip example
2guest104.22.23.13rc1ntoDec 4, 2025 2:23:45 PMlinkAnother new ZK fiddle
1guest172.69.134.2277t7602Dec 4, 2025 1:40:46 PMlinkAnother new ZK fiddle
1peggypeng104.22.17.1802df6e3oDec 4, 2025 8:41:29 AMlinkonClose
1peggypeng172.68.87.248j8kd8aDec 3, 2025 4:10:26 AMlinkAnother new ZK fiddle
1peggypeng172.69.134.2271rm7f4eNov 26, 2025 3:31:24 AMlinkZK-5912-Suggestion
2rebeccalai104.22.20.1442qrmiiuNov 26, 2025 2:07:15 AMlinkgrid sample with ListModel/RowRenderer
2guest154.121.251.92a0c322Jun 21, 2017 12:17:28 AMlinkresources
index.zulzul<?page title="EXCEL文件上传" cacheable="false" language="xul/html" zscriptLanguage="Java" contentType="text/html;charset=UTF-8"?>
<?link rel="stylesheet" href="/css/zk.css" type="text/css"?>
<?script type="text/javascript" src="/js/common.js"?>
<zk xmlns:h="http://www.w3.org/1999/xhtml"
xmlns:n="http://www.zkoss.org/2005/zk/native">
<div apply="org.zkoss.bind.BindComposer" height="100%"
validationMessages="@id('vmsgs')"
viewModel="@id('vm') @init('com.tenvee.tobaccoadmin.web.upload.ui.ExpDataViewModel')">
<progressmeter id="prjogressbar" value="@bind(vm.value)"
visible="@bind(vm.visible)" width="100%" />
<window width="100%" height="100%" title="上传功能">
<label id="va" value="开始行数：" />
<textbox constraint="no empty" placeholder="从第零行开始"
value="@bind(vm.startRow)" width="10%" />
<button id="btn" label="上传文件" width="84.5%"
upload="true,maxsize=10240"
onUpload="@command('uploadFile', file=event.getMedia())">
</button>
<borderlayout>
<center border="none">
<listbox model="@load(vm.result)" sizedByContent="true" span='true'
emptyMessage="没有搜索到匹配的数据！">
<listhead >
<listheader value="${each}" forEach="${vm.errorList}" />
</listhead>
<template name="model" var="item">
<listitem>
<listcell label="@load(item)" />
</listitem>
</template>
</listbox>
</center>
</borderlayout>
</window>
</div>
</zk>
ExpDataViewModel.javajava
import java.io.InputStream;
import java.net.InetAddress;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.List;
import org.zkoss.bind.annotation.BindingParam;
import org.zkoss.bind.annotation.Command;
import org.zkoss.bind.annotation.Init;
import org.zkoss.bind.annotation.NotifyChange;
import org.zkoss.util.media.Media;
import org.zkoss.zk.ui.select.annotation.VariableResolver;
import org.zkoss.zk.ui.select.annotation.WireVariable;
import org.zkoss.zul.Messagebox;
import com.tenvee.tobaccoadmin.web.springsec.SecurityUtil;
import com.tenvee.tobaccoadmin.web.upload.model.PullDownList;
import com.tenvee.tobaccoadmin.web.upload.model.UserUpload;
import com.tenvee.tobaccoadmin.web.upload.service.UploadService;
import com.tenvee.tobaccoadmin.web.upload.util.ExcelUtils;
/**
* @copyright : TENVEE Project: tobaccoadmin Comments: 文件上传 ViewModel 类
* @version used: <JDK1.7> @author： whs Create Date： 2016-08-15
* @version: 1.0
*/
@VariableResolver(org.zkoss.zkplus.spring.DelegatingVariableResolver.class)
public class ExpDataViewModel {
private Integer startRow;
private String value;
private boolean visible;
private List<String> errorList = new ArrayList<String>();
@Init
public void init() {
errorList.add("error1");
errorList.add("error2");
errorList.add("error3");
errorList.add("error4");
}
public List<String> getErrorList() {
return errorList;
}
private List<List<String>> result;
public List<String> getFieldName() {
try {
ExcelUtils excelUtils = new ExcelUtils();
Integer count = excelUtils.getCount();
System.out.println(PullDownList.getFieldName(15));
if(count!= null){
return PullDownList.getFieldName(5);
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public List<String> getColumns() {
try {
System.out.println(PullDownList.getColumns(15));
return PullDownList.getColumns(5);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public List<List<String>> getResult() {
return result;
}
public Integer getStartRow() {
return startRow;
}
public void setStartRow(Integer startRow) {
this.startRow = startRow;
}
public boolean isVisible() {
return visible;
}
public void setVisible(boolean visible) {
this.visible = visible;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
@WireVariable
private UploadService uploadService;
// 上传事件
@Command
@NotifyChange("*")
public void uploadFile(@BindingParam("file") Media media) throws Exception {
try {
if(startRow == null || startRow<0){
Messagebox.show("请输入正确的行数！");
return;
}
if (media == null) {
return;
}
// 获得格式
String type = media.getFormat();
if (!"xls".equals(type) && !"xlsx".equals(type)) {
// 格式不正确
Messagebox.show("不是EXCEL文档！");
return;
}
// 获取流
InputStream in = media.getStreamData();
ExcelUtils eu = new ExcelUtils();
result = eu.readXls(in, type,startRow);
if (result == null) {
Messagebox.show("请删除EXCEL表中空的行或列！");
return;
}
// 保存用户上传数据
Integer userId = saveUserUpload();
// 根据用户userid 获得数据库表ID
Long id = uploadService.findById(Long.valueOf(userId)).getId();
visible = true;
for (List<String> expressData : result) {
// expressData.setExpressid(id);
System.err.println(expressData);
}
value = "100";
// uploadService.insertExp(result);
// Messagebox.show("上传成功！");
}catch (Exception e) {
Messagebox.show("服务器忙，请稍后再试...");
e.printStackTrace();
}
}
private Integer saveUserUpload() throws Exception {
UserUpload userUpload = new UserUpload();
Integer userId = SecurityUtil.getUser().getUsers().getUser_id();
userUpload.setUserid(Long.valueOf(userId));
// 创建当前时间
userUpload.setCreatetime(new Timestamp(System.currentTimeMillis()));
// 获得IP信息
userUpload.setIpinfo(InetAddress.getLocalHost().getHostAddress());
uploadService.save(userUpload);
return userId;
}
}
UserUpload.javajava
import java.io.Serializable;
import java.util.Date;
public class UserUpload implements Serializable {
private Long id;
private Long userid;
private Date createtime;
private String ipinfo;
private static final long serialVersionUID = 1L;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Long getUserid() {
return userid;
}
public void setUserid(Long userid) {
this.userid = userid;
}
public Date getCreatetime() {
return createtime;
}
public void setCreatetime(Date createtime) {
this.createtime = createtime;
}
public String getIpinfo() {
return ipinfo;
}
public void setIpinfo(String ipinfo) {
this.ipinfo = ipinfo;
}
}PullDownList.javajavaExcelUtil.javajava
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
/**
* 读取Excel
*
* @author
*/
public class ExcelUtils {
private Workbook wb;
private Sheet sheet;
private Row row;
private String cellData;
private Integer colNum = 0;
private Integer count;
public Integer getCount(){
if(row !=null ){
return count;
}else {
return null;
}
}
public List<List<String>> readXls(InputStream is,String type,Integer startRow){
try {
if("xls".equals(type)){
wb = new HSSFWorkbook(is);
}
if("xlsx".equals(type)){
wb = new XSSFWorkbook(is);
}
List<List<String>> result = new ArrayList<List<String>>();
sheet = wb.getSheetAt(0);
// 得到总行数
int rowNum = sheet.getLastRowNum();
// 正文内容应该从第二行开始,第一行为表头的标题
for (int i = startRow; i <= rowNum; i++) {
List<String> list = new ArrayList<String>();
//获得行
row = sheet.getRow(i);
//总列数
colNum = row.getPhysicalNumberOfCells();
for(int j=0;j<colNum;j++){
cellData = getStringVal(row.getCell(j));
if(cellData == null){
cellData = "";
colNum++;
}
list.add(cellData);
}
result.add(list);
}
count = colNum;
return result;
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
private static String getStringVal(Cell cell){
if(cell != null){
switch(cell.getCellType()){
case Cell.CELL_TYPE_BOOLEAN:
return cell.getBooleanCellValue() ? "TRUE":"FALSE";
case Cell.CELL_TYPE_FORMULA:
return cell.getCellFormula();
case Cell.CELL_TYPE_NUMERIC:
cell.setCellType(Cell.CELL_TYPE_STRING);
return cell.getStringCellValue();
case Cell.CELL_TYPE_STRING:
return cell.getStringCellValue();
default:
return "";
}
}else {
return null;
}
}
public static void main(String[] args) throws FileNotFoundException {
String filepath = "F:邮政快递数据20160705.xls";
String type = "xls";
InputStream is = new FileInputStream(filepath);
ExcelUtils eu = new ExcelUtils();
List<List<String>> list = eu.readXls(is, type,1);
for(List<String> ed : list){
System.out.println(ed);
}
}
}