1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package com.cmsz.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.cmsz.vo.DepartmentVO;
/**
*
* @author huacha
*
*/
public class DepartmentDaoSupport extends DAOSupport {
public List<DepartmentVO> findByDepartmentId(String departmentId)
{
String sql="SELECT DEPARTMENT_ID, DEPARTMENT_CODE, DEPARTMENT_NAME, DEPARTMENT_NOTE FROM DIM_DEPARTMENT_INFO_T";
if (null==departmentId||departmentId.trim().isEmpty())
{
}
else
{
sql+=" where DEPARTMENT_ID="+departmentId;
}
List<DepartmentVO> departmentList=new ArrayList<DepartmentVO>();
try {
ResultSet rs=this.getResultSet(sql);
while(rs.next())
{
DepartmentVO vo=new DepartmentVO();
vo.setDepartmentId(rs.getString("DEPARTMENT_ID"));
vo.setDepartmentname(rs.getString("DEPARTMENT_NAME"));
vo.setNote(rs.getString("DEPARTMENT_NOTE"));
//userInfoVO.setWorkCode(rs.getString(""));
departmentList.add(vo);
}
this.closeAll();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return departmentList;
}
}