API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 6th, 2018
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.08 KB | None | 0 0
raw download clone embed print report
  1. /**
  2. * Creates new form New1
  3. */
  4. public New1() {
  5. initComponents();
  6. show_provedores_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/sepan","root","");
  15. return con;
  16. } catch (Exception e) {
  17. e.printStackTrace();
  18. return null;
  19. }
  20. }
  21.  
  22. public ArrayList<JavaApp> getusersList()
  23. {
  24. ArrayList<JavaApp> usersList = new ArrayList<JavaApp>();
  25. Connection connection = getConnection();
  26. String query = "SELECT * FROM `provedores`";
  27. Statement st;
  28. ResultSet rs;
  29.  
  30. try {
  31. st = connection.createStatement();
  32. rs = st.executeQuery(query);
  33. JavaApp javaApp;
  34. while(rs.next())
  35. {
  36. javaApp = new JavaApp(rs.getInt("id"),rs.getString("no"),rs.getString("nombre"),rs.getString("rfc"),rs.getString("banco"),rs.getString("numero"),rs.getString("direccion"));
  37. usersList.add(javaApp);
  38. }
  39. } catch (Exception e) {
  40. e.printStackTrace();
  41. }
  42. return usersList;
  43. }
  44.  
  45. public void show_provedores_in_jtable()
  46. {
  47. ArrayList<JavaApp> list = getusersList();
  48. DefaultTableModel model = (DefaultTableModel)jTable.getModel();
  49. Object[] row = new Object[7];
  50. for (int i = 0; i < list.size(); i++)
  51. {
  52. row[0] = list.get(i).getId();
  53. row[1] = list.get(i).getNo();
  54. row[2] = list.get(i).getNombre();
  55. row[3] = list.get(i).getRfc();
  56. row[4] = list.get(i).getCuenta();
  57. row[5] = list.get(i).getNumerodecuenta();
  58. row[6] = list.get(i).getDireccion();
  59.  
  60. model.addRow(row);
  61. }
  62. }
  63.  
  64. // Excute The Sql Query
  65. public void executeSQlQuery(String query, String message)
  66. {
  67. Connection con = getConnection();
  68. Statement st;
  69. try{
  70. st = con.createStatement();
  71. if((st.executeUpdate(query)) == 1)
  72. {
  73.  
  74. // Refrescar Jtablae data
  75. DefaultTableModel model = (DefaultTableModel) jTable.getModel();
  76. model.setRowCount(0);
  77. show_provedores_in_jtable();
  78. JOptionPane.showMessageDialog(null, "Data "+message+"Succefully");
  79.  
  80. }else{
  81. JOptionPane.showMessageDialog(null, "Data Not "+message);
  82. }
  83. }catch(Exception ex){
  84. ex.printStackTrace();
  85. }
  86. }
  87.  
  88.  
  89. /**
  90. * This method is called from within the constructor to initialize the form.
  91. * WARNING: Do NOT modify this code. The content of this method is always
  92. * regenerated by the Form Editor.
  93. */
  94. @SuppressWarnings("unchecked")
  95. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  96. private void initComponents() {
  97.  
  98. jLabel1 = new javax.swing.JLabel();
  99. jLabel2 = new javax.swing.JLabel();
  100. jLabel3 = new javax.swing.JLabel();
  101. jLabel4 = new javax.swing.JLabel();
  102. jLabel5 = new javax.swing.JLabel();
  103. txtno = new javax.swing.JTextField();
  104. txtnombre = new javax.swing.JTextField();
  105. jLabel6 = new javax.swing.JLabel();
  106. txtdire = new javax.swing.JTextField();
  107. txtnumero = new javax.swing.JTextField();
  108. txtbanco = new javax.swing.JTextField();
  109. txtrfc = new javax.swing.JTextField();
  110. btagregar = new javax.swing.JButton();
  111. bteliminar = new javax.swing.JButton();
  112. btactualizar = new javax.swing.JButton();
  113. jScrollPane1 = new javax.swing.JScrollPane();
  114. jTable = new javax.swing.JTable();
  115. btmenu = new javax.swing.JButton();
  116. txtid = new javax.swing.JTextField();
  117.  
  118. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  119.  
  120. jLabel1.setText("No:");
  121.  
  122. jLabel2.setText("Nombre:");
  123.  
  124. jLabel3.setText("RFC:");
  125.  
  126. jLabel4.setText("Cuenta:");
  127.  
  128. jLabel5.setText("Numero de Cuenta:");
  129.  
  130. jLabel6.setText("Direccion:");
  131.  
  132. txtrfc.addActionListener(new java.awt.event.ActionListener() {
  133. public void actionPerformed(java.awt.event.ActionEvent evt) {
  134. txtrfcActionPerformed(evt);
  135. }
  136. });
  137.  
  138. btagregar.setText("Agregar");
  139. btagregar.addActionListener(new java.awt.event.ActionListener() {
  140. public void actionPerformed(java.awt.event.ActionEvent evt) {
  141. btagregarActionPerformed(evt);
  142. }
  143. });
  144.  
  145. bteliminar.setText("Eliminar");
  146. bteliminar.addActionListener(new java.awt.event.ActionListener() {
  147. public void actionPerformed(java.awt.event.ActionEvent evt) {
  148. bteliminarActionPerformed(evt);
  149. }
  150. });
  151.  
  152. btactualizar.setText("Actualizar");
  153. btactualizar.addActionListener(new java.awt.event.ActionListener() {
  154. public void actionPerformed(java.awt.event.ActionEvent evt) {
  155. btactualizarActionPerformed(evt);
  156. }
  157. });
  158.  
  159. jTable.setModel(new javax.swing.table.DefaultTableModel(
  160. new Object [][] {
  161. {null, null, null, null, null, null, null},
  162. {null, null, null, null, null, null, null},
  163. {null, null, null, null, null, null, null},
  164. {null, null, null, null, null, null, null}
  165. },
  166. new String [] {
  167. "Id", "Numero", "Nombre", "Rfc", "Cuenta", "Numero de Cuental", "Direccion"
  168. }
  169. ));
  170. jTable.addMouseListener(new java.awt.event.MouseAdapter() {
  171. public void mouseClicked(java.awt.event.MouseEvent evt) {
  172. jTableMouseClicked(evt);
  173. }
  174. });
  175. jScrollPane1.setViewportView(jTable);
  176.  
  177. btmenu.setText("Menu");
  178.  
  179. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  180. getContentPane().setLayout(layout);
  181. layout.setHorizontalGroup(
  182. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  183. .addGroup(layout.createSequentialGroup()
  184. .addContainerGap()
  185. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  186. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  187. .addGroup(layout.createSequentialGroup()
  188. .addComponent(jLabel2)
  189. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  190. .addComponent(txtnombre))
  191. .addGroup(layout.createSequentialGroup()
  192. .addComponent(jLabel3)
  193. .addGap(18, 18, 18)
  194. .addComponent(txtrfc))
  195. .addGroup(layout.createSequentialGroup()
  196. .addComponent(jLabel4)
  197. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  198. .addComponent(txtbanco))
  199. .addGroup(layout.createSequentialGroup()
  200. .addComponent(jLabel5)
  201. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  202. .addComponent(txtnumero, javax.swing.GroupLayout.PREFERRED_SIZE, 116, javax.swing.GroupLayout.PREFERRED_SIZE))
  203. .addGroup(layout.createSequentialGroup()
  204. .addComponent(jLabel6)
  205. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  206. .addComponent(txtdire, javax.swing.GroupLayout.PREFERRED_SIZE, 122, javax.swing.GroupLayout.PREFERRED_SIZE)))
  207. .addGroup(layout.createSequentialGroup()
  208. .addComponent(btagregar)
  209. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  210. .addComponent(btactualizar)
  211. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  212. .addComponent(bteliminar))
  213. .addComponent(btmenu, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
  214. .addGroup(layout.createSequentialGroup()
  215. .addComponent(jLabel1)
  216. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  217. .addComponent(txtno, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE)
  218. .addGap(18, 18, 18)
  219. .addComponent(txtid, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)))
  220. .addGap(18, 18, 18)
  221. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 452, javax.swing.GroupLayout.PREFERRED_SIZE)
  222. .addContainerGap(50, Short.MAX_VALUE))
  223. );
  224. layout.setVerticalGroup(
  225. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  226. .addGroup(layout.createSequentialGroup()
  227. .addGap(20, 20, 20)
  228. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  229. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 273, javax.swing.GroupLayout.PREFERRED_SIZE)
  230. .addGroup(layout.createSequentialGroup()
  231. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  232. .addComponent(jLabel1)
  233. .addComponent(txtno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  234. .addComponent(txtid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  235. .addGap(18, 18, 18)
  236. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  237. .addComponent(jLabel2)
  238. .addComponent(txtnombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  239. .addGap(18, 18, 18)
  240. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  241. .addComponent(jLabel3)
  242. .addComponent(txtrfc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  243. .addGap(18, 18, 18)
  244. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  245. .addComponent(jLabel4)
  246. .addComponent(txtbanco, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  247. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  248. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  249. .addComponent(jLabel5)
  250. .addComponent(txtnumero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  251. .addGap(18, 18, 18)
  252. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  253. .addComponent(jLabel6)
  254. .addComponent(txtdire, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  255. .addGap(18, 18, 18)
  256. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  257. .addComponent(btagregar)
  258. .addComponent(btactualizar)
  259. .addComponent(bteliminar))
  260. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  261. .addComponent(btmenu)))
  262. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  263. );
  264.  
  265. pack();
  266. }// </editor-fold>
  267.  
  268. private void txtrfcActionPerformed(java.awt.event.ActionEvent evt) {
  269. // TODO add your handling code here:
  270. }
  271.  
  272. private void jTableMouseClicked(java.awt.event.MouseEvent evt) {
  273. //Display Select row in JTextefields
  274. int i = jTable.getSelectedRow();
  275. TableModel model = jTable.getModel();
  276. txtno.setText(model.getValueAt(i,0).toString());
  277. txtnombre.setText(model.getValueAt(i,1).toString());
  278. txtrfc.setText(model.getValueAt(i,2).toString());
  279. txtbanco.setText(model.getValueAt(i,3).toString());
  280. txtnumero.setText(model.getValueAt(i,4).toString());
  281. txtdire.setText(model.getValueAt(i,5).toString());
  282. }
  283.  
  284. private void btagregarActionPerformed(java.awt.event.ActionEvent evt) {
  285. String query = "INSERT INTO `provedores`(`no`, `nombre`, `rfc`, `banco`, `numero`, `direccion`) VALUES ('"+txtid.getText()+"','"+txtno.getText()+"','"+txtrfc.getText()+"','"+txtbanco.getText()+"','"+txtnumero.getText()+"','"+txtdire.getText()+")";
  286. executeSQlQuery(query,"Inserted");
  287. }
  288.  
  289. private void btactualizarActionPerformed(java.awt.event.ActionEvent evt) {
  290. // TODO add your handling code here:
  291. String query = "UPDATE `provedores` SET `no`='"+txtno.getText()+"',`nombre`='"+txtnombre.getText()+"',`rfc`='"+txtrfc.getText()+"',`banco`='"+txtbanco.getText()+"',`numero`='"+txtnumero.getText()+"',`direccion`='"+txtdire.getText()+" WHERE `id` = "+txtid.getText();
  292. executeSQlQuery(query,"Updated");
  293.  
  294.  
  295. }
  296.  
  297. private void bteliminarActionPerformed(java.awt.event.ActionEvent evt) {
  298. // TODO add your handling code here:
  299. String query = "DELETE FROM `provedores` WHERE id = "+txtid.getText();
  300. executeSQlQuery(query, "Deleted");
  301. }
  302.  
  303. /**
  304. * @param args the command line arguments
  305. */
  306. public static void main(String args[]) {
  307. /* Set the Nimbus look and feel */
  308. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  309. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  310. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  311. */
  312. try {
  313. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  314. if ("Nimbus".equals(info.getName())) {
  315. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  316. break;
  317. }
  318. }
  319. } catch (ClassNotFoundException ex) {
  320. java.util.logging.Logger.getLogger(New1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  321. } catch (InstantiationException ex) {
  322. java.util.logging.Logger.getLogger(New1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  323. } catch (IllegalAccessException ex) {
  324. java.util.logging.Logger.getLogger(New1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  325. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  326. java.util.logging.Logger.getLogger(New1.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  327. }
  328. //</editor-fold>
  329.  
  330. /* Create and display the form */
  331. java.awt.EventQueue.invokeLater(new Runnable() {
  332. public void run() {
  333. new New1().setVisible(true);
  334. }
  335. });
  336. }
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!