Changing tinyint(1) datatype in a mysql database using java

Question

When a customer gets removed from the database, his status has to be set to offline (rather than actually deleting the customer from the database). In my database I'm using tinyint(1) to set the status to 0 (inactive) or 1 (active). Now how do I go about coding this?

// Delete a customer on the database by setting his status to inactive
public void deleteCust(int id) throws DBException {

  // connect (and close connection)
  try (Connection conn = ConnectionManager.getConnection();) {
     // PreparedStatement
     try (PreparedStatement stmt = conn.prepareStatement(
        "update customer set active = ? where id = ?");) {
        stmt.settinyint(1, 0);
        stmt.setInt(2, id);

        stmt.execute();
     } catch (SQLException sqlEx) {
        throw new DBException("SQL-exception in deleteCust - statement"+ sqlEx);
     }
  } catch (SQLException sqlEx) {
     throw new DBException(
        "SQL-exception in deleteCust - connection"+ sqlEx);
  }

}

I'm using an SQL database via USB webserver on localhost. I'm unsure whether this works right now because the rest of my code is incomplete and I'm unable to test, but I have to be sure before continuing. Thank you

Rahmat Waisi · Accepted Answer · 2016-07-17 11:03:33Z

1

use setByte() instead.

because TINYINT in SQL is equal to byte in java, also it has some methods, like: setByte() and updateByte() and getByte()

answered Jul 17, 2016 at 11:03

Rahmat Waisi

1,3401 gold badge15 silver badges37 bronze badges

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

2 Comments

user3117628 Over a year ago

Thank you! :) I'll try this

Rahmat Waisi Over a year ago

your welcome, check these examples java2s.com and tutorialspoint.com too.

Collectives™ on Stack Overflow

Changing tinyint(1) datatype in a mysql database using java

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