Insert row into MySQL DB?

Question

The Code:

sql = "INSERT INTO `admin` (`id`,`username`,`password`,`access`) VALUES ('"+(numIds+1)+"','"+addedUsername+"','"+addedPassword+"','"+addedAccess+"');";

Statement statementAdd = (Statement) DBconnection.createStatement();
result = statementAdd.executeUpdate(sql);

The Error:

MySQLLogin.java:133: error: incompatible types
            result = statementAdd.executeUpdate(sql);
                                               ^
required: ResultSet
found:    int
1 error

Any ideas?

Please learn using prepared statements. Your code will be cleaner, more robust, and not vulnerable to SQL injection attacks. download.oracle.com/javase/tutorial/jdbc/basics/prepared.html — JB Nizet
– JB Nizet, Commented Mar 23, 2013 at 14:22
@user2202426: show us how result is declared. ExecuteUpdate returns an int, not a ResultSet. docs.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html — Jeroen Vannevel
– Jeroen Vannevel, Commented Mar 23, 2013 at 14:24

Pragnani Kinnera · Accepted Answer · 2013-03-23 14:20:18Z

4

ExecuteUpdate returns integer it seems you are assigning it to the Result set

answered Mar 23, 2013 at 14:20

Pragnani Kinnera

20.2k6 gold badges54 silver badges76 bronze badges

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

2 Comments

user2202426 Over a year ago

How would I change this then?

Pragnani Kinnera Over a year ago

int count = statementAdd.executeUpdate(sql);

Dan Bracuk · Accepted Answer · 2013-03-23 15:29:31Z

0

For this:

'"+(numIds+1)+"'

You are either trying to do math with a string or insert a string with into a numeric field. Given your error message, I suspect the latter. It's the single quotes that make it a string.

answered Mar 23, 2013 at 15:29

Dan Bracuk

20.8k5 gold badges30 silver badges44 bronze badges

Comments

Abubakkar · Accepted Answer · 2013-03-23 16:20:22Z

0

executeUpdate returns the number of rows affected (in your case, it will return the number of rows inserted. But you are trying to a assign the returning int to a ResultSet object.

So just change it to :

int insertedRows = statementAdd.executeUpdate(sql);

See the javadocs for Statement class for more information.

edited Mar 23, 2013 at 16:20

answered Mar 23, 2013 at 16:13

Abubakkar

15.7k8 gold badges58 silver badges84 bronze badges

Collectives™ on Stack Overflow

Insert row into MySQL DB?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related