how to getInt

[wong chang kit]

JTextField Value = new JFormattedTextField(NumberFormat.getInstance());

     public ArrayList getVal(ArrayList mc, int searchVal){
        try{

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection studentDB = DriverManager.getConnection(sourceURL, "admin", "");
            stmt = studentDB.createStatement();


            String query1 = "SELECT * FROM Stock WHERE Val <="+searchVal+" ORDER BY ItemName" ;
            ResultSet rs = stmt.executeQuery(query1);
         
            mc = new ArrayList();
            int counter=0;
            while(rs.next()){
                mc.add(new ArrayList());
                ((ArrayList)mc.get(counter)).add(rs.getString(6));
                ((ArrayList)mc.get(counter)).add(rs.getString(1));
                ((ArrayList)mc.get(counter)).add(rs.getString(2));
                ((ArrayList)mc.get(counter)).add(rs.getString(3));
                ((ArrayList)mc.get(counter)).add(rs.getString(4));
                ((ArrayList)mc.get(counter)).add("RM "+rs.getInt(5));
                ((ArrayList)mc.get(counter)).add(rs.getString(7));
                counter++;
             
            }
              
        }catch(Exception e){
                  showMessageDialog(null, "Failed, Please Key In Again");
        }
        return mc;
    }

[wong chang kit]

Hi guys.

After I added

 JTextField Value = new JFormattedTextField(NumberFormat.getInstance());

in my code.

I got an error. Saying that
Exception in thread "AWT-EventQueue-0" java.lang.NumberFormatException: For input string: "2,000"


Anyone knows how to solve it?

[Randall Twede]

"2,000" can't be changed to a number. "2000" can

[wong chang kit]

But the thing is that I'm using

JTextField Value = new JFormattedTextField(NumberFormat.getInstance());

The format is fixed. Whatever numbers that I typed in. It will automatically change to 2,000 with the comma .

[Darryl Burke]

wong chang kit wrote:in my code.

I got an error. Saying that
Exception in thread "AWT-EventQueue-0" java.lang.NumberFormatException: For input string: "2,000"

In the code you didn't post?

To get better help sooner, post a SSCCE (Short, Self Contained, Correct (Compilable), Example) that demonstrates the problem.

Before that, read the API for JFormattedTextField and make sure you're using the correct method to obtain the value.

[wong chang kit]

Anyone knows how to remove the comma between "2,000"

Exception in thread "AWT-EventQueue-0" java.lang.NumberFormatException: For input string: "2,000"


by the way, I'm using JTextField Value = new JFormattedTextField(NumberFormat.getInstance());

[Rob Spoor]

You obviously haven't followed Darryl's advice to read the Javadoc, because there is a method to get the value of the field.

[wong chang kit]

I did..but I could not get what I'm looking in the website.

[Rob Spoor]

I'll say it again: can you find a method with which you can get the Value?
Note that that method does not need to return an int; JFormattedTextField is a bit more generic (not with <T> though) than just for numbers, it can also be used for anything that can be formatted (like dates). You will have to check what the actual class of the object is, and then retrieve an int from that.