How to insert data into MySql in some specific column in java

Question

I'm having a problem.

I have a table called issuebook in my MYsql database where there are 5 columns.

The columns are: memberid, membername, bookname, issuedate, returndate.

So I only want to insert data in 3 columns in memberid, membername, bookname and leave the other 2 columns blank for now (because in those columns when admin gives date then data will be inserted in those columns).

But whenever I try to insert it, it shows me an error like this:

java.sql.SQLException: Field 'issuedate' doesn't have a default value

My code is given below:

String bname,name,id;
id = Start.ID1;
name = Start.NAME1;
bname = bookBox.getSelectedItem().toString();
try {
    pst = con.prepareStatement("insert into issuebook(memberid,membername,bookname)values(?,?,?)");
    pst.setInt(1, Integer.parseInt(id));
    pst.setString(2, name);
    pst.setString(3, bname);
    pst.executeUpdate();

    JOptionPane.showMessageDialog(null, "Your Request is sent.");
    
}
catch (SQLException e1) {
    e1.printStackTrace();
}

My database table :

Probably `issuedate` column has been defined as 'not null'. Show us table definition. — Lukasz Blasiak, May 01 '21 at 14:36
@LukaszBlasiak column name : issudate Type : date Null : Not null — MK.Whridoy, May 01 '21 at 14:40
@LukaszBlasiak I am not sure. I edit my question and uploaded a picture of my database. — MK.Whridoy, May 01 '21 at 14:44

Lukasz Blasiak · Accepted Answer · 2021-05-01T14:49:35.040

1

The problem is with issuedate column definition. As you have mentioned in comment - it is defined as not null.

Your SQL ommit issuedate column in into clause which means that query will try to insert null value into it. You have to provide date in your SQL or redefine issuedate column to allow null values.

Check out this SO thread Field doesn't have a default values.

edited May 01 '21 at 14:49

answered May 01 '21 at 14:45

Lukasz Blasiak

642
2
10
16

after editing my column defaultvalue from not null to null by your suggestioin it worked without any error. thanks a lot. – MK.Whridoy May 01 '21 at 14:49
your're welcome, glad it helped :) – Lukasz Blasiak May 01 '21 at 14:50
Thanks a lot once again :) – MK.Whridoy May 01 '21 at 14:52

How to insert data into MySql in some specific column in java

1 Answers1