Project kali ini Whitecyber Team diminta customer untuk mengerjakan software atau aplikasi untuk jual beli hasil pertanian menggunakan javabeans, database mysql. Berikut ini ulasan hasil dari pengerjaan Project tersebut.
Aplikasi pertanian menggunakan Java adalah aplikasi yang dibuat dengan menggunakan bahasa pemrograman Java untuk membantu petani dalam mengelola sektor pertanian. Aplikasi ini dapat menyediakan fitur-fitur seperti artikel pengetahuan terkait pertanian, jual beli peralatan dan hasil panen, forum komunikasi, dan budidaya pertanian. Aplikasi ini juga dapat memanfaatkan teknologi digital agroteknologi untuk meminimalkan risiko yang ada di sektor pertanian, seperti memprediksi kemungkinan hujan, serangan hama dan penyakit. Salah satu contoh aplikasi pertanian menggunakan Java adalah Crop Planning, yang dapat melakukan pengelolaan data perkebunan dan proses pertanian. Aplikasi pertanian menggunakan Java memiliki kelebihan seperti portabilitas, performa, keamanan, dan kemudahan pengembangan.
.
Projects :
- Software Framework : Netbeans
- File Type : Java
- Libraries : –
- Environtment : Java
- Resource : https://github.com/whitecyber-faris/project-dev-8
Jual beli hasil pertanian adalah suatu kegiatan ekonomi yang melibatkan pertukaran barang-barang hasil pertanian antara penjual dan pembeli. Barang-barang hasil pertanian dapat berupa tanaman pangan, hortikultura, perkebunan, peternakan, perikanan, atau kehutanan. Jual beli hasil pertanian dapat dilakukan secara langsung antara petani dan konsumen, atau melalui perantara seperti pedagang, koperasi, pasar, atau lembaga pemasaran lainnya. Jual beli hasil pertanian memiliki peran penting dalam meningkatkan kesejahteraan petani, memenuhi kebutuhan pangan masyarakat, dan mendukung pembangunan ekonomi nasional.
.
SOURCE CODE
/*
* Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
* Click nbfs://nbhost/SystemFileSystem/Templates/GUIForms/JFrame.java to edit this template
*/
package form;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author GK3v
*/
public class fpenjualan extends javax.swing.JFrame {
public Statement st;
public ResultSet rs;
Connection cn = KoneksiDatabase.BukaKoneksi();
int jawab;
/**
* Creates new form fpenjualan
*/
public fpenjualan() {
initComponents();
TampilData();
dataFromDataBaseToComboBox();
}
private void TampilData(){
try {
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM transaksi");
DefaultTableModel model = new DefaultTableModel();
model.addColumn("No.");
model.addColumn("Kode Nota");
model.addColumn("Nama");
model.addColumn("Panen");
model.addColumn("Berat");
model.addColumn("Jumlah");
model.addColumn("Harga");
model.addColumn("Total");
int no = 1;
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
model.setRowCount(0);
while (rs.next()) {
Object[] data = {
no ++,
rs.getString("kodenota"),
rs.getString("nama"),
rs.getString("panen"),
rs.getString("berat"),
rs.getString("jumlah"),
rs.getString("harga"),
rs.getString("total"),
};
model.addRow(data);
jTable1.setModel(model);
}
} catch (Exception e) {
}
}
public void dataFromDataBaseToComboBox(){
KoneksiDatabase.BukaKoneksi();
try {
String query = "SELECT * FROM panen";
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM panen");
while (rs.next()) {
jComboBox2.addItem(rs.getString("jenis_panen"));
}
rs.last();
int jumlahdata = rs.getRow();
rs.first();
} catch (SQLException e) {
}
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
jTextField2 = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jLabel4 = new javax.swing.JLabel();
jComboBox2 = new javax.swing.JComboBox<>();
jLabel5 = new javax.swing.JLabel();
jTextField3 = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
jTextField4 = new javax.swing.JTextField();
jTextField5 = new javax.swing.JTextField();
jButton2 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jTextField7 = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jButton4 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("Nama");
jLabel2.setText("Kode Nota");
jLabel3.setText("FORM PENJUALAN");
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);
jLabel4.setText("Panen");
jLabel5.setText("Harga");
jLabel6.setText("Jumlah");
jButton2.setText("Kembali");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jButton3.setText("Total");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt);
}
});
jLabel7.setText("Berat");
jButton4.setText("Simpan Nota");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(15, 15, 15)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel3)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jButton2)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel1)
.addComponent(jLabel4)
.addComponent(jLabel5)
.addComponent(jLabel6)
.addComponent(jLabel7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jTextField3, javax.swing.GroupLayout.DEFAULT_SIZE, 166, Short.MAX_VALUE)
.addComponent(jTextField2, javax.swing.GroupLayout.DEFAULT_SIZE, 166, Short.MAX_VALUE)
.addComponent(jTextField1)
.addComponent(jTextField5, javax.swing.GroupLayout.DEFAULT_SIZE, 166, Short.MAX_VALUE)
.addComponent(jTextField4, javax.swing.GroupLayout.DEFAULT_SIZE, 166, Short.MAX_VALUE)
.addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jComboBox2, 0, 166, Short.MAX_VALUE)
.addComponent(jTextField7)
.addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 518, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(0, 16, Short.MAX_VALUE))))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addComponent(jLabel3)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel7))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 17, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton4)
.addComponent(jButton2))
.addGap(16, 16, 16))
);
pack();
}// </editor-fold>
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
dispose();
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
//create variable
int angka1,angka2,hasil;
//input nilai
angka1 = Integer.parseInt(jTextField3.getText());
angka2 = Integer.parseInt(jTextField4.getText());
//ru;mus
hasil = angka1 * angka2;
//output
jTextField5.setText(Integer.toString(hasil));
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
st = cn.createStatement();
if (jTextField1.getText().equals("") || jTextField2.getText().equals("") || jTextField3.getText().equals("") || jTextField4.getText().equals("") || jTextField5.getText().equals("") || jTextField7.getText().equals("") ){
JOptionPane.showMessageDialog(null, "Data Tidak Boleh Kosong", "Validasi Data", JOptionPane.INFORMATION_MESSAGE);
return;
}
if (jButton4.getText() == "Simpan Nota") {
String cek = "SELECT * FROM transaksi WHERE kodenota = '" + jTextField1.getText() + "'";
rs = st.executeQuery(cek);
if ( rs.next()) {
JOptionPane.showMessageDialog(null, "Ups... Kode Nota ini sudah ada");
} else {
String sql = "INSERT INTO transaksi VALUES ('" + jTextField1.getText() + "','" + jTextField2.getText() + "','" + jComboBox2.getSelectedItem() + "','" + jTextField7.getText() + "','" + jTextField3.getText() + "','" + jTextField4.getText() + "','" + jTextField5.getText() + "')";
st.executeUpdate(sql);
jTextField8.setText(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil Disimpan");
TampilData();
}
} else {
// aksi ubah data
String update = "UPDATE fuel SET Produk = '" + txtProduk.getText() + "', Harga = '" + txtHarga.getText() + "', Stok = '" + txtStok.getText() + "' WHERE Kode = '" + txtKode.getText() + "'";
st.executeUpdate(update);
JOptionPane.showMessageDialog(null, "Data Berhasil Diupdate");
BersihPembelian();
TampilData();
}
} catch (Exception e) {
}
// TODO add your handling
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(fpenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(fpenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(fpenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(fpenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new fpenjualan().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JComboBox<String> jComboBox2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
private javax.swing.JTextField jTextField3;
private javax.swing.JTextField jTextField4;
private javax.swing.JTextField jTextField5;
private javax.swing.JTextField jTextField7;
// End of variables declaration
}
Bagaimana cara kerja Aplikasi Jual Beli Hasil Panen – Java?