Program Input Siswa Menggunakan Java

Program Input Data Siswa ke Database Menggunakan Java.



Berikut Source codenya :
Forminput.java

Inputkan dibawah paketnya / package
<br /> import java.sql.*;<br /> import javax.swing.JOptionPane;<br />

Tombol input :
<br /> int no= Integer.parseInt(jTextField1.getText());<br /> int nis = Integer.parseInt(jTextField2.getText());<br /> String kelas;<br /> kelas = (String)jComboBox1.getSelectedItem();<br /> String agama;<br /> agama = (String)jComboBox2.getSelectedItem();<br /> String jenis_klm;<br /> if (jRadioButton1.isSelected()) {<br /> jenis_klm = jRadioButton1.getText();<br /> } else {<br /> jenis_klm = jRadioButton2.getText();<br /> }<br /> <br /> String user="root";<br /> String pwd ="";<br /> String host="localhost";<br /> String db="sekolah";<br /> String urlValue="";<br /> <br /> try {<br /> String hobi = null;<br /> if (jRadioButton3.isSelected()) {<br /> hobi = jRadioButton3.getText(); <br /> jTextField6.setEditable(false);<br /> } else if (jRadioButton4.isSelected()) {<br /> hobi = jRadioButton4.getText();<br /> jTextField6.setEditable(false);<br /> } else if (jRadioButton5.isSelected()) {<br /> hobi = jRadioButton5.getText();<br /> jTextField6.setEditable(false);<br /> } else if (jRadioButton6.isSelected()) {<br /> hobi = jRadioButton6.getText(); <br /> jTextField6.setEditable(false);<br /> } else if (jRadioButton7.isSelected()) {<br /> hobi = jRadioButton7.getText();<br /> jTextField6.setEditable(false);<br /> } else if (jRadioButton8.isSelected()) {<br /> jTextField6.setEditable(true);<br /> hobi = jTextField6.getText();<br /> }<br /> Class.forName("com.mysql.jdbc.Driver");<br /> urlValue="jdbc:mysql://"+ host +"/"+<br /> db +"?user=" + user + "&password="+ pwd;<br /> Connection conn = DriverManager.getConnection(urlValue);<br /> PreparedStatement PS = null;<br /> String sql ="insert into siswa1 values (?,?,?,?,?,?,?,?,?)";<br /> <br /> PS = conn.prepareStatement(sql);<br /> <br /> PS.setInt(1, no); //no<br /> PS.setInt(2, nis); //nis<br /> PS.setString(3, jTextField3.getText()); //nama<br /> PS.setString(4, jTextField4.getText()); //Alamat<br /> PS.setString(5, jenis_klm);<br /> PS.setString(6, jTextField5.getText());<br /> PS.setString(7, kelas);<br /> PS.setString(8, agama);<br /> PS.setString(9, (""+hobi));<br /> <br /> int intTambah= PS.executeUpdate();<br /> if (intTambah>0) {<br /> JOptionPane.showMessageDialog(this,<br /> "Data berhasil disimpan!", "Selamat",<br /> JOptionPane.INFORMATION_MESSAGE);<br /> }<br /> <br /> else {<br /> JOptionPane.showMessageDialog(this,<br /> "Gagal menyimpan data!", "Mohon Ma'af!",<br /> JOptionPane.INFORMATION_MESSAGE);<br /> }<br /> <br /> PS.close();<br /> conn.close();<br /> clear(); <br /> }<br /> <br /> catch(ClassNotFoundException e) {<br /> System.out.println("jdbc.Driver tidak ditemukan!");<br /> }<br /> <br /> catch (SQLException e){<br /> System.out.println("Koneksi gagal!" +<br /> e.toString());<br /> }<br /> } <br /> <br /> private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) { <br /> int message = JOptionPane.showConfirmDialog(null,"Exit Program",<br /> "Exit",JOptionPane.YES_NO_OPTION);<br /> if (message == JOptionPane.YES_OPTION){<br /> System.exit(0);<br /> }<br /> <br />

Pada tombol Clear
<br /> <br /> jTextField1.setText("");<br /> jTextField2.setText("");<br /> jTextField3.setText("");<br /> jTextField4.setText("");<br /> jTextField5.setText("");<br /> jTextField6.setText("");<br />

Pada tombol Exit
<br /> int message = JOptionPane.showConfirmDialog(null,"Exit Program",<br /> "Exit",JOptionPane.YES_NO_OPTION);<br /> if (message == JOptionPane.YES_OPTION){<br /> System.exit(0);<br /> }<br />

Pada tombol lihat data
<br /> new OutputTable().setVisible(true);<br />



Screenshot :
Input Form

Setelah di klik input :

Hasil : 

*setelah di klik "lihat data".

Untuk Form Output Tidak saya tuliskan. Tapi bisa anda download lengkap disini.
- Download Program Input Data Siswa -> via 4 Shared