API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 14th, 2018
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.53 KB | None | 0 0
raw download clone embed print report
  1. package tokomaju;
  2. import com.mysql.jdbc.Statement;
  3. import com.mysql.jdbc.Connection;
  4. import java.awt.event.KeyEvent;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import javax.swing.JOptionPane;
  8. import koneksi.konek;
  9. import java.util.logging.Level;
  10. import java.util.logging.Logger;
  11.  
  12. /**
  13. *
  14. * @author aldycavalera
  15. */
  16. public class Sign extends javax.swing.JFrame {
  17.  
  18. /**
  19. * Creates new form Login
  20. */
  21. public Sign() {
  22. initComponents();
  23. }
  24.  
  25. private void login() throws SQLException {
  26. String username = jUsername.getText();
  27. String password = String.valueOf(jPassword.getPassword() );
  28. if(username.trim().isEmpty()) {
  29. JOptionPane.showMessageDialog(null, "Username masih kosong");
  30. } else if(password.trim().isEmpty() ) {
  31. JOptionPane.showMessageDialog(null, "Password masih kosong");
  32. } else {
  33. try{
  34. Connection c = konek.getConnection();
  35. String sql = "SELECT * FROM users WHERE username='"+username+"'";
  36. Statement s = (Statement) c.createStatement();
  37. ResultSet r = s.executeQuery(sql);
  38. boolean ada = r.next();
  39. if (!ada) {
  40. JOptionPane.showMessageDialog(null, "User tidak terdaftar!");
  41. } else {
  42. if (password.equalsIgnoreCase(r.getString("password"))) {
  43. this.setVisible(false);
  44. LandingHolder formUtama = new LandingHolder();
  45. formUtama.setVisible(true);
  46. } else {
  47. JOptionPane.showMessageDialog(null,"Username atau password salah");
  48. jUsername.setText("");
  49. jPassword.setText("");
  50. }
  51. }
  52. } catch(SQLException e) {
  53. JOptionPane.showMessageDialog(null, "Terjadi kesalahan : "+e.getMessage());
  54. }
  55. }
  56. }
  57. /**
  58. * This method is called from within the constructor to initialize the form.
  59. * WARNING: Do NOT modify this code. The content of this method is always
  60. * regenerated by the Form Editor.
  61. */
  62. @SuppressWarnings("unchecked")
  63. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  64. private void initComponents() {
  65.  
  66. jLabel1 = new javax.swing.JLabel();
  67. jLabel2 = new javax.swing.JLabel();
  68. jUsername = new javax.swing.JTextField();
  69. jLabel3 = new javax.swing.JLabel();
  70. BtnLogin = new javax.swing.JButton();
  71. BtnExit = new javax.swing.JButton();
  72. jPassword = new javax.swing.JPasswordField();
  73. BtnDaftar = new javax.swing.JButton();
  74.  
  75. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  76. setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
  77. setLocation(new java.awt.Point(500, 500));
  78.  
  79. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
  80. jLabel1.setText("FORM MASUK / DAFTAR");
  81.  
  82. jLabel2.setText("Nama pengguna");
  83.  
  84. jUsername.addActionListener(new java.awt.event.ActionListener() {
  85. public void actionPerformed(java.awt.event.ActionEvent evt) {
  86. jUsernameActionPerformed(evt);
  87. }
  88. });
  89.  
  90. jLabel3.setText("Kata sandi");
  91.  
  92. BtnLogin.setText("Masuk");
  93. BtnLogin.addActionListener(new java.awt.event.ActionListener() {
  94. public void actionPerformed(java.awt.event.ActionEvent evt) {
  95. BtnLoginActionPerformed(evt);
  96. }
  97. });
  98.  
  99. BtnExit.setText("Keluar");
  100. BtnExit.addActionListener(new java.awt.event.ActionListener() {
  101. public void actionPerformed(java.awt.event.ActionEvent evt) {
  102. BtnExitActionPerformed(evt);
  103. }
  104. });
  105.  
  106. jPassword.addKeyListener(new java.awt.event.KeyAdapter() {
  107. public void keyPressed(java.awt.event.KeyEvent evt) {
  108. jPasswordKeyPressed(evt);
  109. }
  110. });
  111.  
  112. BtnDaftar.setText("Daftar");
  113. BtnDaftar.addActionListener(new java.awt.event.ActionListener() {
  114. public void actionPerformed(java.awt.event.ActionEvent evt) {
  115. BtnDaftarActionPerformed(evt);
  116. }
  117. });
  118.  
  119. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  120. getContentPane().setLayout(layout);
  121. layout.setHorizontalGroup(
  122. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  123. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  124. .addGap(96, 96, 96)
  125. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  126. .addComponent(jLabel3)
  127. .addComponent(jLabel2))
  128. .addGap(27, 27, 27)
  129. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  130. .addGroup(layout.createSequentialGroup()
  131. .addComponent(BtnDaftar)
  132. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 13, Short.MAX_VALUE)
  133. .addComponent(BtnLogin)
  134. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  135. .addComponent(BtnExit))
  136. .addComponent(jUsername)
  137. .addComponent(jPassword))
  138. .addGap(108, 108, 108))
  139. .addGroup(layout.createSequentialGroup()
  140. .addGap(133, 133, 133)
  141. .addComponent(jLabel1)
  142. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  143. );
  144. layout.setVerticalGroup(
  145. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  146. .addGroup(layout.createSequentialGroup()
  147. .addGap(27, 27, 27)
  148. .addComponent(jLabel1)
  149. .addGap(28, 28, 28)
  150. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  151. .addComponent(jLabel2)
  152. .addComponent(jUsername, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  153. .addGap(18, 18, 18)
  154. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  155. .addComponent(jLabel3)
  156. .addComponent(jPassword, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  157. .addGap(27, 27, 27)
  158. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  159. .addComponent(BtnExit)
  160. .addComponent(BtnLogin)
  161. .addComponent(BtnDaftar))
  162. .addContainerGap(50, Short.MAX_VALUE))
  163. );
  164.  
  165. pack();
  166. }// </editor-fold>
  167.  
  168. private void BtnLoginActionPerformed(java.awt.event.ActionEvent evt) {
  169. try {
  170. login();
  171. } catch(SQLException ex) {
  172. Logger.getLogger(Sign.class.getName()).log(Level.SEVERE,null,ex);
  173. }
  174. }
  175.  
  176. private void BtnExitActionPerformed(java.awt.event.ActionEvent evt) {
  177. dispose();
  178. }
  179.  
  180. private void BtnDaftarActionPerformed(java.awt.event.ActionEvent evt) {
  181. String username = jUsername.getText();
  182. String password = String.valueOf(jPassword.getPassword() );
  183. try{
  184. Connection c = konek.getConnection();
  185. String sql = "SELECT * FROM users WHERE username='"+username+"'";
  186. Statement s = (Statement) c.createStatement();
  187. ResultSet r = s.executeQuery(sql);
  188. boolean ada = r.next();
  189. if (ada) {
  190. JOptionPane.showMessageDialog(null, "User sudah ada!");
  191. } else {
  192. Statement statement = (Statement) konek.getConnection().createStatement();
  193. statement.executeUpdate ("INSERT INTO users (username,password) VALUES ('"+ username +"','"+ password +"');");
  194. statement.close();
  195. JOptionPane.showMessageDialog(null, "Terdaftar");
  196. }
  197. } catch(SQLException e) {
  198. JOptionPane.showMessageDialog(null, "Gagal daftar");
  199. }
  200.  
  201. }
  202.  
  203. private void jUsernameActionPerformed(java.awt.event.ActionEvent evt) {
  204. // TODO add your handling code here:
  205. }
  206.  
  207. private void jPasswordKeyPressed(java.awt.event.KeyEvent evt) {
  208. if(evt.getKeyCode()==KeyEvent.VK_ENTER){
  209. try{
  210. String password = String.valueOf(jPassword.getPassword() );
  211. Connection c = konek.getConnection();
  212. String sql = "SELECT * FROM users WHERE username='"+ jUsername.getText() +"'";
  213. Statement s = (Statement) c.createStatement();
  214. ResultSet r = s.executeQuery(sql);
  215. boolean ada = r.next();
  216. if (!ada) {
  217. JOptionPane.showMessageDialog(null, "User tidak terdaftar!");
  218. } else {
  219. if (password.equalsIgnoreCase(r.getString("password"))) {
  220. this.setVisible(false);
  221. LandingHolder formUtama = new LandingHolder();
  222. formUtama.setVisible(true);
  223. } else {
  224. JOptionPane.showMessageDialog(null,"Username atau password salah");
  225. jUsername.setText("");
  226. jPassword.setText("");
  227. }
  228. }
  229. } catch(SQLException e) {
  230. JOptionPane.showMessageDialog(null, "Terjadi kesalahan : "+e.getMessage());
  231. }
  232. }
  233. }
  234.  
  235. /**
  236. * @param args the command line arguments
  237. */
  238. public static void main(String args[]) {
  239. /* Set the Nimbus look and feel */
  240. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  241. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  242. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  243. */
  244. try {
  245. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  246. if ("Nimbus".equals(info.getName())) {
  247. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  248. break;
  249. }
  250. }
  251. } catch (ClassNotFoundException ex) {
  252. java.util.logging.Logger.getLogger(Sign.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  253. } catch (InstantiationException ex) {
  254. java.util.logging.Logger.getLogger(Sign.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  255. } catch (IllegalAccessException ex) {
  256. java.util.logging.Logger.getLogger(Sign.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  257. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  258. java.util.logging.Logger.getLogger(Sign.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  259. }
  260. //</editor-fold>
  261. //</editor-fold>
  262.  
  263. /* Create and display the form */
  264. java.awt.EventQueue.invokeLater(new Runnable() {
  265. public void run() {
  266. new Sign().setVisible(true);
  267. }
  268. });
  269. }
  270.  
  271. // Variables declaration - do not modify
  272. private javax.swing.JButton BtnDaftar;
  273. private javax.swing.JButton BtnExit;
  274. private javax.swing.JButton BtnLogin;
  275. private javax.swing.JLabel jLabel1;
  276. private javax.swing.JLabel jLabel2;
  277. private javax.swing.JLabel jLabel3;
  278. private javax.swing.JPasswordField jPassword;
  279. private javax.swing.JTextField jUsername;
  280. // End of variables declaration
  281. }
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!