import javax.mail.*;
import javax.mail.internet.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.io.*;
import java.sql.*;
public class SammelMailGUI_Swing extends JFrame
{
private JButton sendButton = new JButton("Send Message");
private JLabel fromLabel = new JLabel("From: ");
private JLabel toLabel = new JLabel("To: ");
private JLabel hostLabel = new JLabel("SMTP Server: ");
private JLabel subjectLabel = new JLabel("Subject: ");
private JTextField fromField = new JTextField(40);
private JTextField toField = new JTextField(40);
private JTextField hostField = new JTextField(40);
private JTextField subjectField = new JTextField(40);
//private JTextArea message = new JTextArea(40,40);
//private JScrollPane jsp = new JScrollPane(message);
String INIEmailFrom;
String INIHost;
BufferedReader b;
String line;
String Mailline;
String[] tmp = null;
int counter=0;
String DBServer;
String DBName;
String DBUser;
String DBPassword;
public SammelMailGUI_Swing()
{
super("SammelMailGUI_Swing");
try
{
File Data = new File("C:/Dokumente und Einstellungen/Lempert/Desktop/Project/Data.ini");
b = new BufferedReader(new InputStreamReader(new FileInputStream(Data)));
while ((line = b.readLine()) != null)
{
tmp = line.split(": ");
if (counter==0)
INIEmailFrom=tmp[1];
else if (counter==1)
INIHost=tmp[1];
else if (counter==2)
DBServer=tmp[1];
else if (counter==3)
DBName=tmp[1];
else if (counter==4)
DBUser=tmp[1];
else if (counter==5)
DBPassword=tmp[1];
counter++;
}
b.close();
}
catch (IOException e)
{
System.out.println("Error during data reading");
}
//try
//{
//File MailData = new File("C:/MailSend.ini");
//b = new BufferedReader(new InputStreamReader(new FileInputStream(MailData)));
//while ((Mailline = b.readLine()) != null)
//{
//message.append(Mailline+ " \n");
//}
//b.close();
//}
//catch (IOException e)
//{
//System.out.println("Error during data reading");
//}
try
{
String resultauftrag=new String();
Class.forName("oracle.jdbc.driver.OracleDriver");
//DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@"+DBServer+":1521:"+DBName;
Connection connection = DriverManager.getConnection(url, DBUser, DBPassword);
connection.setAutoCommit(false);
Statement auftrag = connection.createStatement();
resultauftrag = "SELECT AUF001, AUF012, AUF004, AUF015, AUF016, AUF020 FROM Auftrag WHERE customerid='1619'";
ResultSet rs = auftrag.executeQuery(resultauftrag);
connection.commit();
java.util.List auf001 = new ArrayList();
java.util.List auf012 = new ArrayList();
java.util.List auf004 = new ArrayList();
java.util.List auf015 = new ArrayList();
java.util.List auf016 = new ArrayList();
java.util.List auf020 = new ArrayList();
while (rs.next())
{
auf001.add(rs.getString(1));
auf012.add(rs.getString(2));
auf004.add(rs.getString(3));
auf015.add(rs.getString(4));
auf016.add(rs.getString(5));
auf020.add(rs.getString(6));
}
Map map = new HashMap();
map.put("Auftragsnummer", auf001);
map.put("Kommissionsnummer", auf012);
map.put("Gedruckt am", auf004);
map.put("Umsatzwert", auf015);
map.put("WE", auf016);
map.put("Zustand", auf020);
java.util.List listauf001 = (java.util.List) map.get("Auftragsnummer");
java.util.List listauf012 = (java.util.List) map.get("Kommissionsnummer");
java.util.List listauf004 = (java.util.List) map.get("Gedruckt am");
java.util.List listauf015 = (java.util.List) map.get("Umsatzwert");
java.util.List listauf016 = (java.util.List) map.get("WE");
java.util.List listauf020 = (java.util.List) map.get("Zustand");
String outlist001;
String outlist012;
String outlist004;
String outlist015;
String outlist016;
String outlist020;
int len=listauf001.size();
for (int n=0;n<len;n++)
{
outlist001 = (String) listauf001.get(n);
outlist012 = (String) listauf012.get(n);
outlist004 = (String) listauf004.get(n);
outlist015 = (String) listauf015.get(n);
outlist016 = (String) listauf016.get(n);
outlist020 = (String) listauf020.get(n);
//message.append(outlist001 + "\t " + outlist012 + " \t " + outlist004 + "\t " + outlist015 + "\t " + outlist016 + "\t " + outlist020 + "\n");
}
}
catch(ClassNotFoundException e1)
{
e1.printStackTrace();
}
catch(Exception e2)
{
e2.printStackTrace();
}
Container contentPane = this.getContentPane();
contentPane.setLayout(new BorderLayout());
JPanel labels = new JPanel();
labels.setLayout(new GridLayout(4,1));
labels.add(hostLabel);
JPanel fields = new JPanel();
fields.setLayout(new GridLayout(4,1));
hostField.setText(INIHost);
hostField.setEditable(false);
fields.add(hostField);
labels.add(toLabel);
fields.add(toField);
fromField.setText(INIEmailFrom);
fromField.setEditable(false);
labels.add(fromLabel);
fields.add(fromField);
labels.add(subjectLabel);
fields.add(subjectField);
Box north = Box.createHorizontalBox();
north.add(labels);
north.add(fields);
//message.setEditable(false);
contentPane.add(north, BorderLayout.NORTH);
//message.setFont(new Font("Monospaced", Font.PLAIN,12));
//contentPane.add(jsp,BorderLayout.CENTER);
JPanel south = new JPanel();
south.setLayout(new FlowLayout(FlowLayout.CENTER));
south.add(sendButton);
sendButton.addActionListener(new SendAction());
contentPane.add(south, BorderLayout.SOUTH);
this.pack();
}
class SendAction implements ActionListener
{
public void actionPerformed(ActionEvent evt)
{
try
{
Properties props=new Properties();
props.put("mail.host", hostField.getText());
Session mailConnection=Session.getInstance(props,null);
final Message msg=new MimeMessage(mailConnection);
Address to=new InternetAddress(toField.getText());
Address from=new InternetAddress(fromField.getText());
//msg.setContent(message.getText(), "text/plain");
msg.setFrom(from);
msg.setRecipient(Message.RecipientType.TO, to);
msg.setSubject(subjectField.getText());
Runnable r = new Runnable()
{
public void run()
{
try
{
Transport.send(msg);
}
catch (Exception e)
{
e.printStackTrace();
}
}
};
Thread t = new Thread(r);
t.start();
//message.setText("");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
public static void main(String[] args)
{
String[][] data = new String[][]{
{"a", "b", "c", "d"},
{"e", "f", "g", "h"},
{"i", "j", "k", "l"}
};
String[] title = new String[]{
"A", "B", "C", "D"
};
JTable table = new JTable(data,title);
SammelMailGUI_Swing client = new SammelMailGUI_Swing();
client.getContentPane().add( new JScrollPane( table ) );
client.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
client.pack();
client.setVisible( true );
client.show();
}
}
