Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void cargarlistaproductos(String dato){
- String [] Titulo = {"Codigo","Descripcion","Heroe","Rareza","Precio","Stock"};
- tabla=new DefaultTableModel(null,Titulo);
- String []Registro= new String[6];
- String mostrar="SELECT * FROM articulo WHERE CONCAT (cod_art,nom_art,hero_art,nom_art) LIKE '%"+dato+"%'";
- Conexion db = new Conexion();
- try {
- ResultSet rs = db.Consulta(mostrar);
- while(rs.next())
- {
- Registro[0]=rs.getString("cod_art");
- Registro[1]=rs.getString("nom_art");
- Registro[2]=rs.getString("hero_art");
- Registro[3]=rs.getString("rare_art");
- Registro[4]=rs.getString("precio_art");
- Registro[5]=rs.getString("stock_art");
- tabla.addRow(Registro);
- }
- tableArticulos.setModel(tabla);
- } catch (SQLException ex) {
- System.out.println(ex);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement