Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. try
  2. {
  3. connection = DriverManager.getConnection(
  4. "jdbc:oracle:thin:@localhost:1521:" + "XE", "hr","hr");
  5.  
  6. if (connection != null)
  7. {
  8. statement = connection.createStatement();
  9.  
  10. String q2 = "INSERT INTO HR.tweets (";
  11. q2 = q2 + "DATE_TIME,USER_NAME,TWEET_BEFORE,TWEET_AFTER)";
  12. q2 = q2 + "VALUES (";
  13. q2 = q2 + "(select SYSDATE from dual),";
  14. q2 = q2 + "'" + tweet.getUser().getScreenName() + "'" + ",";
  15. q2 = q2 + "'" + tweet.getText() + "'" +",";
  16. q2 = q2 + "'" + finalstring + "')";
  17.  
  18. statement.execute(q2);
  19. statement.close();
  20. connection.close();
  21. }
  22. }
  23. catch (SQLException e)
  24. {
  25. e.printStackTrace();
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement