API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 15th, 2016
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.84 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 myfirstjavagui;
  7.  
  8. /**
  9. *
  10. * @author STUDENT
  11. *
  12. */
  13. import java.sql.*;
  14.  
  15. import java.util.ArrayList;
  16.  
  17. import javax.swing.JOptionPane;
  18.  
  19. import javax.swing.table.DefaultTableModel;
  20.  
  21. import javax.swing.table.TableModel;
  22. public class FRMSTUDENT extends javax.swing.JFrame {
  23.  
  24. /**
  25. * Creates new form FRMSTUDENT
  26. */
  27. public FRMSTUDENT() {
  28.  
  29. initComponents();
  30. Show_Users_In_CMDt();
  31. }
  32. public Connection getConnection(){
  33.  
  34. Connection con;
  35. try {
  36. con = DriverManager.getConnection("jdbc:mysql://localhost/dbstudentdata", "root","");
  37. return con;
  38. }catch(Exception e){
  39. e.printStackTrace();
  40. return null;
  41. }
  42.  
  43.  
  44. }
  45. public ArrayList<Source> getUsersList()
  46. {
  47. ArrayList<Source> usersList = new ArrayList<Source>();
  48. Connection connection = getConnection();
  49. String query = "SELECT * FROM studentinfo";
  50. Statement st;
  51. ResultSet rs;
  52. try {
  53. st = connection.createStatement();
  54. rs = st.executeQuery(query);
  55. Source source;
  56. while(rs.next())
  57. {
  58.  
  59. source = new Source(rs.getInt("StudentID"),rs.getString("FLDFirstName"),rs.getString("FLDMiddleName"),rs.getString("FLDLastName"),rs.getString("FLDCourse"));
  60. usersList.add(source);
  61.  
  62. }
  63.  
  64. } catch (Exception e) {
  65.  
  66. e.printStackTrace();
  67.  
  68. }
  69.  
  70. return usersList;
  71.  
  72. }
  73. public void Show_Users_In_CMDt()
  74.  
  75. {
  76.  
  77. ArrayList<Source> list = getUsersList();
  78.  
  79. DefaultTableModel model = (DefaultTableModel)CMDt.getModel();
  80.  
  81. Object[] row = new Object[5];
  82.  
  83. for(int i = 0; i < list.size(); i++)
  84.  
  85. {
  86.  
  87. row[0] = list.get(i).getID();
  88. row[1] = list.get(i).getfirstname();
  89. row[2] = list.get(i).getmiddlename();
  90.  
  91. row[3] = list.get(i).getlastname();
  92.  
  93. row[4] = list.get(i).getcourse();
  94.  
  95. model.addRow(row);
  96.  
  97. }
  98.  
  99. }
  100. /**
  101. * This method is called from within the constructor to initialize the form.
  102. * WARNING: Do NOT modify this code. The content of this method is always
  103. * regenerated by the Form Editor.
  104. */
  105. @SuppressWarnings("unchecked")
  106. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  107. private void initComponents() {
  108.  
  109. jScrollPane1 = new javax.swing.JScrollPane();
  110. jTable1 = new javax.swing.JTable();
  111. CMBsi = new javax.swing.JLabel();
  112. CMDfn = new javax.swing.JLabel();
  113. CMDmd = new javax.swing.JLabel();
  114. CMBln = new javax.swing.JLabel();
  115. jTextField1 = new javax.swing.JTextField();
  116. jTextField2 = new javax.swing.JTextField();
  117. jTextField3 = new javax.swing.JTextField();
  118. jTextField4 = new javax.swing.JTextField();
  119. CMDc = new javax.swing.JLabel();
  120. jTextField5 = new javax.swing.JTextField();
  121. jScrollPane2 = new javax.swing.JScrollPane();
  122. CMDt = new javax.swing.JTable();
  123. CMDadd = new javax.swing.JButton();
  124. CMDUpdate = new javax.swing.JButton();
  125. CMDd = new javax.swing.JButton();
  126.  
  127. jTable1.setModel(new javax.swing.table.DefaultTableModel(
  128. new Object [][] {
  129. {null, null, null, null},
  130. {null, null, null, null},
  131. {null, null, null, null},
  132. {null, null, null, null}
  133. },
  134. new String [] {
  135. "Title 1", "Title 2", "Title 3", "Title 4"
  136. }
  137. ));
  138. jScrollPane1.setViewportView(jTable1);
  139.  
  140. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  141.  
  142. CMBsi.setText("Student ID");
  143.  
  144. CMDfn.setText("FirstName");
  145. CMDfn.setToolTipText("FirstName");
  146.  
  147. CMDmd.setText("MiddleName");
  148.  
  149. CMBln.setText("LastName");
  150.  
  151. jTextField1.addActionListener(new java.awt.event.ActionListener() {
  152. public void actionPerformed(java.awt.event.ActionEvent evt) {
  153. jTextField1ActionPerformed(evt);
  154. }
  155. });
  156.  
  157. jTextField3.addActionListener(new java.awt.event.ActionListener() {
  158. public void actionPerformed(java.awt.event.ActionEvent evt) {
  159. jTextField3ActionPerformed(evt);
  160. }
  161. });
  162.  
  163. CMDc.setText("Course");
  164.  
  165. jTextField5.addActionListener(new java.awt.event.ActionListener() {
  166. public void actionPerformed(java.awt.event.ActionEvent evt) {
  167. jTextField5ActionPerformed(evt);
  168. }
  169. });
  170.  
  171. CMDt.setModel(new javax.swing.table.DefaultTableModel(
  172. new Object [][] {
  173.  
  174. },
  175. new String [] {
  176. "StudentID", "FirstName", "MiddleName", "LastName", "Course"
  177. }
  178. ));
  179. CMDt.addMouseListener(new java.awt.event.MouseAdapter() {
  180. public void mouseClicked(java.awt.event.MouseEvent evt) {
  181. CMDtMouseClicked(evt);
  182. }
  183. });
  184. jScrollPane2.setViewportView(CMDt);
  185.  
  186. CMDadd.setText("ADD");
  187.  
  188. CMDUpdate.setText("UPDATE");
  189. CMDUpdate.addActionListener(new java.awt.event.ActionListener() {
  190. public void actionPerformed(java.awt.event.ActionEvent evt) {
  191. CMDUpdateActionPerformed(evt);
  192. }
  193. });
  194.  
  195. CMDd.setText("DELETE");
  196. CMDd.addActionListener(new java.awt.event.ActionListener() {
  197. public void actionPerformed(java.awt.event.ActionEvent evt) {
  198. CMDdActionPerformed(evt);
  199. }
  200. });
  201.  
  202. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  203. getContentPane().setLayout(layout);
  204. layout.setHorizontalGroup(
  205. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  206. .addGroup(layout.createSequentialGroup()
  207. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  208. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  209. .addGroup(layout.createSequentialGroup()
  210. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  211. .addComponent(CMDfn, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  212. .addComponent(CMBsi, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  213. .addComponent(CMDmd, javax.swing.GroupLayout.DEFAULT_SIZE, 61, Short.MAX_VALUE)
  214. .addComponent(CMBln, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  215. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  216. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  217. .addComponent(jTextField3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 168, Short.MAX_VALUE)
  218. .addComponent(jTextField2, javax.swing.GroupLayout.Alignment.LEADING)
  219. .addComponent(jTextField1, javax.swing.GroupLayout.Alignment.LEADING)
  220. .addComponent(jTextField4))
  221. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  222. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  223. .addGroup(layout.createSequentialGroup()
  224. .addComponent(CMDc)
  225. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  226. .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 128, javax.swing.GroupLayout.PREFERRED_SIZE)
  227. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  228. .addComponent(CMDadd, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))
  229. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  230. .addGap(0, 0, Short.MAX_VALUE)
  231. .addComponent(CMDUpdate, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))
  232. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  233. .addGap(0, 0, Short.MAX_VALUE)
  234. .addComponent(CMDd, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE)))
  235. .addContainerGap())
  236. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 550, javax.swing.GroupLayout.PREFERRED_SIZE)))
  237. );
  238. layout.setVerticalGroup(
  239. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  240. .addGroup(layout.createSequentialGroup()
  241. .addGap(52, 52, 52)
  242. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  243. .addComponent(CMBsi, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
  244. .addComponent(CMDc, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
  245. .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  246. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  247. .addComponent(CMDadd, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE))
  248. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  249. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  250. .addComponent(CMDfn, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
  251. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  252. .addComponent(CMDUpdate))
  253. .addGap(10, 10, 10)
  254. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  255. .addComponent(CMDmd, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
  256. .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  257. .addComponent(CMDd))
  258. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  259. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  260. .addComponent(CMBln, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
  261. .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  262. .addGap(30, 30, 30)
  263. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 281, javax.swing.GroupLayout.PREFERRED_SIZE)
  264. .addContainerGap(145, Short.MAX_VALUE))
  265. );
  266.  
  267. pack();
  268. }// </editor-fold>
  269.  
  270. private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
  271. // TODO add your handling code here:
  272. }
  273.  
  274. private void jTextField3ActionPerformed(java.awt.event.ActionEvent evt) {
  275. // TODO add your handling code here:
  276. }
  277.  
  278. private void jTextField5ActionPerformed(java.awt.event.ActionEvent evt) {
  279. // TODO add your handling code here:
  280. }
  281.  
  282. private void CMDUpdateActionPerformed(java.awt.event.ActionEvent evt) {
  283. // TODO add your handling code here:
  284. }
  285.  
  286. private void CMDdActionPerformed(java.awt.event.ActionEvent evt) {
  287. // TODO add your handling code here:
  288. }
  289.  
  290. private void CMDtMouseClicked(java.awt.event.MouseEvent evt) {
  291. // TODO add your handling code here:
  292. int i = CMDt.getSelectedRow();
  293. TableModel model = CMDt.getModel();
  294. // Display Slected Row In JTexteFields
  295. jTextField1.setText(model.getValueAt(i,0).toString());
  296. jTextField2.setText(model.getValueAt(i,1).toString());
  297. }
  298.  
  299. /**
  300. * @param args the command line arguments
  301. */
  302. public static void main(String args[]) {
  303. /* Set the Nimbus look and feel */
  304. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  305. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  306. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  307. */
  308. try {
  309. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  310. if ("Nimbus".equals(info.getName())) {
  311. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  312. break;
  313. }
  314. }
  315. } catch (ClassNotFoundException ex) {
  316. java.util.logging.Logger.getLogger(FRMSTUDENT.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  317. } catch (InstantiationException ex) {
  318. java.util.logging.Logger.getLogger(FRMSTUDENT.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  319. } catch (IllegalAccessException ex) {
  320. java.util.logging.Logger.getLogger(FRMSTUDENT.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  321. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  322. java.util.logging.Logger.getLogger(FRMSTUDENT.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  323. }
  324. //</editor-fold>
  325.  
  326. /* Create and display the form */
  327. java.awt.EventQueue.invokeLater(new Runnable() {
  328. public void run() {
  329. new FRMSTUDENT().setVisible(true);
  330. }
  331. });
  332. }
  333.  
  334. // Variables declaration - do not modify
  335. private javax.swing.JLabel CMBln;
  336. private javax.swing.JLabel CMBsi;
  337. private javax.swing.JButton CMDUpdate;
  338. private javax.swing.JButton CMDadd;
  339. private javax.swing.JLabel CMDc;
  340. private javax.swing.JButton CMDd;
  341. private javax.swing.JLabel CMDfn;
  342. private javax.swing.JLabel CMDmd;
  343. private javax.swing.JTable CMDt;
  344. private javax.swing.JScrollPane jScrollPane1;
  345. private javax.swing.JScrollPane jScrollPane2;
  346. private javax.swing.JTable jTable1;
  347. private javax.swing.JTextField jTextField1;
  348. private javax.swing.JTextField jTextField2;
  349. private javax.swing.JTextField jTextField3;
  350. private javax.swing.JTextField jTextField4;
  351. private javax.swing.JTextField jTextField5;
  352. // End of variables declaration
  353.  
  354.  
  355. }
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!