Código
import java.util.List; import java.util.logging.Level; import java.util.logging.Logger; /** * * @author */ public class maindb { /** * @param args the command line arguments */ Pelicula item = new Pelicula(15,"Pantalon azul",700); Peliculas bd = new Peliculas(); try { //bd.guardarProducto(BaseDatos.obtener(), item); //item = bd.recuperarPorId(BaseDatos.obtener(), 100); //System.out.println("Descripcion: " + item.getDescripcion()); //System.out.println("Precio: " + item.getPrecio()); //bd.eliminarPorId(BaseDatos.obtener(), 500); List<Pelicula> lista = bd.recuperarTodas(Pelicula.obtener()); for(int i=0; i<lista.size(); i++){ } Peliculas.cerrar(); Logger.getLogger(maindb.class.getName()).log(Level.SEVERE, null, ex); } } }
Código
import java.sql.SQLException; import java.util.ArrayList; import java.util.List; /** * * @author */ public class bd { /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ /** * * @author */ if (cnx == null) { try { Class.forName("com.mysql.jdbc.Driver"); } } return cnx; } if (cnx != null) { cnx.close(); } } try{ if(item.getId() > 0){ consulta = conexion.prepareStatement("INSERT INTO " + this.tabla + "(id, descripcion, precio) VALUES(?, ?, ?)"); consulta.setInt(1, item.getId()); consulta.setString(2, item.getnombre()); consulta.setFloat(3, item.getPrecio()); } /* else{ consulta = conexion.prepareStatement("UPDATE " + this.tabla + " SET titulo = ?, descripcion = ?, nivel_de_prioridad = ? WHERE id_tarea = ?"); consulta.setString(1, tarea.getTitulo()); consulta.setString(2, tarea.getDescripcion()); consulta.setInt(3, tarea.getNivel_de_prioridad()); consulta.setInt(4, tarea.getId_tarea()); } */ consulta.executeUpdate(); } } Pelicula p = null; try{ PreparedStatement consulta = conexion.prepareStatement("SELECT descripcion, precio FROM " + this.tabla + " WHERE id = ?" ); consulta.setInt(1, id); while(resultado.next()){ p = new Pelicula(id, resultado.getString("nombre"), resultado.getFloat("precio")); } } return p; } try{ PreparedStatement consulta = conexion.prepareStatement("DELETE FROM " + this.tabla + " WHERE id = ?"); consulta.setInt(1, id); consulta.executeUpdate(); } } List<Pelicula> lista = new ArrayList<>(); try{ PreparedStatement consulta = conexion.prepareStatement("SELECT id, descripcion, precio FROM " + this.tabla + " ORDER BY id"); while(resultado.next()){ lista.add(new Pelicula(resultado.getInt("id"), resultado.getString("nombre"), resultado.getFloat("precio"))); } } return lista; } }
Código
Saludos
import java.util.Calendar; import java.util.Scanner; import javax.swing.JOptionPane; /** * * @author */ return obtener; } this.obtener = obtener; } String obtener; static void cerrar() { throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates. } /** * Creates new form Peliculas */ public Peliculas() { initComponents(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { Categorias.setToolTipText(""); Categorias.setAutoscrolls(true); Categorias.setName("Categorias"); // NOI18N jTextField1.setText("BUSCAR PELICULAS"); jTextField1ActionPerformed(evt); } }); jButton2.setText("SELECCIONAR"); jButton2ActionPerformed(evt); } }); jLabel1.setText("GENEROS"); jLabel2.setText("PELICULA"); jButton3.setText("ACCION"); jButton3ActionPerformed(evt); } }); jButton4.setText("Ciencia Ficcion"); jButton4ActionPerformed(evt); } }); jButton5.setText("Aventuras"); jButton5ActionPerformed(evt); } }); jButton6.setText("Animacion"); jButton6ActionPerformed(evt); } }); jButton7.setText("Comedias"); jButton7ActionPerformed(evt); } }); jButton8.setText("Drama"); jButton8ActionPerformed(evt); } }); jButton9.setText("Terror"); jButton9ActionPerformed(evt); } }); jButton10.setText("Suspenso"); jButton10ActionPerformed(evt); } }); Buscar.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" })); Buscar.setSelectedItem(Buscar); BuscarActionPerformed(evt); } }); javax.swing.GroupLayout CategoriasLayout = new javax.swing.GroupLayout(Categorias); Categorias.setLayout(CategoriasLayout); CategoriasLayout.setHorizontalGroup( CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(CategoriasLayout.createSequentialGroup() .addContainerGap() .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(CategoriasLayout.createSequentialGroup() .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, CategoriasLayout.createSequentialGroup() .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(24, 24, 24))) .addGap(41, 41, 41)) .addGroup(CategoriasLayout.createSequentialGroup() .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 231, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(CategoriasLayout.createSequentialGroup() .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton6, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGap(86, 86, 86) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jButton9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton7, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) ); CategoriasLayout.setVerticalGroup( CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(CategoriasLayout.createSequentialGroup() .addGap(28, 28, 28) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel1)) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(CategoriasLayout.createSequentialGroup() .addGap(18, 18, 18) .addComponent(jButton2)) .addGroup(CategoriasLayout.createSequentialGroup() .addGap(10, 10, 10) .addComponent(Buscar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(13, 13, 13) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jButton3) .addGroup(CategoriasLayout.createSequentialGroup() .addGap(9, 9, 9) .addComponent(jButton7))) .addGap(18, 18, 18) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(CategoriasLayout.createSequentialGroup() .addComponent(jButton8, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(32, 32, 32) .addComponent(jButton9)) .addGroup(CategoriasLayout.createSequentialGroup() .addComponent(jButton4) .addGap(40, 40, 40) .addComponent(jButton5))) .addGap(30, 30, 30) .addGroup(CategoriasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton10) .addComponent(jButton6)) ); jTextField2.setText("RENTAS"); jTextField2ActionPerformed(evt); } }); jTextField5.setText("Total a pagar"); jTextField6.setText("15"); jButton1.setText("VER FECHA DE RENTAS ABRIL"); jButton1ActionPerformed(evt); } }); jButton11.setText("VER FECHA DE ENTREGAS ABRIL"); jButton11ActionPerformed(evt); } }); jButton12.setText("VER FECHA DE RENTAS MAYO"); jButton12ActionPerformed(evt); } }); jToggleButton1.setText("VER FECHAS DE ENTREGA MAYO"); jToggleButton1ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(Categorias, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createSequentialGroup() .addGap(22, 22, 22) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(85, 85, 85)) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false) .addComponent(jToggleButton1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 210, Short.MAX_VALUE) .addComponent(jButton1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton11, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jButton12, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(97, 97, 97)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(Categorias, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(135, 135, 135) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton11)) .addGroup(layout.createSequentialGroup() .addGap(142, 142, 142) .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(18, 18, 18) .addComponent(jButton12) .addGap(18, 18, 18) .addComponent(jToggleButton1) ); pack(); }// </editor-fold> // TODO add your handling code here: } // TODO add your handling code here: } // TODO add your handling code here: "Rapido y Furioso 5","Terremoto en los angeles","Termintaor Genesis","Star wars 2015", "Los vengadores la era de ultron","Mision Imposible 2015","Hombre Hormiga","Black hat" }; for(int x = 0;x<peliculasdeaccion.length; x++){ } } // TODO add your handling code here: String peliculascf[]={"Los juegos del hambre sinsajo","The Martian","Insurgente","Chapie","Mad Max", "\n" +"El destino de Jupiter", "Area 51" ,"La rebeleion de Atlas" ,"Halo" ,"Turbo kid" ,"Los pro"}; for(int x = 0;x<peliculascf.length; x++){ } } // TODO add your handling code here: } // TODO add your handling code here: + "Jurasic world", "\n" + "Vacaciones","Start trek","Xmen Apocalipsis","Dragon ball z resurrecion de frezer","\n" + "Warcraft el origen" ,"Un espia y medio"}; for(int x = 0; x<peliculasaventuras.length; x++){ } } // TODO add your handling code here: + "La oveja shaun","Alvin y las ardillas","Pixeles","Strange Magic"}; for(int x =0; x<peliculasdeanimacion.length; x++){ } } // TODO add your handling code here: + "Superpoli en las Vegas","Hipocrates","Negocios con resaca","Los insolitos peces gato" + "Espias","Rey gitano","Ted 2" }; for(int x =0; x<comedias.length; x++){ } } // TODO add your handling code here: + "Bosque de karadima","Enemigo invisible","Remeber","La ultima ola","Trumbo","La gran apuesta"}; for(int x =0; x<drama.length; x++){ } } // TODO add your handling code here: + "La bruja","Los hijos del diablo","La visita","Demoniaco","Cuentos de halloween"}; for(int x =0; x<terror.length; x++){ } } // TODO add your handling code here: String suspensos[]={"El regalo","Obsesion","El clan","El puente de los espias" ,"Mision imposible","\n" +"La maldicion de charlie","Bus 657","Los jefes","Los intrusos","Caza el asesino"}; for(int x = 0; x<suspensos.length; x++){ } } // TODO add your handling code here: } // TODO add your handling code here: +"11 a las 5:30" ,"13 a las 20:00" ,"13 a las 21:45" ,"14 a las 20:00","\n" +"14 a las 9:15","15 a las 20:20","20 a las 18:20" ,"25 a las 22:00" ,"30 a las 20:00"}; for(int x = 0; x<rentasabril.length; x++){ } } // TODO add your handling code here: +"12 a las 21:45" ,"13 a las 18:45" ,"14 a las 22:00", "14 a las 23:15", "\n" +"15 a las 20:00" ,"18 a las 19:00" ,"18 a las 20:00" ,"21 a las 17:00" ,"24 alas 20:15","\n" +"28 a las 22:08","30 a las 23:45"}; for(int x=0; x<rentasmayo.length; x++){ } } // TODO add your handling code here: + "13 a las 5:45" ,"15 a las 20:08" ,"15 a las 23:05" ,"15 a las 23:45" , "\n" + "15 a las 9:45" , "16 a las 22:05" ,"21 a las 18:45" , "26 a las 22:05","\n" +"31 a las 23:50" }; for(int x = 0; x<entregasabril.length; x++){ } } // TODO add your handling code here: +"13 a las 20:00" ,"15 a las 21:15" ,"15 a las 22:00" ,"17 a las 18:25", "\n" +"19 a las 22:20" ,"22 a las 18:05" ,"25 a las 20:00" , "29 a las 20:05", "\n" +"01 a las 17:15"}; for(int x=0; x<entregasmayo.length; x++){ } } /** * @param args the command line arguments */ /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { break; } } java.util.logging.Logger.getLogger(Peliculas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); java.util.logging.Logger.getLogger(Peliculas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); java.util.logging.Logger.getLogger(Peliculas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); java.util.logging.Logger.getLogger(Peliculas.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ public void run() { new Peliculas().setVisible(true); } }); } // Variables declaration - do not modify // End of variables declaration throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates. } throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates. } throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates. } }