Created
June 23, 2018 08:03
-
-
Save robelunatics/5d3a2c662175369d53f121521369a4a5 to your computer and use it in GitHub Desktop.
NETBEANS 8.2 DATABASE CUSTOMER APP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8" ?> | |
<Form version="1.9" maxVersion="1.9" type="org.netbeans.modules.form.forminfo.JFrameFormInfo"> | |
<Properties> | |
<Property name="defaultCloseOperation" type="int" value="3"/> | |
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="c5" green="6a" id="nbProgressBar.Foreground" palette="3" red="31" type="palette"/> | |
</Property> | |
</Properties> | |
<SyntheticProperties> | |
<SyntheticProperty name="formSizePolicy" type="int" value="1"/> | |
<SyntheticProperty name="generateCenter" type="boolean" value="false"/> | |
</SyntheticProperties> | |
<AuxValues> | |
<AuxValue name="FormSettings_autoResourcing" type="java.lang.Integer" value="0"/> | |
<AuxValue name="FormSettings_autoSetComponentName" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_generateFQN" type="java.lang.Boolean" value="true"/> | |
<AuxValue name="FormSettings_generateMnemonicsCode" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_i18nAutoMode" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_layoutCodeTarget" type="java.lang.Integer" value="1"/> | |
<AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/> | |
<AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/> | |
</AuxValues> | |
<Layout> | |
<DimensionLayout dim="0"> | |
<Group type="103" groupAlignment="0" attributes="0"> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="70" pref="70" max="-2" attributes="0"/> | |
<Component id="jLabel1" min="-2" pref="330" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="70" pref="70" max="-2" attributes="0"/> | |
<Component id="jLabel2" min="-2" pref="80" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="170" pref="170" max="-2" attributes="0"/> | |
<Component id="jTextField2" min="-2" pref="220" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="170" pref="170" max="-2" attributes="0"/> | |
<Component id="jTextField5" min="-2" pref="220" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="60" pref="60" max="-2" attributes="0"/> | |
<Component id="jLabel4" min="-2" pref="100" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="60" pref="60" max="-2" attributes="0"/> | |
<Component id="jLabel6" min="-2" pref="100" max="-2" attributes="0"/> | |
<EmptySpace min="10" pref="10" max="-2" attributes="0"/> | |
<Component id="jTextField4" min="-2" pref="220" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="60" pref="60" max="-2" attributes="0"/> | |
<Component id="Tnew" min="-2" pref="57" max="-2" attributes="0"/> | |
<EmptySpace min="13" pref="13" max="-2" attributes="0"/> | |
<Component id="Tsimpan" min="-2" pref="63" max="-2" attributes="0"/> | |
<EmptySpace min="7" pref="7" max="-2" attributes="0"/> | |
<Component id="Tedit" min="-2" pref="51" max="-2" attributes="0"/> | |
<EmptySpace min="19" pref="19" max="-2" attributes="0"/> | |
<Component id="Thapus" min="-2" pref="49" max="-2" attributes="0"/> | |
<EmptySpace min="11" pref="11" max="-2" attributes="0"/> | |
<Component id="Tkeluar" min="-2" pref="72" max="-2" attributes="0"/> | |
</Group> | |
<Component id="jScrollPane1" min="-2" pref="480" max="-2" attributes="0"/> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="170" pref="170" max="-2" attributes="0"/> | |
<Component id="jTextField1" min="-2" pref="220" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="170" pref="170" max="-2" attributes="0"/> | |
<Component id="jTextField3" min="-2" pref="220" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="60" pref="60" max="-2" attributes="0"/> | |
<Component id="jLabel7" min="-2" pref="90" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="60" pref="60" max="-2" attributes="0"/> | |
<Component id="jLabel3" min="-2" pref="90" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="90" pref="90" max="-2" attributes="0"/> | |
<Component id="jLabel5" min="-2" pref="270" max="-2" attributes="0"/> | |
</Group> | |
<Component id="jLabel8" min="-2" pref="480" max="-2" attributes="0"/> | |
</Group> | |
</DimensionLayout> | |
<DimensionLayout dim="1"> | |
<Group type="103" groupAlignment="0" attributes="0"> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="20" pref="20" max="-2" attributes="0"/> | |
<Component id="jLabel1" min="-2" pref="17" max="-2" attributes="0"/> | |
<EmptySpace min="183" pref="183" max="-2" attributes="0"/> | |
<Component id="jLabel2" min="-2" max="-2" attributes="0"/> | |
<EmptySpace min="16" pref="16" max="-2" attributes="0"/> | |
<Component id="jTextField2" min="-2" pref="30" max="-2" attributes="0"/> | |
<EmptySpace min="10" pref="10" max="-2" attributes="0"/> | |
<Component id="jTextField5" min="-2" pref="30" max="-2" attributes="0"/> | |
<EmptySpace min="20" pref="20" max="-2" attributes="0"/> | |
<Component id="jLabel4" min="-2" max="-2" attributes="0"/> | |
<EmptySpace min="26" pref="26" max="-2" attributes="0"/> | |
<Group type="103" groupAlignment="0" attributes="0"> | |
<Component id="jLabel6" min="-2" pref="30" max="-2" attributes="0"/> | |
<Component id="jTextField4" min="-2" pref="30" max="-2" attributes="0"/> | |
</Group> | |
<EmptySpace min="30" pref="30" max="-2" attributes="0"/> | |
<Group type="103" groupAlignment="0" attributes="0"> | |
<Component id="Tnew" min="-2" max="-2" attributes="0"/> | |
<Component id="Tsimpan" min="-2" max="-2" attributes="0"/> | |
<Component id="Tedit" min="-2" max="-2" attributes="0"/> | |
<Component id="Thapus" min="-2" max="-2" attributes="0"/> | |
<Component id="Tkeluar" min="-2" max="-2" attributes="0"/> | |
</Group> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="490" pref="490" max="-2" attributes="0"/> | |
<Component id="jScrollPane1" min="-2" pref="170" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="210" pref="210" max="-2" attributes="0"/> | |
<Component id="jTextField1" min="-2" pref="30" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="330" pref="330" max="-2" attributes="0"/> | |
<Component id="jTextField3" min="-2" pref="30" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="300" pref="300" max="-2" attributes="0"/> | |
<Component id="jLabel7" min="-2" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="260" pref="260" max="-2" attributes="0"/> | |
<Component id="jLabel3" min="-2" max="-2" attributes="0"/> | |
</Group> | |
<Group type="102" attributes="0"> | |
<EmptySpace min="50" pref="50" max="-2" attributes="0"/> | |
<Component id="jLabel5" min="-2" pref="150" max="-2" attributes="0"/> | |
</Group> | |
<Component id="jLabel8" min="-2" pref="660" max="-2" attributes="0"/> | |
</Group> | |
</DimensionLayout> | |
</Layout> | |
<SubComponents> | |
<Component class="javax.swing.JLabel" name="jLabel1"> | |
<Properties> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Times New Roman" size="24" style="1"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="INPUT DATA PEMESANAN"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel2"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Kode Boking"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel3"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Nama Destinasi"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel4"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Total Pembayaran"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JTextField" name="jTextField1"> | |
<Properties> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.EtchedBorderInfo"> | |
<EtchetBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JTextField" name="jTextField2"> | |
<Properties> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.EtchedBorderInfo"> | |
<EtchetBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JTextField" name="jTextField3"> | |
<Properties> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.EtchedBorderInfo"> | |
<EtchetBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JButton" name="Tsimpan"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Simpan"/> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.SoftBevelBorderInfo"> | |
<BevelBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="TsimpanActionPerformed"/> | |
</Events> | |
</Component> | |
<Component class="javax.swing.JButton" name="Tedit"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Edit"/> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.SoftBevelBorderInfo"> | |
<BevelBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="TeditActionPerformed"/> | |
</Events> | |
</Component> | |
<Component class="javax.swing.JButton" name="Thapus"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Hapus"/> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.SoftBevelBorderInfo"> | |
<BevelBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="ThapusActionPerformed"/> | |
</Events> | |
</Component> | |
<Component class="javax.swing.JButton" name="Tkeluar"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Keluar"/> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.SoftBevelBorderInfo"> | |
<BevelBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="mouseClicked" listener="java.awt.event.MouseListener" parameters="java.awt.event.MouseEvent" handler="TkeluarMouseClicked"/> | |
</Events> | |
</Component> | |
<Container class="javax.swing.JScrollPane" name="jScrollPane1"> | |
<AuxValues> | |
<AuxValue name="autoScrollPane" type="java.lang.Boolean" value="true"/> | |
</AuxValues> | |
<Layout class="org.netbeans.modules.form.compat2.layouts.support.JScrollPaneSupportLayout"/> | |
<SubComponents> | |
<Component class="javax.swing.JTable" name="jTable1"> | |
<Properties> | |
<Property name="model" type="javax.swing.table.TableModel" editor="org.netbeans.modules.form.editors2.TableModelEditor"> | |
<Table columnCount="0" rowCount="0"/> | |
</Property> | |
<Property name="columnModel" type="javax.swing.table.TableColumnModel" editor="org.netbeans.modules.form.editors2.TableColumnModelEditor"> | |
<TableColumnModel selectionModel="0"/> | |
</Property> | |
<Property name="tableHeader" type="javax.swing.table.JTableHeader" editor="org.netbeans.modules.form.editors2.JTableHeaderEditor"> | |
<TableHeader reorderingAllowed="true" resizingAllowed="true"/> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="mouseClicked" listener="java.awt.event.MouseListener" parameters="java.awt.event.MouseEvent" handler="jTable1MouseClicked"/> | |
</Events> | |
</Component> | |
</SubComponents> | |
</Container> | |
<Component class="javax.swing.JLabel" name="jLabel5"> | |
<Properties> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="10" style="0"/> | |
</Property> | |
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor"> | |
<Image iconType="2" name="C:\Users\robelunatics\Downloads\jalan2brologo.jpg"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="Database Pemesanan Paket Tour Jalan2BRO.com"/> | |
<Property name="verticalAlignment" type="int" value="1"/> | |
<Property name="cursor" type="java.awt.Cursor" editor="org.netbeans.modules.form.editors2.CursorEditor"> | |
<Color id="Default Cursor"/> | |
</Property> | |
<Property name="debugGraphicsOptions" type="int" value="-1"/> | |
<Property name="horizontalTextPosition" type="int" value="0"/> | |
<Property name="verticalTextPosition" type="int" value="1"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel6"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Nama Pemesan"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JTextField" name="jTextField4"> | |
</Component> | |
<Component class="javax.swing.JButton" name="Tnew"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="New"/> | |
<Property name="border" type="javax.swing.border.Border" editor="org.netbeans.modules.form.editors2.BorderEditor"> | |
<Border info="org.netbeans.modules.form.compat2.border.SoftBevelBorderInfo"> | |
<BevelBorder/> | |
</Border> | |
</Property> | |
</Properties> | |
<Events> | |
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="TnewActionPerformed"/> | |
</Events> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel7"> | |
<Properties> | |
<Property name="text" type="java.lang.String" value="Total Peserta"/> | |
</Properties> | |
</Component> | |
<Component class="javax.swing.JTextField" name="jTextField5"> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel8"> | |
<Properties> | |
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor"> | |
<Image iconType="2" name="C:\Users\robelunatics\Downloads\30494969-travel-background-pattern.jpg"/> | |
</Property> | |
</Properties> | |
</Component> | |
</SubComponents> | |
</Form> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* To change this license header, choose License Headers in Project Properties. | |
* To change this template file, choose Tools | Templates | |
* and open the template in the editor. | |
*/ | |
package prjtransaksi; | |
import java.sql.*; | |
import javax.swing.*; | |
import javax.xml.crypto.Data; | |
import net.proteanit.sql.DbUtils; | |
import javax.swing.JOptionPane; | |
/** | |
* | |
* @author robelunatics | |
*/ | |
public class FormBarang extends javax.swing.JFrame { | |
Connection con=null; | |
ResultSet rs=null; | |
PreparedStatement pst=null; | |
Statement StatBrg; | |
boolean ada=false; | |
/** | |
* Creates new form FormBarang | |
*/ | |
public FormBarang() { | |
initComponents(); | |
koneksi(); | |
display(); | |
} | |
/** | |
* 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">//GEN-BEGIN:initComponents | |
private void initComponents() { | |
jLabel1 = new javax.swing.JLabel(); | |
jLabel2 = new javax.swing.JLabel(); | |
jLabel3 = new javax.swing.JLabel(); | |
jLabel4 = new javax.swing.JLabel(); | |
jTextField1 = new javax.swing.JTextField(); | |
jTextField2 = new javax.swing.JTextField(); | |
jTextField3 = new javax.swing.JTextField(); | |
Tsimpan = new javax.swing.JButton(); | |
Tedit = new javax.swing.JButton(); | |
Thapus = new javax.swing.JButton(); | |
Tkeluar = new javax.swing.JButton(); | |
jScrollPane1 = new javax.swing.JScrollPane(); | |
jTable1 = new javax.swing.JTable(); | |
jLabel5 = new javax.swing.JLabel(); | |
jLabel6 = new javax.swing.JLabel(); | |
jTextField4 = new javax.swing.JTextField(); | |
Tnew = new javax.swing.JButton(); | |
jLabel7 = new javax.swing.JLabel(); | |
jTextField5 = new javax.swing.JTextField(); | |
jLabel8 = new javax.swing.JLabel(); | |
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); | |
setBackground(javax.swing.UIManager.getDefaults().getColor("nbProgressBar.Foreground")); | |
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 24)); // NOI18N | |
jLabel1.setText("INPUT DATA PEMESANAN"); | |
jLabel2.setText("Kode Boking"); | |
jLabel3.setText("Nama Destinasi"); | |
jLabel4.setText("Total Pembayaran"); | |
jTextField1.setBorder(javax.swing.BorderFactory.createEtchedBorder()); | |
jTextField2.setBorder(javax.swing.BorderFactory.createEtchedBorder()); | |
jTextField3.setBorder(javax.swing.BorderFactory.createEtchedBorder()); | |
Tsimpan.setText("Simpan"); | |
Tsimpan.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED)); | |
Tsimpan.addActionListener(new java.awt.event.ActionListener() { | |
public void actionPerformed(java.awt.event.ActionEvent evt) { | |
TsimpanActionPerformed(evt); | |
} | |
}); | |
Tedit.setText("Edit"); | |
Tedit.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED)); | |
Tedit.addActionListener(new java.awt.event.ActionListener() { | |
public void actionPerformed(java.awt.event.ActionEvent evt) { | |
TeditActionPerformed(evt); | |
} | |
}); | |
Thapus.setText("Hapus"); | |
Thapus.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED)); | |
Thapus.addActionListener(new java.awt.event.ActionListener() { | |
public void actionPerformed(java.awt.event.ActionEvent evt) { | |
ThapusActionPerformed(evt); | |
} | |
}); | |
Tkeluar.setText("Keluar"); | |
Tkeluar.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED)); | |
Tkeluar.addMouseListener(new java.awt.event.MouseAdapter() { | |
public void mouseClicked(java.awt.event.MouseEvent evt) { | |
TkeluarMouseClicked(evt); | |
} | |
}); | |
jTable1.setModel(new javax.swing.table.DefaultTableModel( | |
new Object [][] { | |
}, | |
new String [] { | |
} | |
)); | |
jTable1.addMouseListener(new java.awt.event.MouseAdapter() { | |
public void mouseClicked(java.awt.event.MouseEvent evt) { | |
jTable1MouseClicked(evt); | |
} | |
}); | |
jScrollPane1.setViewportView(jTable1); | |
jLabel5.setFont(new java.awt.Font("Tahoma", 0, 10)); // NOI18N | |
jLabel5.setIcon(new javax.swing.ImageIcon("C:\\Users\\robelunatics\\Downloads\\jalan2brologo.jpg")); // NOI18N | |
jLabel5.setText("Database Pemesanan Paket Tour Jalan2BRO.com"); | |
jLabel5.setVerticalAlignment(javax.swing.SwingConstants.TOP); | |
jLabel5.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR)); | |
jLabel5.setDebugGraphicsOptions(javax.swing.DebugGraphics.NONE_OPTION); | |
jLabel5.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER); | |
jLabel5.setVerticalTextPosition(javax.swing.SwingConstants.TOP); | |
jLabel6.setText("Nama Pemesan"); | |
Tnew.setText("New"); | |
Tnew.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.RAISED)); | |
Tnew.addActionListener(new java.awt.event.ActionListener() { | |
public void actionPerformed(java.awt.event.ActionEvent evt) { | |
TnewActionPerformed(evt); | |
} | |
}); | |
jLabel7.setText("Total Peserta"); | |
jLabel8.setIcon(new javax.swing.ImageIcon("C:\\Users\\robelunatics\\Downloads\\30494969-travel-background-pattern.jpg")); // NOI18N | |
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(70, 70, 70) | |
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 330, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(70, 70, 70) | |
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(170, 170, 170) | |
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(170, 170, 170) | |
.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(60, 60, 60) | |
.addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(60, 60, 60) | |
.addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(10, 10, 10) | |
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(60, 60, 60) | |
.addComponent(Tnew, javax.swing.GroupLayout.PREFERRED_SIZE, 57, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(13, 13, 13) | |
.addComponent(Tsimpan, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(7, 7, 7) | |
.addComponent(Tedit, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(19, 19, 19) | |
.addComponent(Thapus, javax.swing.GroupLayout.PREFERRED_SIZE, 49, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(11, 11, 11) | |
.addComponent(Tkeluar, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 480, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(170, 170, 170) | |
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(170, 170, 170) | |
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 220, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(60, 60, 60) | |
.addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(60, 60, 60) | |
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(90, 90, 90) | |
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 270, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 480, javax.swing.GroupLayout.PREFERRED_SIZE) | |
); | |
layout.setVerticalGroup( | |
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(20, 20, 20) | |
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 17, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(183, 183, 183) | |
.addComponent(jLabel2) | |
.addGap(16, 16, 16) | |
.addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(10, 10, 10) | |
.addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addGap(20, 20, 20) | |
.addComponent(jLabel4) | |
.addGap(26, 26, 26) | |
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) | |
.addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE) | |
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGap(30, 30, 30) | |
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) | |
.addComponent(Tnew) | |
.addComponent(Tsimpan) | |
.addComponent(Tedit) | |
.addComponent(Thapus) | |
.addComponent(Tkeluar))) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(490, 490, 490) | |
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(210, 210, 210) | |
.addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(330, 330, 330) | |
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(300, 300, 300) | |
.addComponent(jLabel7)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(260, 260, 260) | |
.addComponent(jLabel3)) | |
.addGroup(layout.createSequentialGroup() | |
.addGap(50, 50, 50) | |
.addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)) | |
.addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 660, javax.swing.GroupLayout.PREFERRED_SIZE) | |
); | |
pack(); | |
}// </editor-fold>//GEN-END:initComponents | |
private void TsimpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_TsimpanActionPerformed | |
// TODO add your handling code here: | |
try{ | |
koneksi(); | |
StatBrg=con.createStatement(); | |
String SQL="insert into barang values('"+jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jTextField4.getText()+"','"+jTextField5.getText()+"')"; | |
StatBrg.executeUpdate(SQL); | |
display(); | |
StatBrg.close(); | |
con.close(); | |
}catch(Exception exc){ | |
System.err.println(exc.getMessage()); | |
} | |
}//GEN-LAST:event_TsimpanActionPerformed | |
int brs; | |
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked | |
// TODO add your handling code here: | |
if(evt.getClickCount()==1){ | |
brs=jTable1.rowAtPoint(evt.getPoint()); | |
jTextField1.setText(jTable1.getValueAt(brs, 0).toString()); | |
jTextField2.setText(jTable1.getValueAt(brs, 1).toString()); | |
jTextField3.setText(jTable1.getValueAt(brs, 2).toString()); | |
jTextField4.setText(jTable1.getValueAt(brs, 3).toString()); | |
jTextField5.setText(jTable1.getValueAt(brs, 4).toString()); | |
} | |
}//GEN-LAST:event_jTable1MouseClicked | |
private void TeditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_TeditActionPerformed | |
// TODO add your handling code here: | |
try{ | |
koneksi(); | |
StatBrg=con.createStatement(); | |
String SQL=("update barang set nabar='"+jTextField2.getText()+"',pembayaran='"+jTextField3.getText()+"',nama_pemesan='"+jTextField4.getText()+"',total_peserta='"+jTextField5.getText()+"'where kobar='"+jTextField1.getText()+"'"); | |
StatBrg.executeUpdate(SQL); | |
display(); | |
StatBrg.close(); | |
con.close(); | |
}catch(Exception exc){ | |
System.err.println(exc.getMessage()); | |
} | |
}//GEN-LAST:event_TeditActionPerformed | |
private void ThapusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_ThapusActionPerformed | |
// TODO add your handling code here: | |
try{ | |
koneksi(); | |
StatBrg=con.createStatement(); | |
String SQL="delete from barang where kobar='"+jTextField1.getText()+"'"; | |
StatBrg.executeUpdate(SQL); | |
display(); | |
StatBrg.close(); | |
con.close(); | |
}catch(Exception exc){ | |
System.out.println(exc.getMessage()); | |
} | |
}//GEN-LAST:event_ThapusActionPerformed | |
private void TnewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_TnewActionPerformed | |
// TODO add your handling code here: | |
jTextField1.setText(""); | |
jTextField2.setText(""); | |
jTextField3.setText(""); | |
jTextField4.setText(""); | |
jTextField5.setText(""); | |
}//GEN-LAST:event_TnewActionPerformed | |
private void TkeluarMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_TkeluarMouseClicked | |
// TODO add your handling code here: | |
int confirm = JOptionPane.showConfirmDialog(this, | |
"Anda Yakin keluar program ?", | |
"KELUAR PROGRAM", | |
JOptionPane.YES_NO_OPTION, | |
JOptionPane.QUESTION_MESSAGE); | |
if (confirm == JOptionPane.YES_OPTION) { | |
System.exit(0); | |
} | |
}//GEN-LAST:event_TkeluarMouseClicked | |
/** | |
* @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(FormBarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (InstantiationException ex) { | |
java.util.logging.Logger.getLogger(FormBarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (IllegalAccessException ex) { | |
java.util.logging.Logger.getLogger(FormBarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (javax.swing.UnsupportedLookAndFeelException ex) { | |
java.util.logging.Logger.getLogger(FormBarang.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 FormBarang().setVisible(true); | |
} | |
}); | |
} | |
// Variables declaration - do not modify//GEN-BEGIN:variables | |
private javax.swing.JButton Tedit; | |
private javax.swing.JButton Thapus; | |
private javax.swing.JButton Tkeluar; | |
private javax.swing.JButton Tnew; | |
private javax.swing.JButton Tsimpan; | |
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.JLabel jLabel8; | |
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; | |
// End of variables declaration//GEN-END:variables | |
private void koneksi(){ | |
try{ | |
Class.forName("com.mysql.jdbc.Driver"); | |
con=DriverManager.getConnection("jdbc:mysql://localhost/transaksi","root",""); | |
StatBrg=con.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE); | |
rs=StatBrg.executeQuery("select*from barang"); | |
}catch(Exception e){JOptionPane.showMessageDialog(null, e); | |
System.exit(0);}} | |
private void display(){ | |
try{String sql="select*from barang"; | |
pst=con.prepareStatement(sql); | |
rs=pst.executeQuery(); | |
jTable1.setModel(DbUtils.resultSetToTableModel(rs)); | |
}catch(Exception e){JOptionPane.showMessageDialog(null, e); | |
}}} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8" ?> | |
<Form version="1.9" maxVersion="1.9" type="org.netbeans.modules.form.forminfo.JFrameFormInfo"> | |
<NonVisualComponents> | |
<Container class="javax.swing.JScrollPane" name="jScrollPane1"> | |
<AuxValues> | |
<AuxValue name="autoScrollPane" type="java.lang.Boolean" value="true"/> | |
</AuxValues> | |
<Layout class="org.netbeans.modules.form.compat2.layouts.support.JScrollPaneSupportLayout"/> | |
<SubComponents> | |
<Component class="javax.swing.JEditorPane" name="jEditorPane1"> | |
</Component> | |
</SubComponents> | |
</Container> | |
</NonVisualComponents> | |
<Properties> | |
<Property name="defaultCloseOperation" type="int" value="3"/> | |
</Properties> | |
<SyntheticProperties> | |
<SyntheticProperty name="formSizePolicy" type="int" value="1"/> | |
<SyntheticProperty name="generateCenter" type="boolean" value="false"/> | |
</SyntheticProperties> | |
<AuxValues> | |
<AuxValue name="FormSettings_autoResourcing" type="java.lang.Integer" value="0"/> | |
<AuxValue name="FormSettings_autoSetComponentName" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_generateFQN" type="java.lang.Boolean" value="true"/> | |
<AuxValue name="FormSettings_generateMnemonicsCode" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_i18nAutoMode" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_layoutCodeTarget" type="java.lang.Integer" value="1"/> | |
<AuxValue name="FormSettings_listenerGenerationStyle" type="java.lang.Integer" value="0"/> | |
<AuxValue name="FormSettings_variablesLocal" type="java.lang.Boolean" value="false"/> | |
<AuxValue name="FormSettings_variablesModifier" type="java.lang.Integer" value="2"/> | |
<AuxValue name="designerSize" type="java.awt.Dimension" value="-84,-19,0,5,115,114,0,18,106,97,118,97,46,97,119,116,46,68,105,109,101,110,115,105,111,110,65,-114,-39,-41,-84,95,68,20,2,0,2,73,0,6,104,101,105,103,104,116,73,0,5,119,105,100,116,104,120,112,0,0,1,-20,0,0,2,0"/> | |
</AuxValues> | |
<Layout class="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout"> | |
<Property name="useNullLayout" type="boolean" value="true"/> | |
</Layout> | |
<SubComponents> | |
<Component class="javax.swing.JLabel" name="jLabel5"> | |
<Properties> | |
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="cc" green="ff" red="0" type="rgb"/> | |
</Property> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="14" style="1"/> | |
</Property> | |
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="d1" green="b4" id="Active Caption" palette="2" red="99" type="palette"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="LOGIN FORM DATABASE PEMESANAN "/> | |
</Properties> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="90" y="170" width="280" height="-1"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel2"> | |
<Properties> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="18" style="1"/> | |
</Property> | |
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="f0" green="f0" red="f0" type="rgb"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="Username"/> | |
</Properties> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="60" y="200" width="100" height="-1"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel3"> | |
<Properties> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="18" style="1"/> | |
</Property> | |
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="f0" green="f0" red="f0" type="rgb"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="Password"/> | |
</Properties> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="60" y="290" width="130" height="-1"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JTextField" name="txt_name"> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="60" y="230" width="340" height="40"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JPasswordField" name="txt_pass"> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="60" y="330" width="340" height="40"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JCheckBox" name="jCheckBox1"> | |
<Properties> | |
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="ff" green="33" red="33" type="rgb"/> | |
</Property> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="11" style="1"/> | |
</Property> | |
<Property name="foreground" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="f0" green="f0" red="f0" type="rgb"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="SHOW PASSWORD"/> | |
</Properties> | |
<Events> | |
<EventHandler event="mouseClicked" listener="java.awt.event.MouseListener" parameters="java.awt.event.MouseEvent" handler="jCheckBox1MouseClicked"/> | |
</Events> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="280" y="380" width="130" height="-1"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JButton" name="jButton1"> | |
<Properties> | |
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="ff" green="ff" id="Button.highlight" palette="3" red="ff" type="palette"/> | |
</Property> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="12" style="1"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="Login"/> | |
</Properties> | |
<Events> | |
<EventHandler event="mouseClicked" listener="java.awt.event.MouseListener" parameters="java.awt.event.MouseEvent" handler="jButton1MouseClicked"/> | |
<EventHandler event="actionPerformed" listener="java.awt.event.ActionListener" parameters="java.awt.event.ActionEvent" handler="jButton1ActionPerformed"/> | |
</Events> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="80" y="420" width="120" height="40"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JButton" name="jButton2"> | |
<Properties> | |
<Property name="background" type="java.awt.Color" editor="org.netbeans.beaninfo.editors.ColorEditor"> | |
<Color blue="ff" green="ff" id="Button.highlight" palette="3" red="ff" type="palette"/> | |
</Property> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Tahoma" size="12" style="1"/> | |
</Property> | |
<Property name="text" type="java.lang.String" value="Cancel"/> | |
</Properties> | |
<Events> | |
<EventHandler event="mouseClicked" listener="java.awt.event.MouseListener" parameters="java.awt.event.MouseEvent" handler="jButton2MouseClicked"/> | |
</Events> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="260" y="420" width="110" height="40"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JLabel" name="showpassword"> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="390" y="40" width="34" height="14"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel1"> | |
<Properties> | |
<Property name="font" type="java.awt.Font" editor="org.netbeans.beaninfo.editors.FontEditor"> | |
<Font name="Times New Roman" size="8" style="1"/> | |
</Property> | |
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor"> | |
<Image iconType="2" name="C:\Users\robelunatics\Downloads\login-system-icon-13.png"/> | |
</Property> | |
<Property name="verticalAlignment" type="int" value="1"/> | |
<Property name="maximumSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor"> | |
<Dimension value="[100, 60]"/> | |
</Property> | |
<Property name="minimumSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor"> | |
<Dimension value="[100, 60]"/> | |
</Property> | |
<Property name="preferredSize" type="java.awt.Dimension" editor="org.netbeans.beaninfo.editors.DimensionEditor"> | |
<Dimension value="[100, 60]"/> | |
</Property> | |
</Properties> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="50" y="10" width="310" height="180"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
<Component class="javax.swing.JLabel" name="jLabel4"> | |
<Properties> | |
<Property name="icon" type="javax.swing.Icon" editor="org.netbeans.modules.form.editors2.IconEditor"> | |
<Image iconType="2" name="C:\Users\robelunatics\Downloads\backgroundform.jpg"/> | |
</Property> | |
</Properties> | |
<Constraints> | |
<Constraint layoutClass="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout" value="org.netbeans.modules.form.compat2.layouts.DesignAbsoluteLayout$AbsoluteConstraintsDescription"> | |
<AbsoluteConstraints x="0" y="0" width="550" height="510"/> | |
</Constraint> | |
</Constraints> | |
</Component> | |
</SubComponents> | |
</Form> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* To change this license header, choose License Headers in Project Properties. | |
* To change this template file, choose Tools | Templates | |
* and open the template in the editor. | |
*/ | |
package prjtransaksi; | |
import javax.swing.JOptionPane; | |
import java.sql.*; | |
import javax.swing.*; | |
import javax.xml.crypto.Data; | |
import net.proteanit.sql.DbUtils; | |
import java.sql.Connection; | |
import java.sql.ResultSet; | |
import java.sql.Statement; | |
/** | |
* | |
* @author robelunatics | |
*/ | |
public class Login extends javax.swing.JFrame { | |
Connection con=null; | |
ResultSet rs=null; | |
PreparedStatement pst=null; | |
Statement StatBrg; | |
boolean ada=false; | |
String sql; | |
/** | |
* Creates new form Login | |
*/ | |
public Login() { | |
initComponents(); | |
koneksi(); | |
showpassword.setVisible(false); | |
} | |
/** | |
* 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">//GEN-BEGIN:initComponents | |
private void initComponents() { | |
jScrollPane1 = new javax.swing.JScrollPane(); | |
jEditorPane1 = new javax.swing.JEditorPane(); | |
jLabel5 = new javax.swing.JLabel(); | |
jLabel2 = new javax.swing.JLabel(); | |
jLabel3 = new javax.swing.JLabel(); | |
txt_name = new javax.swing.JTextField(); | |
txt_pass = new javax.swing.JPasswordField(); | |
jCheckBox1 = new javax.swing.JCheckBox(); | |
jButton1 = new javax.swing.JButton(); | |
jButton2 = new javax.swing.JButton(); | |
showpassword = new javax.swing.JLabel(); | |
jLabel1 = new javax.swing.JLabel(); | |
jLabel4 = new javax.swing.JLabel(); | |
jScrollPane1.setViewportView(jEditorPane1); | |
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); | |
getContentPane().setLayout(null); | |
jLabel5.setBackground(new java.awt.Color(0, 255, 204)); | |
jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N | |
jLabel5.setForeground(java.awt.SystemColor.activeCaption); | |
jLabel5.setText("LOGIN FORM DATABASE PEMESANAN "); | |
getContentPane().add(jLabel5); | |
jLabel5.setBounds(90, 170, 280, 17); | |
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N | |
jLabel2.setForeground(new java.awt.Color(240, 240, 240)); | |
jLabel2.setText("Username"); | |
getContentPane().add(jLabel2); | |
jLabel2.setBounds(60, 200, 100, 22); | |
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N | |
jLabel3.setForeground(new java.awt.Color(240, 240, 240)); | |
jLabel3.setText("Password"); | |
getContentPane().add(jLabel3); | |
jLabel3.setBounds(60, 290, 130, 22); | |
getContentPane().add(txt_name); | |
txt_name.setBounds(60, 230, 340, 40); | |
getContentPane().add(txt_pass); | |
txt_pass.setBounds(60, 330, 340, 40); | |
jCheckBox1.setBackground(new java.awt.Color(51, 51, 255)); | |
jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N | |
jCheckBox1.setForeground(new java.awt.Color(240, 240, 240)); | |
jCheckBox1.setText("SHOW PASSWORD"); | |
jCheckBox1.addMouseListener(new java.awt.event.MouseAdapter() { | |
public void mouseClicked(java.awt.event.MouseEvent evt) { | |
jCheckBox1MouseClicked(evt); | |
} | |
}); | |
getContentPane().add(jCheckBox1); | |
jCheckBox1.setBounds(280, 380, 130, 23); | |
jButton1.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.highlight")); | |
jButton1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N | |
jButton1.setText("Login"); | |
jButton1.addMouseListener(new java.awt.event.MouseAdapter() { | |
public void mouseClicked(java.awt.event.MouseEvent evt) { | |
jButton1MouseClicked(evt); | |
} | |
}); | |
jButton1.addActionListener(new java.awt.event.ActionListener() { | |
public void actionPerformed(java.awt.event.ActionEvent evt) { | |
jButton1ActionPerformed(evt); | |
} | |
}); | |
getContentPane().add(jButton1); | |
jButton1.setBounds(80, 420, 120, 40); | |
jButton2.setBackground(javax.swing.UIManager.getDefaults().getColor("Button.highlight")); | |
jButton2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N | |
jButton2.setText("Cancel"); | |
jButton2.addMouseListener(new java.awt.event.MouseAdapter() { | |
public void mouseClicked(java.awt.event.MouseEvent evt) { | |
jButton2MouseClicked(evt); | |
} | |
}); | |
getContentPane().add(jButton2); | |
jButton2.setBounds(260, 420, 110, 40); | |
getContentPane().add(showpassword); | |
showpassword.setBounds(390, 40, 34, 14); | |
jLabel1.setFont(new java.awt.Font("Times New Roman", 1, 8)); // NOI18N | |
jLabel1.setIcon(new javax.swing.ImageIcon("C:\\Users\\robelunatics\\Downloads\\login-system-icon-13.png")); // NOI18N | |
jLabel1.setVerticalAlignment(javax.swing.SwingConstants.TOP); | |
jLabel1.setMaximumSize(new java.awt.Dimension(100, 60)); | |
jLabel1.setMinimumSize(new java.awt.Dimension(100, 60)); | |
jLabel1.setPreferredSize(new java.awt.Dimension(100, 60)); | |
getContentPane().add(jLabel1); | |
jLabel1.setBounds(50, 10, 310, 180); | |
jLabel4.setIcon(new javax.swing.ImageIcon("C:\\Users\\robelunatics\\Downloads\\backgroundform.jpg")); // NOI18N | |
getContentPane().add(jLabel4); | |
jLabel4.setBounds(0, 0, 550, 510); | |
pack(); | |
}// </editor-fold>//GEN-END:initComponents | |
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed | |
// TODO add your handling code here: | |
try { | |
sql = "select*from admin WHERE username='"+txt_name.getText()+"' AND password='"+txt_pass.getText()+"'"; | |
rs = StatBrg.executeQuery(sql); | |
if(rs.next()){ | |
if(txt_name.getText().equals(rs.getString("username")) && txt_pass.getText().equals(rs.getString("password"))){ | |
JOptionPane.showMessageDialog(null, "berhasil login"); | |
FormBarang n = new FormBarang(); | |
n.setVisible(true); | |
this.setVisible(false); | |
} | |
}else{ | |
JOptionPane.showMessageDialog(null, "username atau password salah"); | |
this.setVisible(true); | |
} | |
}catch(Exception e) { | |
JOptionPane.showMessageDialog(this, e.getMessage()); | |
} | |
}//GEN-LAST:event_jButton1ActionPerformed | |
private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton1MouseClicked | |
// TODO add your handling code here: | |
}//GEN-LAST:event_jButton1MouseClicked | |
private void jButton2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton2MouseClicked | |
// TODO add your handling code here: | |
int confirm = JOptionPane.showConfirmDialog(this, | |
"Anda Yakin keluar program ?", | |
"KELUAR PROGRAM", | |
JOptionPane.YES_NO_OPTION, | |
JOptionPane.QUESTION_MESSAGE); | |
if (confirm == JOptionPane.YES_OPTION) { | |
System.exit(0); | |
} | |
}//GEN-LAST:event_jButton2MouseClicked | |
private void jCheckBox1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jCheckBox1MouseClicked | |
// TODO add your handling code here: | |
if(showpassword.getText().equals("")){ | |
txt_pass.setEchoChar((char)0); | |
showpassword.setText(("Set")); | |
}else{ | |
txt_pass.setEchoChar('*'); | |
showpassword.setText(""); | |
} | |
}//GEN-LAST:event_jCheckBox1MouseClicked | |
/** | |
* @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(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (InstantiationException ex) { | |
java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (IllegalAccessException ex) { | |
java.util.logging.Logger.getLogger(Login.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); | |
} catch (javax.swing.UnsupportedLookAndFeelException ex) { | |
java.util.logging.Logger.getLogger(Login.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 Login().setVisible(true); | |
} | |
}); | |
} | |
// Variables declaration - do not modify//GEN-BEGIN:variables | |
private javax.swing.JButton jButton1; | |
private javax.swing.JButton jButton2; | |
private javax.swing.JCheckBox jCheckBox1; | |
private javax.swing.JEditorPane jEditorPane1; | |
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.JScrollPane jScrollPane1; | |
private javax.swing.JLabel showpassword; | |
private javax.swing.JTextField txt_name; | |
private javax.swing.JPasswordField txt_pass; | |
// End of variables declaration//GEN-END:variables | |
private void koneksi(){ | |
try{ | |
Class.forName("com.mysql.jdbc.Driver"); | |
con=DriverManager.getConnection("jdbc:mysql://localhost/transaksi","root",""); | |
StatBrg=con.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE); | |
rs=StatBrg.executeQuery("select*from admin"); | |
}catch(Exception e){JOptionPane.showMessageDialog(null, e); | |
System.exit(0);}} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* To change this license header, choose License Headers in Project Properties. | |
* To change this template file, choose Tools | Templates | |
* and open the template in the editor. | |
*/ | |
package prjtransaksi; | |
/** | |
* | |
* @author robelunatics | |
*/ | |
public class PrjTransaksi { | |
/** | |
* @param args the command line arguments | |
*/ | |
public static void main(String[] args) { | |
// TODO code application logic here | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 4.8.0.1 | |
-- https://www.phpmyadmin.net/ | |
-- | |
-- Host: 127.0.0.1 | |
-- Waktu pembuatan: 04 Jun 2018 pada 18.27 | |
-- Versi server: 10.1.32-MariaDB | |
-- Versi PHP: 7.2.5 | |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; | |
SET AUTOCOMMIT = 0; | |
START TRANSACTION; | |
SET time_zone = "+00:00"; | |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | |
/*!40101 SET NAMES utf8mb4 */; | |
-- | |
-- Database: `transaksi` | |
-- | |
-- -------------------------------------------------------- | |
-- | |
-- Struktur dari tabel `admin` | |
-- | |
CREATE TABLE `admin` ( | |
`id` int(11) NOT NULL, | |
`username` varchar(30) DEFAULT NULL, | |
`password` varchar(20) DEFAULT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
-- | |
-- Dumping data untuk tabel `admin` | |
-- | |
INSERT INTO `admin` (`id`, `username`, `password`) VALUES | |
(1, 'robe', '123'); | |
-- -------------------------------------------------------- | |
-- | |
-- Struktur dari tabel `barang` | |
-- | |
CREATE TABLE `barang` ( | |
`kobar` varchar(10) NOT NULL, | |
`nabar` varchar(100) DEFAULT NULL, | |
`harga` int(11) DEFAULT NULL, | |
`nama_pemesan` varchar(30) DEFAULT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; | |
-- | |
-- Dumping data untuk tabel `barang` | |
-- | |
INSERT INTO `barang` (`kobar`, `nabar`, `harga`, `nama_pemesan`) VALUES | |
('D12345', 'RAJA SINGA', 12000000, 'SAIFUK'), | |
('D12346', 'PULAU SERIBU', 300000, 'BARI'), | |
('D12347', 'DIENG', 700000, 'JONOJONI'); | |
-- | |
-- Indexes for dumped tables | |
-- | |
-- | |
-- Indeks untuk tabel `admin` | |
-- | |
ALTER TABLE `admin` | |
ADD PRIMARY KEY (`id`); | |
-- | |
-- Indeks untuk tabel `barang` | |
-- | |
ALTER TABLE `barang` | |
ADD PRIMARY KEY (`kobar`); | |
COMMIT; | |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment