public void actionPerformed(ActionEvent ev) {
try {
// stok
String query = "DELETE FROM stok_produk WHERE id_produk=" + idProduk;
int hasil1 = stm.executeUpdate(query);
// pemasukkan
query = "DELETE FROM pemasukan WHERE id_produk=" + idProduk;
int hasil2 = stm.executeUpdate(query);
// pengeluaran
query = "DELETE FROM pengeluaran WHERE id_produk=" + idProduk;
int hasil3 = stm.executeUpdate(query);
// produk
query = "DELETE FROM produk WHERE id_produk=" + idProduk;
int hasil4 = stm.executeUpdate(query);
if (hasil1 == 1 || hasil2 == 1 || hasil3 == 1 && hasil4 == 1) {
setDataTabel();
JOptionPane.showMessageDialog(null, "berhasil hapus");
} else {
JOptionPane.showMessageDialog(null, "gagal");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
private void prosesEdit(String query) {
try {
int hasil = stm.executeUpdate(query);
if (hasil == 1) {
setDataTabel();
JOptionPane.showMessageDialog(null, "edit berhasil");
} else {
JOptionPane.showMessageDialog(null, "gagal");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
}
public void setJenis() {
dataJenis = new ArrayList<Jenis>();
try {
String qry = "SELECT * from jenis";
ResultSet rs = stm.executeQuery(qry);
while (rs.next()) {
Jenis j = new Jenis();
j.setIdJenis(rs.getInt("id_jenis"));
j.setNamaJenis(rs.getString("nama_jenis"));
dataJenis.add(j);
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
public void tableChanged(TableModelEvent tme) {
int baris = tme.getFirstRow();
int kolom = tme.getColumn();
TableModel model = (TableModel) tme.getSource();
int id = (Integer) model.getValueAt(baris, 0);
String query = "";
switch (kolom) {
case 1:
String nama = (String) model.getValueAt(baris, kolom);
query = "UPDATE produk SET nama_produk='" + nama + "' WHERE id_produk=" + id;
prosesEdit(query);
break;
case 2:
String jenis = (String) model.getValueAt(baris, kolom);
try {
query = "select * from jenis where nama_jenis='" + jenis + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idJenis = rs.getInt("id_jenis");
query = "UPDATE produk SET id_jenis=" + idJenis + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,jenis tidak ada");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
case 3:
int stok = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE `stok_produk` SET stok=" + stok + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 4:
int harga = (Integer) model.getValueAt(baris, kolom);
query = "UPDATE produk SET harga=" + harga + " WHERE id_produk=" + id;
prosesEdit(query);
break;
case 5:
String suplier = (String) model.getValueAt(baris, kolom);
try {
query = "SELECT * FROM suplier WHERE nama_suplier='" + suplier + "'";
ResultSet rs = stm.executeQuery(query);
if (rs.next()) {
int idSuplier = rs.getInt("id_suplier");
query = "UPDATE produk SET id_suplier=" + idSuplier + " WHERE id_produk=" + id;
prosesEdit(query);
} else {
setDataTabel();
JOptionPane.showMessageDialog(null, "gagal,suplier belum terdaftar");
}
} catch (SQLException SQLerr) {
SQLerr.printStackTrace();
}
break;
default:
break;
}
}
public void setContent(String cat) {
cat = cat.trim();
selectAllCB.setVisible(false);
selectAllCB.setSelected(false);
deleteBut.setVisible(false);
restoreBut.setVisible(false);
refreshBut.setVisible(true);
Object columns[] = null;
int count = 0;
switch (cat) {
case "Inbox":
columns = new Object[] {"", "From", "Date", "Subject", "Content"};
count = Database.getCount("Inbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='inbox' ORDER BY msg_id desc");
;
break;
case "SentMail":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Sentmail");
workingSet = db.getData("SELECT * FROM messages WHERE tag='sentmail' ORDER BY msg_id desc");
break;
case "Draft":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Draft");
workingSet = db.getData("SELECT * FROM messages WHERE tag='draft' ORDER BY msg_id desc");
break;
case "Outbox":
columns = new Object[] {"", "To", "Date", "Subject", "Content"};
count = Database.getCount("Outbox");
workingSet = db.getData("SELECT * FROM messages WHERE tag='outbox' ORDER BY msg_id desc");
break;
case "Trash":
// restoreBut.setVisible(true);
columns = new Object[] {"", "To/From", "Date", "Subject", "Content"};
count = Database.getCount("Trash");
workingSet =
db.getData(
"SELECT * FROM messages,trash WHERE messages.tag='trash' and messages.msg_id=trash.msg_id ORDER BY deleted_at desc");
break;
default:
System.out.println("in default case");
}
if (count > 0) {
selectAllCB.setVisible(true);
rows = new Object[count][];
msgID = new int[count];
try {
workingSet.beforeFirst();
for (int i = 0; i < count && workingSet.next(); i++) {
msgID[i] = workingSet.getInt(1);
rows[i] =
new Object[] {
false,
workingSet.getString(2),
workingSet.getDate(3),
workingSet.getString(4),
workingSet.getString(5)
};
}
} catch (SQLException sqlExc) {
JOptionPane.showMessageDialog(null, sqlExc, "EXCEPTION", JOptionPane.ERROR_MESSAGE);
sqlExc.printStackTrace();
}
tableModel = new MyDefaultTableModel(rows, columns);
table = new JTable(tableModel);
table.getSelectionModel().addListSelectionListener(this);
table.addMouseListener(this);
table.getTableHeader().setOpaque(true);
table.getTableHeader().setReorderingAllowed(false);
// table.getTableHeader().setBackground(Color.blue);
table.getTableHeader().setForeground(Color.blue);
// table.setRowSelectionAllowed(false);
// table.setColumnSelectionAllowed(false);
table.setFont(new Font(Font.SANS_SERIF, Font.PLAIN, 14));
table.setRowHeight(20);
table.setFillsViewportHeight(true);
TableColumn column = null;
for (int i = 0; i < 5; i++) {
column = table.getColumnModel().getColumn(i);
if (i == 0) {
column.setPreferredWidth(6);
} else if (i == 3) {
column.setPreferredWidth(250);
} else if (i == 4) {
column.setPreferredWidth(450);
} else {
column.setPreferredWidth(40);
}
}
table.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
remove(contentPan);
contentPan = new JScrollPane(table);
contentPan.setBackground(Color.orange);
contentPan.setOpaque(true);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
Home.home.homeFrame.setVisible(true);
} else {
JPanel centPan = new JPanel(new GridBagLayout());
centPan.setBackground(new Color(52, 86, 70));
JLabel label = new JLabel("No Messages In This Category");
label.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 22));
label.setForeground(Color.orange);
centPan.add(label);
remove(contentPan);
contentPan = new JScrollPane(centPan);
contentPan.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
add(contentPan, "Center");
contentPan.repaint();
}
}
public ItensVendidos() {
super("Itens Vendidos");
JButton imprimir;
final DefaultTableModel modelo = new DefaultTableModel();
// constrói a tabela
JTable tabela = new JTable(modelo);
// Cria duas colunas
modelo.addColumn("Código");
modelo.addColumn("Vendedor");
modelo.addColumn("Produto");
modelo.addColumn("Quantidade");
imprimir = new JButton("Imprimir");
imprimir.setBounds(100, 450, 30, 24);
// exibe os dados da tabela MySQL
// Conexao banco = new Conexao();
String retorno = "erro";
try {
// Connection ExConn = (Connection) banco.abrirBDconn();
Class.forName("com.mysql.jdbc.Driver");
Connection conexao = DriverManager.getConnection("jdbc:mysql://localhost/banco", "root", "");
Statement stmt = conexao.createStatement();
// procedimentos para obter os dados de uma tabela
String query = "SELECT * FROM venda2";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
int id = rs.getInt("idVendedor");
String nome = rs.getString("nomeVendedor");
String produto = rs.getString("produto");
int qtd = rs.getInt("qtd");
modelo.addRow(new Object[] {new Integer(id), nome, produto, new Integer(qtd)});
}
// fim procedimento para obter os dados
} catch (SQLException ex) {
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} catch (Exception e) {
System.out.println("Problemas ao tentar conectar com o banco de dados");
}
// fim MySQL
tabela.setPreferredScrollableViewportSize(new Dimension(350, 50));
Container c = getContentPane();
c.setLayout(new FlowLayout());
JScrollPane scrollPane = new JScrollPane(tabela);
c.add(scrollPane);
c.add(imprimir);
setSize(400, 300);
setVisible(true);
}
