Advertisement
Guest User

Untitled

a guest
Jan 27th, 2016
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.21 KB | None | 0 0
  1. kelas koneksi
  2. package Class;
  3.  
  4. import java.sql.*;
  5.  
  6. public class Koneksi {
  7.  
  8. protected final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  9. protected final String DB_URL = "jdbc:mysql://localhost/dbakademik";
  10.  
  11.  
  12. protected final String USER = "root";
  13. protected final String PASS = "";
  14.  
  15. protected Connection conn = null;
  16. protected Statement stmt = null;
  17.  
  18. //konsturtor
  19.  
  20. public Koneksi(){
  21.  
  22. }
  23. public void openConn(){
  24.  
  25. try{
  26. Class.forName("com.mysql.jdbc.Driver");
  27. conn = DriverManager.getConnection(DB_URL,USER,PASS);
  28.  
  29. }
  30. catch(Exception se){
  31. se.printStackTrace();
  32. }
  33.  
  34. }
  35. public void closeConn(){
  36.  
  37. try{
  38. if(conn!=null)
  39. conn.close();
  40.  
  41. }catch(SQLException se){
  42. se.printStackTrace();
  43. }
  44. }
  45. }
  46.  
  47.  
  48. ---------------------------------------------------------------------------------------------
  49.  
  50. frame utama
  51.  
  52. public class FramUtama extends javax.swing.JFrame {
  53. public String gender;
  54. public FramUtama() {
  55. initComponents();
  56.  
  57. Mahasiswa mhs = new Mahasiswa();
  58. DefaultTableModel dtm = mhs.tampil();
  59. jTable1.setModel(dtm);
  60.  
  61. }
  62.  
  63. String jk;
  64. String jurusan;
  65. String waktu;
  66.  
  67.  
  68. private void bSimpanActionPerformed(java.awt.event.ActionEvent evt) {
  69. Mahasiswa m = new Mahasiswa();
  70.  
  71. String npm = (txtNpm.getText().toString());
  72. String nama = (txtNama.getText().toString());
  73. int usia = Integer.parseInt(txtUsia.getText().toString());
  74.  
  75. if(rLaki.isSelected() || rPerempuan.isSelected()){
  76. if (rLaki.isSelected()){
  77. jk = "laki-laki";
  78. }
  79. else jk = "perempuan";
  80. }
  81.  
  82.  
  83. String jurusan = cbJurusan.getSelectedItem().toString();
  84.  
  85. if(rPagi.isSelected() || rMalam.isSelected()){
  86. if(rPagi.isSelected()){
  87. waktu = "Pagi";
  88. }
  89. else waktu = "Malam";
  90. }
  91. m.setNPM(npm);
  92. m.setNama(nama);
  93. m.setUsia(usia);
  94. m.setJK(jk);
  95. m.setJurusan(jurusan);
  96. m.setWaktu(waktu);
  97. m.simpan(m);
  98.  
  99. DefaultTableModel dtm = m.tampil();
  100. jTable1.setModel(dtm);
  101.  
  102.  
  103.  
  104. }
  105.  
  106. private void bUbahActionPerformed(java.awt.event.ActionEvent evt) {
  107.  
  108.  
  109. Mahasiswa m = new Mahasiswa();
  110.  
  111. String npm = (txtNpm.getText().toString());
  112. String nama = (txtNama.getText().toString());
  113. int usia = Integer.parseInt(txtUsia.getText().toString());
  114.  
  115. if(rLaki.isSelected() || rPerempuan.isSelected()){
  116. if (rLaki.isSelected()){
  117. jk = "laki-laki";
  118. }
  119. else jk = "perempuan";
  120. }
  121.  
  122. String jurusan = cbJurusan.getSelectedItem().toString();
  123.  
  124. if(rPagi.isSelected() || rMalam.isSelected()){
  125. if(rPagi.isSelected()){
  126. waktu = "Pagi";
  127. }
  128. else waktu = "Malam";
  129. }
  130.  
  131. m.setNPM(npm);
  132. m.setNama(nama);
  133. m.setUsia(usia);
  134. m.setJK(jk);
  135. m.setJurusan(jurusan);
  136. m.setWaktu(waktu);
  137. m.ubah(m);
  138. DefaultTableModel dtm = m.tampil();
  139. jTable1.setModel(dtm);
  140. }
  141.  
  142. private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {
  143. Mahasiswa m = new Mahasiswa();
  144.  
  145. String npm = (txtNpm.getText().toString());
  146.  
  147. m.setNPM(npm);
  148.  
  149. m.hapus(m);
  150. DefaultTableModel dtm = m.tampil();
  151. jTable1.setModel(dtm);
  152. }
  153.  
  154. private void rLakiActionPerformed(java.awt.event.ActionEvent evt) {
  155. gender ="laki"; // TODO add your handling code here:
  156. }
  157.  
  158. private void rPerempuanActionPerformed(java.awt.event.ActionEvent evt) {
  159. gender = "perempuan";
  160. }
  161.  
  162. ---------------------------------------------------------------------------------------------------------------\
  163. kelas mahasiswa\
  164.  
  165.  
  166. //nama file mahasiswa.java
  167. //lokasi : src/class/mahasiswa.java
  168. package Class;
  169.  
  170. import java.sql.ResultSet;
  171. import java.sql.ResultSetMetaData;
  172. import java.sql.SQLException;
  173. import javax.swing.table.DefaultTableModel;
  174.  
  175. public class Mahasiswa extends Koneksi{
  176. protected String npm;
  177. protected String nama;
  178. protected int usia;
  179. protected String jk;
  180. protected String jurusan;
  181. protected String waktu;
  182. protected String gender;
  183. private String sql;
  184.  
  185.  
  186.  
  187.  
  188.  
  189.  
  190. public void setNPM(String npm){
  191. this.npm = npm;
  192. }
  193. public void setNama(String nama){
  194. this.nama = nama;
  195. }
  196. public void setUsia(int usia){
  197. this.usia = usia;
  198. }
  199. public void setJK(String jk){
  200. this.jk = jk;
  201. }
  202. public void setJurusan(String jurusan){
  203. this.jurusan = jurusan;
  204. }
  205. public void setWaktu(String waktu){
  206. this.waktu = waktu;
  207. }
  208.  
  209. public void simpan(Mahasiswa m){
  210.  
  211. try{
  212. this.openConn();
  213. this.stmt = this.conn.createStatement();
  214. sql = "insert into tblmahasiswa values " +
  215. "('" + m.npm + "','" + m.nama + "','" + m.usia + "'" +
  216. ",'" + m.jk + "','" + m.jurusan + "','" + m.waktu + "')";
  217. stmt.executeUpdate(sql);
  218.  
  219. this.closeConn();
  220.  
  221. }
  222. catch(SQLException se){
  223. se.printStackTrace();
  224. }
  225.  
  226. }
  227.  
  228. public void ubah(Mahasiswa m){
  229.  
  230. try{
  231. this.openConn();
  232. this.stmt = this.conn.createStatement();
  233. sql = "UPDATE tblmahasiswa "
  234. + "SET nama = '" + m.nama + "', usia = '" + m.usia + "',"
  235. + "`jenis kelamin` = '" +m.jk+ "', jurusan = '" +m.jurusan+ "', `waktu kuliah` = '" +m.waktu+ "'"
  236. + "WHERE npm = '" + m.npm + "'";
  237. stmt.executeUpdate(sql);
  238.  
  239. this.closeConn();
  240. }
  241. catch(SQLException se){
  242. se.printStackTrace();
  243. }
  244.  
  245. }
  246. public void hapus(Mahasiswa m){
  247. try{
  248. this.openConn();
  249. this.stmt = this.conn.createStatement();
  250. sql = "DELETE FROM tblmahasiswa " + "WHERE npm = '" + m.npm + "'";
  251. stmt.executeUpdate(sql);
  252.  
  253. this.closeConn();
  254. }
  255. catch(SQLException se){
  256. se.printStackTrace();
  257. }
  258. }
  259.  
  260. public DefaultTableModel tampil(){
  261.  
  262. try{
  263. this.openConn();
  264. this.stmt = this.conn.createStatement();
  265. sql = "SELECT *FROM tblmahasiswa";
  266. ResultSet rs = stmt.executeQuery(sql);
  267. ResultSetMetaData rsmt = rs.getMetaData();
  268.  
  269. DefaultTableModel dtm = new DefaultTableModel();
  270. dtm.addColumn("npm");
  271. dtm.addColumn("nama");
  272. dtm.addColumn("usia");
  273. dtm.addColumn("jenis kelamin");
  274. dtm.addColumn("jurusan");
  275. dtm.addColumn("waktu kuliah");
  276.  
  277. while (rs.next()){
  278. dtm.addRow(new Object[]{
  279. rs.getString(1),
  280. rs.getString(2),
  281. rs.getString(3),
  282. rs.getString(4),
  283. rs.getString(5),
  284. rs.getString(6)
  285. });
  286. }
  287.  
  288. this.closeConn();
  289.  
  290. return dtm;
  291.  
  292. }
  293.  
  294. catch(Exception se){
  295. se.printStackTrace();
  296. }
  297. return null;
  298. }
  299. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement