sqlite ²»Ö§³Ölast()?
Java code:
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select * from table");//±¨´íµÄÐÐ
rs.last()
ÓÃrs.last()ÒÆµ½×îºóÒ»Ìõ¼Ç¼µÄʱºò,±¨¿ÕÖ¸ÕëÒì³£,³ö´íÐÐÊÇ»ñÈ¡Êý¾ÝµÄÐÐ
Èç¹ûÊÇ
Java code:
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from table");
rs.last()
ÔòÊDZ¨resultset is type_forward_only
ÄѵÀSqlite²»Ö§³ÖÓαê¹ö¶¯?
Á½ÖÖ´ò¿ª·½Ê½¶¼ÊÇ¿ÉÒÔµÄ,²»last()Ò²¿ÉÒÔÕý³£ÔËÐÐ,µ«ÊÇÈç¹ûÕâÑùµÄ»°,¾ÍÖ»ÄÜͨ¹ýselect count()À´»ñµÃ½á¹û¼Ç¼µÄÌõÊýÁË?
²»ÖªµÀÄãµÄJAVAÊÇÈçºÎ´ò¿ª¼Ç¼¼¯µÄ¡£
ÔÚCÖлòÕßVBÖÐ (×¢Ò⿴һϣ¬adOpenForwardOnly 0 ĬÈÏÖµ¡£ÕâÒ»ÐеĽâÊÍ£¬ÏàÐÅJAVAÖÐÒ²Ò»Ñù£©
recordset.Open Source, ActiveConnection, CursorType, LockType, Options
CursorTypeEnum
adOpenDynamic 2 ʹÓö¯Ì¬ÓαꡣÆäËûÓû§Ëù×öµÄÌí¼Ó¡¢¸ü¸Ä»òɾ³ý¾ù¿É¼û£¬¶øÇÒÔÊÐí Recordset ÖеÄËùÓÐÒÆ¶¯ÀàÐÍ£¨Èç¹ûÌṩÕß²»Ö§³ÖÊéÇ©£¬ÔòÊéÇ©³ýÍ⣩¡£
adOpenForwardOnly 0 ĬÈÏÖµ¡£Ê¹ÓýöÏòǰÓαꡣ³ýÁËÔڼǼÖÐÖ»ÄÜÏòǰ¹ö¶¯Í⣬Ó뾲̬ÓαêÏàͬ¡£µ±Ö»ÐèÒªÔÚ Recordset ÖнøÐÐÒ»¸ö´«µÝʱ£¬ÓÃËü¿ÉÌá¸ßÐÔÄÜ¡£
adOpenKeyset 1 ʹÓüü¼¯Óαꡣ¾¡¹Ü´ÓÄúµÄ Recordset ²»ÄÜ·ÃÎÊÆäËûÓû§É¾³
Ïà¹ØÎÊ´ð£º
GUID£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7
SELECT fldGuid, fldName, fldUserGuid from table
Äܲéѯ fldUserGuid Ϊ£º0C3EDEE8-B14F-4220-8D64-990E00D84AF7 µÄÊý¾ÝÒ»Ìõ
SELECT fldGuid, fldN ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼þ£¬²éÑ¯Ê ......
ÓÃevc±àдӦÓóÌÐò£¬¿ª·¢Êý¾Ý¿â¹ÜÀíϵͳ¡£ÉèÖÃencodingΪUTF-8£¬Äܹ»²åÈëÖÐÎÄÊý¾Ý£¬ÓÃSQLite Expert Personal¿´Êý¾Ý¿â£¬ÖÐÎÄÕý³£¡£±ðµÄ³ÌÐò²éѯÊý¾Ý¿â£¬²¢ÏÔʾÓÚEDIT¿Ø¼þÖУ¬Õý³£¡£µ«ÊÇʹÓÃlist control ¿Ø¼ ......
ÒªÔÚlinuxÉÏʹÓÃsqliteÊDz»ÊÇÒªÏȱàÒë°²×°£¿Ôõô°²×°£¿
c#+sqlite+linuxµÄÏà¹ØÓ¦ÓÃÓÐûÓÐһЩÏà¹Ø×ÊÁÏ£¿
linux ÉÏÄÜÔËÐУ㣡¡?
Äã¿ÉÒÔÏÂÔØ±àÒëºÃµÄ£¬Ò²¿ÉÒÔÏÂÔØÔ´´úÂëÔÙ×Ô¼º±àÒë
http://www.sqlite.org/downl ......