¹ØÓÚsqlserver»õ±ÒÐÍ×Ö¶ÎÏÔʾµÄÎÊÌâ
´ó¼ÒºÃ,СµÜÓÖÓöÒ»ÐÂÎÊÌâ: VB+SQL ÓÐN¸ö×Ö¶Î,´°ÌåÉÏÓÐN¸ötext.±£´æÊäÈë½á¹ûºó,ÓÐN¸ö¶ÔӦΪ»õ±Ò×ԶεÄtextÔÚûÓÐÊäÈëÈκÎÖµ(¼´Îª¿Õ)µÄÇé¿öÏÂ,´ÓSQL²éѯ·ÖÎöÆ÷Àï²éµ½,Æä¾ÓÈ»ÊÇ"0.00". ¶øÇÒ½«Æä¶Á³öµ½TEXT¿òÄÚÒ²ÏÔʾΪ 0,ÏÖÎÒÏëÔÚ¶Á³öÊý¾ÝµÄʱºò,ÓÐÊý¾ÝµÄÏÔʾÊý¾Ý,¶øΪ 0 µÄÊýÖµ²»ÏÔʾÓÚÎı¾¿òÄÚ,¼´Îı¾¿òÄÚ¾ÍΪ¿Õ,²»ÏÔʾ"0". ÇëÎʸ÷λ´óÏÀÓз¨×ÓÂð?
if rs.fields("mymoney")=0 then text1="" else text1=rs.fields("mymoney") end if лл´ð¸´,ÎÊÌâÊÇÎÒÓÐ20¶à¸ötext°¡ Òª¼ò±ã£¬¿ÉÒÔÓÃÒ»¸ö¹ý³Ì±éÀútext£¬Åжϲ¢Ð޸ģ¬µ«ÊÇÕâÑù×öÏîÄ¿²»ºÃÒýÓà »òÕßÓÃsqlÓï¾ä¿ØÖÆ select id , (case mymoney when 0 then '' else mymoney end ) as mymoney from mytable Õâ¸ö¿ÉÒÔ ²»ÒªÓÃÎı¾¿òÊý¾Ý°ó¶¨,ÓÃsqlÓï¾ä±£´æ Ϊ¿ÕµÄÎı¾¿ò¶ÔÓ¦µÄ×ֶβ»±£´æ¼´¿É
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿ ......
sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Ã»Õâ¸ö˵·¨. Ö»¸øSELECT , UPDATEµÄÖ»¸øijЩ±í ¸ö²»»á µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class QueryTest&n ......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍƼöÂ𣿠Õâ¸öÓ¦µ±Ã»ÓÐʲôÌرð,ÓëÆäËûµÄ±à³ÌÒ»Ñù. JDBC ÇëÎÊÔÚSwingÖмÓÔر³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿ ......
ÈçÌâ¡£ ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬ µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......