Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try
- {
- connection = DriverManager.getConnection(
- "jdbc:oracle:thin:@localhost:1521:" + "XE", "hr","hr");
- if (connection != null)
- {
- statement = connection.createStatement();
- String q2 = "INSERT INTO HR.tweets (";
- q2 = q2 + "DATE_TIME,USER_NAME,TWEET_BEFORE,TWEET_AFTER)";
- q2 = q2 + "VALUES (";
- q2 = q2 + "(select SYSDATE from dual),";
- q2 = q2 + "'" + tweet.getUser().getScreenName() + "'" + ",";
- q2 = q2 + "'" + tweet.getText() + "'" +",";
- q2 = q2 + "'" + finalstring + "')";
- statement.execute(q2);
- statement.close();
- connection.close();
- }
- }
- catch (SQLException e)
- {
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement