¹ØÓÚ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Óï¾ä±£´æ Ϊ¿ÕµÄÎı¾¿ò¶ÔÓ¦µÄ×ֶβ»±£´æ¼´¿É
Ïà¹ØÎÊ´ð£º
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 ......
ÔÚjspÒ³ÃæÖÐ,ÎÒÏëÏÔʾÊý¾Ý¿â±íÖÐijЩ×ֶεÄÖµ,ÔÚ·½·¨ÖÐ,ÎÒÓ¦¸ÃÓÃʲôÑùµÄ¼¯ºÏÀàÐÍ×öΪ·µ»ØÖµ±È½ÏºÃ,»¹ÓÐ,ÔÚÒ³ÃæÉÏÈçºÎÑ»·Êä³öÎÒ²éѯµÄÄÚÈÝ..¼±ÓÃ!!!!!°ÝÍÐ ÓÃList²»ÐÐÂ𣿠ÓÃlist Ò³ÃæÓà <c:forEach& ......
ÒÑÖª sql serverÖÐ $server="se"; $username="us"; $password="pa"; $datebase="ds"; 1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ ......
ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë Ôõô»ØÊ¡£ ´úÂëÒѾдÁ˹ýÂË×Ö·û´® Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË »¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½ Ôõôà ......