sql ÎÊÌâ
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"
ÕâÑùдÓÐÎÊÌâÂð£¬StartTime, EndTimeÔÚÊý¾Ý¿âÖÐÊÇdatetimeÀàÐÍ
ÓÃmessagebox('',sql)³öÀ´¿´¿´¾ÍÖªµÀÁ˰¡
µ÷ÊÔÏ¿´¿´¾ÍÐС£whereǰ¼Ó¸ö¿Õ¸ñ£¬where×Ö¾äÖпոñÈ¥µô£¬ ʱ¼äÓà '2009-1-1' £¬×¢Ò⣬'£¬'ÐèҪתÒå¡£
×îºÃµÄ辦·¨ÊÇÓÃmessagebox³ö來¿´Ò»Ï£¬SQL語¾äÓÐ沒問題¡£
ÓÃstringÊÔÊÔ
string startTime,endTime
startTime=em_1.Text
endTime=em_2.Text
string sql
sql = dw_1.GetSQLSelect()+" Where (StartTime> '"+startTime+"') and (EndTime < '"+endTime+"')"
Èç¹ûÄãÊÇÓÃÀ´¸ù¾Ýʱ¼ä²éѯ¼Ç¼µÄ»°
ls_select = "(convert(char(10),em_work.work_date,120) >= '" +ls_begin+ "') and (convert(char(10),em_work.work_date,120) <= '" + ls_end + "')"
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º
An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48: ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
»ìSQL°æÕâô¾ÃÁË£¬·ÖÏíÒ»µã×ÊÁÏ
sql serverµÄÏà¹ØÈÏÖ¤µÄÊÔÌ⼯ºÏ£¬°æÓÑÓл¹ÔÚѧУµÄ»°¾ÍÏÂÔØÏÂÀ´Óлú»á¿¼ÊÔһϣ¬±Ï¾¹350Ôª´ó¼Ò»¹ÊǸºµ£µÃÆðµÄ£¬½«À´±ÏÒµºóÒ²ÊÇÒ»¸öºÃÒ»µãµÄÖ¤ÊéÖ¤Ã÷
Èç¹û×¼±¸×¨×¢ÓÚÕâ ......