Package com.dev.trade.bo

Examples of com.dev.trade.bo.Stock

55
56
57
58
59
60
61
62
63
64
65
66
67
68
    List stocks = new ArrayList();
    try {
      String query = "select A.quantity,A.stockid,B.name,B.price from TradingAccount A,stocks B where A.userid = ? and A.stockid = B.id";
      PreparedStatement pStmt = con.prepareStatement(query);
      pStmt.setString(1, userId);
      Stock stock = null;
      ResultSet rs = pStmt.executeQuery();
      while (rs.next()) {
        stock = new Stock(rs.getString(2), rs.getString(3), rs
            .getFloat(4), rs.getInt(1));
        stocks.add(stock);
      }
      pStmt.close();
    } catch (SQLException ex) {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    List stocks = new ArrayList();
    try {
      String query = "select * from stocks";
      PreparedStatement pStmt = con.prepareStatement(query);

      Stock stock = null;
      ResultSet rs = pStmt.executeQuery();
      while (rs.next()) {
        stock = new Stock(rs.getString(1), rs.getString(2), rs
            .getFloat(3), 0);
        stocks.add(stock);
      }
      pStmt.close();
    } catch (SQLException ex) {
View Full Code Here
TOP

Related Classes of com.dev.trade.bo.Stock

  • com.dev.trade.dao.TradeDAO
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.