可以使用以下代码来解决这个问题:
SELECT CAST(is_deleted
AS SIGNED) as is_deleted FROM table_name
public class CustomRowMapper implements RowMapper
@Override
public MyClass mapRow(ResultSet rs, int rowNum) throws SQLException {
MyClass myClass = new MyClass();
myClass.setDeleted(convertTinyintToBoolean(rs.getInt("is_deleted")));
// 其他字段的设置
return myClass;
}
private boolean convertTinyintToBoolean(int tinyintVal) {
return tinyintVal == 1;
}
}
JdbcTemplate jdbcTemplate = getJdbcTemplate();
List