package com.bx.test.services.impl;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import com.bx.test.bean.Users;
import com.bx.test.dao.UserDao;
import com.bx.test.dao.impl.UserDaoImpl;
import com.bx.test.services.UserServices;
public class UserServicesImpl implements UserServices {
private UserDao userDao= new UserDaoImpl();
public void setUserDao(UserDao userDao) {
this.userDao = userDao;
}
public List<Users> QueryAll() {
return this.userDao.QueryAll();
}
public boolean delInfo(int id) {
return this.userDao.delInfo(id);
}
public Users findById(int id) {
return this.userDao.findById(id);
}
public boolean saveInfo(Users users) {
return this.userDao.saveInfo(users);
}
public boolean updateInfo(Users users) {
return this.userDao.updateInfo(users);
}
/**
* 为生成的excel文件导出，获得输入流
*
* @return InputStream
*/
public InputStream getInputStream() {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell((short)0);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("编号");
cell = row.createCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("用户名");
cell = row.createCell((short)2);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("密码");
List<Users> list = this.QueryAll();
for(int i=0; i < list.size(); i++ ) {
Users user = list.get(i);
row = sheet.createRow(i+1);
cell = row.createCell((short)0);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(i + 1);
cell = row.createCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(user.getUsername());
cell = row.createCell((short)2);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(user.getPassword());
}
File file = new File("test.xsl");
try {
OutputStream os = new FileOutputStream(file);
wb.write(os);
os.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
InputStream is = null;
try {
is = new FileInputStream(file);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
return is;
}
/**
* 新式for循环写法测试
*/
void getUsersName() {
Users user1 = new Users();
user1.setId(71);
user1.setUsername("simens");
Users user2 = new Users();
user2.setId(81);
user2.setUsername("nokia");
Users user3 = new Users();
user3.setId(91);
user3.setUsername("moto");
List<Users> list = new ArrayList<Users>();
list.add(user1);
list.add(user2);
list.add(user3);
int i = 1;
for(Users user : list) {
System.out.println("第"+i+"个 : "+user.getUsername());
i++;
}
}
public static void main(String[] args) {
new UserServicesImpl().getUsersName();
}
}
ssh.rar_SSH 附加_struts 2 hibernate_文件上传下载 java （134个子文件） 
UserServicesImpl.class 5KB UserDaoImpl.class 2KB DeleteUserAction.class 2KB SaveUserAction.class 2KB UpdatePUserAction.class 1KB ListUserAction.class 1KB UpdateUserAction.class 1KB Users.class 1KB GenerateExcelAction.class 989B UserServices.class 428B UserDao.class 362B .classpath 6KB
struts2-core-2.0.14.jar 2.22MB hibernate3.jar 2.15MB aspectjweaver.jar 1.8MB jasperreports-1.3.4.jar 1.61MB itext-1.3.jar 1.09MB xerces-2.6.2.jar 987KB freemarker.jar 834KB freemarker-2.3.8.jar 784KB poi-2.5.1.jar 783KB jxl.jar 597KB c3p0-0.9.1.2.jar 596KB sqljdbc.jar 570KB struts.jar 537KB javassist.jar 460KB xwork-2.0.7.jar 449KB antlr-2.7.6.jar 433KB jboss-archive-browsing.jar 404KB velocity-1.5.jar 383KB spring-beans.jar 381KB log4j-1.2.14.jar 359KB log4j-1.2.11.jar 342KB cglib-nodep-2.1_3.jar 317KB dom4j-1.6.1.jar 307KB spring-aop.jar 301KB spring-webmvc.jar 279KB cglib-2.1.3.jar 276KB commons-httpclient.jar 273KB hibernate-annotations.jar 259KB commons-lang.jar 237KB spring-jdbc.jar 222KB jaxen-1.1-beta-7.jar 222KB ehcache-1.2.3.jar 203KB spring-core.jar 178KB commons-collections-2.1.1.jar 171KB ognl-2.6.11.jar 164KB spring-context.jar 157KB spring-web.jar 149KB spring-dao.jar 127KB jotm.jar 121KB xml-apis.jar 121KB commons-dbcp.jar 119KB spring-portlet.jar 115KB hibernate-entitymanager.jar 114KB aspectjrt.jar 112KB velocity-tools-view-1.3.jar 105KB spring-hibernate3.jar 105KB jaas.jar 102KB spring-jpa.jar 96KB xapool.jar 90KB commons-io.jar 82KB persistence.jar 69KB hibernate-commons-annotations.jar 65KB jakarta-oro-2.0.8.jar 64KB spring-jdo.jar 61KB commons-pool.jar 61KB hibernate-validator.jar 60KB spring-toplink.jar 56KB cos.jar 55KB commons-fileupload.jar 52KB commons-logging.jar 52KB ejb3-persistence.jar 49KB commons-codec.jar 46KB commons-logging-1.0.4.jar 37KB commons-attributes-api.jar 35KB asm-util-2.2.3.jar 34KB commons-attributes-compiler.jar 29KB asm.jar 26KB spring-struts.jar 25KB spring-ibatis.jar 24KB asm-attrs.jar 16KB portlet-api.jar 15KB asm-commons-2.2.3.jar 15KB struts2-spring-plugin-2.0.11.jar 9KB jta.jar 9KB jdbc2_0-stdext.jar 7KB spring-tomcat-weaver.jar 5KB aopalliance.jar 4KB spring-agent.jar 1KB UserServicesImpl.java 3KB UserDaoImpl.java 1KB SaveUserAction.java 1KB UpdatePUserAction.java 954B DeleteUserAction.java 952B Users.java 889B UpdateUserAction.java 691B ListUserAction.java 675B GenerateExcelAction.java 578B UserServices.java 355B共 134 条
- 1
- 2
资源评论
