Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- String url ="jdbc:mysql://localhost/pegawai2";
- String user="root";
- String pass="";
- Class.forName("com.mysql.jdbc.Driver");
- con =DriverManager.getConnection(url,user,pass);
- String var_nip = txt_nip.getText();
- String var_nama = txt_nama.getText();
- String var_jk;
- if(laki.isSelected())
- {
- var_jk="Laki-Laki";
- }
- else
- {
- var_jk="Perempuan";
- }
- String kode_jabatan;
- String var_golongan=(String) cb_golongan.getSelectedItem();
- String var_jabatan=(String) jabatan.getSelectedItem();
- if(var_jabatan.equals("Manager")){
- kode_jabatan="101";
- }
- else if(var_jabatan.equals("Suvervisor")){
- kode_jabatan="102";
- }
- else if(var_jabatan.equals("Staff")){
- kode_jabatan="103";
- }
- else
- {
- kode_jabatan="104";
- }
- int var_anak =Integer.parseInt(txt_jumlah_anak.getText());
- JOptionPane.showMessageDialog(null, "Data id : Tersimpan"+kode_jabatan);
- String Status=(String) cb_status.getSelectedItem();
- JOptionPane.showMessageDialog(null, "Data id : Tersimpan"+Status);
- String sql = "insert into pegawai(nip,nama,jenis_kelamin,kode_jabatan,golongan,status,jumlah_anak)values('"+var_nip+"','"+var_nama+"','"+var_jk+"','"+var_jabatan+"','"+var_golongan+"','"+Status+"',"+var_anak+")";
- stm = con.createStatement();
- stm.executeUpdate(sql);
- JOptionPane.showMessageDialog(null, "Data id :"+var_nip+" Tersimpan");
- bersihkan();
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "Data tidak tersimpan");
- bersihkan();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement