ÔÚoracleÖÐÓÐDBMS_OUTPUT.put_line(); ÕâÑùÒ»¾ä»°¿ÉÒÔÊä³ö ÄÇôÔÚSQL server 2005ÖÐÓëËü¶ÔÓ¦µÄÊä³öÔõôдµÄѽ
²»Ì«Á˽âÄǸöº¯Ó÷¨£¬´óÖ²éÁËһϣ¬SQLÖÐÃ²ËÆ PRINT
print ''
¶÷ ¶Ô
print ÊÇÊä³ö¹Ø¼ü´Ê
print '11111'
print '²âÊÔ'
ÒýÓÃ
¶÷ ¶Ô
print ÊÇÊä³ö¹Ø¼ü´Ê
ÈçÏÂÈç¹ûÎÒÒªµ÷ÓøĴ洢¹ý³Ì
create ......
String[] goods=str.split("\n");//ÓÐ1000Ìõ
ÄÇÎÒÊÇ
for(int i=0;i<1000:i++)
{
sql="select * from tab where barcode='"+goods[i]+"'"
ResultSet rs_tmp = null; rs_tmp=b_st.executeQuery(sql_tmp);
}
·½·¨¶þ
String sss="";
for(i=0;i& ......
ÎÒÏëÕÒ¸ö¶®vb+sqlµÄСÀÏʦ£¬¶ÔÎÒÖ¸µ¼Ò»Ï£¬ÏÖÔÚÔÚ×öͼÊé¹ÜÀíϵͳ£¬ÓкöàÎÊÌâÏëÇë½Ì£¬¿ÉÒÔ°ïÒ»ÏÂÂð£¿
ллллл~~~À²£¡
¿É·ñÁô¸öqqѽ£¿
ÕâÊÇÎÒµÄqq£º253214495
....
VB°æ±È½Ï¶à£¬ÓÑÇé°ï¶¥¡£
vbûʲô¾Ñé
ÎÒÒ²¼±¶î···
²»ºÃÒâ˼···
............
ÎÒÃÇÊÇÓÃvb6.0µÄ¡£
¸ ......
¶ÔÓÚ²éѯÓï¾äÀ´Ëµ£¬¿ÉÓÉÆ´´®·½Ê½´æÔÚÓÚÏîÄ¿ÀàÎļþÖУ¬Ò²¿ÉÒÔÊÇ·ÅÔÚÊý¾Ý¿âµÄ´æ´¢¹ý³ÌÀï¡£
Õë¶ÔµÚÒ»ÖÖÇé¿ö£¬±ÈÈçÎÒÓÐÒ»¸ö²éѯÓï¾ä£º
SQL code:
Select FunctionID, FunctionName, FunctionUrl, ParentUrl from SysFunction
Where 1=1 [color=#FF0000]and FunctionID = '46'[/color]
ÎÒ»á°ÑºìÉ«µÄ×Ӿ䣬×÷Ϊ²éѯÌõ¼þ´ ......
ÓÐÁ½Õűí Ò»¸öÕűístuInfoÓÐstudenNo,studentName,studentSex,studentBirthDate ,course1,course2,course3 µÈ×Ö¶Î
ÁíÒ»Õűí studentImageÓÐ studentNo,studentPhoto µÈ×Ö¶Î.
Ò»¸öÒ³ÃæÀïÓÐһЩÊý¾Ý£¬Òª·Ö±ð²åÈëÕâÁ½ÕűíÀï,ÆäÖÐstuInfo.studentNo=studentImage.studentNo µÄ£¬ÄÇÒ»Ìõinsert Óï¾äÒªÔõôд?
±ØÐëдÁ½Ìõinsert ......
±¾²Ë²ËÄñ´óר ÍøÕ¾¿ª·¢£¨PHP·½Ïò£©±ÏÒµ¡£ÓÉÓÚÉÏѧûѧϰ¡£ÏÖÔÚÏÖʵ¸øÁËÎÒÒ»¶Ù¶¾´ò¡£ÎÒÇåÐÑÁË¡£ÏÖÔÚ¿ªÊ¼×ÔѧPHP¡£ÓÉÓÚÉÏѧÓеã»ù´¡¡£ÎÒÏëͨ¹ýÑо¿Ô´Â루ÀàËÆÁôÑÔ±¾£©Ìá¸ßһϡ£ËÄÜÍÆ¼ö¸öºÃµãµÄ¡£¡£Ö»ÒªÄÜÌá¸ß¡£ÄÜѧϰµ½ÖªÊ¶¡£Ê²Ã´·½·¨¶¼ÐС£²»Ñо¿±ðÈ˵ÄÔ´ÂëÒ²ÐС£Íûǰ±²¸ßÊÖÖ¸µãÃÔ½ò¡£¡£ÎÒÕâÀïÏÈллÁË¡£
Âþ³¤ÄØ
ÏÂÔØÒ ......