Advertisement
Guest User

Untitled

a guest
Nov 1st, 2018
257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.31 KB | None | 0 0
  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 javaapplication1;
  7.  
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.Statement;
  11.  
  12. /**
  13. *
  14. * @author RiyanSurya
  15. */
  16. public class tes_koneksi extends javax.swing.JFrame {
  17. public static Connection con;
  18. public static Statement stm;{
  19. try {
  20. String url ="jdbc:mysql://localhost:3306/tutorial";
  21. String user="root";
  22. String pass="";
  23. Class.forName("com.mysql.jdbc.Driver");
  24. con =DriverManager.getConnection(url,user,pass);
  25. stm = con.createStatement();
  26. System.out.println("Koneksi Berhasil;");
  27. } catch (Exception e) {
  28. System.err.println("Koneksi Gagal" +e.getMessage());
  29. }
  30. }
  31. /**
  32. * Creates new form tes_koneksi
  33. */
  34. public tes_koneksi() {
  35. initComponents();
  36. }
  37.  
  38. /**
  39. * This method is called from within the constructor to initialize the form.
  40. * WARNING: Do NOT modify this code. The content of this method is always
  41. * regenerated by the Form Editor.
  42. */
  43. @SuppressWarnings("unchecked")
  44. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  45. private void initComponents() {
  46.  
  47. jLabel1 = new javax.swing.JLabel();
  48. jTextField1 = new javax.swing.JTextField();
  49. jLabel2 = new javax.swing.JLabel();
  50. jTextField2 = new javax.swing.JTextField();
  51. jLabel3 = new javax.swing.JLabel();
  52. jTextField3 = new javax.swing.JTextField();
  53. jButton1 = new javax.swing.JButton();
  54. jLabel4 = new javax.swing.JLabel();
  55.  
  56. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  57.  
  58. jLabel1.setText("Database");
  59.  
  60. jTextField1.setText("jTextField1");
  61.  
  62. jLabel2.setText("User");
  63.  
  64. jTextField2.setText("jTextField2");
  65.  
  66. jLabel3.setText("Password");
  67.  
  68. jTextField3.setText("jTextField3");
  69.  
  70. jButton1.setText("Connect");
  71. jButton1.addActionListener(new java.awt.event.ActionListener() {
  72. public void actionPerformed(java.awt.event.ActionEvent evt) {
  73. jButton1ActionPerformed(evt);
  74. }
  75. });
  76.  
  77. jLabel4.setText("jLabel4");
  78.  
  79. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  80. getContentPane().setLayout(layout);
  81. layout.setHorizontalGroup(
  82. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  83. .addGroup(layout.createSequentialGroup()
  84. .addGap(67, 67, 67)
  85. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  86. .addGroup(layout.createSequentialGroup()
  87. .addComponent(jLabel1)
  88. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  89. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  90. .addGroup(layout.createSequentialGroup()
  91. .addComponent(jLabel3)
  92. .addGap(18, 18, 18)
  93. .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  94. .addGroup(layout.createSequentialGroup()
  95. .addComponent(jLabel2)
  96. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  97. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  98. .addGap(59, 59, 59)
  99. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  100. .addComponent(jLabel4)
  101. .addComponent(jButton1))
  102. .addContainerGap(53, Short.MAX_VALUE))
  103. );
  104. layout.setVerticalGroup(
  105. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  106. .addGroup(layout.createSequentialGroup()
  107. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  108. .addGroup(layout.createSequentialGroup()
  109. .addGap(47, 47, 47)
  110. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  111. .addComponent(jLabel1)
  112. .addComponent(jButton1)))
  113. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  114. .addContainerGap()
  115. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  116. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  117. .addGroup(layout.createSequentialGroup()
  118. .addGap(18, 18, 18)
  119. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  120. .addComponent(jLabel2)
  121. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  122. .addGap(22, 22, 22)
  123. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  124. .addComponent(jLabel3)
  125. .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  126. .addGroup(layout.createSequentialGroup()
  127. .addGap(24, 24, 24)
  128. .addComponent(jLabel4)))
  129. .addContainerGap(144, Short.MAX_VALUE))
  130. );
  131.  
  132. pack();
  133. }// </editor-fold>
  134.  
  135. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  136. // TODO add your handling code here:
  137.  
  138. String db = jTextField1.getText();
  139. String host = "jdbc:mysql://localhost:3306/"+db;
  140. String user = jTextField2.getText();
  141. String pass = jTextField3.getText();
  142. String driver = "com.mysql.jdbc.Driver";
  143.  
  144. try {
  145. Class.forName(driver).newInstance();
  146. con = DriverManager.getConnection(host, user, pass);
  147. jLabel4.setText("Koneksi Berhasil");
  148. } catch (Exception e){
  149. jLabel4.setText("Koneksi Gagal " +e.getMessage());
  150. }
  151. }
  152.  
  153. /**
  154. * @param args the command line arguments
  155. */
  156. public static void main(String args[]) {
  157. /* Set the Nimbus look and feel */
  158. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  159. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  160. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  161. */
  162. try {
  163. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  164. if ("Nimbus".equals(info.getName())) {
  165. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  166. break;
  167. }
  168. }
  169. } catch (ClassNotFoundException ex) {
  170. java.util.logging.Logger.getLogger(tes_koneksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  171. } catch (InstantiationException ex) {
  172. java.util.logging.Logger.getLogger(tes_koneksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  173. } catch (IllegalAccessException ex) {
  174. java.util.logging.Logger.getLogger(tes_koneksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  175. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  176. java.util.logging.Logger.getLogger(tes_koneksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  177. }
  178. //</editor-fold>
  179.  
  180. /* Create and display the form */
  181. java.awt.EventQueue.invokeLater(new Runnable() {
  182. public void run() {
  183. new tes_koneksi().setVisible(true);
  184. }
  185. });
  186. }
  187.  
  188. // Variables declaration - do not modify
  189. private javax.swing.JButton jButton1;
  190. private javax.swing.JLabel jLabel1;
  191. private javax.swing.JLabel jLabel2;
  192. private javax.swing.JLabel jLabel3;
  193. private javax.swing.JLabel jLabel4;
  194. private javax.swing.JTextField jTextField1;
  195. private javax.swing.JTextField jTextField2;
  196. private javax.swing.JTextField jTextField3;
  197. // End of variables declaration
  198. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement