http://snippets.dzone.com/posts Sun, 27 Jul 2008 03:41:27 GMT DZone Snippets: id code http://snippets.dzone.com/posts/show/4521 // @TableName is obviously the TABLE name u use <br />// @ColumnName is obviously the COLUMN name u use <br /> <br /><code> <br />---Get next ID number <br /> DECLARE <br /> @ID int <br /> <br /> IF (SELECT count(*) FROM @TableName ) > 0 <br /> BEGIN <br /> SELECT @ID = max(ColumnName ) from @TableName <br /> SET @ID = @ID + 1 <br /> END <br /> ELSE <br /> BEGIN <br /> SET @ID = 1 <br /> END <br /></code> Tue, 11 Sep 2007 07:50:29 GMT http://snippets.dzone.com/posts/show/4521 dubby (Dave) http://snippets.dzone.com/posts/show/2615 // IdGenerator <br /> <br /><code> <br />public class IdGenerator { <br /> <br /> private long maxId; <br /> <br /> public IdGenerator(long start) { <br /> maxId = start; <br /> } <br /> <br /> public long getNextId () { <br /> return ++maxId; <br /> } <br /> <br />} // IdGenerator <br /></code> Sun, 17 Sep 2006 19:34:56 GMT http://snippets.dzone.com/posts/show/2615 ovhaag (Oliver Haag) http://snippets.dzone.com/posts/show/1716 The online service <a href=http://www.dopa.go.th/online/inqelect.htm>here</a> aims to help people <br />check where they are to vote. However, it can be <br />used as ID certification as well. <br /><code> <br /># nnnn is the id to be checked <br />http://www.dopa.go.th/cgi-bin/inqelect.sh?pid=nnnn <br /></code> <br />Here I make it into a function call. <br /><code> <br />import urllib, re <br />def getname(id): <br /> url = 'http://www.dopa.go.th/cgi-bin/inqelect.sh?pid=' + str(id) <br /> src = urllib.urlopen(url).read() <br /> pat = '<H3> *(.*?) *<' <br /> name = re.findall(pat, src)[0] # don't use other info <br /> return name <br /> <br />print getname(5100900050063) # show a name (one of my relatives) <br /></code> Sun, 19 Mar 2006 16:30:32 GMT http://snippets.dzone.com/posts/show/1716 korakot (Korakot Chaovavanich) http://snippets.dzone.com/posts/show/1692 <code> <br /># table schema <br /># CREATE TABLE person (id COUNTER, name VARCHAR) <br /> <br />db = e32db.Dbms() <br />db.begin() # begin transaction (lock other inserts) <br />db.execute(u"INSERT INTO person(name) VALUES 'korakot' ") # insert a new row <br /> <br />dbv = e32db.Db_view() <br />dbv.prepare(db, u"SELECT id FROM person ORDER BY id DESC") <br />dbv.first_line() <br />dbv.get_line() <br />last_id = dbv.col(1) # get it! <br /> <br />db.commit() # commit the transaction <br /></code> Mon, 13 Mar 2006 17:23:21 GMT http://snippets.dzone.com/posts/show/1692 korakot (Korakot Chaovavanich)