Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- connection = connector.getConnection();
- query = connection.prepareStatement(INSERT INTO document_s (document_id, document_name, document_type, creation_date, parent_id) VALUES(?,?,?,?,?), Statement.RETURN_GENERATED_KEYS);
- query.setNull(1, Types.INTEGER);
- query.setString(2, docid.getDoc_name());
- query.setString(3, docid.getDoc_type());
- query.setString(4, docid.getCreation_date());
- query.setInt(5, docid.getParent_id());
- query.executeUpdate();
- resultSet = query.getGeneratedKeys();
- resultSet.next();
- int key = resultSet.getInt(1);
- query1 = connection.prepareStatement(INSERT INTO document_r(index, document_id, authors, keywords) VALUES(?,?,?,?));
- query1.setNull(1, Types.INTEGER);
- query1.setInt(2, key);
- query1.setString(3, docid.getAuthors());
- query1.setString(4, docid.getKeywords());
- query1.executeUpdate();
- return 0;
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- connector.close1(connection, query, resultSet);
- }
- return 0;
- for (String retval: s.split(" ")) {
- query1.setString(1, retval);
- query1.executeUpdate();
- }
- String[] authors = docid.getAuthors().split(" ");
- String[] keywords = docid.getKeywords().split(" ");
- int minLen = Math.min(authors.length, keywords.length);
- for (int i = 0; i < minLen; i++) {
- query1.setString(3, authors[i]);
- query1.setString(4, keyword[i]);
- query1.executeUpdate();
- }
- query1.setNull(3, Types.STRING);
- for (int i = minLen; i < keywords.length; i++) {
- query1.setString(4, keyword[i]);
- query1.executeUpdate();
- }
- query1.setNull(4, Types.STRING);
- for (int i = minLen; i < authors.length; i++) {
- query1.setString(3, authors[i]);
- query1.executeUpdate();
- }
- String[] autors = docid.getAuthors().split( " " );
- String[] keywords = docid.getKeywords().split( " " );
- for ( int i = 0; i < Math.max( autors.length, keywords.lenght ); i++ ) {
- query.setInt( 1, i+1 );
- //? query.setTimestamp( 2, date );
- if ( i >= autors.length ) {
- query.setNull( 3, Types./*N*/VARCHAR );
- } else {
- query.setString( 3, autors[i] );
- }
- if ( i >= keywords.length ) {
- query.setNull( 4, Types./*N*/VARCHAR );
- } else {
- query.setString( 4, keywords[i] );
- }
- query.executeUpdate();
- }
Add Comment
Please, Sign In to add comment