C99999 format in java to be used in sql

Question

i have a number with format "C99999"

i need import it to sql

i try this

while (rs.next()){
         int s=rs.getInt("Number");
        s++;

        String n = String.format("%05d",s);
        view.txtcustomernumber.setText(n);

how to add "C" into this format and the data type in mysql is int

Why are you trying to import a String "C00002" as a number? It is not a number. Do you want to discard the leading "C" and store only the numeric part? — Jim Garrison, Aug 20 '13 at 07:24
Then you can't use a numeric column. It has to be placed into a VARCHAR column. — Jim Garrison, Aug 20 '13 at 14:40

score 0 · Answer 1 · answered Aug 20 '13 at 04:28

0

Just use "C%05d" as the format string.

answered Aug 20 '13 at 04:28

C. K. Young

219,335
46
382
435

i alread try that but i get some error when add it to sql this is the error " java.lang.NumberFormatException: For input string: "C00002" – Yuuki Rito Aug 20 '13 at 04:29
Okay, do you have a stack trace for that exception? – C. K. Young Aug 20 '13 at 04:30

C99999 format in java to be used in sql

1 Answers1