how to insert into mysql database from table in java GUI?

Question

I'm trying to insert data into mysql db from java GUI , however there is an exception stating

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near '?,?,?,?.?)' at line 1

String sql = "INSERT INTO ugc VALUES (?,?,?,?,?)";

    try {
        pst=conn.prepareStatement(sql);
        pst.setString(1, univ_name.getText());
        pst.setString(2, reg_no.getText());
        pst.setString(3,affiliation);
        String naac_grade=naac.getSelectedItem().toString();
        pst.setString(4, naac_grade);
        pst.setString(5, country.getText());

        pst.executeUpdate(sql);

are you sure the sql excuted is the above as you showed because exception says you have a dot before last ? which is an error but in you code there is no dot — singhakash
– singhakash, Commented Aug 7, 2015 at 11:15
remove the parameters from pst.executeUpdate(sql); because you have already prepared the statement then there is no need to provide it again — singhakash
– singhakash, Commented Aug 7, 2015 at 11:17
Does you table has 5 columns ?? It not then this exception may arise.Add column name in the after "insert into ugc" — Mahesh
– Mahesh, Commented Aug 7, 2015 at 11:19
yes it has, and if i use executeQuery() it gives me another exception , stating data manipulations are not allowed — user3598542
– user3598542, Commented Aug 7, 2015 at 11:27

wero · Accepted Answer · 2015-08-07 11:44:09Z

1

When executing the PreparedStatement use

pst.executeUpdate();

instead of

pst.executeUpdate(sql);

answered Aug 7, 2015 at 11:44

wero

33.1k3 gold badges63 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

how to insert into mysql database from table in java GUI?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related