public void addValue(DeweyID deweyID, String value, int parentCID) throws IOException, Exception {
// we may have problem here
// maybe we should update previously inserted attributes instead of insert new one
// FOR ATTrib Values (Actually they are behaved the same as text contents)
// text contents are not added to element index,thier CID shouldn be Zero
// elemIndex.insert(0,deweyID);
// bTreeIndex.insert(deweyID,-1,value);
logManager.LogManager.log(6, value);
logManager.LogManager.log(6, "Value: " + deweyID.toString());
try {
if (con != null) {
String sqlQuery =
"INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\" , \"Value\") VALUES (?, ? ,?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
pst.setString(3, value);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
// structSumIndex.add(-1,value,parentCID);THIS IS NOT NEEDED!
// checkBufPool();
}
public void addAttribute(DeweyID deweyID, String qName, int parentCID, boolean qNameFound)
throws IOException, Exception {
// parentCID is curNode's CID
// logManager.LogManager.log(6,qName);
// logManager.LogManager.log(6,"Attrib: "+deweyID.toString());
// logManager.LogManager.log(6,String.valueOf(deweyID.getCID()));
// }
// elemIndex.insert(deweyID.getCID(),deweyID);
// bTreeIndex.insert(deweyID,deweyID.getCID(),qName);
if (!qNameFound) {
// structSumIndex.add(deweyID.getCID(),qName,parentCID);
try {
if (con != null) {
String sqlQuery = "INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\") VALUES (?, ?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
// pst.setString(3, String.v);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
}
// checkBufPool();
}
public void addContent(DeweyID deweyID, StringBuilder contentBuilder, int parentCID)
throws IOException, Exception {
String content = new String(contentBuilder);
try {
if (con != null) {
String sqlQuery =
"INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\" , \"Value\") VALUES (?, ? ,?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
pst.setString(3, content);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
// text contents are not added to element index,thier CID shouldn be Zero
// elemIndex.insert(0,deweyID);
// bTreeIndex.insert(deweyID,-2,content);
// System.out.println("CID: -2");
// structSumIndex.add(-2,content,parentCID);THIS IS NOT NEEDED
// checkBufPool();
}
public void addElement(DeweyID deweyID, String qName, int parentCID, boolean qNameFound)
throws IOException, Exception, SQLException {
try {
if (con != null) {
String sqlQuery = "INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\") VALUES (?, ?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
}
