spring+struts2+dwr

Java代码

1. package org.swj.site.dao;
3. import java.io.File;
4. import java.sql.SQLException;
5. import java.util.List;
7. import org.springframework.orm.ibatis.SqlMapClientCallback;
8. import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
9. import org.swj.site.domain.Staff;
10. import org.swj.site.util.ExcelUtil;
12. import com.ibatis.sqlmap.client.SqlMapExecutor;
14. public class StaffDao extends SqlMapClientDaoSupport
15. {
16. private ExcelUtil excelUtil;
17. private Staff staff;
19. public void setStaff(Staff staff)
20. {
21. this.staff = staff;
22. }
23. public void setExcelUtil(ExcelUtil excelUtil)
24. {
25. this.excelUtil = excelUtil;
26. }
28. @SuppressWarnings("unchecked")
29. public void insertStaff(File file,int sheetNum,int rowNum,int cellNum){
31. final List<String> result = excelUtil.readExcel(file,sheetNum,rowNum,cellNum);
32. getSqlMapClientTemplate().execute(new SqlMapClientCallback(){
33. public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException
34. {
35. executor.startBatch();
36. for(int i=0;i<result.size();i++){
37. String[] strs = result.get(i).split(",");
38. staff.setStaffNo(strs[0]);
39. staff.setStaffName(strs[1]);
40. staff.setStaffDepartment(strs[2]);
41. staff.setStatus(strs[3]);
42. executor.insert("insertStaff",staff);
43. }
44. executor.executeBatch();
45. return null;
46. }
47. });
48. }
50. public void updateStaff(Staff staff){
51. getSqlMapClientTemplate().update("updateStaff",staff);
52. }
54. @SuppressWarnings("unchecked")
55. public List<Staff> selectAllStaff(Staff staff){
56. return getSqlMapClientTemplate().queryForList("selectStaff",staff);
57. }
59. public Staff selectStaffByNo(Staff staff){
60. return (Staff)getSqlMapClientTemplate().queryForObject("selectStaff",staff);
61. }
62. }
64. package org.swj.site.service;
66. import java.io.File;
67. import java.util.List;
69. import org.swj.site.dao.StaffDao;
70. import org.swj.site.domain.Staff;
72. public class StaffService
73. {
74. private StaffDao staffDao;
76. public void setStaffDao(StaffDao staffDao)
77. {
78. this.staffDao = staffDao;
79. }
80. public void insertStaff(File file,int sheetNum,int rowNum,int cellNum){
81. staffDao.insertStaff(file,sheetNum,rowNum,cellNum);
82. }
84. public void updateStaff(Staff staff){
85. staffDao.updateStaff(staff);
86. }
88. public List<Staff> selectAllStaff(Staff staff){
90. List<Staff> staffList = staffDao.selectAllStaff(staff);
92. return staffList;
93. }
95. public Staff selectStaffByNo(Staff staff){
96. return staffDao.selectStaffByNo(staff);
97. }
99. }