package org.swj.site.util;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelUtil
{
public List<String> readExcel(File excelFile,int sheetNum,int rowNum,int cellNum)
{
XSSFWorkbook wb;
List<String> result = new ArrayList<String>();
try
{
wb = new XSSFWorkbook(new FileInputStream(excelFile));
XSSFSheet sheet = wb.getSheetAt(sheetNum);
int totalRows = sheet.getLastRowNum();
for(int i = rowNum; i <= totalRows; i++) {
XSSFRow row = sheet.getRow(i);
if(row == null) {
continue;
}
int totalCells = row.getLastCellNum();
System.out.println(totalCells);
StringBuffer sb = new StringBuffer();
for(int j=cellNum;j < totalCells;j++){
sb.append(row.getCell(j).toString()).append(",");
}
result.add(sb.toString());
}
}
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
return result;
}
}
package org.swj.site.web;
import java.io.File;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import org.apache.struts2.ServletActionContext;
import org.swj.site.domain.Staff;
import org.swj.site.service.StaffService;
import com.opensymphony.xwork2.ActionSupport;
public class StaffAction extends ActionSupport
{
private static final long serialVersionUID = 1L;
private File file;
private String sheet;
private String row;
private String cell;
private Staff staff;
private StaffService staffService;
public void setStaff(Staff staff)
{
this.staff = staff;
}
public Staff getStaff()
{
return staff;
}
public void setStaffService(StaffService staffService)
{
this.staffService = staffService;
}
public File getFile()
{
return file;
}
public void setFile(File file)
{
this.file = file;
}
public String getSheet()
{
return sheet;
}
public void setSheet(String sheet)
{
this.sheet = sheet;
}
public String getRow()
{
return row;
}
public void setRow(String row)
{
this.row = row;
}
public String getCell()
{
return cell;
}
public void setCell(String cell)
{
this.cell = cell;
}
public String index() throws Exception
{
return SUCCESS;
}
public String upload() throws Exception
{
if(file == null){
return INPUT;
}
int sheetNum = Integer.parseInt(sheet);
int rowNum = Integer.parseInt(row);
int cellNum = Integer.parseInt(cell);
staffService.insertStaff(file,sheetNum,rowNum,cellNum);
staff.setStaffNo("");
staff.setStaffName("");
staff.setStatus("");
List<Staff> list = staffService.selectAllStaff(staff);
HttpServletRequest request = ServletActionContext.getRequest();
request.setAttribute("staff",list);
return SUCCESS;
}
public String list() throws Exception
{
HttpServletRequest request = ServletActionContext.getRequest();
System.out.println("--------"+staff.getStaffNo());
System.out.println("--------"+staff.getStaffName());
System.out.println("--------"+staff.getStatus());
String action = request.getParameter("action");
if("renounce".equals(action)){
String staffNo = request.getParameter("staffNo");
staff.setStaffNo(staffNo);
staff.setStatus("none");
staffService.updateStaff(staff);
//staff = null;
}
List<Staff> list = staffService.selectAllStaff(staff);
request.setAttribute("staff",list);
return SUCCESS;
}
public String lottery() throws Exception
{
return SUCCESS;
}
}
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<constant name="struts.objectFactory" value="spring"/>
<constant name="struts.ognl.allowStaticMethodAccess" value="true"/>
<constant name="struts.i18n.encoding" value="UTF-8"/>
<constant name="struts.devMode" value="false"/>
<include file="web-config.xml"></include>
</struts>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Staff">
<typeAlias alias="Staff" type="org.swj.site.domain.Staff"/>
<resultMap id="staffResult" class="Staff">
<!--
<result property="staffId" column="STAFFID"/>
-->
<result property="staffNo" column="STAFFNO"/>
<result property="staffName" column="STAFFNAME"/>
<result property="staffDepartment" column="STAFFDEPARTMENT"/>
<result property="status" column="STAFFSTATUS"/>
</resultMap>
<parameterMap id="staffParameter" class="Staff">
<parameter property="staffNo" jdbcType="VARCHAR2"/>
<parameter property="status" jdbcType="VARCHAR2"/>
</parameterMap>
<insert id="insertStaff" parameterClass="Staff">
INSERT INTO T_STAFF (STAFFNO,STAFFNAME,STAFFDEPARTMENT,STAFFSTATUS) VALUES (#staffNo#,#staffName#,#staffDepartment#,#status#)
</insert>
<select id="selectStaff" parameterMap="staffParameter" resultMap="staffResult">
SELECT STAFFNO,STAFFNAME,STAFFDEPARTMENT,STAFFSTATUS FROM T_STAFF WHERE 1=1
<isNotEmpty prepend="AND" property="staffNo">
STAFFNO = #staffNo#
</isNotEmpty>
<isNotEmpty prepend="AND" property="staffName">
STAFFNAME = #staffName#
</isNotEmpty>
<isNotEmpty prepend="AND" property="status">
STAFFSTATUS = #status#
</isNotEmpty>
</select>
<update id="updateStaff" parameterClass="Staff">
UPDATE T_STAFF SET STAFFSTATUS = #status# WHERE STAFFNO = #staffNo#
</update>
</sqlMap>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<package name="default" namespace="/" extends="struts-default">
<action name="index" method="index" class="staffAction">
<result name="success">page/jsp/index.jsp</result>
</action>
<action name="upload" method="upload" class="staffAction">
<interceptor-ref name="fileUpload">
<param name="allowedTypes">
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel
</param>
<param name="maximumSize">10485760</param>
</interceptor-ref>
<interceptor-ref name="defaultStack"></interceptor-ref>
<result name="input">/page/jsp/fileUpload.jsp</result>
<result name="success">/page/jsp/display.jsp</result>
</action>
<action name="list" method="list" class="staffAction">
<result name="success">/page/jsp/display.jsp</result>
</action>
<action name="lottery" method="lottery" class="staffAction">
<result name="success">/page/jsp/lottery.jsp</result>
</action>
</package>
</struts>
分享到:
相关推荐
DWR+Struts+spring+hibernate的订货系统,自己添加的dwr功能
spring+struts+hibernate+jbpm+dwr整合开发的OA办公系统源码
用户注册和登录是每个系统的必须存在的一部分,基于Dwr+Struts2+Spring+Hibernate写了一个用户登录注册系统。 其中用Dwr去进行用户注册的用户是否存在的验证。 全部业务控制交由Spring去进行处理。事务处理也...
spring+ibatis+struts2+dwr反转 加上上面的 spring+ibatis+struts2+dwr反转部分架包 在按照说明执行上面的脚本运行项目就可以看到效果了
总结,该例示注释非常详细,演示Spring托管Hibernate和Struts的Action, 以及Spring的事务声明(包括1.x与2.x的用法)与非事务声明的使用方式。 使用DWR可以方便的使用Spring托管的持久层功能。 目的:希望广大Java...
使用struts2、hibernate、spring、dwr整合的简单项目。包括级联等 注意:csdn上面显示为chm文件。该文件为.7z的压缩文件。用压缩软件可以打开的 csdn弄错了
spring+struts+hibernate+dwr+jstl做的实例.rar
一个struts2+spring+hibernate+dwr的小实例,不过木有搭建说明,不过有dwr的使用说明,至于表结构可以看映射配置文件就知道创建什么表了
spring+ibatis+struts2+dwr反转部分架包
DWR+spring+struts+hibernat整合登陆,一个简单的登陆系统,适合于初学者
struts2+hibernate+spring+dwr(用户注册)struts2+hibernate+spring+dwr(用户注册)
dwr+spring+struts+hibernate 整合在一起,代码写的不是很好,可以运行!
Spring+Struts+Hibernate+DWR集成教程.rar saivicky出品!必属精品!
Spring+Struts2+Hibernate整合框架的全部jar包,同时还有DWRjar包,MD5,放在工程中直接可用,无冲突
以用户管理为例,结合spring struts hibernate dwr jstl做的实例,struts hibernate dwr 与Spring完全结合,实现用户列表、信息增、删、改、查、维护时用户重名提示等功能,还包括页面自动转码设置(web.xml),...
EXT + DWR + Struts + Hibernate + Spring Demo
Struts2 + spring + hibernate + dwr 完美整合代码 dwr 用户注册 多级下拉联动 刷新表格.. 全部代码
struts1+spring+hibernate+dwr 项目 满意度调查struts1+spring+hibernate+dwr 项目 满意度调查struts1+spring+hibernate+dwr 项目 满意度调查struts1+spring+hibernate+dwr 项目 满意度调查
我自己做的spring3+struts2+hibernate3+dwr3+spring security3+ajax请求+数据库配置权限 完整实例