adding data to hashmap from database

Question

Hello I am creating an application where I can store data in a Hashmap and List for a shopping cart module.But I want to fetch this data from my MS-Access database.I tried the following code but its not compiling.Please give me guidance.

Code:

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

public class Program {
    public static void main(String [] args){}

    public static HashMap getProductsAsMap() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:pd");
            ResultSet rs = null;
            Statement st = con.createStatement();
            String sql = ("select * from products");
            rs=st.executeQuery(sql);
            while (rs.next()) { 
                HashMap<String, ProductBean> products= new HashMap<String, ProductBean>();
                String name=rs.getString("pname");
                String desc=rs.getString("pdesc");
                String image=rs.getString("pimage");
                products.put("P1", new ProductBean(name,desc,image));
                return products;
            }
            rs.close();
            st.close();
            con.close();
        }
        catch(Exception e){}   
    }

    public static List getProductsAsList() {
        List<ProductBean> products = new ArrayList<ProductBean>();
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:pd");
            ResultSet rs = null;
            Statement st = con.createStatement();
            String sql = ("select * from products");
            rs=st.executeQuery(sql);
            while (rs.next()) { 
                String name=rs.getString("pname");
                String desc=rs.getString("pdesc");
                String image=rs.getString("pimage");
                products.add(new ProductBean(name,desc,image));
            }
            rs.close();
            st.close();
            con.close();
        }
        catch(Exception e){}
        return products;  
    }
}

I get 2 errors as follows:

enter image description here

The answer is in the screen shot itself. Cannot find symbol constructor. I am guessing you are very new to programming! You should definitely pick up some beginner books on Java. — Chetan Kinger
– Chetan Kinger, Commented Sep 15, 2012 at 12:31
yes i corrected that and now its showing missing return statement. — prakash_d22
– prakash_d22, Commented Sep 15, 2012 at 12:53

assylias · Accepted Answer · 2012-09-15 11:41:21Z

2

Your ProductBean class does not have a constructor that takes three strings as parameters.

answered Sep 15, 2012 at 11:41

assylias

330k84 gold badges680 silver badges806 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Reimeus · Accepted Answer · 2012-09-15 11:53:18Z

1

As the error shows, the class ProductBean is missing a constructor with signature with 3 Strings - ProductBean(String, String, String).

Check this class again to match the existing constructor or add a new one to match your code here.

edited Sep 15, 2012 at 11:53

answered Sep 15, 2012 at 11:41

Reimeus

160k16 gold badges225 silver badges282 bronze badges

Comments

joran · Accepted Answer · 2013-07-30 01:44:52Z

0

It should be like this:

products.add(bean)

bean is the object of ProductBean class ProductBean bean = new ProductBean();

edited Jul 30, 2013 at 1:44

joran

175k34 gold badges439 silver badges484 bronze badges

answered Jul 29, 2013 at 19:05

Nirmalya Roykarmakar

1

Collectives™ on Stack Overflow

adding data to hashmap from database

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related