API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 10th, 2019
160
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.31 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 autoexotic;
  7.  
  8. import java.beans.PropertyChangeSupport;
  9. import java.sql.*;
  10. import javax.swing.event.ListSelectionEvent;
  11. import javax.swing.table.AbstractTableModel;
  12. import javax.swing.table.DefaultTableModel;
  13. import javax.swing.table.TableModel;
  14.  
  15. /**
  16. *
  17. * @author Cynergy
  18. */
  19. public class staffManage extends javax.swing.JFrame {
  20. private PropertyChangeSupport changeSupport = new PropertyChangeSupport(this);
  21.  
  22. /**
  23. * Creates new form staffManage
  24. */
  25. public staffManage() {
  26. initComponents();
  27. }
  28.  
  29. /**
  30. * This method is called from within the constructor to initialize the form.
  31. * WARNING: Do NOT modify this code. The content of this method is always
  32. * regenerated by the Form Editor.
  33. */
  34. @SuppressWarnings("unchecked")
  35. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  36. private void initComponents() {
  37. bindingGroup = new org.jdesktop.beansbinding.BindingGroup();
  38.  
  39. entityManager = java.beans.Beans.isDesignTime() ? null : javax.persistence.Persistence.createEntityManagerFactory("AutoExotic?zeroDateTimeBehavior=convertToNullPU").createEntityManager();
  40. usersQuery = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery("SELECT u FROM Users u");
  41. usersList = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : usersQuery.getResultList();
  42. jScrollPane1 = new javax.swing.JScrollPane();
  43. jTable1 = new javax.swing.JTable();
  44. jLabel1 = new javax.swing.JLabel();
  45. jLabel2 = new javax.swing.JLabel();
  46. userField = new javax.swing.JTextField();
  47. jLabel3 = new javax.swing.JLabel();
  48. passwordField = new javax.swing.JPasswordField();
  49. output = new javax.swing.JLabel();
  50. submit = new javax.swing.JButton();
  51. jButton1 = new javax.swing.JButton();
  52.  
  53. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  54.  
  55. org.jdesktop.swingbinding.JTableBinding jTableBinding = org.jdesktop.swingbinding.SwingBindings.createJTableBinding(org.jdesktop.beansbinding.AutoBinding.UpdateStrategy.READ_WRITE, usersList, jTable1);
  56. org.jdesktop.swingbinding.JTableBinding.ColumnBinding columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${username}"));
  57. columnBinding.setColumnName("Username");
  58. columnBinding.setColumnClass(String.class);
  59. columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${password}"));
  60. columnBinding.setColumnName("Password");
  61. columnBinding.setColumnClass(String.class);
  62. columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${active}"));
  63. columnBinding.setColumnName("Active");
  64. columnBinding.setColumnClass(String.class);
  65. columnBinding = jTableBinding.addColumnBinding(org.jdesktop.beansbinding.ELProperty.create("${payowed}"));
  66. columnBinding.setColumnName("Payowed");
  67. columnBinding.setColumnClass(Integer.class);
  68. bindingGroup.addBinding(jTableBinding);
  69. jTableBinding.bind();
  70. jTable1.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
  71. public void propertyChange(java.beans.PropertyChangeEvent evt) {
  72. jTable1PropertyChange(evt);
  73. }
  74. });
  75. jScrollPane1.setViewportView(jTable1);
  76. if (jTable1.getColumnModel().getColumnCount() > 0) {
  77. jTable1.getColumnModel().getColumn(0).setHeaderValue("Username");
  78. jTable1.getColumnModel().getColumn(1).setHeaderValue("Password");
  79. jTable1.getColumnModel().getColumn(2).setHeaderValue("Active");
  80. jTable1.getColumnModel().getColumn(3).setHeaderValue("Payowed");
  81. }
  82.  
  83. jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
  84. jLabel1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/autoexotic/banner.png"))); // NOI18N
  85.  
  86. jLabel2.setText("New Staff");
  87.  
  88. jLabel3.setText("Password?");
  89.  
  90. submit.setText("Create Staff");
  91. submit.addActionListener(new java.awt.event.ActionListener() {
  92. public void actionPerformed(java.awt.event.ActionEvent evt) {
  93. submitActionPerformed(evt);
  94. }
  95. });
  96.  
  97. jButton1.setText("jButton1");
  98. jButton1.addActionListener(new java.awt.event.ActionListener() {
  99. public void actionPerformed(java.awt.event.ActionEvent evt) {
  100. jButton1ActionPerformed(evt);
  101. }
  102. });
  103.  
  104. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  105. getContentPane().setLayout(layout);
  106. layout.setHorizontalGroup(
  107. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  108. .addGroup(layout.createSequentialGroup()
  109. .addContainerGap()
  110. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  111. .addComponent(jScrollPane1)
  112. .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  113. .addGroup(layout.createSequentialGroup()
  114. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  115. .addGroup(layout.createSequentialGroup()
  116. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  117. .addComponent(output, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  118. .addGroup(layout.createSequentialGroup()
  119. .addComponent(jLabel2)
  120. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  121. .addComponent(userField, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
  122. .addGap(18, 18, 18)
  123. .addComponent(jLabel3)
  124. .addGap(18, 18, 18)
  125. .addComponent(passwordField, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)))
  126. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  127. .addComponent(submit, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE))
  128. .addComponent(jButton1))
  129. .addGap(0, 274, Short.MAX_VALUE)))
  130. .addContainerGap())
  131. );
  132. layout.setVerticalGroup(
  133. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  134. .addGroup(layout.createSequentialGroup()
  135. .addContainerGap()
  136. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE)
  137. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  138. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  139. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  140. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  141. .addGroup(layout.createSequentialGroup()
  142. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  143. .addComponent(jLabel2)
  144. .addComponent(userField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  145. .addComponent(jLabel3)
  146. .addComponent(passwordField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  147. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  148. .addComponent(output, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  149. .addComponent(submit, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE))
  150. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  151. .addComponent(jButton1)
  152. .addContainerGap(129, Short.MAX_VALUE))
  153. );
  154.  
  155. bindingGroup.bind();
  156.  
  157. pack();
  158. }// </editor-fold>
  159.  
  160. private void submitActionPerformed(java.awt.event.ActionEvent evt) {
  161. // TODO add your handling code here:
  162. Connection con;
  163. try{
  164. Class.forName("com.mysql.jdbc.Driver");
  165. con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/autoexotic","root","");
  166. String insertRow = "INSERT INTO users(username, password) VALUES (?,?)";
  167. PreparedStatement statement = con.prepareStatement(insertRow);
  168. statement.setString(1, userField.getText());
  169. statement.setString(2, new String(passwordField.getPassword()));
  170. // statement.setString(3, "ACTIVE");
  171. //statement.setString(4, "0");
  172.  
  173. int rowsInserted = statement.executeUpdate();
  174.  
  175. if (rowsInserted > 0){
  176. output.setText("Staff Account Created: " + userField.getText());
  177.  
  178. } else{
  179. output.setText("Sorry, an error occured while creating the new account!");
  180.  
  181. }
  182. }catch(Exception e){
  183. System.out.println(e);
  184. }
  185.  
  186.  
  187. }
  188.  
  189. private void jTable1PropertyChange(java.beans.PropertyChangeEvent evt) {
  190. // TODO add your handling code here:
  191. }
  192.  
  193. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  194. // TODO add your handling code here:
  195. jTable1.repaint();
  196. jTable1.updateUI();
  197. }
  198.  
  199. /**
  200. * @param args the command line arguments
  201. */
  202. public static void main(String args[]) {
  203. /* Set the Nimbus look and feel */
  204. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  205. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  206. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  207. */
  208. try {
  209. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  210. if ("Nimbus".equals(info.getName())) {
  211. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  212. break;
  213. }
  214. }
  215. } catch (ClassNotFoundException ex) {
  216. java.util.logging.Logger.getLogger(staffManage.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  217. } catch (InstantiationException ex) {
  218. java.util.logging.Logger.getLogger(staffManage.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  219. } catch (IllegalAccessException ex) {
  220. java.util.logging.Logger.getLogger(staffManage.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  221. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  222. java.util.logging.Logger.getLogger(staffManage.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  223. }
  224. //</editor-fold>
  225.  
  226. /* Create and display the form */
  227. java.awt.EventQueue.invokeLater(new Runnable() {
  228. public void run() {
  229. new staffManage().setVisible(true);
  230. }
  231. });
  232. }
  233.  
  234. // Variables declaration - do not modify
  235. private javax.persistence.EntityManager entityManager;
  236. private javax.swing.JButton jButton1;
  237. private javax.swing.JLabel jLabel1;
  238. private javax.swing.JLabel jLabel2;
  239. private javax.swing.JLabel jLabel3;
  240. private javax.swing.JScrollPane jScrollPane1;
  241. private javax.swing.JTable jTable1;
  242. private javax.swing.JLabel output;
  243. private javax.swing.JPasswordField passwordField;
  244. private javax.swing.JButton submit;
  245. private javax.swing.JTextField userField;
  246. private java.util.List<autoexotic.Users> usersList;
  247. private javax.persistence.Query usersQuery;
  248. private org.jdesktop.beansbinding.BindingGroup bindingGroup;
  249. // End of variables declaration
  250. }
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!