API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 27th, 2016
36
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.35 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 minesweeper;
  7.  
  8. /**
  9. *bron: http://1bestcsharp.blogspot.be/2016/01/java-and-mysql-insert-update-delete-display.html?m=1
  10. * @author Quinten
  11. */
  12. import java.sql.Connection;
  13. import java.sql.DriverManager;
  14. import java.sql.ResultSet;
  15. import java.sql.Statement;
  16. import java.util.ArrayList;
  17. import javax.swing.JOptionPane;
  18. import javax.swing.table.DefaultTableModel;
  19. import javax.swing.table.TableModel;
  20.  
  21. /**
  22. *
  23. * Dit is een databank om de score op te slaan en weer te geven. De score wordt automatisch ingevuld.
  24. *
  25. */
  26. public class Score extends javax.swing.JFrame {
  27.  
  28. /**
  29. * form aanmaken
  30. */
  31. public Score() {
  32. initComponents();
  33. Show_Users_In_JTable();
  34. }
  35.  
  36. // get the connection
  37. public Connection getConnection()
  38. {
  39. Connection con;
  40. try {
  41. con = DriverManager.getConnection("jdbc:mysql://localhost/quintengip", "root","");
  42. return con;
  43. } catch (Exception e) {
  44. e.printStackTrace();
  45. return null;
  46. }
  47. }
  48.  
  49.  
  50. // lijst met mysql database
  51. public ArrayList<Data> getUsersList()
  52. {
  53. ArrayList<Data> usersList = new ArrayList<Data>();
  54. Connection connection = getConnection();
  55.  
  56. String query = "SELECT * FROM `quintengip`";
  57. Statement st;
  58. ResultSet rs;
  59.  
  60. try {
  61. st = connection.createStatement();
  62. rs = st.executeQuery(query);
  63. Data user;
  64. while(rs.next())
  65. {
  66. user = new Data(rs.getInt("Id"),rs.getString("Naam"),rs.getInt("Score"));
  67. usersList.add(user);
  68. }
  69. } catch (Exception e) {
  70. e.printStackTrace();
  71. }
  72. return usersList;
  73. }
  74.  
  75. // data weergeven
  76.  
  77. public void Show_Users_In_JTable()
  78. {
  79. ArrayList<Data> list = getUsersList();
  80. DefaultTableModel model = (DefaultTableModel)jTable_Display_Users.getModel();
  81. Object[] row = new Object[4];
  82. for(int i = 0; i < list.size(); i++)
  83. {
  84. row[0] = list.get(i).getId();
  85. row[1] = list.get(i).getNaam();
  86. row[2] = list.get(i).getScore();
  87.  
  88. model.addRow(row);
  89. }
  90. }
  91.  
  92. // voor Insert Query uit
  93. public void executeSQlQuery(String query, String message)
  94. {
  95. Connection con = getConnection();
  96. Statement st;
  97. try{
  98. st = con.createStatement();
  99. if((st.executeUpdate(query)) == 1)
  100. {
  101. // vernieuwen
  102. DefaultTableModel model = (DefaultTableModel)jTable_Display_Users.getModel();
  103. model.setRowCount(0);
  104. Show_Users_In_JTable();
  105.  
  106. JOptionPane.showMessageDialog(null, "Data "+message+" Succefully");
  107. }else{
  108. JOptionPane.showMessageDialog(null, "Data Not "+message);
  109. }
  110. }catch(Exception ex){
  111. ex.printStackTrace();
  112. }
  113. }
  114.  
  115. @SuppressWarnings("unchecked")
  116.  
  117. private void initComponents() {
  118.  
  119. jPanel1 = new javax.swing.JPanel();
  120. ID = new javax.swing.JLabel();
  121. Naam = new javax.swing.JLabel();
  122.  
  123. Score = new javax.swing.JLabel();
  124. id = new javax.swing.JTextField();
  125. voornaam = new javax.swing.JTextField();
  126.  
  127. score = new javax.swing.JTextField();
  128. jScrollPane1 = new javax.swing.JScrollPane();
  129. jTable_Display_Users = new javax.swing.JTable();
  130. jButton_Insert = new javax.swing.JButton();
  131.  
  132. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  133.  
  134. jPanel1.setBackground(new java.awt.Color(204, 204, 204));
  135.  
  136. setFont(new java.awt.Font("Verdana", 0, 18));
  137. ID.setText("Id:");
  138. Naam.setText("Naam:");
  139. Score.setText("Score:");
  140.  
  141. id.setFont(new java.awt.Font("Verdana", 0, 14));
  142.  
  143. voornaam.setFont(new java.awt.Font("Verdana", 0, 14));
  144. voornaam.addActionListener(new java.awt.event.ActionListener() {
  145. public void actionPerformed(java.awt.event.ActionEvent evt) {
  146. jTextField_FirstNameActionPerformed(evt);
  147. }
  148. });
  149.  
  150. score.setFont(new java.awt.Font("Verdana", 0, 14));
  151. score.addActionListener(new java.awt.event.ActionListener() {
  152. public void actionPerformed(java.awt.event.ActionEvent evt) {
  153. jTextField_AgeActionPerformed(evt);
  154. }
  155. });
  156.  
  157. jTable_Display_Users.setModel(new javax.swing.table.DefaultTableModel(
  158. new Object [][] {
  159.  
  160. },
  161. new String [] {
  162. "Id", "Naam", "Score"
  163. }
  164. ));
  165. jTable_Display_Users.addMouseListener(new java.awt.event.MouseAdapter() {
  166. public void mouseClicked(java.awt.event.MouseEvent evt) {
  167. jTable_Display_UsersMouseClicked(evt);
  168. }
  169. });
  170. jScrollPane1.setViewportView(jTable_Display_Users);
  171.  
  172. jButton_Insert.setFont(new java.awt.Font("Verdana", 1, 14));
  173.  
  174. jButton_Insert.setText("OK");
  175. jButton_Insert.addActionListener(new java.awt.event.ActionListener() {
  176. public void actionPerformed(java.awt.event.ActionEvent evt) {
  177. jButton_InsertActionPerformed(evt);
  178. }
  179. });
  180. ;
  181.  
  182.  
  183.  
  184. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);//dit alles is om te positioneren en de grootte te bepalen
  185. jPanel1.setLayout(jPanel1Layout);
  186. jPanel1Layout.setHorizontalGroup(
  187. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  188. .addGroup(jPanel1Layout.createSequentialGroup()
  189. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  190. .addGroup(jPanel1Layout.createSequentialGroup()
  191. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  192. .addGroup(jPanel1Layout.createSequentialGroup()
  193. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  194. .addComponent(Score))
  195. .addGap(12, 12, 12))
  196. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  197. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  198. .addComponent(Naam)
  199. .addComponent(ID))
  200. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)))//dit alles is om te positioneren en de grootte te bepalen
  201. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  202. .addComponent(id, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)
  203. .addComponent(voornaam, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)
  204. .addComponent(score, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)))
  205. .addGroup(jPanel1Layout.createSequentialGroup()
  206. .addComponent(jButton_Insert)
  207. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 20, Short.MAX_VALUE)))
  208. .addGap(18, 18, 18)
  209. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 409, javax.swing.GroupLayout.PREFERRED_SIZE)
  210. .addContainerGap())
  211. );
  212. jPanel1Layout.setVerticalGroup(
  213. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  214. .addGroup(jPanel1Layout.createSequentialGroup()
  215. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  216. .addGroup(jPanel1Layout.createSequentialGroup()
  217. .addGap(36, 36, 36)
  218. .addComponent(ID))
  219. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  220. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  221. .addComponent(id, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)))
  222. .addGap(11, 11, 11)//dit alles is om te positioneren en de grootte te bepalen
  223. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  224. .addComponent(Naam)
  225. .addComponent(voornaam, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE))
  226. .addGap(18, 18, 18)
  227. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE))
  228. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  229. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  230. .addComponent(Score)
  231. .addComponent(score, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE))
  232. .addGap(75, 75, 75)
  233. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  234. .addComponent(jButton_Insert, javax.swing.GroupLayout.PREFERRED_SIZE, 46, javax.swing.GroupLayout.PREFERRED_SIZE))
  235. .addGap(192, 192, 192))
  236. .addGroup(jPanel1Layout.createSequentialGroup()
  237. .addContainerGap()
  238. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  239. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  240. );
  241.  
  242. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  243. getContentPane().setLayout(layout);
  244. layout.setHorizontalGroup(
  245. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  246. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  247. );//dit alles is om te positioneren en de grootte te bepalen
  248. layout.setVerticalGroup(
  249. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  250. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  251. );
  252.  
  253. pack();
  254. }
  255.  
  256. private void jTextField_FirstNameActionPerformed(java.awt.event.ActionEvent evt) {
  257. // TODO add your handling code here:
  258. }
  259.  
  260. private void jTextField_LastNameActionPerformed(java.awt.event.ActionEvent evt) {
  261. // TODO add your handling code here:
  262. }
  263.  
  264. private void jTextField_AgeActionPerformed(java.awt.event.ActionEvent evt) {
  265. // TODO add your handling code here:
  266. }
  267.  
  268.  
  269. private void jTable_Display_UsersMouseClicked(java.awt.event.MouseEvent evt) {
  270. // index geselecteerde rij
  271. int i = jTable_Display_Users.getSelectedRow();
  272.  
  273. TableModel model = jTable_Display_Users.getModel();
  274.  
  275. // rij teruggeven in tekstvelden
  276. id.setText(model.getValueAt(i,0).toString());
  277. Naam.setText(model.getValueAt(i,1).toString());
  278. Score.setText(model.getValueAt(i,2).toString());
  279. }
  280.  
  281. private void jButton_InsertActionPerformed(java.awt.event.ActionEvent evt) {
  282. String query = "INSERT INTO `quintengip`(`Naam`,`Score`) VALUES ('"+voornaam.getText()+"',"+score.getText()+")";
  283.  
  284. executeSQlQuery(query, "Inserted");//query alles uitvoeren
  285. }
  286.  
  287. public static void main(String args[]) {
  288. java.awt.EventQueue.invokeLater(new Runnable() {
  289. public void run() {
  290. new Score().setVisible(true);
  291. }
  292. });
  293. }
  294.  
  295. private javax.swing.JButton jButton_Insert;
  296. private javax.swing.JLabel ID;
  297. private javax.swing.JLabel Naam;
  298. private javax.swing.JLabel Score;
  299. private javax.swing.JPanel jPanel1;
  300. private javax.swing.JScrollPane jScrollPane1;
  301. private javax.swing.JTable jTable_Display_Users;
  302. public javax.swing.JTextField score;
  303. public javax.swing.JTextField voornaam;
  304. private javax.swing.JTextField id;
  305.  
  306.  
  307. }
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!