package db.app;
import javax.swing.JOptionPane;
import java.util.ArrayList;
import java.util.List;
public class MyWindow extends javax.swing.JFrame {
PersonManager pmgr = new PersonManager();
List<Person> persons = new ArrayList<Person>();
int currentRow = 0;
private void loadData()
{
persons = pmgr.getPersons();
}
private void bindData()
{
if(persons.size()>0)
{
Person p = persons.get(currentRow);
txtid.setText(p.getId()+"");
txtnama.setText(p.getNama());
txtalamat.setText(p.getAlamat());
}
else
{
currentRow = 0;
txtid.setText("");
txtnama.setText("");
txtalamat.setText("");
}
}
private void bprevActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(currentRow>0)
{
--currentRow;
}
bindData();
}
private void bnewActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
txtid.setText("");
txtnama.setText("");
txtalamat.setText("");
txttlp.setText("");
txtid.setEditable(true);
txtnama.setEditable(true);
txtalamat.setEditable(true);
txttlp.setEditable(true);
txtid.requestFocus();
}
private void bsaveActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
Person p = new Person();
p.setId(Integer.parseInt(txtid.getText()));
p.setNama(txtnama.getText());
p.setAlamat(txtalamat.getText());
p.setTelp(txttlp.getText());
if(pmgr.insert(p)>0)
{
loadData();
currentRow = persons.size()-1;
bindData();
JOptionPane.showMessageDialog(this,"DATA BERHASIL DISIMPAN","INFORMASI",JOptionPane.INFORMATION_MESSAGE);
txtid.setEditable(false);
txtnama.setEditable(false);
txtalamat.setEditable(false);
txttlp.setEditable(false);
}
else
{
JOptionPane.showMessageDialog(this,"DATA GAGAL DISIMPAN","INFORMASI",JOptionPane.INFORMATION_MESSAGE);
}
}
private void bdeleteActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
Person p = persons.get(currentRow);
if(pmgr.delete(p)>0)
{
loadData();
currentRow = currentRow-1;
bindData();
JOptionPane.showMessageDialog(this,"DATA BERHASIL DI HAPUS","INFORMASI",JOptionPane.INFORMATION_MESSAGE);
}
else
{
JOptionPane.showMessageDialog(this,"DATA BERHASIL DI HAPUS","INFORMASI",JOptionPane.INFORMATION_MESSAGE);
}
}
private void bnextActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(currentRow<0)
{
++currentRow;
}
bindData();
}
//person.java
package db.app;
/**
*
* @author acer 4738z
*/
public class Person {
private int id;
private String nama;
private String alamat;
private String telp;
public Person(){
}
public int getId(){
return id;
}
public void setId(int id){
this.id=id;
}
public String getNama(){
return nama;
}
public void setNama(String nama){
this.nama=nama;
}
public String getAlamat(){
return alamat;
}
public void setAlamat(String alamat){
this.alamat=alamat;
}
public String getTelp(){
return telp;
}
public void setTelp(String telp){
this.telp=telp;
}
}
//personmanager.java
package db.app;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
*
* @author acer 4738z
*/
public class PersonManager {
Connection con=null;
Statement st=null;
String url="jdbc:mysql://localhost:3306/dbapp_12090627";
String user="root";
String pass="password";
public PersonManager(){
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection(url, user, pass);
st=con.createStatement();
}catch(Exception ex){
ex.printStackTrace();
}
}
public List
getPersons(){
ResultSet rs=null;
List
persons=new ArrayList();
try{
rs=st.executeQuery("SELECT ID,NAMA,ALAMAT,TELP FROM tperson");
while(rs.next()){
Person p=new Person();
p.setId(rs.getInt(1));
p.setNama(rs.getString(2));
p.setAlamat(rs.getString(3));
p.setTelp(rs.getString(4));
persons.add(p);
}
}catch(Exception ex){
ex.printStackTrace();
}
return persons;
}
public int insert(Person p){
int result=0;
try{
result=st.executeUpdate("INSERT INTO tperson(id,nama,alamat,telp)"+"VALUES("+p.getId()+",'"+p.getNama()+"','"+p.getAlamat()+"',"+"'"+p.getTelp()+"')");
}catch(Exception ex){
ex.printStackTrace();
}
return result;
}
public int delete(Person p){
int result=0;
try{
result=st.executeUpdate("DELETE FROM tperson WHERE ID="+p.getId()+"");
}catch(Exception ex){
ex.printStackTrace();
}
return result;
}
}
MAHASISWA
package koneksi;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
private void btTambahActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
txtNim.setText("");
txtNama.setText("");
txtAlamat.setText("");
txtNim.setEditable(true);
txtNama.setEditable(true);
txtAlamat.setEditable(true);
txtNim.requestFocus();
}
private void btSimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nim = txtNim.getText();
String nama = txtNama.getText();
String alamat = txtAlamat.getText();
try
{
String dbname = "jdbc:odbc:latihanDB_12090627";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "insert into mahasiswa_12090627 values('"+nim+"','"+nama+"','"+alamat+"');";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null,"Data berhasil dimasukkan..","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null,"Error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void btCariActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nim = txtNim.getText();
try
{
String dbname = "jdbc:odbc:latihanDB_12090627";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
Statement statement = con.createStatement();
String sql = "SELECT * FROM mahasiswa_12090627 WHERE NIM like'"+nim+"'";
ResultSet rs = statement.executeQuery(sql);
if (rs.next())
{
txtNama.setText(rs.getString(2));
txtAlamat.setText(rs.getString(3));
JOptionPane.showMessageDialog(null,"Data Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
else
{
JOptionPane.showMessageDialog(null,"Data Tidak Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
statement.close();
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void btEditActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nim = txtNim.getText();
String nama = txtNama.getText();
String alamat = txtAlamat.getText();
try
{
String dbname = "jdbc:odbc:latihanDB_12090627";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
Statement statement = con.createStatement();
String sql = "UPDATE mahasiswa_12090627 SET NAMA = '"+nama+"',ALAMAT='"+alamat+"'WHERE NIM LIKE'"+nim+"'";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null,"Data berhasil di edit...","Edit Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void btHapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String nim = txtNim.getText();
try
{
String dbname = "jdbc:odbc:latihanDB_12090627";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
Statement statement = con.createStatement();
String sql = "DELETE FROM mahasiswa_12090627 WHERE NIM LIKE'"+nim+"'";
statement.executeUpdate(sql);
statement.close();
txtNim.setText("");
txtNama.setText("");
txtAlamat.setText("");
JOptionPane.showMessageDialog(null,"Data berhasil di hapus","Hapus Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
DATA BARANG
package Databarang;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
private void bttambahActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
txtkode.setText("");
txtnama.setText("");
txtharga.setText("");
txtstok.setText("");
txtsup.setText("");
txtjumbel.setText("");
txttotal.setText("");
txtkode.setEditable(true);
txtnama.setEditable(true);
txtharga.setEditable(true);
txtstok.setEditable(true);
txtsup.setEditable(true);
txtjumbel.setEditable(true);
txttotal.setEditable(true);
txtkode.requestFocus();
}
private void btsimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
String nama = txtnama.getText();
String harga = txtharga.getText();
String stok = txtstok.getText();
String suply = txtsup.getText();
String jumlah = txtjumbel.getText();
String total = txttotal.getText();
try
{
String dbname = "jdbc:odbc:latihanDB2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "insert into tabel_barang values('"+kode+"','"+nama+"','"+harga+"','"+stok+"','"+suply+"','"+jumlah+"','"+total+"');";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null,"Data berhasil dimasukkan..","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null,"Error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void btcariActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
try
{
String dbname = "jdbc:odbc:latihanDB2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "SELECT * FROM tabel_barang WHERE kd_barang like'"+kode+"'";
ResultSet rs = statement.executeQuery(sql);
if (rs.next())
{
txtnama.setText(rs.getString(2));
txtharga.setText(rs.getString(3));
txtstok.setText(rs.getString(4));
txtsup.setText(rs.getString(5));
txtjumbel.setText("");
txttotal.setText("");
txtjumbel.requestFocus();
JOptionPane.showMessageDialog(null,"Data Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
else
{
JOptionPane.showMessageDialog(null,"Data Tidak Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
statement.close();
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void bthapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
try
{
String dbname = "jdbc:odbc:latihanDB2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "DELETE FROM tabel_barang WHERE kd_barang LIKE'"+kode+"'";
statement.executeUpdate(sql);
statement.close();
txtkode.setText("");
txtnama.setText("");
txtharga.setText("");
txtstok.setText("");
txtsup.setText("");
txtjumbel.setText("");
txttotal.setText("");
JOptionPane.showMessageDialog(null,"Data berhasil di hapus","Hapus Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void txtjumbelActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
total=(Integer.parseInt(txtharga.getText()))*(Integer.parseInt(txtjumbel.getText()));
stok=(Integer.parseInt(txtstok.getText()))-(Integer.parseInt(txtjumbel.getText()));
txttotal.setText(Integer.toString(total));
txtstok.setText(Integer.toString(stok));
}
DATA STOK BARANG
package Databarang2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
private void btambahActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
txtkode.setText("");
txtmerk.setText("");
txtharga.setText("");
txtstok.setText("");
txtsuply.setText("");
txtkode.setEditable(true);
txtmerk.setEditable(true);
txtharga.setEditable(true);
txtstok.setEditable(true);
txtsuply.setEditable(true);
txtkode.requestFocus();
}
private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
String merk = txtmerk.getText();
String harga = txtharga.getText();
String stok = txtstok.getText();
String suply = txtsuply.getText();
try
{
String dbname = "jdbc:odbc:latihanDB3";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "insert into stok_barang values ('"+kode+"','"+merk+"','"+harga+"','"+stok+"','"+suply+"');";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null,"Data berhasil dimasukkan..","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null,"Error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void beditActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
String merk = txtmerk.getText();
String harga = txtharga.getText();
String stok = txtstok.getText();
String suply = txtsuply.getText();
try
{
String dbname = "jdbc:odbc:latihanDB3";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "UPDATE stok_barang SET Kode = '"+kode+"',Merk = '"+merk+"',Harga='"+harga+"',Stok='"+stok+"',Supplier='"+suply+"'WHERE Kode LIKE'"+kode+"'";
statement.executeUpdate(sql);
statement.close();
JOptionPane.showMessageDialog(null,"Data berhasil di edit...","Edit Data",
JOptionPane.INFORMATION_MESSAGE);
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void bcariActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String kode = txtkode.getText();
try
{
String dbname = "jdbc:odbc:latihanDB3";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbname,"admin","admin");
java.sql.Statement statement = con.createStatement();
String sql = "SELECT * FROM stok_barang WHERE KODE like'"+kode+"'";
ResultSet rs = statement.executeQuery(sql);
if (rs.next())
{
txtkode.setText(rs.getString(1));
txtmerk.setText(rs.getString(2));
txtharga.setText(rs.getString(3));
txtstok.setText(rs.getString(4));
txtsuply.setText(rs.getString(5));
JOptionPane.showMessageDialog(null,"Data Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
else
{
JOptionPane.showMessageDialog(null,"Data Tidak Ditemukan","Insert Data",
JOptionPane.INFORMATION_MESSAGE);
}
statement.close();
con.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
}
}
private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
JOptionPane.showMessageDialog(null,"Terima Kasih","Keluar",1);
System.exit(0);
}
Tidak ada komentar:
Posting Komentar