Inserting into Access database from NetBeans

Question

I have created a GUI based Hotel Management System in java netbeans which is connected with Ms Access Database. In database, i have a table named "RoomInfo".

When i try to execute the following query, i get two kinds of errors.

String sql = "INSERT INTO RoomInfo(RoomNumber,Reserved,RoomCategory,AirConditioned,
    BedType, RentPerDay)VALUES("+objr.roomno+","+objr.reserved+","+objr.category+","
   +objr.AirConditioned+","+objr.bedtype+","+objr.rent+")";

First error is net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.7 unexpected token: , I get this error when i leave all the Jtextfields empty and try to insert new record in to the database.

Second Error is net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.7 user lacks privilege or object not found: Economy (Economy is the entry for room category) I get this error when i enter data in to the Jtextfields and try to save it in to the database.

Need help identifying the problem.

Two problems: (1) You should be using question marks (?) as parameter placeholders in your SQL command text, e.g., ... VALUES (?,?,?,?,?,?). (2) You are doing your "None of the fields can be left empty" check after trying to insert the row, instead of before. — Gord Thompson
– Gord Thompson, Commented Nov 19, 2016 at 21:16

Charles · Accepted Answer · 2016-11-19 21:17:39Z

3

Instead of passing the the variable names directly into the sql string and then setting them again using ps.setString(); just use place holders in the sql string. What I mean is

String sql = "INSERT INTO RoomInfo (RoomNumber, Reserved, RoomCategory, AirConditioned, BedType, RentPerDay) 
VALUES (?, ?, ?, ?,?)";
        ps = con.prepareStatement(sql);

        ps.setString(1, objr.roomno);
        ps.setString(2, objr.reserved);
        ps.setString(3, objr.category);
        ps.setString(4, objr.AirConditioned);
        ps.setString(5, objr.bedtype);
        ps.setString(6, objr.rent);

answered Nov 19, 2016 at 21:17

Charles

1121 silver badge11 bronze badges

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

2 Comments

Yousaf Over a year ago

Thanks for the response. So the syntax of my INSERT QUERY is wrong ?

Charles Over a year ago

Looks that way.

Collectives™ on Stack Overflow

Inserting into Access database from NetBeans

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related