API tools faq
paste
Guest User

Untitled

a guest
Feb 17th, 2017
106
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.82 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.Statement;
  2. import java.sql.Connection;
  3. import java.sql.DriverManager;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import javax.swing.JOptionPane;
  7.  
  8.  
  9. public class UserMaster extends javax.swing.JFrame {
  10. MainClass mc=new MainClass();
  11. ResultSet rsuser;
  12. int rspos=0;
  13. int rscount=0;
  14. boolean chadd=false;
  15. /** Creates new form UserMaster */
  16. public UserMaster() {
  17. initComponents();
  18. }
  19.  
  20. /** This method is called from within the constructor to
  21. * initialize the form.
  22. * WARNING: Do NOT modify this code. The content of this method is
  23. * always regenerated by the Form Editor.
  24. */
  25. // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
  26. private void initComponents() {
  27.  
  28. jLabel3 = new javax.swing.JLabel();
  29. TxtUserName = new javax.swing.JTextField();
  30. jLabel4 = new javax.swing.JLabel();
  31. TxtPassword = new javax.swing.JTextField();
  32. jLabel1 = new javax.swing.JLabel();
  33. jLabel8 = new javax.swing.JLabel();
  34. CmbUserType = new javax.swing.JComboBox();
  35. ChkUserActive = new javax.swing.JCheckBox();
  36. CmdFirst = new javax.swing.JButton();
  37. CmdPrevious = new javax.swing.JButton();
  38. CmdNext = new javax.swing.JButton();
  39. CmdLast = new javax.swing.JButton();
  40. CmdNew = new javax.swing.JButton();
  41. CmdEdit = new javax.swing.JButton();
  42. CmdSave = new javax.swing.JButton();
  43. CmdClose = new javax.swing.JButton();
  44. LblPosition = new javax.swing.JLabel();
  45.  
  46. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  47. setTitle("Simplified Library : User Master");
  48. addWindowListener(new java.awt.event.WindowAdapter() {
  49. public void windowOpened(java.awt.event.WindowEvent evt) {
  50. formWindowOpened(evt);
  51. }
  52. });
  53.  
  54. jLabel3.setText("User Name :");
  55.  
  56. TxtUserName.setText("jTextField1");
  57.  
  58. jLabel4.setText("Password :");
  59.  
  60. TxtPassword.setText("jTextField1");
  61.  
  62. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  63. jLabel1.setForeground(new java.awt.Color(204, 0, 0));
  64. jLabel1.setText("Simplified Library - User Master");
  65.  
  66. jLabel8.setText("User Type :");
  67.  
  68. CmbUserType.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
  69.  
  70. ChkUserActive.setText("Member Active");
  71.  
  72. CmdFirst.setText("First");
  73. CmdFirst.addActionListener(new java.awt.event.ActionListener() {
  74. public void actionPerformed(java.awt.event.ActionEvent evt) {
  75. CmdFirstActionPerformed(evt);
  76. }
  77. });
  78.  
  79. CmdPrevious.setText("Previous");
  80. CmdPrevious.addActionListener(new java.awt.event.ActionListener() {
  81. public void actionPerformed(java.awt.event.ActionEvent evt) {
  82. CmdPreviousActionPerformed(evt);
  83. }
  84. });
  85.  
  86. CmdNext.setText("Next");
  87. CmdNext.addActionListener(new java.awt.event.ActionListener() {
  88. public void actionPerformed(java.awt.event.ActionEvent evt) {
  89. CmdNextActionPerformed(evt);
  90. }
  91. });
  92.  
  93. CmdLast.setText("Last");
  94. CmdLast.addActionListener(new java.awt.event.ActionListener() {
  95. public void actionPerformed(java.awt.event.ActionEvent evt) {
  96. CmdLastActionPerformed(evt);
  97. }
  98. });
  99.  
  100. CmdNew.setText("New");
  101. CmdNew.addActionListener(new java.awt.event.ActionListener() {
  102. public void actionPerformed(java.awt.event.ActionEvent evt) {
  103. CmdNewActionPerformed(evt);
  104. }
  105. });
  106.  
  107. CmdEdit.setText("Edit");
  108. CmdEdit.addActionListener(new java.awt.event.ActionListener() {
  109. public void actionPerformed(java.awt.event.ActionEvent evt) {
  110. CmdEditActionPerformed(evt);
  111. }
  112. });
  113.  
  114. CmdSave.setText("Save");
  115. CmdSave.addActionListener(new java.awt.event.ActionListener() {
  116. public void actionPerformed(java.awt.event.ActionEvent evt) {
  117. CmdSaveActionPerformed(evt);
  118. }
  119. });
  120.  
  121. CmdClose.setText("Close");
  122. CmdClose.addActionListener(new java.awt.event.ActionListener() {
  123. public void actionPerformed(java.awt.event.ActionEvent evt) {
  124. CmdCloseActionPerformed(evt);
  125. }
  126. });
  127.  
  128. LblPosition.setText("position");
  129.  
  130. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  131. getContentPane().setLayout(layout);
  132. layout.setHorizontalGroup(
  133. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  134. .addGroup(layout.createSequentialGroup()
  135. .addGap(71, 71, 71)
  136. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  137. .addComponent(jLabel3)
  138. .addComponent(jLabel8)
  139. .addComponent(jLabel4))
  140. .addGap(20, 20, 20)
  141. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  142. .addGroup(layout.createSequentialGroup()
  143. .addComponent(ChkUserActive)
  144. .addContainerGap())
  145. .addGroup(layout.createSequentialGroup()
  146. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  147. .addComponent(CmbUserType, 0, 187, Short.MAX_VALUE)
  148. .addComponent(TxtPassword, javax.swing.GroupLayout.DEFAULT_SIZE, 187, Short.MAX_VALUE)
  149. .addComponent(TxtUserName, javax.swing.GroupLayout.DEFAULT_SIZE, 187, Short.MAX_VALUE))
  150. .addGap(340, 340, 340))))
  151. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  152. .addContainerGap()
  153. .addComponent(CmdFirst)
  154. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  155. .addComponent(CmdPrevious)
  156. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  157. .addComponent(CmdNext)
  158. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  159. .addComponent(CmdLast)
  160. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  161. .addComponent(CmdNew)
  162. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  163. .addComponent(CmdEdit)
  164. .addGap(6, 6, 6)
  165. .addComponent(CmdSave)
  166. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  167. .addComponent(CmdClose)
  168. .addGap(155, 155, 155))
  169. .addGroup(layout.createSequentialGroup()
  170. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171. .addGroup(layout.createSequentialGroup()
  172. .addGap(27, 27, 27)
  173. .addComponent(jLabel1))
  174. .addGroup(layout.createSequentialGroup()
  175. .addGap(113, 113, 113)
  176. .addComponent(LblPosition)))
  177. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  178. );
  179. layout.setVerticalGroup(
  180. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  181. .addGroup(layout.createSequentialGroup()
  182. .addGap(25, 25, 25)
  183. .addComponent(jLabel1)
  184. .addGap(40, 40, 40)
  185. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  186. .addGroup(layout.createSequentialGroup()
  187. .addComponent(TxtUserName, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
  188. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  189. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  190. .addComponent(TxtPassword, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
  191. .addComponent(jLabel4)))
  192. .addGroup(layout.createSequentialGroup()
  193. .addGap(3, 3, 3)
  194. .addComponent(jLabel3)))
  195. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  196. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  197. .addComponent(jLabel8)
  198. .addGroup(layout.createSequentialGroup()
  199. .addGap(1, 1, 1)
  200. .addComponent(CmbUserType, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)))
  201. .addGap(29, 29, 29)
  202. .addComponent(ChkUserActive)
  203. .addGap(61, 61, 61)
  204. .addComponent(LblPosition)
  205. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  206. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  207. .addComponent(CmdFirst)
  208. .addComponent(CmdPrevious)
  209. .addComponent(CmdNext)
  210. .addComponent(CmdLast)
  211. .addComponent(CmdEdit)
  212. .addComponent(CmdSave)
  213. .addComponent(CmdNew)
  214. .addComponent(CmdClose))
  215. .addContainerGap(25, Short.MAX_VALUE))
  216. );
  217.  
  218. pack();
  219. }// </editor-fold>//GEN-END:initComponents
  220.  
  221. private void CmdFirstActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdFirstActionPerformed
  222. try {
  223. rsuser.first();
  224. Display();
  225.  
  226. } catch (Exception e) {
  227. System.err.println(e);
  228.  
  229. }
  230. }//GEN-LAST:event_CmdFirstActionPerformed
  231.  
  232. private void CmdPreviousActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdPreviousActionPerformed
  233. try {
  234. if (rsuser.isFirst()==true) {
  235. JOptionPane.showMessageDialog(null,"Already in first record.");
  236. return;
  237.  
  238. }
  239.  
  240. rsuser.previous();
  241. Display();
  242.  
  243. } catch (Exception e) {
  244. System.err.println(e);
  245.  
  246. }
  247. }//GEN-LAST:event_CmdPreviousActionPerformed
  248.  
  249. private void CmdNextActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdNextActionPerformed
  250. try {
  251. if (rsuser.isLast()==true) {
  252. JOptionPane.showMessageDialog(null,"Already in last record.");
  253. return;
  254.  
  255. }
  256. rsuser.next();
  257. Display();
  258.  
  259. } catch (Exception e) {
  260. System.err.println(e);
  261.  
  262. }
  263. }//GEN-LAST:event_CmdNextActionPerformed
  264.  
  265. private void CmdLastActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdLastActionPerformed
  266. try {
  267. rsuser.last();
  268. Display();
  269.  
  270. } catch (Exception e) {
  271. System.err.println(e);
  272. //System.exit(1);
  273. }
  274. }//GEN-LAST:event_CmdLastActionPerformed
  275.  
  276. private void CmdNewActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdNewActionPerformed
  277. chadd=true;
  278. ClearText();
  279. }//GEN-LAST:event_CmdNewActionPerformed
  280.  
  281. private void CmdEditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdEditActionPerformed
  282. chadd=false;
  283. }//GEN-LAST:event_CmdEditActionPerformed
  284.  
  285. private void CmdSaveActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdSaveActionPerformed
  286. //validate entry and save record
  287. try {
  288.  
  289. if (TxtUserName.getText().trim().length()==0 ) {
  290. JOptionPane.showMessageDialog(null,"Enter user name.");
  291. return;
  292. }
  293.  
  294. if (TxtPassword.getText().trim().length()==0 ) {
  295. JOptionPane.showMessageDialog(null,"Enter password.");
  296. return;
  297. }
  298.  
  299.  
  300.  
  301.  
  302.  
  303. //String strqr="";
  304. Connection connection;
  305. connection=DriverManager.getConnection(mc.StrUrl,mc.StrUid,mc.StrPwd);
  306.  
  307. if (chadd==true ) {
  308.  
  309. rsuser.moveToInsertRow();
  310.  
  311. rsuser.updateString("user_name",TxtUserName.getText());
  312. rsuser.updateString("user_password",TxtPassword.getText());
  313. rsuser.updateString("user_type",CmbUserType.getSelectedItem().toString());
  314.  
  315. if (ChkUserActive.isSelected()==true) {
  316. rsuser.updateString("user_active","YES");
  317. } else {
  318. rsuser.updateString("user_active","NO");
  319. }
  320.  
  321. rsuser.insertRow();
  322.  
  323. rsuser.last();
  324. Display();
  325. } else {
  326. rsuser.updateString("user_password",TxtPassword.getText());
  327. rsuser.updateString("user_type",CmbUserType.getSelectedItem().toString());
  328.  
  329. if (ChkUserActive.isSelected()==true) {
  330. rsuser.updateString("user_active","YES");
  331. } else {
  332. rsuser.updateString("user_active","NO");
  333. }
  334.  
  335.  
  336.  
  337. rsuser.updateRow();
  338. rsuser.refreshRow();
  339. }
  340.  
  341. chadd=false;
  342. JOptionPane.showMessageDialog(null,"Record updated.");
  343. } catch (Exception e) {
  344. System.err.println(e);
  345. JOptionPane.showMessageDialog(null,"Unable to save record.");
  346. return;
  347. }
  348. }//GEN-LAST:event_CmdSaveActionPerformed
  349.  
  350. private void CmdCloseActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_CmdCloseActionPerformed
  351. // TODO add your handling code here:
  352. this.setVisible(false);
  353. }//GEN-LAST:event_CmdCloseActionPerformed
  354.  
  355. private void formWindowOpened(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowOpened
  356. try
  357. {
  358.  
  359. this.setLocationRelativeTo(null);
  360.  
  361. ClearText();
  362. CmbUserType.removeAllItems();
  363. CmbUserType.addItem("Admin");
  364. CmbUserType.addItem("User");
  365.  
  366. Connection connection;
  367. connection=DriverManager.getConnection(mc.StrUrl,mc.StrUid,mc.StrPwd);
  368. ResultSet rs;
  369.  
  370. PreparedStatement stmt;
  371. //get user count
  372. stmt=connection.prepareStatement("select count(*) from lib_user");
  373. rs = stmt.executeQuery();
  374. rs.first();
  375. rscount=rs.getInt(1);
  376.  
  377. //get user details
  378. Statement stmt1 = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
  379. String sqlQuery = "select * from lib_user ";
  380. rsuser = stmt1.executeQuery(sqlQuery);
  381.  
  382. //display first record
  383. rsuser.first();
  384.  
  385. Display();
  386.  
  387. }
  388. catch (Exception e)
  389. {
  390. System.err.println(e);
  391. //System.exit(1);
  392. }
  393.  
  394. }//GEN-LAST:event_formWindowOpened
  395. private void Display()
  396. {
  397. try
  398. {
  399. //clear text of fields for entry/display old data
  400. TxtUserName.setText(rsuser.getString("user_name"));
  401. TxtPassword.setText(rsuser.getString("user_password"));
  402. CmbUserType.setSelectedItem(rsuser.getString("user_type"));
  403.  
  404. if (rsuser.getString("user_active").equals("YES"))
  405. {
  406. ChkUserActive.setSelected(true);
  407. }
  408. else
  409. {
  410. ChkUserActive.setSelected(false);
  411. }
  412.  
  413. LblPosition.setText("Record position : " + rsuser.getRow() + "/" + String.valueOf(rscount));
  414. }
  415. catch (Exception e)
  416. {
  417. System.err.println(e);
  418.  
  419. }
  420. }
  421.  
  422. private void ClearText()
  423. {
  424. //clear text of fields for entry/display old data
  425. TxtUserName.setText("");
  426. TxtPassword.setText("");
  427. ChkUserActive.setSelected(false);
  428.  
  429.  
  430. LblPosition.setText("");
  431. }
  432.  
  433.  
  434. /**
  435. * @param args the command line arguments
  436. */
  437. public static void main(String args[]) {
  438. java.awt.EventQueue.invokeLater(new Runnable() {
  439. public void run() {
  440. new UserMaster().setVisible(true);
  441. }
  442. });
  443. }
  444.  
  445. // Variables declaration - do not modify//GEN-BEGIN:variables
  446. private javax.swing.JCheckBox ChkUserActive;
  447. private javax.swing.JComboBox CmbUserType;
  448. private javax.swing.JButton CmdClose;
  449. private javax.swing.JButton CmdEdit;
  450. private javax.swing.JButton CmdFirst;
  451. private javax.swing.JButton CmdLast;
  452. private javax.swing.JButton CmdNew;
  453. private javax.swing.JButton CmdNext;
  454. private javax.swing.JButton CmdPrevious;
  455. private javax.swing.JButton CmdSave;
  456. private javax.swing.JLabel LblPosition;
  457. private javax.swing.JTextField TxtPassword;
  458. private javax.swing.JTextField TxtUserName;
  459. private javax.swing.JLabel jLabel1;
  460. private javax.swing.JLabel jLabel3;
  461. private javax.swing.JLabel jLabel4;
  462. private javax.swing.JLabel jLabel8;
  463. // End of variables declaration//GEN-END:variables
  464.  
  465. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!