Sentencia SQL
Publicado por Alejandro (21 intervenciones) el 28/10/2019 13:38:44
Cuando realizo la consulta sql me tendría que devolver todos los registros por debajo del stock mínimo (ya me asegure de que estén todos por debajo del stock mínimo), sin embargo solo le selecciona aquellos que en su cantidad tiene números con decimales.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
public void CargarArticulos(){
String proveedor = comboproveedor.getSelectedItem().toString();
if (proveedor == "TODOS"){
DefaultTableModel modelo = (DefaultTableModel) tablaarticulos.getModel();
modelo.setRowCount(0);
PreparedStatement pst = null; ResultSet rs = null; try { Statement st = null;String sql = "Select stockminimo from articulos";
st = connect().createStatement();
rs = st.executeQuery(sql);
while(rs.next()){
String stockminimo = rs.getString("stockminimo");
try{String sql1 = "SELECT cod, articulo, proveedor, stockminimo, cantidad, unidad, preciocosto FROM articulos WHERE cantidad <= "+stockminimo+"";
pst =connect().prepareStatement(sql1);
rs = pst.executeQuery();
while(rs.next()){
Vector v = new Vector();
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
v.add(rs.getString(4));
v.add(rs.getString(5));
v.add(rs.getString(6));
v.add(rs.getString(7));
modelo.addRow(v);
tablaarticulos.setModel(modelo);
}}catch(Exception e){
System.err.println("Error" + e);
}finally {
try{if (connect() != null && !connect().isClosed()) {
connect().close();
}}catch (SQLException ex) {
ex.printStackTrace(System.out);
} } }}catch (Exception e) {
JOptionPane.showMessageDialog(null,e);
}finally {
try{if (connect() != null && !connect().isClosed()) {
connect().close();
}}catch (SQLException ex) {
ex.printStackTrace(System.out);
} }}else{
DefaultTableModel modelo = (DefaultTableModel) tablaarticulos.getModel();
modelo.setRowCount(0);
PreparedStatement pst = null; ResultSet rst = null; try { Statement st = null;String sql = "Select stockminimo from articulos";
st = connect().createStatement();
rst = st.executeQuery(sql);
while(rst.next()){
String stockminimo = rst.getString("stockminimo");
try{String sql1 = "SELECT cod, articulo, proveedor, stockminimo, cantidad, unidad, preciocosto FROM articulos WHERE cantidad <= "+stockminimo+" AND proveedor = '"+proveedor+"'";
pst =connect().prepareStatement(sql1);
rst = pst.executeQuery();
while(rst.next()){
Vector v = new Vector();
v.add(rst.getString(1));
v.add(rst.getString(2));
v.add(rst.getString(3));
v.add(rst.getString(4));
v.add(rst.getString(5));
v.add(rst.getString(6));
v.add(rst.getString(7));
modelo.addRow(v);
tablaarticulos.setModel(modelo);
}}catch(Exception e){
System.err.println("Error" + e);
}finally {
try{if (connect() != null && !connect().isClosed()) {
connect().close();
}}catch (SQLException ex) {
ex.printStackTrace(System.out);
} } }}catch (Exception e) {
JOptionPane.showMessageDialog(null,e);
}finally {
try{if (connect() != null && !connect().isClosed()) {
connect().close();
}}catch (SQLException ex) {
ex.printStackTrace(System.out);
} } }}Valora esta pregunta
0
