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) »òÕßʲô£¬½«»áÊä³öÊ²Ã´ÄØ£¿ ´ð£º×Ô¼ºÊÔ£¬¹À¼ÆÊÇ»á³öÏÖË÷ÒýµÄÒì³£¡£ ²»ÊÔ²»ÖªµÀ£¬Ò»ÊÔÒì³£×¼¿´µ½£¡
Ïà¹ØÎÊ´ð£º
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True"); ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......