Advertisement
Guest User

Untitled

a guest
Mar 6th, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.96 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.PreparedStatement;
  3. import java.sql.*;
  4. import java.sql.ResultSet;
  5. import javax.swing.JFrame;
  6. import java.awt.*;
  7.  
  8.  
  9.  
  10.  
  11. public class LoginForm extends javax.swing.JFrame {
  12.  
  13. private String sql;
  14.  
  15. /**
  16. * Creates new form LoginForm
  17. */
  18. public LoginForm() {
  19. initComponents();
  20. username_error_lbl.setVisible(false);
  21. password_error_lbl.setVisible(false);
  22. }
  23.  
  24. /**
  25. * This method is called from within the constructor to initialize the form.
  26. * WARNING: Do NOT modify this code. The content of this method is always
  27. * regenerated by the Form Editor.
  28. */
  29. @SuppressWarnings("unchecked")
  30. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  31. private void initComponents() {
  32.  
  33. login_panel = new javax.swing.JPanel();
  34. title_label = new javax.swing.JLabel();
  35. username_label = new javax.swing.JLabel();
  36. password_label = new javax.swing.JLabel();
  37. password_textfield = new javax.swing.JPasswordField();
  38. username_textfield = new javax.swing.JTextField();
  39. login_button = new javax.swing.JButton();
  40. cancel_button = new javax.swing.JButton();
  41. username_error_lbl = new javax.swing.JLabel();
  42. password_error_lbl = new javax.swing.JLabel();
  43.  
  44. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  45.  
  46. login_panel.setBackground(new java.awt.Color(153, 255, 204));
  47. login_panel.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
  48.  
  49. title_label.setFont(new java.awt.Font("Times New Roman", 1, 24)); // NOI18N
  50. title_label.setForeground(new java.awt.Color(0, 0, 0));
  51. title_label.setText("LoginForm");
  52.  
  53. username_label.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
  54. username_label.setForeground(new java.awt.Color(0, 0, 0));
  55. username_label.setText("Username");
  56.  
  57. password_label.setFont(new java.awt.Font("Times New Roman", 1, 14)); // NOI18N
  58. password_label.setForeground(new java.awt.Color(0, 0, 0));
  59. password_label.setText("Password");
  60.  
  61. login_button.setText("Login");
  62. login_button.addActionListener(new java.awt.event.ActionListener() {
  63. public void actionPerformed(java.awt.event.ActionEvent evt) {
  64. login_buttonActionPerformed(evt);
  65. }
  66. });
  67.  
  68. cancel_button.setText("Cancel");
  69. cancel_button.addActionListener(new java.awt.event.ActionListener() {
  70. public void actionPerformed(java.awt.event.ActionEvent evt) {
  71. cancel_buttonActionPerformed(evt);
  72. }
  73. });
  74.  
  75. username_error_lbl.setForeground(new java.awt.Color(204, 0, 0));
  76. username_error_lbl.setText("*");
  77.  
  78. password_error_lbl.setForeground(new java.awt.Color(255, 51, 51));
  79. password_error_lbl.setText("*");
  80.  
  81. javax.swing.GroupLayout login_panelLayout = new javax.swing.GroupLayout(login_panel);
  82. login_panel.setLayout(login_panelLayout);
  83. login_panelLayout.setHorizontalGroup(
  84. login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  85. .addGroup(login_panelLayout.createSequentialGroup()
  86. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  87. .addGroup(login_panelLayout.createSequentialGroup()
  88. .addGap(128, 128, 128)
  89. .addComponent(title_label, javax.swing.GroupLayout.PREFERRED_SIZE, 213, javax.swing.GroupLayout.PREFERRED_SIZE))
  90. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, login_panelLayout.createSequentialGroup()
  91. .addContainerGap()
  92. .addComponent(login_button)
  93. .addGap(88, 88, 88)
  94. .addComponent(cancel_button, javax.swing.GroupLayout.PREFERRED_SIZE, 70, javax.swing.GroupLayout.PREFERRED_SIZE))
  95. .addGroup(login_panelLayout.createSequentialGroup()
  96. .addContainerGap()
  97. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  98. .addComponent(password_label, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE)
  99. .addComponent(username_label, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE))
  100. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  101. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  102. .addComponent(username_textfield)
  103. .addComponent(password_textfield))))
  104. .addGap(18, 18, 18)
  105. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  106. .addComponent(username_error_lbl)
  107. .addComponent(password_error_lbl))
  108. .addContainerGap(38, Short.MAX_VALUE))
  109. );
  110. login_panelLayout.setVerticalGroup(
  111. login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  112. .addGroup(login_panelLayout.createSequentialGroup()
  113. .addContainerGap()
  114. .addComponent(title_label)
  115. .addGap(50, 50, 50)
  116. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  117. .addComponent(username_label)
  118. .addComponent(username_textfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  119. .addComponent(username_error_lbl))
  120. .addGap(33, 33, 33)
  121. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  122. .addComponent(password_label)
  123. .addComponent(password_textfield, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  124. .addComponent(password_error_lbl))
  125. .addGap(44, 44, 44)
  126. .addGroup(login_panelLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  127. .addComponent(cancel_button)
  128. .addComponent(login_button))
  129. .addContainerGap(56, Short.MAX_VALUE))
  130. );
  131.  
  132. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  133. getContentPane().setLayout(layout);
  134. layout.setHorizontalGroup(
  135. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  136. .addComponent(login_panel, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  137. );
  138. layout.setVerticalGroup(
  139. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  140. .addComponent(login_panel, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  141. );
  142.  
  143. pack();
  144. }// </editor-fold>
  145.  
  146. private void login_buttonActionPerformed(java.awt.event.ActionEvent evt) {
  147. username_error_lbl.setVisible(false);
  148. password_error_lbl.setVisible(false);
  149.  
  150. if(username_textfield.getText().equals("")){
  151.  
  152. username_error_lbl.setVisible(true);
  153.  
  154. }if(String.valueOf(password_textfield.getPassword()).equals("")){
  155. password_error_lbl.setVisible(true);
  156. }else{
  157.  
  158. Connection conn = MyConnection.getConnection();
  159. PreparedStatement ps;
  160. try {
  161. ps=conn.prepareStatement("SELECT * FROM users WHERE username = ? AND password = ?");
  162. ps.setString(1, username_textfield.getText());
  163. ps.setString(2, String.valueOf(password_textfield.getPassword()));
  164. ResultSet rs = ps.executeQuery();
  165.  
  166. if(rs.next()){
  167.  
  168. MainForm mf = new MainForm();
  169. mf.setVisible(true);
  170. mf.pack();
  171. mf.setLocationRelativeTo(null);
  172. mf.setExtendedState(JFrame.MAXIMIZED_BOTH);
  173. MainForm.welcome_label.setText("Welcome *" +username_textfield.getText()+" *");
  174. MainForm.student_count_label.setText("Student Count=" +Integer.toString(MyFunction.countData("users")));
  175. MainForm.courses_count_label.setText("Course Count=" +Integer.toString(MyFunction.countData("courses")));
  176. this.dispose();
  177.  
  178. }else{
  179.  
  180. System.out.println("NO");
  181. }
  182.  
  183. } catch (Exception e) {
  184. }
  185.  
  186. }
  187.  
  188. private void cancel_buttonActionPerformed(java.awt.event.ActionEvent evt) {
  189. System.exit(0);
  190. }
  191. }
  192. /**
  193. * @param args the command line arguments
  194. */
  195.  
  196.  
  197. }
  198. }
  199. try {
  200. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  201. if ("Nimbus".equals(info.getName())) {
  202. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  203. break;
  204. }
  205. }
  206. } catch (ClassNotFoundException ex) {
  207. java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  208. } catch (InstantiationException ex) {
  209. java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  210. } catch (IllegalAccessException ex) {
  211. java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  212. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  213. java.util.logging.Logger.getLogger(LoginForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  214. }
  215. //</editor-fold>
  216.  
  217. public static void main(String args[]) {
  218. java.awt.EventQueue.invokeLater(new Runnable() {
  219. public void run() {
  220. new LoginForm().setVisible(true);
  221. }
  222. });
  223. }
  224.  
  225. // Variables declaration - do not modify
  226. private javax.swing.JButton cancel_button;
  227. private javax.swing.JButton login_button;
  228. public static javax.swing.JPanel login_panel;
  229. private javax.swing.JLabel password_error_lbl;
  230. private javax.swing.JLabel password_label;
  231. private javax.swing.JPasswordField password_textfield;
  232. private javax.swing.JLabel title_label;
  233. private javax.swing.JLabel username_error_lbl;
  234. private javax.swing.JLabel username_label;
  235. private javax.swing.JTextField username_textfield;
  236. // End of variables declaration
  237. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement