Statement µÄ execute(sql) ·½·¨µÄ·µ»ØÖµ
Statement µÄ execute(sql) ·½·¨µÄ·µ»ØÖµ
true if the first result is a ResultSet object;
false if it is an update count or there are no resultsTop
// Èç¹û executeµÄ·µ»ØÖµÊÇ ResultSetÔò·µ»Ø true
boolean sta=stmt.execute(sql);
if(sta){ // ·µ»ØÖµÊÇ ResultSet
ResultSet rs=stmt.getResultSet();
..............
}
else{//
int x=stmt.getUpdateCount();
............
}
Ïà¹ØÎĵµ£º
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracle ÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR Oracle ÀïÃæ×î´ó³¤¶ÈΪ 4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® NCHAR NCHAR ǰÕß×î´ó³¤¶È2kb ......
ÔÚʹÓÃsqlserver2005´´½¨×÷ҵʱ£¬´´½¨²»ÁË£¬Ìáʾ
ÎÞ·¨½«ÀàÐÍΪ“Microsoft.SqlServer.Management.Smo.SimpleObjectKey”µÄ¶ÔÏóÇ¿ÖÆ×ª»»ÎªÀàÐÍ“Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey”¡£ (Microsoft.SqlServer.Smo)
ÓÚÊǾÍgoogle£¬°Ù¶ÈÁËһϣ¬ºÃ¶àÎÄÕºÍÌù×Ó˵ÐèÒª° ......
ÓÉÓÚ×î½üÒªÓõ½´ò°üSQL Server 2005 Express Edition £¬ÓÉÓÚÔÚ°²×°¹ý³ÌÖÐÐèÒªÉèÖúܶණÎ÷¡£´øÀ´ºÜ¶àµÄ²»±ã£¬ÓÚÊÇÔÚÍøÉϺÍMSDNÕÒÁ˺þÃÖÕÓÚÕÒµ½°ì·¨ÁË ^_^
ÎÒÓõÄÊÇÅú´¦ÀíÀ´ÊµÏֵģ¬ºÃÁËÖ±½ÓÌù´úÂë
CLS
@ECHO OFF
ECHO.
ECH ......
ÒÀ¾Ýcsdn¸ßÊÖдµÄ×Ô¼ºÁ·Ï°Ò»Ï·½±ãÒÔºó²éÕÒ
--Creator:Gongl
--Date:2009-1-8
--sql server 2000
--ѧϰÐÐתÁУ¬ÎªÁ˽øÒ»²½Á˽⶯̬sqlÆ´½Ó£¨µ¥Ë«ÈýÒýºÅ£©
--¼¸ÖÖÀàÐÍ
--Numeric(10,2) Ö¸×Ö¶ÎÊÇÊý×ÖÐÍ,³¤¶ÈΪ10 СÊýΪÁ½Î»
--varcharºÍnvarcharµÄÇø±ð
--1.´Ó´æ´¢·½Ê½ÉÏ£¬nvarcharÊǰ´×Ö·û´æ´¢µÄ£¬¶ø varcharÊǰ´×Ö½ ......