Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÔ¤´¦ÀíÓï¾ä

ÓбíÈçÏ£º
id  name  sex  brithday
1    ÕÅÈý  ÄР 1983-12
2    ÀîËÄ  ÄР 1984-11
3    ÍõÎå  Å®  1985-07
4    ÕÔ¶þ  ÄР 1986-08
Java code:

PrepareStatement sql;
sql=con.prepareStatement("select * from ta_name where id=?");
//ÏÂÃæÕâ¾ä²»¶®£¬Ö÷ÒªÊÇÊä³öÔ­Àí²»¶®
sql.setInt(1,2)


Èç¹ûÕâÀï²ÎÊý¸ÄΪsql.setInt(2,4) »òÕßʲô£¬½«»áÊä³öÊ²Ã´ÄØ£¿


Çë¸÷λ°ïæ¸ø¸ö½âÊ͹þ¡£
ллÀ²
SetInt·½·¨µÄ˵Ã÷£º
Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.

sql.setInt(1,2)µÄÒâ˼ÊÇÉèÖÃsqlµÄµÚÒ»¸ö²ÎÊý(µÚÒ»¸öÎʺÅÖµ)Ϊ2;

ÒýÓÃ
sql.setInt(1,2)µÄÒâ˼ÊÇÉèÖÃsqlµÄµÚÒ»¸ö²ÎÊý(µÚÒ»¸öÎʺÅÖµ)Ϊ2;

up
Èç¹ûÕâÀï²ÎÊý¸ÄΪsql.setInt(2,4) »òÕßʲô£¬½«»áÊä³öÊ²Ã´ÄØ£¿
´ð£º×Ô¼ºÊÔ£¬¹À¼ÆÊÇ»á³öÏÖË÷ÒýµÄÒì³£¡£

²»ÊÔ²»ÖªµÀ£¬Ò»ÊÔÒì³£×¼¿´µ½£¡


Ïà¹ØÎÊ´ð£º

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ