SQL code:
insert into NewsInfo (title,date,author,sourse,contents)
values ('bbb','bbb','bbb','bbb','Õ¹ÀÀʱ¼äÉϺ£Ð¹ú¼Ê²©ÀÀÖÐÐÄ'ÉϺ£ÊÐÁúÑô·2345ºÅ'')
³ÌÐòÖиÃÔõô¸Ä
¼Ó\'
insert into NewsInfo (title,date,author,sourse,contents)
values ('bbb','bbb','bbb','bbb','Õ¹ÀÀʱ¼äÉϺ£Ð¹ú¼Ê²©ÀÀÖÐÐÄ''ÉϺ£ÊÐÁúÑô·2345ºÅ''')
2¸öµ¥Òý
insert into NewsInfo (title,date,author,sourse,contents)
values ('bbb','bbb','bbb','bbb','Õ¹ÀÀʱ¼äÉϺ£Ð¹ú¼Ê²©ÀÀÖÐÐÄ\'ÉϺ£ÊÐÁúÑô·2345ºÅ\'')
SQL code:
sql = string.Format("insert into NewsInfo (title,date,author,sourse,contents)"
+ "values ('" + info.Title + "','" + info.Date + "','" + info.Author + "','" + info.Sourse + "','" + info.Contents + "')");
¾Í¼ÓÕâÀïÃæ£¿
SQL code:
sql = string.Format("insert into NewsInfo (title,date,author,sourse,contents)"
+ "values ('" + \info.Title\ + "','" + \info.Date\ + "','" + \info.Author\ + "','" + \info.Sourse\ + "','" + \info.Contents\ + "')");
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......