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 ²»ÄÜ·ÃÎÊÆäËûÓû§É¾³
Ïà¹ØÎÊ´ð£º
ÄǸö¸ßÊÖ½Ó´¥¹ýsqlite£¬·¢µã¶ÔsqliteµÄÏêϸԴÂë·ÖÎö£¬Ð»Ð»~~
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÒýÓÃ
Ô´´úÂëµ¹ÊDz»ÉÙÈËÏÂÁË,Ò²¿´ÁË,µ«ÍêÕûµÄ·ÖÎöûÓÐ.
ÓÐûÓÐһЩ¹ØÓÚSQLiteÄÚ´æ·ÖÅä· ......
ÏÖÔÚÏë×öÒ»¸ö½øÏú´æ,¿ÉÄÜ»áÓÐ20ÈËͬʱһÆðÓÃ
²»ÖªµÀµ½ÊÇÑ¡Ôñ sqlite »¹ÊÇ access
´ó¼Ò¸ø¸øÒâ¼û°É
»¹ÊÇÓÃaccess°É£¬ÒòΪÄã¿Ï¶¨ÊÇÓÃ.net¿ª·¢£¬³öÁËʲôÎÊÌâµÄ»°ºÃ½â¾öһЩ¡£
Èç¹ûÓÃsqlite×ÊÁÏÏà¶Ô±È½ÏÉÙ¡£
²»¹ýÌý ......
c# + sqlite ³ö´í£¡£¡£¡
File opened that is not a database file
file is encrypted or is not a database
ºÍÒÔÇ°Ò»ÑùµÄд£¬ÔõôÕâ´Î¾ÍÊDz»Ðа¡£¡£¡£¡
ÎÒ¿ì²»ÐÐÁË£¬´ó¼Ò°ï°ïÎÒ°¡£¡£¡£¡
¼û¹ýһƪÎÄÕÂÊÇ˵Õâ¸ö
......
ÇëÎʸ÷λ´ó¸ç,ËÓÐÉú³É·ÃÎÊsqliteÊý¾Ý¿âµÄ´úÂëÉú³ÉÆ÷,·üÍû´ó¼Ò°ïæ...
СµÜ¼±ÓÃ
wuyq11
(ÈËÉúÈçÃÎ) ÄúºÃ,wuyq11
UcfarDBAÊÇÔõôʹÓõÄ,СµÜ¿´µ½ÀïÃæÖ»ÓÐcstÎļþ,Ó¦¸ÃÊÇÄ£°å,ÕâЩģ°åÒªÔõÃ´Ê ......