Java Reference
In-Depth Information
values[0] = article.getAttribute("id");
NodeList dataNodes = article.getChildNodes();
for(int i=0,j=1;i<dataNodes.getLength();i++){
Node dataNode = dataNodes.item(i);
if(dataNode.getNodeType()==Node.ELEMENT_NODE){
Node textNode = ((Element)dataNode).getFirstChild();
if(textNode!=null)
values[j++] = textNode.getNodeValue();
else
values[j++] = null;
}
}
return values;
}
private void prepareStatement(){
try {
Class.forName("com.inet.pool.PoolDriver");
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "MARS" );
tds.setDatabaseName( "MOREOVERNEWS" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
DataSource ds = tds;
con = ds.getConnection(dbUserName,dbPassword);
String SQLCmd = "INSERT INTO HEADLINES
VALUES(?,?,?,?,?,?,?,?,?,?,?);";
pstmt = con.prepareStatement(SQLCmd);
}catch(ClassNotFoundException e){
System.err.println(e.getMessage());
}catch(SQLException e){
System.err.println(e.getMessage());
}
}
private void closeConnection(){
try {
con.close();
}catch(SQLException e){
System.err.println(e.getMessage());
}
Search WWH ::




Custom Search