|
发表于 2014-8-5 17:21:50
|
显示全部楼层
可以在action对应的java中操作javaBean
- public static List getOrganizedTask(String idcardNo, int pageNo,
- int pageSize) {
- String userId = "";
- X5ServiceProvider x5 = new X5ServiceProvider();
- String result = x5.getPersonInfo(x5.getUserId(idcardNo));
- String cookie = null;
- try {
- cookie = x5.Login(result.split(",")[0], result.split(",")[1]);
- } catch (IOException e1) {
- // TODO Auto-generated catch block
- e1.printStackTrace();
- } catch (SAXException e1) {
- // TODO Auto-generated catch block
- e1.printStackTrace();
- } catch (Exception e1) {
- // TODO Auto-generated catch block
- e1.printStackTrace();
- }
- userId = x5.getUserId(idcardNo);
- String sql = "select t.sstatusid sstatusid, t.sid taskId,t.screatorpersonname creatorName, ''|| t.seurl || '?task='|| t.sid || '&'||'activity-pattern=detail' || '&'|| 'language=zh_CN'|| '&' ||'executor=' || t.sexecutorfid || '&'|| 'bsessionid=' url,to_char(t.screatetime,'yyyy-MM-dd hh:mm:ss') createTime, ******to_char(t.slimittime,'yyyy-MM-dd hh:mm:ss') expireTime******,t.sname taskName from sa_task t where t.sexecutorpersonid = '"
- + userId + "' and t.sstatusid = 'tesFinished'";
- int intPageNo = 0;
- int intPageSize = 0;
- int totalCount = 0;
- String taskId = "";
- String creatorName = "";
- String url = "";
- String createTime = "";
- *****String expireTime = "";
- String taskName = "";
- List<Task> list = new ArrayList<Task>();
- int i;
- intPageNo = pageNo;
- intPageSize = pageSize;
- Connection con = null;
- Statement stmt = null;
- ResultSet rs = null;
- try {
- con = DBUtil.getSYSDBConnection();
- stmt = con.createStatement(
- java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,
- java.sql.ResultSet.CONCUR_READ_ONLY);
- rs = stmt.executeQuery(sql);
- rs.last();
- totalCount = rs.getRow();
- if (totalCount > 0) {
- if (intPageNo > 0) {
- rs.absolute((intPageNo - 1) * intPageSize + 1);
- i = 0;
- while (i < intPageSize && !rs.isAfterLast()) {
- taskId = rs.getString("taskId");
- creatorName = rs.getString("creatorName");
- url = "/x5" + rs.getString("url") + cookie;
- createTime = rs.getString("createTime");
- expireTime = rs.getString("expireTime");
- taskName = rs.getString("taskName");
- Task task = new Task();
- task.setTaskId(taskId);
- task.setTotalCount(totalCount);
- task.setCreatorName(creatorName);
- task.setUrl(url);
- task.setCreateTime(createTime);
- *****task.setExpireTime(expireTime);
- task.setTaskName(taskName);
- list.add(i, task);
- rs.next();
- i++;
- }
- }
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } finally {
- try {
- rs.close();
- if (rs != null)
- rs = null;
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- stmt.close();
- if (stmt != null)
- stmt = null;
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- try {
- con.close();
- if (con != null)
- con = null;
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- return list;
- }
复制代码 |
|