How to add variable value into mysql statement?

Question

I'm learning to work with mysql database and now trying to populate statement with text from textfield. The program is phone book and strings are name, surname and telephone number which must be writen in textfield and then added to statement for import in database. So, for now I have this, but not working because statement dont even recognize strings as value.. any ideas what to use/write?

if("Potvrdi".equals(buttonLabel)) {

            String ime = a.getText();
            String prezime = b.getText();
            String broj = c.getText();

            Connection conn = dc.connect();
            Statement st = (Statement) conn.createStatement(); 
            st.executeUpdate("INSERT INTO imenik VALUES (ime,prezime,broj)");
            conn.close();
            }

You should use PreparedStatement instead of Statement. PreparedStatement stmt =con.prepareStatement("INSERT INTO imenik VALUES (?, ?, ?)"); stmt.setString(1, ime); stmt.setString(2, prezime); stmt.setString(3, broj); — Oleksandr Riznyk
– Oleksandr Riznyk, Commented Sep 25, 2018 at 13:28
If you have to cast Statment, you must have the wrong imports. — SedJ601
– SedJ601, Commented Sep 25, 2018 at 13:29
Please see regarding MySQL Injection here: stackoverflow.com/a/60496/2430549 — HoldOffHunger
– HoldOffHunger, Commented Sep 25, 2018 at 13:36

benjamin c · Accepted Answer · 2018-09-25 13:35:05Z

2

Using prepare statement,

String insertTableSQL = "INSERT INTO imenik VALUES (?,?,?)";
PreparedStatement preparedStatement = conn.prepareStatement(insertTableSQL);
preparedStatement.setString(1, ime);
preparedStatement.setString(2, prezime);
preparedStatement.setString(3, broj);
// execute insert
preparedStatement .executeUpdate();

edited Sep 25, 2018 at 13:35

answered Sep 25, 2018 at 13:33

benjamin c

2,33819 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

How to add variable value into mysql statement?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related