Thursday 25 December 2008

Example Save

String kd_brg="",nm_brg="",no_sj="",tgl_masuk="",satuan="",hrg_sat="",ket="";
try{
kd_brg=jTextField1.getText();
nm_brg=jTextField2.getText();
no_sj=jTextField3.getText();
tgl_masuk= jTextField4.getText();
satuan=jComboBox1.getSelectedItem().toString();
hrg_sat=jTextField5.getText();
ket=jTextField6.getText();

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:kitra","","");
String sql = "insert into barang values('"+kd_brg+"','"+nm_brg+"','"+no_sj+"','"+tgl_masuk+"','"+satuan+"','"+hrg_sat+"','"+ket+"')";
Statement st = con.createStatement();
st.executeUpdate(sql);

JOptionPane.showMessageDialog(null, "data berhasil disimpan");

jTextField1.setText("");
jTextField2.setText("");
jComboBox1.setSelectedItem("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
} catch(Exception ex){ JOptionPane.showMessageDialog(null,"Data gagal disimpan \n coba lagi ok ");
}

No comments:

Post a Comment