Java Reference
In-Depth Information
}
private int insertHeadline(String[] values){
int rowsInserted = -1;
try {
for(int i=0;i<values.length;i++){
pstmt.setString(i+1, fixApostrophes(values[i]));
}
rowsInserted = pstmt.executeUpdate();
}catch(SQLException e){
System.err.println(e.getMessage());
}
return rowsInserted;
}
private String fixApostrophes(String in) {
if(in!=null){
int n=0;
while((n=in.indexOf("'",n))>=0){
in = in.substring(0,n)+"'"+in.substring(n);
n+=2;
}
}
return in;
}
public static void main(String[] args){
try{
DOMParserBean parser = new DOMParserBean();
SQLInsertBean insertBean = new SQLInsertBean();
SerializerBean serializer = new SerializerBean();
parser.setUrlString(moreoverUrl);
parser.setDOMListener(insertBean);
//insertBean.setDOMListener(serializer);
parser.processDocument();
}catch(Exception e){
System.err.println("Exception in SQLInsertBeanTest");
}
}
}
