sql - java- generate id (combination of string and integer) -


I am creating an application in NetBeans (java). This app has unique ID combinations of string and integers like abc / 111 or xyz / 253 and should increase the integer part when there is a new entry in the database ABC / 112 and xyz / 254 .

The problem is that the increase in the value of the integer part until it reaches proper 10, but after that it does not increase for further entries in the database.

I try the following code - 

  {string sql = "death number by resigner dessc select number from;"; Pst = conn.prepareStatement (SQL); Rs = pst.executeQuery (); If (rsnext ()) {string add1 = rs.getString ("RegNumber"); String [] parts = add1.split ("/"); String part 1 = parts [0]; String Part 2 = Part [1]; Int a, b; A = integer Parasont (Part 2); B = A + 1; JTextField20.setText ("" + part1 + "/" + b); Yosepepationpen Show Messagidoug (blank, "done"); }}   
 " Integer increment of 10"  "means that if I start the first value of the id in the database such as  abc / 1 < / Code> then the new ID automatically generates a rising value of 1 for the next entry, which is  abc / 2  and for the next entry it will be  abc / 3  And similar  sequential  abc / 4 , ...,  abc / 10   
 but when this  abc / 10  New Generated ID is one for every new entry in the database I.e. means  abc / 10  (I am using MS Access 2007 and type  id  of  text ). The first ID in the database Created by yourself.  
 If anyone has any other option to generate  id , then please let me know.   
 
 The problem is that  
  string = "RegNumber selects RegNumber from the order of death by DESC";   
 The alphabetic order will be described as descending, And speaking alphabetically  
  "abc / 9" & gt; "ABC / 10"   
 And that's why your program always fetches 9 times and more frequently ...  
 I think you'll find that column Will have to split up for storage, and store the numerical part as a real number type in the database. It's probably not as hard as it seems, you can always sort on 2 fields  
  string by registering sql = "Regstring DESC, by RegNumber DESC, select RegNumber"; You can consider using a  SERIAL  (autoincrement) datatype for the RegNumber part in some cases (ie if RegNumber is not reset such as when String part changes) to further your entry logic.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more