API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 27th, 2015
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.59 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 banco;
  7.  
  8. import java.sql.*;
  9. import java.util.ArrayList;
  10. import java.util.List;
  11. import java.util.logging.Level;
  12. import java.util.logging.Logger;
  13.  
  14. /**
  15. *
  16. * @author omarcarreon
  17. */
  18. public class Grupo_Alimenticio extends javax.swing.JFrame {
  19.  
  20. /**
  21. * Creates new form Grupo_Alimenticio
  22. */
  23. int numcols;
  24. List <List <String> > res = new ArrayList<>();
  25. public Grupo_Alimenticio() {
  26. initComponents();
  27.  
  28. Database db = new Database();
  29. ResultSet resultset = null;
  30. Statement stmt = null;
  31. String idGrupoAlim = null;
  32.  
  33.  
  34.  
  35. if (db.connect()) {
  36. final Connection conn = db.getConnection();
  37. try {
  38. stmt = conn.createStatement();
  39. resultset = stmt.executeQuery("select * from GrupoAlim");
  40.  
  41. numcols = resultset.getMetaData().getColumnCount();
  42.  
  43.  
  44. while (resultset.next()) {
  45. List <String> row = new ArrayList<>(numcols);
  46.  
  47. for (int i=1; i<= numcols; i++) { // don't skip the last column, use <=
  48. row.add(resultset.getString(i));
  49. //System.out.print(resultset.getString(i) + "\t");
  50. }
  51. res.add(row); // add it to the result
  52. //System.out.print("\n");
  53. }
  54.  
  55.  
  56.  
  57. } catch (SQLException ex) {
  58. Logger.getLogger(Grupo_Alimenticio.class.getName()).log(Level.SEVERE, null, ex);
  59. } finally {
  60. if (resultset != null){
  61. try {
  62. resultset.close();
  63. } catch (SQLException ex) {
  64. Logger.getLogger(Grupo_Alimenticio.class.getName()).log(Level.SEVERE, null, ex);
  65. }
  66. }
  67. if (stmt != null){
  68. try {
  69. stmt.close();
  70. } catch (SQLException ex) {
  71. Logger.getLogger(Grupo_Alimenticio.class.getName()).log(Level.SEVERE, null, ex);
  72. }
  73. }
  74. }
  75.  
  76. }
  77. for (int i=0; i< res.size(); i++) {
  78. jComboBox1.addItem(res.get(i).get(1));
  79. }
  80. jComboBox1.setSelectedIndex(-1);
  81. }
  82.  
  83. /**
  84. * This method is called from within the constructor to initialize the form.
  85. * WARNING: Do NOT modify this code. The content of this method is always
  86. * regenerated by the Form Editor.
  87. */
  88. @SuppressWarnings("unchecked")
  89. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  90. private void initComponents() {
  91.  
  92. jButton7 = new javax.swing.JButton();
  93. jButton8 = new javax.swing.JButton();
  94. jButton9 = new javax.swing.JButton();
  95. jButton10 = new javax.swing.JButton();
  96. jButton11 = new javax.swing.JButton();
  97. jButton12 = new javax.swing.JButton();
  98. jPanel4 = new javax.swing.JPanel();
  99. jLabel1 = new javax.swing.JLabel();
  100. jComboBox1 = new javax.swing.JComboBox();
  101. jPanel1 = new javax.swing.JPanel();
  102. jLabel2 = new javax.swing.JLabel();
  103. jLabel3 = new javax.swing.JLabel();
  104. jTextField1 = new javax.swing.JTextField();
  105. jTextField2 = new javax.swing.JTextField();
  106. jButton1 = new javax.swing.JButton();
  107. jButton2 = new javax.swing.JButton();
  108. jButton3 = new javax.swing.JButton();
  109. jButton4 = new javax.swing.JButton();
  110. jButton5 = new javax.swing.JButton();
  111. jButton6 = new javax.swing.JButton();
  112.  
  113. jButton7.setText("Borrar");
  114.  
  115. jButton8.setText("Editar");
  116.  
  117. jButton9.setText("Nuevo");
  118.  
  119. jButton10.setText("Grabar");
  120.  
  121. jButton11.setText("Cancelar");
  122.  
  123. jButton12.setText("Salir");
  124.  
  125. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  126.  
  127. jPanel4.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  128.  
  129. jLabel1.setText("Descripción");
  130.  
  131. jComboBox1.addPopupMenuListener(new javax.swing.event.PopupMenuListener() {
  132. public void popupMenuWillBecomeVisible(javax.swing.event.PopupMenuEvent evt) {
  133. jComboBox1PopupMenuWillBecomeVisible(evt);
  134. }
  135. public void popupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {
  136. jComboBox1PopupMenuWillBecomeInvisible(evt);
  137. }
  138. public void popupMenuCanceled(javax.swing.event.PopupMenuEvent evt) {
  139. }
  140. });
  141. jComboBox1.addActionListener(new java.awt.event.ActionListener() {
  142. public void actionPerformed(java.awt.event.ActionEvent evt) {
  143. jComboBox1ActionPerformed(evt);
  144. }
  145. });
  146.  
  147. javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
  148. jPanel4.setLayout(jPanel4Layout);
  149. jPanel4Layout.setHorizontalGroup(
  150. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  151. .addGroup(jPanel4Layout.createSequentialGroup()
  152. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  153. .addComponent(jLabel1)
  154. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  155. .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 402, javax.swing.GroupLayout.PREFERRED_SIZE)
  156. .addContainerGap())
  157. );
  158. jPanel4Layout.setVerticalGroup(
  159. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  160. .addGroup(jPanel4Layout.createSequentialGroup()
  161. .addGap(10, 10, 10)
  162. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  163. .addComponent(jLabel1)
  164. .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  165. .addContainerGap(16, Short.MAX_VALUE))
  166. );
  167.  
  168. jPanel1.setBorder(javax.swing.BorderFactory.createEtchedBorder());
  169.  
  170. jLabel2.setText("Grupo");
  171.  
  172. jLabel3.setText("Descripción");
  173.  
  174. jTextField1.addActionListener(new java.awt.event.ActionListener() {
  175. public void actionPerformed(java.awt.event.ActionEvent evt) {
  176. jTextField1ActionPerformed(evt);
  177. }
  178. });
  179.  
  180. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  181. jPanel1.setLayout(jPanel1Layout);
  182. jPanel1Layout.setHorizontalGroup(
  183. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  184. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
  185. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  186. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  187. .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING)
  188. .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.TRAILING))
  189. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  190. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  191. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
  192. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 408, javax.swing.GroupLayout.PREFERRED_SIZE))
  193. .addContainerGap())
  194. );
  195. jPanel1Layout.setVerticalGroup(
  196. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  197. .addGroup(jPanel1Layout.createSequentialGroup()
  198. .addContainerGap()
  199. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  200. .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
  201. .addComponent(jLabel2))
  202. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  203. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  204. .addComponent(jLabel3)
  205. .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  206. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  207. );
  208.  
  209. jPanel1Layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {jTextField1, jTextField2});
  210.  
  211. jButton1.setText("Nuevo");
  212. jButton1.addActionListener(new java.awt.event.ActionListener() {
  213. public void actionPerformed(java.awt.event.ActionEvent evt) {
  214. jButton1ActionPerformed(evt);
  215. }
  216. });
  217.  
  218. jButton2.setText("Editar");
  219.  
  220. jButton3.setText("Borrar");
  221.  
  222. jButton4.setText("Grabar");
  223.  
  224. jButton5.setText("Cancelar");
  225.  
  226. jButton6.setText("Salir");
  227.  
  228. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  229. getContentPane().setLayout(layout);
  230. layout.setHorizontalGroup(
  231. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  232. .addGroup(layout.createSequentialGroup()
  233. .addComponent(jButton1)
  234. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  235. .addComponent(jButton2)
  236. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  237. .addComponent(jButton3)
  238. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  239. .addComponent(jButton4)
  240. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  241. .addComponent(jButton5)
  242. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  243. .addComponent(jButton6, javax.swing.GroupLayout.PREFERRED_SIZE, 98, javax.swing.GroupLayout.PREFERRED_SIZE))
  244. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  245. .addContainerGap()
  246. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  247. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  248. .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  249. );
  250.  
  251. layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jButton1, jButton2, jButton3, jButton4, jButton5});
  252.  
  253. layout.setVerticalGroup(
  254. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  255. .addGroup(layout.createSequentialGroup()
  256. .addGap(36, 36, 36)
  257. .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  258. .addGap(18, 18, 18)
  259. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  260. .addGap(32, 32, 32)
  261. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  262. .addComponent(jButton1)
  263. .addComponent(jButton2)
  264. .addComponent(jButton3)
  265. .addComponent(jButton4)
  266. .addComponent(jButton5)
  267. .addComponent(jButton6))
  268. .addContainerGap(14, Short.MAX_VALUE))
  269. );
  270.  
  271. pack();
  272. }// </editor-fold>
  273.  
  274. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  275. // TODO add your handling code here:
  276. }
  277.  
  278. private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
  279. // TODO add your handling code here:
  280. }
  281.  
  282. private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {
  283.  
  284. }
  285.  
  286. private void jComboBox1PopupMenuWillBecomeInvisible(javax.swing.event.PopupMenuEvent evt) {
  287. // TODO add your handling code here:
  288. int selectedindex = jComboBox1.getSelectedIndex();
  289. jTextField1.setText(res.get(selectedindex).get(0));
  290. jTextField2.setText(jComboBox1.getSelectedItem().toString());
  291. }
  292.  
  293. private void jComboBox1PopupMenuWillBecomeVisible(javax.swing.event.PopupMenuEvent evt) {
  294. // TODO add your handling code here:
  295. /*
  296. String data[]={"Frutas", "Verduras"};
  297. DefaultComboBoxModel mod = new DefaultComboBoxModel(data);
  298. jComboBox1.setModel(mod);
  299. */
  300.  
  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(Grupo_Alimenticio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  321. } catch (InstantiationException ex) {
  322. java.util.logging.Logger.getLogger(Grupo_Alimenticio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  323. } catch (IllegalAccessException ex) {
  324. java.util.logging.Logger.getLogger(Grupo_Alimenticio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  325. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  326. java.util.logging.Logger.getLogger(Grupo_Alimenticio.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 Grupo_Alimenticio().setVisible(true);
  334. }
  335. });
  336.  
  337. }
  338.  
  339. // Variables declaration - do not modify
  340. private javax.swing.JButton jButton1;
  341. private javax.swing.JButton jButton10;
  342. private javax.swing.JButton jButton11;
  343. private javax.swing.JButton jButton12;
  344. private javax.swing.JButton jButton2;
  345. private javax.swing.JButton jButton3;
  346. private javax.swing.JButton jButton4;
  347. private javax.swing.JButton jButton5;
  348. private javax.swing.JButton jButton6;
  349. private javax.swing.JButton jButton7;
  350. private javax.swing.JButton jButton8;
  351. private javax.swing.JButton jButton9;
  352. private javax.swing.JComboBox jComboBox1;
  353. private javax.swing.JLabel jLabel1;
  354. private javax.swing.JLabel jLabel2;
  355. private javax.swing.JLabel jLabel3;
  356. private javax.swing.JPanel jPanel1;
  357. private javax.swing.JPanel jPanel4;
  358. private javax.swing.JTextField jTextField1;
  359. private javax.swing.JTextField jTextField2;
  360. // End of variables declaration
  361.  
  362. }
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!