Java error: 'java.lang.String cannot be cast to java.lang.Integer' [duplicate]

Question

When I run the following code I get an error:

java.lang.String cannot be cast to java.lang.Integer

This is my code:

try{
       int rows = jTable1.getRowCount();
       String myUrl = "jdbc:mySql://localhost:3306/hospital"; 
       Connection con = DriverManager.getConnection(myUrl,"root","");
       con.setAutoCommit(false);


            String query = "Insert into `test and treatment_has_admission`(`Test and Treatment_id`,`Admission_a_id`,`Test_Result`,`Treatment_Result`,`Date`)"+" values (?, ?, ?, ?, ?)";
            PreparedStatement pst = con.prepareStatement(query);
            for(int row=0; row<rows; row++){
                int TestTreatmentID = (int) jTable1.getValueAt(row, 1);
                String test_result = (String) jTable1.getValueAt(row, 2);
                String treatment_result = (String) jTable1.getValueAt(row, 3);
                String Date = (String) jTable1.getValueAt(row, 4);
                pst.setInt(1,TestTreatmentID);
                pst.setInt(2,Integer.parseInt(t2.getText()));
                pst.setString(3, test_result);
                pst.setString(4, treatment_result);
                pst.setString(5, Date);

                pst.addBatch();
            }
            pst.executeBatch();
            con.commit();
            con.close();
        }


    catch(Exception e){
        e.printStackTrace();
    }



}

Error: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer

Why am I receiving such an error? Please help me to resolve it.

It seems your answer here: stackoverflow.com/questions/14921446/… — taile
– taile, Commented May 10, 2017 at 6:19
That is so weird!!!! 5 lines down, you know how to use Integer.parseInt() to convert a String to an int. How come you don't know that 5 lines before?!?!?!? — Andreas
– Andreas, Commented May 10, 2017 at 6:21

AAryan · Accepted Answer · 2017-05-10 06:17:57Z

1

String can't cast into Integer. Use this

 int TestTreatmentID = Integer.parseInt(jTable1.getValueAt(row, 1));

EDIT

 String string= jTable1.getValueAt(row, 1).toString();
 int TestTreatmentID = Integer.parseInt(string);

edited May 10, 2017 at 6:17

answered May 10, 2017 at 6:15

AAryan

20.2k8 gold badges49 silver badges69 bronze badges

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

3 Comments

Joe C Over a year ago

jTable1.getValueAt(row, 1) returns an Object.

AAryan Over a year ago

@JoeC my mistake, edited

maneesha Over a year ago

thanks alot. this is a good help

taile · Accepted Answer · 2017-05-10 06:17:17Z

0

It seems you got problem at line

int TestTreatmentID = (int) jTable1.getValueAt(row, 1);

Let's use Integer.parseInt instead

Integer TestTreatmentID = Integer.parseInt(jTable1.getValueAt(row, 1).toString());

answered May 10, 2017 at 6:17

taile

2,77619 silver badges32 bronze badges

1 Comment

maneesha Over a year ago

Thanks alot..that helped

Raman Sahasi · Accepted Answer · 2017-05-10 06:22:34Z

0

You cannot simply typecast integers like this

int TestTreatmentID = (int) jTable1.getValueAt(row, 1);

Instead, parse this string to get proper integer value

int TestTreatmentID = Integer.parseInt(jTable1.getValueAt(row, 1));

answered May 10, 2017 at 6:22

Raman Sahasi

32.1k9 gold badges63 silver badges74 bronze badges

Comments

saum22 · Accepted Answer · 2017-05-10 06:26:47Z

0

You need to parse the value returned from method to Int using

Integer.parseInt(jTable1.getValueAt(row, 1));

answered May 10, 2017 at 6:26

saum22

88212 silver badges28 bronze badges

Collectives™ on Stack Overflow

Java error: 'java.lang.String cannot be cast to java.lang.Integer' [duplicate]

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Linked

Related