コード例 #1
0
  public ArrayList<String> findDishsbyWindowid(Window window) throws Exception { // 搜索特定窗口下的所有菜系名称
    ArrayList<String> dishs = new ArrayList<String>();
    String sql = "select distinct dishname from recipe where windowid=?";
    this.pstmt = this.conn.prepareStatement(sql);
    this.pstmt.setInt(1, window.getWindowId());
    ResultSet rs = this.pstmt.executeQuery();

    while (rs.next()) {
      dishs.add(rs.getString(1));
    }
    return dishs;
  }
コード例 #2
0
  @Override
  public Recipe findRecipeIdbyWindowDishname(Window window, String dishname) throws Exception {
    Recipe recipe = new Recipe();

    String sql = "select distinct recipeid from recipe where windowid=? and dishname=?";
    this.pstmt = this.conn.prepareStatement(sql);
    this.pstmt.setInt(1, window.getWindowId());
    this.pstmt.setString(2, dishname);
    ResultSet rs = this.pstmt.executeQuery();
    if (rs.next()) {
      recipe.setRecipeId(rs.getInt(1));
      // *********************************************
    } // if
    return recipe;
  }