package uts_pbo_2;
public class Surat {
private String noSurat;
private String perihal;
private String TglSurat;
private String TglTerima;
private String pengirim;
private String penerima;
private String search;
public Surat(){
}
public Surat(String noSurat, String perihal, String TglSurat, String TglTerima, String pengirim, String penerima) {
this.noSurat = noSurat;
this.perihal = perihal;
this.TglSurat = TglSurat;
this.TglTerima = TglTerima;
this.pengirim = pengirim;
this.penerima = penerima;
}
/**
* @return the noSurat
*/
public String getNoSurat() {
return noSurat;
}
/**
* @param noSurat the noSurat to set
*/
public void setNoSurat(String noSurat) {
this.noSurat = noSurat;
}
/**
* @return the perihal
*/
public String getPerihal() {
return perihal;
}
/**
* @param perihal the perihal to set
*/
public void setPerihal(String perihal) {
this.perihal = perihal;
}
/**
* @return the TglSurat
*/
public String getTglSurat() {
return TglSurat;
}
/**
* @param TglSurat the TglSurat to set
*/
public void setTglSurat(String TglSurat) {
this.TglSurat = TglSurat;
}
/**
* @return the TglTerima
*/
public String getTglTerima() {
return TglTerima;
}
/**
* @param TglTerima the TglTerima to set
*/
public void setTglTerima(String TglTerima) {
this.TglTerima = TglTerima;
}
/**
* @return the pengirim
*/
public String getPengirim() {
return pengirim;
}
/**
* @param pengirim the pengirim to set
*/
public void setPengirim(String pengirim) {
this.pengirim = pengirim;
}
/**
* @return the penerima
*/
public String getPenerima() {
return penerima;
}
/**
* @param penerima the penerima to set
*/
public void setPenerima(String penerima) {
this.penerima = penerima;
}
/**
* @return the search
*/
public String getSearch() {
return search;
}
/**
* @param search the search to set
*/
public void setSearch(String search) {
this.search = search;
}
}
Rabu, 21 Desember 2011
Proyek PBO_Kelas Read
package uts_pbo_2;
import java.awt.*;
import java.awt.event.*;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.SQLException;
import java.util.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
public class Read extends JFrame {
Scanner input = new Scanner(System.in);
JCheckBox cbox[];
DataHandler data;
private JRadioButton[] radioButton;
JButton ok;
ButtonGroup bg;
String[] btnText = {"No Surat", "Perihal", "Penerima", "Pengirim", "Tanggal Kirim", "Tanggal Terima"};
JPanel cpanel, opanel;
String word = null;
Surat key;
Read() {
}
public Read(Frame owner) {
Container content = getContentPane();
setTitle("Read Mail");
setSize(300, 300);
setLocation(300, 300);
content.setLayout(new BorderLayout());
cpanel = new JPanel(new GridLayout(0, 1));
cpanel.setBorder(BorderFactory.createTitledBorder("Cari Berdasarkan: "));
bg = new ButtonGroup();
radioButton = new JRadioButton[btnText.length];
for (int i = 0; i < radioButton.length; i++) {
radioButton[i] = new JRadioButton(btnText[i]);
// radioButton[i].addItemListener(this);
bg.add(radioButton[i]);
cpanel.add(radioButton[i]);
}
ok = new JButton("OK");
opanel = new JPanel();
opanel.add(ok);
content.add(cpanel, BorderLayout.CENTER);
content.add(opanel, BorderLayout.SOUTH);
ok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (radioButton[0].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchNo(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getNo());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[1].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchHal(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getHal());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[2].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchPenerima(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getPnrm());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[3].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchPengirim(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getPkrm());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[4].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchTglSurat(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getTglSurat());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else{
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchNo(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getTglTerima());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
});
}
}
import java.awt.*;
import java.awt.event.*;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.SQLException;
import java.util.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
public class Read extends JFrame {
Scanner input = new Scanner(System.in);
JCheckBox cbox[];
DataHandler data;
private JRadioButton[] radioButton;
JButton ok;
ButtonGroup bg;
String[] btnText = {"No Surat", "Perihal", "Penerima", "Pengirim", "Tanggal Kirim", "Tanggal Terima"};
JPanel cpanel, opanel;
String word = null;
Surat key;
Read() {
}
public Read(Frame owner) {
Container content = getContentPane();
setTitle("Read Mail");
setSize(300, 300);
setLocation(300, 300);
content.setLayout(new BorderLayout());
cpanel = new JPanel(new GridLayout(0, 1));
cpanel.setBorder(BorderFactory.createTitledBorder("Cari Berdasarkan: "));
bg = new ButtonGroup();
radioButton = new JRadioButton[btnText.length];
for (int i = 0; i < radioButton.length; i++) {
radioButton[i] = new JRadioButton(btnText[i]);
// radioButton[i].addItemListener(this);
bg.add(radioButton[i]);
cpanel.add(radioButton[i]);
}
ok = new JButton("OK");
opanel = new JPanel();
opanel.add(ok);
content.add(cpanel, BorderLayout.CENTER);
content.add(opanel, BorderLayout.SOUTH);
ok.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (radioButton[0].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchNo(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getNo());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[1].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchHal(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getHal());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[2].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchPenerima(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getPnrm());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[3].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchPengirim(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getPkrm());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else if (radioButton[4].isSelected()) {
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchTglSurat(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getTglSurat());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
} else{
data = new DataHandler();
try {
Surat surat = new Surat();
word = JOptionPane.showInputDialog("Masukkan Keyword: ");
surat.setSearch(word);
ArrayList test = data.searchNo(surat.getSearch());
for (int i = 0; i < test.size(); i++) {
DataHandler temp = (DataHandler) test.get(i);
JOptionPane.showMessageDialog(rootPane, temp.getTglTerima());
}
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
});
}
}
Proyek PBO_Kelas MailTable
package uts_pbo_2;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.swing.table.AbstractTableModel;
public class MailTable extends AbstractTableModel{
String columNames[] = {"No Surat", "Perihal", "Penerima", "Pengirim",
"Tanggal Kirim", "Tanggal Terima"};
ArrayList data;
public MailTable(String keyword) throws SQLException {
data = DataHandler.searchNo(keyword);
}
public int getRowCount() {
return data.size();
}
public int getColumnCount() {
return columNames.length;
}
@Override
public String getColumnName(int col) {
return columNames[col];
}
public Object getValueAt(int rowIndex, int columnIndex) {
DataHandler temp = (DataHandler) data.get(rowIndex);
if (columnIndex == 0) {
return temp.getNo();
} else if (columnIndex == 1){
return temp.getHal();
} else if (columnIndex == 2){
return temp.getPnrm();
}else if (columnIndex == 3){
return temp.getPkrm();
}else if (columnIndex == 4){
return temp.getTglSurat();
}else {
return temp.getTglTerima();
}
}
@Override
public Class getColumnClass(int c) {
return getValueAt(0, c).getClass();
}
}
import java.sql.SQLException;
import java.util.ArrayList;
import javax.swing.table.AbstractTableModel;
public class MailTable extends AbstractTableModel{
String columNames[] = {"No Surat", "Perihal", "Penerima", "Pengirim",
"Tanggal Kirim", "Tanggal Terima"};
ArrayList data;
public MailTable(String keyword) throws SQLException {
data = DataHandler.searchNo(keyword);
}
public int getRowCount() {
return data.size();
}
public int getColumnCount() {
return columNames.length;
}
@Override
public String getColumnName(int col) {
return columNames[col];
}
public Object getValueAt(int rowIndex, int columnIndex) {
DataHandler temp = (DataHandler) data.get(rowIndex);
if (columnIndex == 0) {
return temp.getNo();
} else if (columnIndex == 1){
return temp.getHal();
} else if (columnIndex == 2){
return temp.getPnrm();
}else if (columnIndex == 3){
return temp.getPkrm();
}else if (columnIndex == 4){
return temp.getTglSurat();
}else {
return temp.getTglTerima();
}
}
@Override
public Class getColumnClass(int c) {
return getValueAt(0, c).getClass();
}
}
Proyek PBO_Kelas KotakMasuk
package uts_pbo_2;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
public class KotakMasuk extends JFrame {
JMenu menuFile, menuHelp;
JMenuItem itemPengirim, exit, baca, semua;
JMenuBar bar;
DataSuratMasuk surat;
Read read;
ImageIcon img;
JLabel label;
public KotakMasuk() {
Container content = getContentPane();
setSize(400, 300);
setLocation(300, 300);
setTitle("Kotak Masuk");
setDefaultCloseOperation(EXIT_ON_CLOSE);
img = new ImageIcon("Koala.jpg");
label = new JLabel(img);
content.add(label);
menuFile = new JMenu("File");
menuHelp = new JMenu("Help");
bar = new JMenuBar();
itemPengirim = new JMenuItem("New Mail");
baca = new JMenuItem("Read Mail");
semua = new JMenuItem("Mail Table");
exit = new JMenuItem("Exit");
setJMenuBar(bar);
bar.add(menuFile);
bar.add(menuHelp);
menuFile.add(baca);
menuFile.add(itemPengirim);
menuFile.add(semua);
menuFile.addSeparator();
menuFile.add(exit);
baca.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
DataHandler data = new DataHandler();
read = new Read(new KotakMasuk());
read.setVisible(true);
}
});
itemPengirim.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
surat = new DataSuratMasuk(new KotakMasuk());
surat.setVisible(true);
}
});
semua.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
JDialog dialog = new JDialog(new JFrame(), true);
AllTable searchPanel = new AllTable("");
dialog.add(searchPanel);
dialog.setSize(600, 300);
dialog.setVisible(true);
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
exit.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
setDefaultCloseOperation(EXIT_ON_CLOSE);
}
}
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
public class KotakMasuk extends JFrame {
JMenu menuFile, menuHelp;
JMenuItem itemPengirim, exit, baca, semua;
JMenuBar bar;
DataSuratMasuk surat;
Read read;
ImageIcon img;
JLabel label;
public KotakMasuk() {
Container content = getContentPane();
setSize(400, 300);
setLocation(300, 300);
setTitle("Kotak Masuk");
setDefaultCloseOperation(EXIT_ON_CLOSE);
img = new ImageIcon("Koala.jpg");
label = new JLabel(img);
content.add(label);
menuFile = new JMenu("File");
menuHelp = new JMenu("Help");
bar = new JMenuBar();
itemPengirim = new JMenuItem("New Mail");
baca = new JMenuItem("Read Mail");
semua = new JMenuItem("Mail Table");
exit = new JMenuItem("Exit");
setJMenuBar(bar);
bar.add(menuFile);
bar.add(menuHelp);
menuFile.add(baca);
menuFile.add(itemPengirim);
menuFile.add(semua);
menuFile.addSeparator();
menuFile.add(exit);
baca.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
DataHandler data = new DataHandler();
read = new Read(new KotakMasuk());
read.setVisible(true);
}
});
itemPengirim.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
surat = new DataSuratMasuk(new KotakMasuk());
surat.setVisible(true);
}
});
semua.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
JDialog dialog = new JDialog(new JFrame(), true);
AllTable searchPanel = new AllTable("");
dialog.add(searchPanel);
dialog.setSize(600, 300);
dialog.setVisible(true);
} catch (SQLException ex) {
Logger.getLogger(KotakMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
});
exit.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
setDefaultCloseOperation(EXIT_ON_CLOSE);
}
}
Proyek PBO_Kelas
package uts_pbo_2;
import java.awt.FlowLayout;
import java.awt.Frame;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
public class DataSuratMasuk extends JDialog {
JLabel labelNo, labelHal, labelTglSurat, labelTglTerima, labelPengirim, labelPenerima;
JTextField fieldNo, fieldHal, fieldTglSurat, fieldTglTerima, fieldPengirim, fieldPenerima;
JButton btnOK;
public DataSuratMasuk(Frame owner) {
super(owner);
setTitle("Data Surat Masuk");
setSize(500, 250);
setLocation(300, 300);
setResizable(false);
setLayout(new FlowLayout());
labelNo = new JLabel("No");
labelHal = new JLabel("Perihal");
labelTglSurat = new JLabel("Tanggal Surat (DD-MMM-YY)");
labelTglTerima = new JLabel("Tanggal Terima (DD-MMM-YY)");
labelPengirim = new JLabel("Pengirim");
labelPenerima = new JLabel("Penerima");
fieldNo = new JTextField(20);
fieldHal = new JTextField(20);
fieldPenerima = new JTextField(20);
fieldPengirim = new JTextField(20);
fieldTglSurat = new JTextField(20);
fieldTglTerima = new JTextField(20);
JPanel panel = new JPanel(new GridLayout(6, 1));
getContentPane().add(panel);
panel.setBorder(BorderFactory.createTitledBorder("Masukkan Identitas Surat: "));
panel.add(labelNo);
panel.add(fieldNo);
panel.add(labelHal);
panel.add(fieldHal);
panel.add(labelPenerima);
panel.add(fieldPenerima);
panel.add(labelPengirim);
panel.add(fieldPengirim);
panel.add(labelTglSurat);
panel.add(fieldTglSurat);
panel.add(labelTglTerima);
panel.add(fieldTglTerima);
btnOK = new JButton("Simpan");
getContentPane().add(btnOK);
btnOK.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (fieldNo.getText().equals("") || fieldHal.getText().equals("") || fieldPenerima.getText().equals("")
|| fieldPengirim.getText().equals("") || fieldTglSurat.getText().equals("")
|| fieldTglTerima.getText().equals("")) {
JOptionPane.showMessageDialog(null, "Ada Field yang Kosong");
} else {
Surat surat = new Surat();
surat.setNoSurat(fieldNo.getText());
surat.setPerihal(fieldHal.getText());
surat.setTglSurat(fieldTglSurat.getText());
surat.setTglTerima(fieldTglTerima.getText());
surat.setPenerima(fieldPenerima.getText());
surat.setPengirim(fieldPengirim.getText());
JOptionPane.showMessageDialog(rootPane, "Surat Telah Berhasil Disimpan");
DataHandler datahandler = new DataHandler();
try {
datahandler.add(surat.getNoSurat(), surat.getPerihal(), surat.getPenerima(),
surat.getPengirim(), surat.getTglSurat(), surat.getTglTerima());
} catch (SQLException ex) {
Logger.getLogger(DataSuratMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
});
}
}
import java.awt.FlowLayout;
import java.awt.Frame;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
public class DataSuratMasuk extends JDialog {
JLabel labelNo, labelHal, labelTglSurat, labelTglTerima, labelPengirim, labelPenerima;
JTextField fieldNo, fieldHal, fieldTglSurat, fieldTglTerima, fieldPengirim, fieldPenerima;
JButton btnOK;
public DataSuratMasuk(Frame owner) {
super(owner);
setTitle("Data Surat Masuk");
setSize(500, 250);
setLocation(300, 300);
setResizable(false);
setLayout(new FlowLayout());
labelNo = new JLabel("No");
labelHal = new JLabel("Perihal");
labelTglSurat = new JLabel("Tanggal Surat (DD-MMM-YY)");
labelTglTerima = new JLabel("Tanggal Terima (DD-MMM-YY)");
labelPengirim = new JLabel("Pengirim");
labelPenerima = new JLabel("Penerima");
fieldNo = new JTextField(20);
fieldHal = new JTextField(20);
fieldPenerima = new JTextField(20);
fieldPengirim = new JTextField(20);
fieldTglSurat = new JTextField(20);
fieldTglTerima = new JTextField(20);
JPanel panel = new JPanel(new GridLayout(6, 1));
getContentPane().add(panel);
panel.setBorder(BorderFactory.createTitledBorder("Masukkan Identitas Surat: "));
panel.add(labelNo);
panel.add(fieldNo);
panel.add(labelHal);
panel.add(fieldHal);
panel.add(labelPenerima);
panel.add(fieldPenerima);
panel.add(labelPengirim);
panel.add(fieldPengirim);
panel.add(labelTglSurat);
panel.add(fieldTglSurat);
panel.add(labelTglTerima);
panel.add(fieldTglTerima);
btnOK = new JButton("Simpan");
getContentPane().add(btnOK);
btnOK.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
if (fieldNo.getText().equals("") || fieldHal.getText().equals("") || fieldPenerima.getText().equals("")
|| fieldPengirim.getText().equals("") || fieldTglSurat.getText().equals("")
|| fieldTglTerima.getText().equals("")) {
JOptionPane.showMessageDialog(null, "Ada Field yang Kosong");
} else {
Surat surat = new Surat();
surat.setNoSurat(fieldNo.getText());
surat.setPerihal(fieldHal.getText());
surat.setTglSurat(fieldTglSurat.getText());
surat.setTglTerima(fieldTglTerima.getText());
surat.setPenerima(fieldPenerima.getText());
surat.setPengirim(fieldPengirim.getText());
JOptionPane.showMessageDialog(rootPane, "Surat Telah Berhasil Disimpan");
DataHandler datahandler = new DataHandler();
try {
datahandler.add(surat.getNoSurat(), surat.getPerihal(), surat.getPenerima(),
surat.getPengirim(), surat.getTglSurat(), surat.getTglTerima());
} catch (SQLException ex) {
Logger.getLogger(DataSuratMasuk.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
});
}
}
ProyekPBO_Kelas DataHandler
package uts_pbo_2;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import oracle.jdbc.pool.OracleDataSource;
public class DataHandler {
String jdbcUrl = "jdbc:oracle:thin:172.23.9.185:1521:orcl";
String userid = "mhs105314031";
String password = "mhs105314031";
Connection conn;
Statement stmt;
ResultSet rset;
String query;
String sqlString;
private String no;
private String hal;
private String pnrm;
private String pkrm;
private String TglSurat;
private String TglTerima;
public DataHandler() {
}
public DataHandler(String no, String hal, String pnrm, String pkrm, String TglSurat, String TglTerima) {
this.no = no;
this.hal = hal;
this.pnrm = pnrm;
this.pkrm = pkrm;
this.TglSurat = TglSurat;
this.TglTerima = TglTerima;
}
public void getDBConnection() throws SQLException {
OracleDataSource ds;
ds = new OracleDataSource();
ds.setURL(jdbcUrl);
conn = ds.getConnection(userid, password);
}
public ResultSet getAllEmployees() throws SQLException {
getDBConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
// query = "SELECT * FROM Employees ORDER BY employee_id";
query = "SELECT first_name FROM Employees ORDER BY employee_id";
System.out.println("\nExecuting query: " + query);
rset = stmt.executeQuery(query);
return rset;
}
public static ArrayList searchMail(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchNo(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where NoSurat like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchHal(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Perihal) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchPenerima(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Penerima) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchPengirim(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Pengirim) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchTglSurat(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where TglSurat like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchTglTerima(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where TglTerima like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static void add(String no, String hal, String pnrm, String pkrm, String TglSurat, String TglTerima) throws SQLException {
DataHandler dataHandler = new DataHandler();
ArrayList result = null;
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "INSERT INTO Mail VALUES ('" + no + "', '" + hal + "', '"
+ pnrm + "', '" + pkrm + "', '" + TglSurat + "', '"
+ TglTerima + "')";
result = new ArrayList();
try {
result.add(stmt.executeUpdate(query));
} catch (SQLException ex) {
System.out.println("error : " + ex.getMessage());
}
conn.close();
}
/**
* @return the no
*/
public String getNo() {
return no;
}
/**
* @param no the no to set
*/
public void setNo(String no) {
this.no = no;
}
/**
* @return the hal
*/
public String getHal() {
return hal;
}
/**
* @param hal the hal to set
*/
public void setHal(String hal) {
this.hal = hal;
}
/**
* @return the pnrm
*/
public String getPnrm() {
return pnrm;
}
/**
* @param pnrm the pnrm to set
*/
public void setPnrm(String pnrm) {
this.pnrm = pnrm;
}
/**
* @return the pkrm
*/
public String getPkrm() {
return pkrm;
}
/**
* @param pkrm the pkrm to set
*/
public void setPkrm(String pkrm) {
this.pkrm = pkrm;
}
/**
* @return the TglSurat
*/
public String getTglSurat() {
return TglSurat;
}
/**
* @param TglSurat the TglSurat to set
*/
public void setTglSurat(String TglSurat) {
this.TglSurat = TglSurat;
}
/**
* @return the TglTerima
*/
public String getTglTerima() {
return TglTerima;
}
/**
* @param TglTerima the TglTerima to set
*/
public void setTglTerima(String TglTerima) {
this.TglTerima = TglTerima;
}
}
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import oracle.jdbc.pool.OracleDataSource;
public class DataHandler {
String jdbcUrl = "jdbc:oracle:thin:172.23.9.185:1521:orcl";
String userid = "mhs105314031";
String password = "mhs105314031";
Connection conn;
Statement stmt;
ResultSet rset;
String query;
String sqlString;
private String no;
private String hal;
private String pnrm;
private String pkrm;
private String TglSurat;
private String TglTerima;
public DataHandler() {
}
public DataHandler(String no, String hal, String pnrm, String pkrm, String TglSurat, String TglTerima) {
this.no = no;
this.hal = hal;
this.pnrm = pnrm;
this.pkrm = pkrm;
this.TglSurat = TglSurat;
this.TglTerima = TglTerima;
}
public void getDBConnection() throws SQLException {
OracleDataSource ds;
ds = new OracleDataSource();
ds.setURL(jdbcUrl);
conn = ds.getConnection(userid, password);
}
public ResultSet getAllEmployees() throws SQLException {
getDBConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
// query = "SELECT * FROM Employees ORDER BY employee_id";
query = "SELECT first_name FROM Employees ORDER BY employee_id";
System.out.println("\nExecuting query: " + query);
rset = stmt.executeQuery(query);
return rset;
}
public static ArrayList searchMail(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchNo(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where NoSurat like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchHal(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Perihal) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchPenerima(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Penerima) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchPengirim(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where LOWER (Pengirim) like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchTglSurat(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where TglSurat like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static ArrayList searchTglTerima(String keyword) throws SQLException {
ArrayList result = null;
DataHandler dataHandler = new DataHandler();
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM Mail where TglTerima like '%" + keyword + "%'";
ResultSet rset = stmt.executeQuery(query);
result = new ArrayList();
while (rset.next()) {
DataHandler temp = new DataHandler(rset.getString(1),rset.getString(2),rset.getString(3)
,rset.getString(4),rset.getString(5),rset.getString(6));
result.add(temp);
}
conn.close();
return result;
}
public static void add(String no, String hal, String pnrm, String pkrm, String TglSurat, String TglTerima) throws SQLException {
DataHandler dataHandler = new DataHandler();
ArrayList result = null;
dataHandler.getDBConnection();
Connection conn = dataHandler.conn;
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "INSERT INTO Mail VALUES ('" + no + "', '" + hal + "', '"
+ pnrm + "', '" + pkrm + "', '" + TglSurat + "', '"
+ TglTerima + "')";
result = new ArrayList();
try {
result.add(stmt.executeUpdate(query));
} catch (SQLException ex) {
System.out.println("error : " + ex.getMessage());
}
conn.close();
}
/**
* @return the no
*/
public String getNo() {
return no;
}
/**
* @param no the no to set
*/
public void setNo(String no) {
this.no = no;
}
/**
* @return the hal
*/
public String getHal() {
return hal;
}
/**
* @param hal the hal to set
*/
public void setHal(String hal) {
this.hal = hal;
}
/**
* @return the pnrm
*/
public String getPnrm() {
return pnrm;
}
/**
* @param pnrm the pnrm to set
*/
public void setPnrm(String pnrm) {
this.pnrm = pnrm;
}
/**
* @return the pkrm
*/
public String getPkrm() {
return pkrm;
}
/**
* @param pkrm the pkrm to set
*/
public void setPkrm(String pkrm) {
this.pkrm = pkrm;
}
/**
* @return the TglSurat
*/
public String getTglSurat() {
return TglSurat;
}
/**
* @param TglSurat the TglSurat to set
*/
public void setTglSurat(String TglSurat) {
this.TglSurat = TglSurat;
}
/**
* @return the TglTerima
*/
public String getTglTerima() {
return TglTerima;
}
/**
* @param TglTerima the TglTerima to set
*/
public void setTglTerima(String TglTerima) {
this.TglTerima = TglTerima;
}
}
Proyek PBO_Kelas AllTable
package uts_pbo_2;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class AllTable extends JPanel{
public AllTable(String keyWord) throws SQLException {
super(new GridLayout(1,0));
JTable table = new JTable(new MailTable(keyWord));
table.setPreferredScrollableViewportSize(new Dimension(500, 300));
JScrollPane scrollPane = new JScrollPane(table);
add(scrollPane);
}
}
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class AllTable extends JPanel{
public AllTable(String keyWord) throws SQLException {
super(new GridLayout(1,0));
JTable table = new JTable(new MailTable(keyWord));
table.setPreferredScrollableViewportSize(new Dimension(500, 300));
JScrollPane scrollPane = new JScrollPane(table);
add(scrollPane);
}
}
Langganan:
Postingan (Atom)