Multiple File convert to 7Zip File and attachments Through the Email !

The Send Email Application has been created Using java with jdbc:oracle DataBase,with Multiple File convert to 7Zip File and attachments Through the Email .
Project  Folder and Jar File Position: 



Properties File: "dataBase.properties" is file Name
Application Code:
1. Zip7AutoTOEmail.java
package zip7autotoemail; import java.io.File; import java.io.FileInputStream; import java.io.FileWriter; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.Arrays; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Properties; import static zip7autotoemail.ZipCompress.muliZip; public class Zip7AutoTOEmail { /** * * @author manoj */ public static void main(String[] args) throws IOException { Properties prop = new Properties(); String DATABASE_URL = ""; String DATABASE_USER = ""; InputStream input; String DATABASE_PASSWORD = ""; ResultSet rs = null; Connection con = null; String TABLE_NAME = ""; String TABLE_FILE_NAME = ""; String TABLE_TO_EMAIL = ""; String EMAIL_USER_NAME = ""; String EMAIL_USER_PASSWORD = ""; String EMAIL_HOST = ""; String EMAIL_PORT = ""; String EMAIL_SUBJECT = ""; String EMAIL_TEXTBODY = ""; String ATTACHED_FILE_URL = ""; String ATTACHED_FILE7ZIP_URL = ""; String FILE_EXTATION = ""; String FILE_Name = ""; String result = ""; PrintWriter out = null; Map<String, String> map = new HashMap<String, String>(); SendMail sendTo = new SendMail(); //Create sending Log file Name EmailLogFile.txt out = new PrintWriter(new FileWriter("EmailLogFile.txt", true), true); try { System.out.print("Precessing......\n"); // Create properties File.. input = new FileInputStream("dataBase.properties"); prop.load(input); /*Database Connection*/ DATABASE_URL = prop.getProperty("DATABASE_URL"); DATABASE_USER = prop.getProperty("DATABASE_USER"); DATABASE_PASSWORD = prop.getProperty("DATABASE_PASSWORD"); /*Database Table Connection*/ TABLE_NAME = prop.getProperty("TABLE_NAME"); TABLE_FILE_NAME = prop.getProperty("TABLE_FILE_NAME"); TABLE_TO_EMAIL = prop.getProperty("TABLE_TO_EMAIL"); /*Email Connection With File Name*/ EMAIL_USER_NAME = prop.getProperty("EMAIL_USER_NAME"); EMAIL_USER_PASSWORD = prop.getProperty("EMAIL_USER_PASSWORD"); EMAIL_HOST = prop.getProperty("EMAIL_HOST"); EMAIL_PORT = prop.getProperty("EMAIL_PORT"); EMAIL_SUBJECT = prop.getProperty("EMAIL_SUBJECT"); EMAIL_TEXTBODY = prop.getProperty("EMAIL_TEXTBODY"); ATTACHED_FILE_URL = prop.getProperty("ATTACHED_FILE_URL"); ATTACHED_FILE7ZIP_URL = prop.getProperty("ATTACHED_FILE7ZIP_URL"); String sql = "Select " + TABLE_FILE_NAME + "," + TABLE_TO_EMAIL + " from " + TABLE_NAME +" ORDER by "+ TABLE_FILE_NAME; DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); con = DriverManager.getConnection(DATABASE_URL, DATABASE_USER, DATABASE_PASSWORD); Statement st = con.createStatement(); rs = st.executeQuery(sql); String Attachfile = ""; String AttachfileZip = ""; while (rs.next()) { if(rs.getString(TABLE_TO_EMAIL)!=null && !rs.getString(TABLE_TO_EMAIL).trim().isEmpty()){ map.put(rs.getString(TABLE_FILE_NAME), rs.getString(TABLE_TO_EMAIL)); }else{ out.println(rs.getString(TABLE_FILE_NAME)+" IS EMAIL NOT FOUND IN DATEBASE"); } } // get the property value and print it out File[] files = new File(ATTACHED_FILE_URL).listFiles(); Arrays.sort(files); String fileName = ""; String toEmail = ""; for(String fileNameDb: map.keySet()){ fileName = fileNameDb; toEmail = map.get(fileNameDb); //System.out.println(fileNameDb+" - " + map.get(fileNameDb)); if(toEmail!=null && !toEmail.trim().isEmpty() ){ List<string> fileAnme = new ArrayList<string>(); for (File file : files) { if (file.isFile()) { FILE_EXTATION = file.getName().substring(4, 12); FILE_Name = file.getName().substring(0, 4); if (FILE_Name.equalsIgnoreCase(fileName)) { Attachfile = ATTACHED_FILE_URL + file.getName(); fileAnme.add(file.getName()); // convert multiple files to 7Zip Function. muliZip(fileAnme, ATTACHED_FILE_URL, ATTACHED_FILE7ZIP_URL, fileName); } } } File[] files7Zip = new File(ATTACHED_FILE7ZIP_URL).listFiles(); for (File filezip : files7Zip) { if (filezip.isFile()) { FILE_Name = filezip.getName().substring(0, 4); int lastIndex = filezip.getName().lastIndexOf('.'); String str = filezip.getName().substring(lastIndex); if (FILE_Name.equalsIgnoreCase(fileName) && str.equalsIgnoreCase(".zip")) { AttachfileZip = ATTACHED_FILE7ZIP_URL + filezip.getName(); System.out.println(AttachfileZip); // Send multiple files attachments through SendToEmail Function. result =sendTo.SendToEmail(EMAIL_USER_NAME, EMAIL_USER_PASSWORD, EMAIL_HOST, EMAIL_PORT, toEmail, EMAIL_SUBJECT, EMAIL_TEXTBODY, AttachfileZip); if (result.equalsIgnoreCase("success")) { out.println("File Name is: " + filezip.getName() + " Email ID is: " + toEmail + " -> Mail Status is Success! \n And Send DateTime:" + new Date()); File indexzip = new File(AttachfileZip); if (indexzip.exists()) { indexzip.delete(); } } else { out.println("File Name is: " + filezip.getName() + " Email ID is: " + toEmail + " -> Mail Status is Failed! \n And Send DateTime:" + new Date()); } } } } } } con.close(); } catch (Exception ex) { out.println(ex.getMessage() + " Log DateTime is : " + new Date()); } out.flush(); out.close(); } }
2. ZipCompress.java
package zip7autotoemail; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.util.Arrays; import java.util.List; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; /** * * @author manoj */ public class ZipCompress { int i=0; public static void muliZip(List<string> srcFiles, String Pathpdf, String zipPath, String fileName) throws Exception{ FileOutputStream fos = new FileOutputStream(zipPath+fileName+".zip"); ZipOutputStream zipOut = new ZipOutputStream(fos); for (String srcFile : srcFiles) { File fileToZip = new File(Pathpdf+srcFile); FileInputStream fis = new FileInputStream(fileToZip); ZipEntry zipEntry = new ZipEntry(fileToZip.getName()); zipOut.putNextEntry(zipEntry); byte[] bytes = new byte[1024]; int length; while((length = fis.read(bytes)) >= 0) { zipOut.write(bytes, 0, length); } fis.close(); } zipOut.close(); fos.close(); } }
3. SendMail.java
package zip7autotoemail; import java.util.Properties; import javax.activation.DataHandler; import javax.activation.DataSource; import javax.activation.FileDataSource; import javax.mail.BodyPart; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.Multipart; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeBodyPart; import javax.mail.internet.MimeMessage; import javax.mail.internet.MimeMultipart; /** * * @author manoj */ public class SendMail { String success=""; int i=0; public String SendToEmail(String username, String password, String host, String port, String sentTomail, String Subject, String bodyText, String PathFile) throws Exception{ Properties props = new Properties(); props.put("mail.smtp.starttls.enable", "true"); props.put("mail.smtp.auth", "true"); props.put("mail.smtp.host", host); props.put("mail.smtp.port", port); String filePath = PathFile; Session session = Session.getInstance(props, new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); } }); try { if (sentTomail != null && sentTomail.matches("^[_A-Za-z0-9-\\+]+(\\.[_A-Za-z0-9-]+)*@[A-Za-z0-9-]+(\\.[A-Za-z0-9]+)*(\\.[A-Za-z]{2,})$")) { Message message = new MimeMessage(session); message.setFrom(new InternetAddress(username)); message.setRecipients(Message.RecipientType.TO, InternetAddress.parse(sentTomail)); message.setSubject(Subject); message.setText(bodyText); BodyPart messageBodyPart1 = new MimeBodyPart(); messageBodyPart1.setText(bodyText); // 4) create new MimeBodyPart object and set DataHandler object to this object MimeBodyPart messageBodyPart2 = new MimeBodyPart(); DataSource source = new FileDataSource(filePath); messageBodyPart2.setDataHandler(new DataHandler(source)); messageBodyPart2.setFileName(filePath); // 5) create Multipart object and add MimeBodyPart objects to this object Multipart multipart = new MimeMultipart(); multipart.addBodyPart(messageBodyPart1); multipart.addBodyPart(messageBodyPart2); message.setContent(multipart); Transport tr = session.getTransport("smtp"); tr.connect(host, username, password); tr.sendMessage(message, message.getAllRecipients()); tr.close(); success = "success"; System.out.println(success +"send ZIP Count :"+i++); } else { success = "Unable To Send or Some Error"; } } catch (MessagingException e) { success = RuntimeException(e); } return success; } private String RuntimeException(MessagingException e) { throw new RuntimeException(e); } }