Programming

There is a gap below the bottom of an inline image element

Even though there is no margin or padding on the inline image element. In fact, it has nothing to do with the box model but line boxes, i.e., inline image elements by default align with the baseline of a line box, just like texts.

Read carefully the org.springframework.jdbc.BadSqlGrammarException

You may think the query is wrong, maybe one of the column names is misspelled. But the actual error is in the row mapper or in the row extractor.

Oracle database DATE data type does not store timezone information

The Oracle database DATE data type does not store timezone information, so it will be good to consistently store GMT time in a DATE column and use the time in GMT in code. The idea is that we also save the current timezone of a user, so that the code can always calculate the local time of the user by shifting the GMT time.