public List
     
       searchTplReleaseById(TplRelease tr)throws Exception{        DBOperator dbo = getDBOperator();        try{            List
      
        tplReleaseList = new ArrayList
       
        ();            String sqlWhere = "select b.* from "+                            "(SELECT max(a.CREATE_TIME) AS CREATE_TIME ,  a.TPL_ID    FROM  template.tpl_release a WHERE a.TPL_ID =? AND a.TPL_STATUS ='1' GROUP BY a.TPL_ID ) c "+                            " left join template.tpl_release  b on c.CREATE_TIME = b.CREATE_TIME and c.TPL_ID = b.TPL_ID";            PreparedStatement pst = dbo.createPreparedStatement(sqlWhere);            pst.setString(1,tr.getTplID());            ResultSet rs = pst.executeQuery();            while (rs.next()) {                    TplRelease tplRelease = new TplRelease();                                tplRelease.setTplID(rs.getString("Tpl_ID"));                tplRelease.setTplVersion(rs.getString("Tpl_Version"));                tplRelease.setTplName(rs.getString("Tpl_Name"));                tplRelease.setTplNamePy(rs.getString("Tpl_Name_Py"));                tplRelease.setTplDesc(rs.getString("Tpl_Desc"));                tplRelease.setTplData(rs.getString("Tpl_Data"));                tplRelease.setTplStatus(rs.getString("Tpl_Status"));                tplRelease.setTreeNode(rs.getString("Tree_Node"));                tplRelease.setNodeIndex(rs.getString("Node_Index"));                tplRelease.setCreator(rs.getString("Creator"));                tplRelease.setCreateTime(rs.getString("Create_Time"));                tplRelease.setModifier(rs.getString("Modifier"));                tplRelease.setModifyTime(rs.getString("Modify_Time"));                tplRelease.setOwnerOrg(rs.getString("Owner_Org"));                tplRelease.setInoutFlag(rs.getString("Inout_Flag"));                tplRelease.setTplType(rs.getString("Tpl_Type"));                tplReleaseList.add(tplRelease);            }            dbo.commit();            return tplReleaseList;        }catch(Exception e){            dbo.rollback();            throw e;        }finally{            dbo.close();        }    }