Examples of JSTree

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
   * @return
   */
  public List<JSTree> getRootNode(int id)
  {
    PreparedStatement pstm = null;
    JSTree rootNode = new JSTree();
    List<JSTree> result = new ArrayList<JSTree>();
    Connection conn = null;
    ResultSet rs = null;
    try{
      conn = DbPoolConnection.getInstance().getReadConnection();
      String sql = "select * from tree where parent_id="+id+"";
      pstm = conn.prepareStatement(sql);
      rs = pstm.executeQuery();
      if(rs.next()){
        rootNode.setId(rs.getInt("id"));
        rootNode.setParentId(rs.getInt("parent_id"));
        rootNode.setPosition(rs.getInt("position"));
        rootNode.setUserName(rs.getString("user_name"));
        rootNode.setTitle(rs.getString("title"));
        result.add(rootNode);
      }
    }catch(Exception e)
    {
      e.printStackTrace();
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
      conn = DbPoolConnection.getInstance().getReadConnection();
      String sql = "select * from tree where parent_id="+id+" and user_name='"+userName+"' order by title";
      pstm = conn.prepareStatement(sql);
      rs = pstm.executeQuery();
      while(rs.next()){
        JSTree jsTree = new JSTree();
        jsTree.setId(rs.getInt("id"));
        jsTree.setParentId(rs.getInt("parent_id"));
        jsTree.setPosition(rs.getInt("position"));
        jsTree.setUserName(rs.getString("user_name"));
        jsTree.setTitle(rs.getString("title"));
        jsTree.setFilters(rs.getString("filters"));
        result.add(jsTree);
      }
    }catch(Exception e)
    {
      e.printStackTrace();
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
        String deleteChildrenSql = "delete from tree where id in "+ids;
        pstm = conn.prepareStatement(deleteChildrenSql);
        pstm.execute();
      }
     
      JSTree node = this.getNodeById(id);

      //删除关注节点
      String filterIdsStr = node.getFilters();
      if (filterIdsStr != null) {
        String[] filterArray = filterIdsStr.split(",");
        if(filterArray != null && filterArray.length >0){
          for (String filterIdStr : filterArray) {
            DataAccessSession das = DataAccessFactory.getInstance().getSysDas();
            das.removeUserFocusFilter(DataAccessFactory.getInstance().createUUID(filterIdStr)); 
          }
        }
      }
     
      //删除定时器
      String deleteTimerSql = "delete from timer where filter_id in (" + filterIdsStr + ")" ;
      pstm = conn.prepareStatement(deleteTimerSql);
      pstm.execute();
     
      //更新同事节点的位置信息
      String updatePositionSql = "update tree set position=(position-1) where parent_id=? and position >?";
      pstm = conn.prepareStatement(updatePositionSql);
      pstm.setInt(1, node.getParentId());
      pstm.setInt(2, node.getPosition());
      pstm.execute();
     
    } catch (Exception e) {
      e.printStackTrace();
    }finally{
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

373
374
375
376
377
378
379
380
381
382
383
384
385
386
   */
  public boolean removeFilterId(int filterId,int parentId)
  {
    Connection conn = null;
    PreparedStatement pstm = null;
    JSTree parentNode = this.getNodeById(parentId);
    try{
      conn = DbPoolConnection.getInstance().getConnection();
      String oldFiltersStr = parentNode.getFilters();
      if(oldFiltersStr!=null&&!"".equals(oldFiltersStr))
      {
        String[] oldFiltersOld = oldFiltersStr.split(",");
        List<String> oldFiltersList= new ArrayList<String>();
        for(String str : oldFiltersOld)
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
   */
  public boolean addFilterToFolder(String filterId,int nodeId)
  {
    Connection conn = null;
    PreparedStatement pstm = null;
    JSTree node = this.getNodeById(nodeId);
    try
    {
      conn = DbPoolConnection.getInstance().getConnection();
      String oldFilters = node.getFilters();
      String newFilters = null;
      if(oldFilters==null||"".equals(oldFilters))
      {
        newFilters = filterId;
      }else
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
   */
  public boolean moveFilter(int filterId,int refId,int parentId)
  {
    Connection conn = null;
    PreparedStatement pstm = null;
    JSTree refNode = this.getNodeById(refId);
    JSTree parentNode = this.getNodeById(parentId);
    try{
      if(refId == parentId)
        return true;
      conn = DbPoolConnection.getInstance().getConnection();

      String oldFiltersStr = parentNode.getFilters();
      String newFiltersStr = refNode.getFilters();
      //先加入新的文件夹
      if(newFiltersStr!=null&&!"".equals(newFiltersStr))
      {
        if(newFiltersStr.contains(Integer.toString(filterId)))
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

575
576
577
578
579
580
581
582
583
584
585
586
  public boolean moveNode(int id,int refId,int position,String title,boolean copy,String userName){

    Connection conn = null;
    PreparedStatement pstm = null;

    JSTree node = this.getNodeById(id);
    JSTree refNode = this.getNodeById(refId);
   
    try{
      conn = DbPoolConnection.getInstance().getConnection();
      if(!copy)
      {
View Full Code Here

Examples of com.sogou.qadev.service.cynthia.bean.JSTree

39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
   * @param id
   * @return
   */
  public JSTree getNodeById(int id)
  {
    JSTree jsTree = new JSTree();
    PreparedStatement pstm = null;
    Connection conn = null;
    ResultSet rs = null;
    try{
      conn = DbPoolConnection.getInstance().getReadConnection();
      pstm = conn.prepareStatement("SELECT * FROM tree WHERE id =?");
      pstm.setInt(1, id);
      rs = pstm.executeQuery();
      if(rs.next()){
        jsTree.setId(rs.getInt("id"));
        jsTree.setParentId(rs.getInt("parent_id"));
        jsTree.setPosition(rs.getInt("position"));
        jsTree.setUserName(rs.getString("user_name"));
        jsTree.setTitle(rs.getString("title"));
        jsTree.setFilters(rs.getString("filters"));
      }
    }catch(Exception e)
    {
      e.printStackTrace();
    }finally
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.