select_means.java

超市进销存系统+源代码 软件版本:1.0 应用系统:跨平台 使用权限:免费 软件介绍: 本软件运行环境: JDK1.5+SQL2000SP4 源代码运行环境: JBuider200

        try {
            conn = DBAccess.getConnection();
            pmst = conn.prepareStatement(select6);
            pmst.setString(1, name);
            pmst.setString(2, password);
            pmst.setString(3, "管理员");
            rs = pmst.executeQuery();
            rs.next();
            vcUser.add(rs.getString(1));
            vcUser.add(rs.getString(2));
            vcUser.add(rs.getString(3));
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pmst != null) {
                    pmst.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception ex1) {
                ex1.printStackTrace();
            }

        }
        return vcUser;
    }

    public static Vector Select_UserManager(String CardId) { //查询卡信息
        Vector vcUser = new Vector();
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement pmst = null;
        try {
            conn = DBAccess.getConnection();
            pmst = conn.prepareStatement(select5);
            pmst.setString(1, CardId);
            rs = pmst.executeQuery();
            rs.next();
            vcUser.add(rs.getString(1));
            vcUser.add(rs.getString(2));
            vcUser.add(rs.getString(3));
            vcUser.add(rs.getString(4));
            vcUser.add(rs.getString(5));
            vcUser.add(rs.getString(6));
            vcUser.add(rs.getString(7));
            vcUser.add(rs.getString(8));
            vcUser.add(rs.getString(9));
            vcUser.add(rs.getString(10));

        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pmst != null) {
                    pmst.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception ex1) {
                ex1.printStackTrace();
            }

        }
        return vcUser;
    }

    public static Vector Select_inoutSale(String Product_ID, String NextBack) { //查询进退货信息
        Vector vector1 = new Vector();
        Vector vector2 = new Vector();
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement pmst = null;
        try {
            conn = DBAccess.getConnection();
            if (Product_ID.length() == 0) {
                pmst = conn.prepareStatement(select7);
                pmst.setString(1, NextBack);
            } else {
                pmst = conn.prepareStatement(select8);
                pmst.setString(1, Product_ID);
                pmst.setString(2, NextBack);
            }
            rs = pmst.executeQuery();
            rs.next();
            vector1.add(rs.getString(2));
            vector1.add(rs.getString(3));
            vector1.add(rs.getString(4));
            vector1.add(rs.getString(5));
            vector1.add(rs.getString(6));
            vector1.add(rs.getString(7));
            vector1.add(rs.getString(8));
            vector1.add(rs.getString(9));
            vector2.add(vector1);
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pmst != null) {
                    pmst.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception ex1) {
                ex1.printStackTrace();
            }

        }
        return vector2;
    }

    public static int Select_StockPile(String Product_ID) { //查询商品库存数量
        int number1 = 0;
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement pmst = null;
        try {
            conn = DBAccess.getConnection();
            pmst = conn.prepareStatement(select9);
            pmst.setString(1, Product_ID);
            rs = pmst.executeQuery();
            rs.next();
            String num = rs.getString(1);
            Integer number = new Integer(num);
            number1 = number;
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pmst != null) {
                    pmst.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception ex1) {
                ex1.printStackTrace();
            }

        }
        return number1;
    }

    public static Vector Select_repertory(String Product_ID) { //根据商品编码查询库存
        Vector vector2 = new Vector(); //将vector1装入形成一条数据
        Connection conn = null;
        ResultSet rs = null;
        PreparedStatement pmst = null;
        try {
            conn = DBAccess.getConnection();
            pmst = conn.prepareStatement(select10);
            pmst.setString(1, Product_ID);
            rs = pmst.executeQuery();
            while (rs.next()) {
                Vector vector1 = new Vector(); //记录查询的数据
                Vector vector3 = new Vector(); //接收查询到的商品信息的一条数据
                Vector vector4 = new Vector(); //接收vector3中商品的名称
                vector1.add(rs.getString(1));
                vector1.add(rs.getString(2));
                vector3 = Select_sort2(rs.getString(2)); //根据商品编号查询商品信息
                vector4 = (Vector) vector3.get(0);
                vector1.add(vector4.get(3).toString());
                vector1.add(rs.getString(3));
                vector2.add(vector1);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (pmst != null) {
                    pmst.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (Exception ex1) {
                ex1.printStackTrace();
            }

        }
        return vector2;
    }
    public static Vector Select_All_repertory() { //查询所有库存
           Vector vector2 = new Vector(); //将vector1装入形成一条数据
           Connection conn = null;
           ResultSet rs = null;
           PreparedStatement pmst = null;
           try {
               conn = DBAccess.getConnection();
               pmst = conn.prepareStatement(select11);
               rs = pmst.executeQuery();
               while (rs.next()) {
                   Vector vector1 = new Vector(); //记录查询的数据
                   Vector vector3 = new Vector(); //接收查询到的商品信息的一条数据
                   Vector vector4 = new Vector(); //接收vector3中商品的名称
                   vector1.add(rs.getString(1));
                   vector1.add(rs.getString(2));
                   vector3 = Select_sort2(rs.getString(2)); //根据商品编号查询商品信息
                   vector4 = (Vector) vector3.get(0);
                   vector1.add(vector4.get(3).toString());
                   vector1.add(rs.getString(3));
                   vector2.add(vector1);
               }
           } catch (Exception ex) {
               ex.printStackTrace();
           } finally {
               try {
                   if (rs != null) {
                       rs.close();
                   }
                   if (pmst != null) {
                       pmst.close();
                   }
                   if (conn != null) {
                       conn.close();
                   }
               } catch (Exception ex1) {
                   ex1.printStackTrace();
               }

           }
           return vector2;
    }

}