Generate encoding String according to creation order.

Posted by Tony on Stack Overflow See other posts from Stack Overflow or by Tony
Published on 2010-05-16T07:42:20Z Indexed on 2010/05/16 7:50 UTC
Read the original article Hit count: 223

Filed under:
|
|

I need to generate encoding String for each item I inserted into the database. for example:

x00001 for the first item
x00002 for the sencond item
x00003 for the third item

The way I chose to do this is counting the rows. Before I insert the third item, I count against the database, I know there're already 2 rows, so the next encoding is ended with 3. But there is a problem. If I delete the second item, the forth item will not be the x00004,but x00003.

I can add additional columns to table, to store the next encoding, I don't know if there's other better solutions ?

© Stack Overflow or respective owner

Related posts about java

Related posts about database