Java Reference
In-Depth Information
public MailSaver(){
try{
Class.forName("com.inet.pool.PoolDriver");
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "MARS" );
tds.setDatabaseName( "EMAIL" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
DataSource ds = tds;
con = ds.getConnection(dbUserName,dbPassword);
}
catch(Exception e){
System.err.println("SQL Exception registering driver");
}
}
public void saveEmail(String date,String sender,String senderEmail,
String subject,String mimeType,String msg){
String cmd = "INSERT INTO EMAIL "+
"(MsgDate,Sender,SenderEmail,Subject,ContentType,Message) "+
"VALUES(?,?,?,?,?,?)";
try {
PreparedStatement pstmt = con.prepareStatement(cmd);
pstmt.setString(1, date);
pstmt.setString(2, sender);
pstmt.setString(3, senderEmail);
pstmt.setString(4, subject);
pstmt.setString(5, mimeType);
pstmt.setString(6, msg);
pstmt.executeUpdate();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
The example of Listing 16-3 is a straightforward JavaMail application. It logs on to the SMTP server and
uses the getMessages() method to get all the messages on the server, as shown here:
Message[] msgs = folder.getMessages();
Search WWH ::




Custom Search