API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 17th, 2018
159
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.79 KB | None | 0 0
raw download clone embed print report
  1. /**
  2. * Creates new form TelaPrincipal
  3. */
  4. public TelaPrincipal() {
  5. initComponents();
  6. Show_Users_In_JTable();
  7. }
  8.  
  9. public Connection getConnection(){
  10.  
  11. Connection con;
  12. try{
  13. Class.forName("com.mysql.jdbc.Driver");
  14. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sistema_clientes","danilo","2701232");
  15. return con;
  16. } catch (ClassNotFoundException | SQLException e){
  17. return null;
  18. }
  19.  
  20. }
  21.  
  22. public ArrayList<User> getUserList(){
  23.  
  24. ArrayList<User> usersList = new ArrayList<>();
  25. Connection connection = getConnection();
  26. String query = "SELECT * FROM `users`";
  27. Statement st;
  28. ResultSet rs;
  29.  
  30. try{
  31. st = connection.createStatement();
  32. rs = st.executeQuery(query);
  33. User user;
  34. while(rs.next()){
  35. user = new User(rs.getInt("id"),rs.getString("first_name"),rs.getString("last_name"),rs.getInt("age"));
  36. usersList.add(user);
  37. }
  38. } catch(SQLException e){
  39. }
  40. return usersList;
  41. }
  42.  
  43. // Display Data in JTable
  44.  
  45. public void Show_Users_In_JTable(){
  46.  
  47. ArrayList<User> list = getUserList();
  48. DefaultTableModel model = (DefaultTableModel)jTable_Display_Users.getModel();
  49. Object[] row = new Object[4];
  50.  
  51. for(int i = 0; i < list.size();i++){
  52. row[0] = list.get(i).getId();
  53. row[1] = list.get(i).getFirstName();
  54. row[2] = list.get(i).getLastName();
  55. row[3] = list.get(i).getAge();
  56.  
  57. model.addRow(row);
  58. }
  59.  
  60. }
  61.  
  62. /**
  63. * This method is called from within the constructor to initialize the form.
  64. * WARNING: Do NOT modify this code. The content of this method is always
  65. * regenerated by the Form Editor.
  66. */
  67. @SuppressWarnings("unchecked")
  68. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  69. private void initComponents() {
  70.  
  71. jPanel1 = new javax.swing.JPanel();
  72. jScrollPane1 = new javax.swing.JScrollPane();
  73. jTable_Display_Users = new javax.swing.JTable();
  74. jLabel1 = new javax.swing.JLabel();
  75. jTextField_Id = new javax.swing.JTextField();
  76. jLabel2 = new javax.swing.JLabel();
  77. jTextField_FirstName = new javax.swing.JTextField();
  78. jLabel3 = new javax.swing.JLabel();
  79. jTextField_LastName = new javax.swing.JTextField();
  80. jLabel4 = new javax.swing.JLabel();
  81. jTextField_Age = new javax.swing.JTextField();
  82. jButton_Insert = new javax.swing.JButton();
  83. jButton_Update = new javax.swing.JButton();
  84. jButton_Delete = new javax.swing.JButton();
  85.  
  86. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  87.  
  88. jTable_Display_Users.setModel(new javax.swing.table.DefaultTableModel(
  89. new Object [][] {
  90.  
  91. },
  92. new String [] {
  93. "Id", "First Name", "Last Name", "Age"
  94. }
  95. ));
  96. jScrollPane1.setViewportView(jTable_Display_Users);
  97.  
  98. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  99. jPanel1.setLayout(jPanel1Layout);
  100. jPanel1Layout.setHorizontalGroup(
  101. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  102. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  103. .addContainerGap(153, Short.MAX_VALUE)
  104. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  105. .addGap(35, 35, 35))
  106. );
  107. jPanel1Layout.setVerticalGroup(
  108. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  109. .addGroup(jPanel1Layout.createSequentialGroup()
  110. .addContainerGap()
  111. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  112. .addContainerGap(52, Short.MAX_VALUE))
  113. );
  114.  
  115. jLabel1.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  116. jLabel1.setText("Id:");
  117.  
  118. jTextField_Id.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  119.  
  120. jLabel2.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  121. jLabel2.setText("First Name:");
  122.  
  123. jTextField_FirstName.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  124.  
  125. jLabel3.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  126. jLabel3.setText("Last Name:");
  127.  
  128. jTextField_LastName.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  129.  
  130. jLabel4.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  131. jLabel4.setText("Age:");
  132.  
  133. jTextField_Age.setFont(new java.awt.Font("Dialog", 0, 18)); // NOI18N
  134.  
  135. jButton_Insert.setText("Insert");
  136.  
  137. jButton_Update.setText("Update");
  138.  
  139. jButton_Delete.setText("Delete");
  140.  
  141. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  142. getContentPane().setLayout(layout);
  143. layout.setHorizontalGroup(
  144. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  145. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  146. .addContainerGap()
  147. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  148. .addGroup(layout.createSequentialGroup()
  149. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  150. .addComponent(jLabel1)
  151. .addComponent(jLabel4)
  152. .addComponent(jLabel3)
  153. .addComponent(jLabel2))
  154. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  155. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  156. .addComponent(jTextField_Id, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE)
  157. .addComponent(jTextField_FirstName, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE)
  158. .addComponent(jTextField_LastName, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE)
  159. .addComponent(jTextField_Age, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE))
  160. .addGap(0, 1, Short.MAX_VALUE))
  161. .addGroup(layout.createSequentialGroup()
  162. .addGap(0, 0, Short.MAX_VALUE)
  163. .addComponent(jButton_Insert)
  164. .addGap(18, 18, 18)
  165. .addComponent(jButton_Update)
  166. .addGap(18, 18, 18)
  167. .addComponent(jButton_Delete)))
  168. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  169. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  170. .addContainerGap())
  171. );
  172. layout.setVerticalGroup(
  173. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  174. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  175. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  176. .addGap(0, 0, Short.MAX_VALUE))
  177. .addGroup(layout.createSequentialGroup()
  178. .addContainerGap()
  179. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  180. .addComponent(jLabel1)
  181. .addComponent(jTextField_Id, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
  182. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  183. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  184. .addComponent(jLabel2)
  185. .addComponent(jTextField_FirstName, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
  186. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  187. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  188. .addComponent(jLabel3)
  189. .addComponent(jTextField_LastName, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
  190. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  191. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  192. .addComponent(jLabel4)
  193. .addComponent(jTextField_Age, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE))
  194. .addGap(102, 102, 102)
  195. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  196. .addComponent(jButton_Insert)
  197. .addComponent(jButton_Update)
  198. .addComponent(jButton_Delete))
  199. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  200. );
  201.  
  202. pack();
  203. }// </editor-fold>
  204.  
  205. /**
  206. * @param args the command line arguments
  207. */
  208. public static void main(String args[]) {
  209. /* Set the Nimbus look and feel */
  210. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  211. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  212. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  213. */
  214. try {
  215. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  216. if ("Nimbus".equals(info.getName())) {
  217. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  218. break;
  219. }
  220. }
  221. } catch (ClassNotFoundException ex) {
  222. java.util.logging.Logger.getLogger(TelaPrincipal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  223. } catch (InstantiationException ex) {
  224. java.util.logging.Logger.getLogger(TelaPrincipal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  225. } catch (IllegalAccessException ex) {
  226. java.util.logging.Logger.getLogger(TelaPrincipal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  227. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  228. java.util.logging.Logger.getLogger(TelaPrincipal.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  229. }
  230. //</editor-fold>
  231.  
  232. /* Create and display the form */
  233. java.awt.EventQueue.invokeLater(() -> {
  234. new TelaPrincipal().setVisible(true);
  235. });
  236. }
  237.  
  238. // Variables declaration - do not modify
  239. private javax.swing.JButton jButton_Delete;
  240. private javax.swing.JButton jButton_Insert;
  241. private javax.swing.JButton jButton_Update;
  242. private javax.swing.JLabel jLabel1;
  243. private javax.swing.JLabel jLabel2;
  244. private javax.swing.JLabel jLabel3;
  245. private javax.swing.JLabel jLabel4;
  246. private javax.swing.JPanel jPanel1;
  247. private javax.swing.JScrollPane jScrollPane1;
  248. private javax.swing.JTable jTable_Display_Users;
  249. private javax.swing.JTextField jTextField_Age;
  250. private javax.swing.JTextField jTextField_FirstName;
  251. private javax.swing.JTextField jTextField_Id;
  252. private javax.swing.JTextField jTextField_LastName;
  253. // End of variables declaration
  254.  
  255. //Atributos
  256.  
  257. private int id,age;
  258. private String firstName, lastName;
  259.  
  260. //Métodos Especiais
  261.  
  262. public User(int id,String firstName, String lastName, int age) {
  263. this.id = id;
  264. this.age = age;
  265. this.firstName = firstName;
  266. this.lastName = lastName;
  267. }
  268.  
  269. public int getId() {
  270. return id;
  271. }
  272.  
  273. public void setId(int id) {
  274. this.id = id;
  275. }
  276.  
  277. public int getAge() {
  278. return age;
  279. }
  280.  
  281. public void setAge(int age) {
  282. this.age = age;
  283. }
  284.  
  285. public String getFirstName() {
  286. return firstName;
  287. }
  288.  
  289. public void setFirstName(String firstName) {
  290. this.firstName = firstName;
  291. }
  292.  
  293. public String getLastName() {
  294. return lastName;
  295. }
  296.  
  297. public void setLastName(String lastName) {
  298. this.lastName = lastName;
  299. }
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!