Revision 2653
Added by Jing Tao over 18 years ago
| src/edu/ucsb/nceas/metacat/RelationHandler.java | ||
|---|---|---|
| 172 | 172 |
* @param docid the document identifier of the package |
| 173 | 173 |
* @return the document identifier of the access file for that package |
| 174 | 174 |
*/ |
| 175 |
public static String getAccessFileID(String docid) throws SQLException |
|
| 175 |
public static String getAccessFileIDWithRevision(String docid) throws SQLException
|
|
| 176 | 176 |
{
|
| 177 | 177 |
String aclid = null; |
| 178 |
int rev; |
|
| 178 | 179 |
PreparedStatement pstmt = null; |
| 179 | 180 |
DBConnection dbConn = null; |
| 180 | 181 |
int serialNumber = -1; |
| 181 | 182 |
|
| 182 | 183 |
StringBuffer sql = new StringBuffer(); |
| 183 |
sql.append("SELECT docid FROM xml_documents WHERE docid in (SELECT subject ");
|
|
| 184 |
sql.append("SELECT docid, rev FROM xml_documents WHERE docid in (SELECT subject ");
|
|
| 184 | 185 |
sql.append("FROM xml_relation WHERE docid='").append(docid);
|
| 185 | 186 |
sql.append("' AND (");
|
| 186 | 187 |
Vector accessdoctypes = MetaCatUtil.getOptionList( |
| ... | ... | |
| 208 | 209 |
boolean hasRow = rs.next(); |
| 209 | 210 |
if (hasRow) {
|
| 210 | 211 |
aclid = rs.getString(1); |
| 212 |
rev = rs.getInt(2); |
|
| 213 |
aclid = aclid +MetaCatUtil.getOption("accNumSeparator")+rev;
|
|
| 211 | 214 |
} |
| 212 | 215 |
pstmt.close(); |
| 213 | 216 |
}//try |
Also available in: Unified diff
Change the method to get access document docid and revision.