Guest User

Untitled

a guest
Feb 20th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.30 KB | None | 0 0
  1. connection = connector.getConnection();
  2. query = connection.prepareStatement(INSERT INTO document_s (document_id, document_name, document_type, creation_date, parent_id) VALUES(?,?,?,?,?), Statement.RETURN_GENERATED_KEYS);
  3. query.setNull(1, Types.INTEGER);
  4. query.setString(2, docid.getDoc_name());
  5. query.setString(3, docid.getDoc_type());
  6. query.setString(4, docid.getCreation_date());
  7. query.setInt(5, docid.getParent_id());
  8.  
  9. query.executeUpdate();
  10. resultSet = query.getGeneratedKeys();
  11. resultSet.next();
  12. int key = resultSet.getInt(1);
  13. query1 = connection.prepareStatement(INSERT INTO document_r(index, document_id, authors, keywords) VALUES(?,?,?,?));
  14. query1.setNull(1, Types.INTEGER);
  15. query1.setInt(2, key);
  16. query1.setString(3, docid.getAuthors());
  17. query1.setString(4, docid.getKeywords());
  18. query1.executeUpdate();
  19. return 0;
  20. } catch (SQLException e) {
  21. e.printStackTrace();
  22. } finally {
  23. connector.close1(connection, query, resultSet);
  24. }
  25. return 0;
  26.  
  27. for (String retval: s.split(" ")) {
  28. query1.setString(1, retval);
  29. query1.executeUpdate();
  30. }
  31.  
  32. String[] authors = docid.getAuthors().split(" ");
  33. String[] keywords = docid.getKeywords().split(" ");
  34. int minLen = Math.min(authors.length, keywords.length);
  35.  
  36. for (int i = 0; i < minLen; i++) {
  37. query1.setString(3, authors[i]);
  38. query1.setString(4, keyword[i]);
  39. query1.executeUpdate();
  40. }
  41.  
  42. query1.setNull(3, Types.STRING);
  43. for (int i = minLen; i < keywords.length; i++) {
  44. query1.setString(4, keyword[i]);
  45. query1.executeUpdate();
  46. }
  47.  
  48. query1.setNull(4, Types.STRING);
  49. for (int i = minLen; i < authors.length; i++) {
  50. query1.setString(3, authors[i]);
  51. query1.executeUpdate();
  52. }
  53.  
  54. String[] autors = docid.getAuthors().split( " " );
  55. String[] keywords = docid.getKeywords().split( " " );
  56. for ( int i = 0; i < Math.max( autors.length, keywords.lenght ); i++ ) {
  57. query.setInt( 1, i+1 );
  58. //? query.setTimestamp( 2, date );
  59. if ( i >= autors.length ) {
  60. query.setNull( 3, Types./*N*/VARCHAR );
  61. } else {
  62. query.setString( 3, autors[i] );
  63. }
  64. if ( i >= keywords.length ) {
  65. query.setNull( 4, Types./*N*/VARCHAR );
  66. } else {
  67. query.setString( 4, keywords[i] );
  68. }
  69. query.executeUpdate();
  70. }
Add Comment
Please, Sign In to add comment