Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General 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();
}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic