API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2020
137
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.65 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package T13_18410100185;
  7.  
  8. import java.awt.TextComponent;
  9. import java.sql.*;
  10. import javax.swing.JOptionPane;
  11. import javax.swing.table.DefaultTableModel;
  12. import javax.swing.text.DefaultEditorKit;
  13. import static javax.swing.text.DefaultEditorKit.selectionEndAction;
  14.  
  15. /**
  16. *
  17. * @author mhs
  18. */
  19. public class COBA_1 extends javax.swing.JFrame {
  20. private String dbUrl ="jdbc:sqlserver://192.168.171.233;database=Praktikum;user=P18410100158;password=P180158Irn";
  21. private Connection conn = null;
  22. private Statement sqlcomand = null;
  23. private ResultSet sqlresult = null;
  24.  
  25. public COBA_1() {
  26. initComponents();
  27. }
  28.  
  29. @SuppressWarnings("unchecked")
  30. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  31. private void initComponents() {
  32.  
  33. jLabel1 = new javax.swing.JLabel();
  34. jLabel2 = new javax.swing.JLabel();
  35. txt_nid = new javax.swing.JTextField();
  36. txt_nama = new javax.swing.JTextField();
  37. jScrollPane1 = new javax.swing.JScrollPane();
  38. table_dosen = new javax.swing.JTable();
  39. jButton2 = new javax.swing.JButton();
  40. jButton3 = new javax.swing.JButton();
  41. jButton4 = new javax.swing.JButton();
  42.  
  43. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  44. addWindowListener(new java.awt.event.WindowAdapter() {
  45. public void windowOpened(java.awt.event.WindowEvent evt) {
  46. formWindowOpened(evt);
  47. }
  48. });
  49.  
  50. jLabel1.setText("NID");
  51.  
  52. jLabel2.setText("Nama");
  53.  
  54. txt_nid.addActionListener(new java.awt.event.ActionListener() {
  55. public void actionPerformed(java.awt.event.ActionEvent evt) {
  56. txt_nidActionPerformed(evt);
  57. }
  58. });
  59.  
  60. txt_nama.addMouseListener(new java.awt.event.MouseAdapter() {
  61. public void mouseClicked(java.awt.event.MouseEvent evt) {
  62. txt_namaMouseClicked(evt);
  63. }
  64. public void mouseEntered(java.awt.event.MouseEvent evt) {
  65. txt_namaMouseEntered(evt);
  66. }
  67. });
  68. txt_nama.addKeyListener(new java.awt.event.KeyAdapter() {
  69. public void keyPressed(java.awt.event.KeyEvent evt) {
  70. txt_namaKeyPressed(evt);
  71. }
  72. });
  73.  
  74. table_dosen.setModel(new javax.swing.table.DefaultTableModel(
  75. new Object [][] {
  76. {null, null, null, null},
  77. {null, null, null, null},
  78. {null, null, null, null},
  79. {null, null, null, null}
  80. },
  81. new String [] {
  82. "Title 1", "Title 2", "Title 3", "Title 4"
  83. }
  84. ));
  85. jScrollPane1.setViewportView(table_dosen);
  86.  
  87. jButton2.setText("UPDATE");
  88. jButton2.addActionListener(new java.awt.event.ActionListener() {
  89. public void actionPerformed(java.awt.event.ActionEvent evt) {
  90. jButton2ActionPerformed(evt);
  91. }
  92. });
  93.  
  94. jButton3.setText("DELETE");
  95. jButton3.addActionListener(new java.awt.event.ActionListener() {
  96. public void actionPerformed(java.awt.event.ActionEvent evt) {
  97. jButton3ActionPerformed(evt);
  98. }
  99. });
  100.  
  101. jButton4.setText("INSERT");
  102. jButton4.addActionListener(new java.awt.event.ActionListener() {
  103. public void actionPerformed(java.awt.event.ActionEvent evt) {
  104. jButton4ActionPerformed(evt);
  105. }
  106. });
  107.  
  108. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  109. getContentPane().setLayout(layout);
  110. layout.setHorizontalGroup(
  111. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  112. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 511, Short.MAX_VALUE)
  113. .addGroup(layout.createSequentialGroup()
  114. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  115. .addGroup(layout.createSequentialGroup()
  116. .addGap(119, 119, 119)
  117. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  118. .addComponent(jLabel1)
  119. .addComponent(jLabel2))
  120. .addGap(36, 36, 36)
  121. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  122. .addComponent(txt_nid, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
  123. .addComponent(txt_nama, javax.swing.GroupLayout.PREFERRED_SIZE, 116, javax.swing.GroupLayout.PREFERRED_SIZE)))
  124. .addGroup(layout.createSequentialGroup()
  125. .addGap(101, 101, 101)
  126. .addComponent(jButton4)
  127. .addGap(18, 18, 18)
  128. .addComponent(jButton2)
  129. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  130. .addComponent(jButton3)))
  131. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  132. );
  133. layout.setVerticalGroup(
  134. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  135. .addGroup(layout.createSequentialGroup()
  136. .addGap(17, 17, 17)
  137. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  138. .addComponent(jLabel1)
  139. .addComponent(txt_nid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  140. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  141. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  142. .addComponent(jLabel2)
  143. .addComponent(txt_nama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  144. .addGap(46, 46, 46)
  145. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  146. .addComponent(jButton2)
  147. .addComponent(jButton3)
  148. .addComponent(jButton4))
  149. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 50, Short.MAX_VALUE)
  150. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 194, javax.swing.GroupLayout.PREFERRED_SIZE))
  151. );
  152.  
  153. pack();
  154. }// </editor-fold>
  155.  
  156. private void txt_nidActionPerformed(java.awt.event.ActionEvent evt) {
  157. // TODO add your handling code here:
  158. }
  159.  
  160. public void getData(){
  161. try{
  162. conn=DriverManager.getConnection(dbUrl);
  163. sqlcomand = conn.createStatement();
  164. DefaultTableModel tabmodel = new DefaultTableModel(new String []{"NID","NAMA DOSEN"},0);
  165. tabmodel.setRowCount(0);
  166. sqlresult = sqlcomand.executeQuery("select nid,nama_dosen from dosen");
  167. while(sqlresult.next()){
  168. tabmodel.addRow(new Object[] {sqlresult.getString("nid"),sqlresult.getString("nama_dosen")});
  169. }
  170. table_dosen.setModel(tabmodel);
  171. }catch(SQLException se){
  172. System.out.println("Database gagal");
  173. }
  174. }
  175. private void formWindowOpened(java.awt.event.WindowEvent evt) {
  176. try{
  177. conn=DriverManager.getConnection(dbUrl);
  178. sqlcomand = conn.createStatement();
  179. DefaultTableModel tabmodel = new DefaultTableModel(new String []{"NID","NAMA DOSEN"},0);
  180. tabmodel.setRowCount(0);
  181. sqlresult = sqlcomand.executeQuery("select nid,nama_dosen from dosen");
  182. while(sqlresult.next()){
  183. tabmodel.addRow(new Object[] {sqlresult.getString("nid"),sqlresult.getString("nama_dosen")});
  184. }
  185. table_dosen.setModel(tabmodel);
  186. }catch(SQLException se){
  187. System.out.println("Database gagal");
  188. }
  189. }
  190.  
  191. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  192. // TODO add your handling code here:
  193. try{
  194. conn=DriverManager.getConnection(dbUrl);
  195. sqlcomand = conn.createStatement();
  196. int result = 0;
  197. result = sqlcomand.executeUpdate("update dosen set nid = '"+txt_nid.getText()+"',nama_dosen='"+txt_nama.getText()+"' where nid = '"+txt_nid.getText()+"' ");
  198. if (result > 0) {
  199. JOptionPane.showMessageDialog(null, "Data Berhasil DiUpdate");
  200. }
  201. getData();
  202. }catch(SQLException se){
  203. System.out.println("GAGAL DIINSERT");
  204. }
  205. }
  206.  
  207. private void txt_namaKeyPressed(java.awt.event.KeyEvent evt) {
  208. // TODO add your handling code here:
  209.  
  210. }
  211.  
  212. private void txt_namaMouseEntered(java.awt.event.MouseEvent evt) {
  213.  
  214. }
  215.  
  216. private void txt_namaMouseClicked(java.awt.event.MouseEvent evt) {
  217. // TODO add your handling code here:
  218. // TODO add your handling code here:
  219. try{
  220. conn=DriverManager.getConnection(dbUrl);
  221. sqlcomand = conn.createStatement();
  222. int result = 0;
  223. sqlresult = sqlcomand.executeQuery("select nama_dosen from dosen where nid = '"+txt_nid.getText()+"'");
  224. while(sqlresult.next()){
  225. txt_nama.setText(sqlresult.getString("nama_dosen"));
  226. }
  227. }catch(SQLException se){
  228.  
  229. }
  230. }
  231.  
  232. public void refresh(){
  233. txt_nama.setText("");
  234. txt_nid.setText("");
  235. txt_nama.requestFocus();
  236. }
  237. private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  238. // TODO add your handling code here:
  239. //
  240. try{
  241. conn=DriverManager.getConnection(dbUrl);
  242. sqlcomand = conn.createStatement();
  243. int result = 0;
  244. result = sqlcomand.executeUpdate("Delete from dosen where nid='"+txt_nid.getText()+"'");
  245. if (result > 0) {
  246. JOptionPane.showMessageDialog(null, "Data Berhasil DiUpdate");
  247. }
  248. getData();
  249. }catch(SQLException se){
  250. System.out.println("GAGAL DIhapus");
  251. }
  252. }
  253.  
  254. private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
  255. // TODO add your handling code here:
  256. try{
  257. conn=DriverManager.getConnection(dbUrl);
  258. sqlcomand = conn.createStatement();
  259. int result = 0;
  260. result = sqlcomand.executeUpdate("Insert into dosen values ('"+txt_nid.getText()+"','"+txt_nama.getText()+"')");
  261. if (result > 0) {
  262. JOptionPane.showMessageDialog(null, "Data Berhasil Disimpan");
  263. }
  264. getData();
  265. refresh();
  266. }catch(SQLException se){
  267. System.out.println("GAGAL DISIMPAN");
  268. }
  269. }
  270.  
  271. public static void main(String args[]) {
  272.  
  273. java.awt.EventQueue.invokeLater(new Runnable() {
  274. public void run() {
  275. new COBA_1().setVisible(true);
  276. }
  277. });
  278. }
  279.  
  280. // Variables declaration - do not modify
  281. private javax.swing.JButton jButton2;
  282. private javax.swing.JButton jButton3;
  283. private javax.swing.JButton jButton4;
  284. private javax.swing.JLabel jLabel1;
  285. private javax.swing.JLabel jLabel2;
  286. private javax.swing.JScrollPane jScrollPane1;
  287. private javax.swing.JTable table_dosen;
  288. private javax.swing.JTextField txt_nama;
  289. private javax.swing.JTextField txt_nid;
  290. // End of variables declaration
  291. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!