ssh三大框架整合struts2+hibernate3+Spring2xingluckystar总结.pdf

《ssh三大框架整合struts2+hibernate3+Spring2xingluckystar总结.pdf》由会员分享，可在线阅读，更多相关《ssh三大框架整合struts2+hibernate3+Spring2xingluckystar总结.pdf（33页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、SSH三大框架整合struts2+hibernate3+Spring2 IDE 工具:myeclipse6.5 数据库：mysql 此 SSH 所实现的功能首页：点击 save users:点击保存一个记录到数据库：这里面可以对表进行删除和修改，和生成Excel 表格保存到本地点击生成 Excel:点击序号为1 的 update:1.首先在数据库中创建一个表：注意：我创建的是test数据库createtable test.users(id INT notnull,firstname VARCHAR(50)notnull,lastname VARCHAR(50)notnull,age INT n

2、otnull,primarykey(id);2.在 myeclipse中建立一个 web工程，hibernate3和 Spring2 是 myeclipse自动导入：在建立的web项目上单击鼠标右键选中myeclipse项目就能添加，Struts2和 mysql 驱动手动添加。3.Struts2和 mysql 驱动需要的文件：把这几个文件复制粘贴到WEB-INF 下的 lib 下4.web 工程和里面所需要建立的文件：按照下面建立文件和所需要的包5.可以对照一下导入的包是否正确：下面为从上到下包中文件的代码：com.test.action.user包下：GenerateExcelAction.

3、java package com.test.action.user;import java.io.InputStream;import com.opensymphony.xwork2.ActionSupport;import com.test.service.UserService;public class GenerateExcelAction extends ActionSupport private UserService service;public UserService getService()return service;public void setService(UserSe

4、rvice service)this.service=service;public InputStream getDownloadFile()return this.service.getInputStream();Override public String execute()throws Exception /TODO Auto-generated method stub return SUCCESS;+ListUserAction.java package com.test.action.user;import java.util.Map;import com.opensymphony.

5、xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;import com.test.service.UserService;public class ListUserAction extends ActionSupport private UserService userService;public UserService getUserService()return userService;public void setUserService(UserService userService)this.userSe

6、rvice=userService;SuppressWarnings(unchecked)Override public String execute()throws Exception Map request=(Map)ActionContext.getContext().get(request);request.put(list,userService.findAll();return SUCCESS;+RemoveUserAction.java package com.test.action.user;import com.opensymphony.xwork2.ActionSuppor

7、t;import com.test.bean.User;import com.test.service.UserService;public class RemoveUserAction extends ActionSupport private User user;private UserService service;public User getUser()return user;public void setUser(User user)this.user=user;public UserService getService()return service;public void se

8、tService(UserService service)this.service=service;Override public String execute()throws Exception this.service.delete(user);return SUCCESS;+SaveUserAction.java package com.test.action.user;import com.opensymphony.xwork2.ActionSupport;import com.test.bean.User;import com.test.service.UserService;pub

9、lic class SaveUserAction extends ActionSupport private User user;private UserService service;public UserService getService()return service;public void setService(UserService service)this.service=service;public User getUser()return user;public void setUser(User user)this.user=user;Override public Str

10、ing execute()throws Exception this.service.save(this.user);return SUCCESS;+UpdatePUserAction.java package com.test.action.user;import com.opensymphony.xwork2.ActionSupport;import com.test.bean.User;import com.test.service.UserService;public class UpdatePUserAction extends ActionSupport private User

11、user;private UserService service;public User getUser()return user;public void setUser(User user)this.user=user;public UserService getService()return service;public void setService(UserService service)this.service=service;Override public String execute()throws Exception user=this.service.findById(use

12、r.getId();return SUCCESS;+UpdateUserAction.java package com.test.action.user;import com.opensymphony.xwork2.ActionSupport;import com.test.bean.User;import com.test.service.UserService;public class UpdateUserAction extends ActionSupport private User user;private UserService service;public User getUse

13、r()return user;public void setUser(User user)this.user=user;public UserService getService()return service;public void setService(UserService service)this.service=service;Override public String execute()throws Exception this.service.update(user);return SUCCESS;+SaveUserAction-validation.xml!-required

14、 first namerequired last namerequired age1150age should be between$min and$max-user trueusers +UpdateUserAction-validation.xml!-required first namerequired last namerequired age1150age should be between$min and$max-user trueusers +com.test.bean包下User.java package com.test.bean;publicclass User priva

15、te Integer id;private String firstname;private String lastname;private Integer age;public Integer getId()returnid;publicvoid setId(Integer id)this.id =id;public String getFirstname()returnfirstname;publicvoid setFirstname(String firstname)this.firstname=firstname;public String getLastname()returnlas

16、tname;publicvoid setLastname(String lastname)this.lastname=lastname;public Integer getAge()returnage;publicvoid setAge(Integer age)this.age =age;+User.hbm.xml+User-user-validation.xml required first namerequired last namerequired age1150 age should be between$min and$max+com.test.dao 包下UserDAO.java

17、package com.test.dao;import java.util.List;import com.test.bean.User;public interface UserDAO public void save(User user);public void removeUser(User user);public User findUserById(Integer id);public List findAllUsers();public void updateUser(User user);+UserDaoImpl.java package com.test.dao;import

18、java.util.List;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.test.bean.User;public class UserDaoImpl extends HibernateDaoSupport implements UserDAO SuppressWarnings(unchecked)public List findAllUsers()/按照 id 的降序排列下面是按照id 的升序排列/String hql=from User user order by use

19、r.id desc;String hql=from User user order by user.id asc;return(List)this.getHibernateTemplate().find(hql);public User findUserById(Integer id)User user=(User)this.getHibernateTemplate().get(User.class,id);return user;public void removeUser(User user)this.getHibernateTemplate().delete(user);public v

20、oid save(User user)this.getHibernateTemplate().save(user);public void updateUser(User user)this.getHibernateTemplate().update(user);+com.test.service 包下UserService.java package com.test.service;import java.io.InputStream;import java.util.List;import com.test.bean.User;public interface UserService pu

21、blic List findAll();public void save(User user);public void delete(User user);public User findById(Integer id);public void update(User user);public InputStream getInputStream();+UserServiceImpl.java 这个里面如果使用另外一种方法应该把相应的包导入package com.test.service;import java.io.ByteArrayInputStream;import java.io.By

22、teArrayOutputStream;import java.io.IOException;import java.io.InputStream;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.test.

23、bean.User;import com.test.dao.UserDAO;publicclass UserServiceImpl implements UserService private UserDAO userDao;public UserDAO getUserDao()returnuserDao;publicvoid setUserDao(UserDAO userDao)this.userDao=userDao;publicvoid delete(User user)this.userDao.removeUser(user);public List findAll()returnth

24、is.userDao.findAllUsers();public User findById(Integer id)/TODO Auto-generated method stubreturnthis.userDao.findUserById(id);publicvoid save(User user)this.userDao.save(user);publicvoid update(User user)this.userDao.updateUser(user);/poi进行 excl表格生成public InputStream getInputStream()HSSFWorkbook wb=

25、new HSSFWorkbook();/相当于创建一个excl表格HSSFSheet sheet=wb.createSheet(sheet1);/创建一个 sheetHSSFRow 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)

26、;cell.setCellValue(姓);cell=row.createCell(short)2);cell.setEncoding(HSSFCell.ENCODING_UTF_16);cell.setCellValue(名);cell=row.createCell(short)3);cell.setEncoding(HSSFCell.ENCODING_UTF_16);cell.setCellValue(年龄 );List list=this.findAll();for(int i=0;ilist.size();+i)User user=list.get(i);row=sheet.creat

27、eRow(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.getFirstname();cell=row.createCell(short)2);cell.setEncoding(HSSFCell.ENCODING_UTF_16);cell.setCellV

28、alue(user.getLastname();cell=row.createCell(short)3);cell.setEncoding(HSSFCell.ENCODING_UTF_16);cell.setCellValue(user.getAge();/*方法一*把excel文件写到内存里的输出流（字节数组输出流），*在通过字节数组构造一个字节数组输出流返回浏览器*/ByteArrayOutputStream os=new ByteArrayOutputStream();try wb.write(os);catch(IOException e)/TODO Auto-generated ca

29、tch blocke.printStackTrace();byte content=os.toByteArray();InputStream is=new ByteArrayInputStream(content);return is;/*方法二*文件输出流 FileOutputStream，在硬盘中，生成临时文件，*临时文件过多会产生垃圾，所有下载完后或重启服务器时再删除临时文件的方法实*现excel表格的下载*/在内存里面真正的导出到一个文件里面,struts的action在这个文件里面以输入流的形式把信息get 出来返回给我们的客户端/commons-lang.jar下mons.lang

30、下RandomStringUtils/String filename=RandomStringUtils.randomAlphanumeric(10);/String filename=CharacterUtils.getRandomString(10);/filename=new StringBuffer(filename).append(.xls).toString();/final File file=new File(filename);/try/OutputStream os=new FileOutputStream(file);/wb.write(os);/os.close();/

31、catch(Exception e)/TODO Auto-generated catch block/e.printStackTrace();/InputStream is=null;/try/is=new FileInputStream(file);/catch(FileNotFoundException e)/TODO Auto-generated catch block/e.printStackTrace();/用线程的方法删除临时文件/new Thread(new Runnable()/public void run()/try/Thread.sleep(15000);/catch(I

32、nterruptedException e)/TODO Auto-generated catch block/e.printStackTrace();/file.delete();/删除临时文件/).start();/return is;+com.test.servlet 包下DeleteFilesServlet.java package com.test.servlet;import java.io.File;import java.io.FileFilter;import javax.servlet.ServletException;import javax.servlet.http.Ht

33、tpServlet;publicclass DeleteFilesServlet extends HttpServlet publicvoid destroy()publicvoid init()throws ServletException /第一种方法/File file=new File(.);/File subFiles=file.listFiles();/for(File f:subFiles)/if(f.getName().endsWith(xls)/f.delete();/第二种方法File file=new File(.);File subFiles=file.listFile

34、s(new FileFilter()publicboolean accept(File pathname)if(pathname.getName().endsWith(xls)returntrue;returnfalse;);for(File f:subFiles)f.delete();+com.test.util 包下CharacterUtils.java package com.test.util;import java.util.Random;/第一种方法在小写字母大写字母和数字中取出length位随机数，用str字符串的方法，在字符串里随即取publicclass CharacterU

35、tils publicstatic String getRandomString(int length)String str=abcdefghijklmnopqrstuvwxyzABCDEFGHIGKLMNOPQRSTUVWXYZ0123456789;Random random=new Random();StringBuffer sb=new StringBuffer();for(int i=0;ilength;+i)int number=random.nextInt(62);sb.append(str.charAt(number);return sb.toString();/publicst

36、atic String getRandomString2(int length)Random random=new Random();StringBuffer sb=new StringBuffer();for(int i=0;ilength;+i)int number=random.nextInt(3);long result=0;switch(number)case 0:result=Math.round(Math.random()*25+65);/Math.round方法是四舍五入，Math.random()表示 0.01.0中的数*25 就是 0.025之间+65 是大写字母sb.ap

37、pend(String.valueOf(char)result);/result整形先转换成字符，再转化成字符串；break;case 1:result=Math.round(Math.random()*25+97);/大写字母sb.append(String.valueOf(char)result);break;case 2:sb.append(String.valueOf(newRandom().nextInt(10);break;return sb.toString();publicstaticvoid main(String args)System.out.println(getRan

38、domString2(10);+globalMessages_en.properties firstname=firstnamelastname=lastnameage=ageglobalMessages_zh.properties firstname=u59D3lastname=u540Dage=u5E74u9F84hibernate.cfg.xml struts.properties struts.custom.i18n.resources=globalMessages+struts.xml listUser.action/save.jsp/list.jsplistUser.action/

39、update.jsplistUser.action/update.jspapplication/vnd.ms-excelattachment;filename=AllUsers.xlsdownloadFile+applicationContext.xml org.hibernate.dialect.MySQLDialecttruecom/test/bean/User.hbm.xml+index.jsp base href=Operation首页 save userslistUser+list.jsp My JSP list.jsp starting page!-function del()if

40、(confirm(你真的想删除这条记录吗？)return true;return false;User List序号 姓名年龄 删除 更新 deleteupdate首页 生成 Excel+save.jsp base href=save page!-save users+update.jsp base href=update user page!-Update User+总结：*三大框架整合注意的几点*=1.bean 是数据库中对应数据的定义，用hibernate与表进行关联名字起法：类名+“.”+hbm+“.”.xml 与数据库中表关联用：hibernate-mapping class pro

41、pertie 2.action是struts的action 进行页面的处理和显示。继承ActionSupport 3.dao 数据层，与数据库打交道用hibernate实现4.service服务层,处理页面和数据库的业务逻辑5.struts.xml配置文件，action 的name 要和页面发送的action 或其他地方发送的action 名字保持一致，class 是处理 action 的类，redirect是重定向好处：避免重复提交表单到某个 jsp 它和 response（不写默认情况下是这个）的区别在于redirect是发送两次而response 是发送一次，并且response 刷新时

42、也执行。6.struts.properties对struts进行配置，这里面用于资源国际化：struts.custom.i18n.resources=globalMessages，用 globalMessages 作为前缀对中文和英文进行配置7.applicationContext.xml是spring 的配置文件，其中进行一些依赖注入。的id 在 struts中处理 action 类的名字，class 是处理这个的类.的name 是在 class 中成员变量的名字 ref是注入某个 bean要与注入 bean的id 对应8.输入校验的三种方法：第一种：在 action 的类中继承 validate方法。第二种：用 struts的校验框架：命名规则：需要校验的类名+“-”+需要校验类中方法名（如果有的话，没有不用加这个）+“-”+validation.xml 第三种：是用struts的visitor进行校验，这个需要两个xml另一个要放在要校验bean类的文件夹下命名规则：bean类的名字+“-”+上面 context 的名字+validation.xml=*由LuckyStar 总结完成2010年11月19日*欢迎参考，有问题多多指教*