コード例 #1
0
ファイル: AanLoader.java プロジェクト: memray/ACMParser
 private void process(AANPaper paper) throws NumberFormatException, SQLException {
   String sqlString =
       "INSERT INTO `semsearch`.`acl_paper` (`id`, `title`, `author`, `venue`, `year`) VALUES (?, ?, ?, ?, ?);";
   pstmt = conn.prepareStatement(sqlString);
   if (set.contains(paper.getId())) {
     return;
   } else {
     set.add(paper.getId());
   }
   pstmt.setString(1, paper.getId());
   pstmt.setString(2, paper.getTitle());
   pstmt.setString(3, paper.getAuthor());
   pstmt.setString(4, paper.getVenue());
   pstmt.setInt(5, Integer.parseInt(paper.getYear()));
   pstmt.executeUpdate();
   pstmt.close();
 }