Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

saving messages

 
hon eb
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi every one i hve tried alot but cant save the incoming messages through java mail API into database ACCESS here is my code plz do do respond. It is not giving any errors at compile time of any kind but still not saving
//FOR DATABASE

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String sourceURL = "jdbc dbc:junk";
Connection databaseConnection=DriverManager.getConnection(sourceURL);
Statement statement=databaseConnection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

Subject=message[i].getSubject().toString();
Message=message[i].getContent().toString();
From=message[i].getFrom()[0].toString();
String Date="none";
PreparedStatement stat = databaseConnection.prepareStatement("INSERT INTO MINFO (From,Subject,Message,Date) VALUES(?,?,?,?)");
stat.setString(1,From);
stat.setString(2,Subject);
stat.setString(3,Message);
stat.setString(4,Date);
stat.executeUpdate();
stat.close();
}
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!