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

C#Á¬½ÓmysqlÊý¾Ý¿â

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string mySqlConnectionString="Database=newdb;Data Source=localhost;User Id=root;Password=";
using (MySqlConnection myCon = new MySqlConnection(mySqlConnectionString))
{
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Test(uid,regdate,remark) values(@uid,curdate(),@remark)", myCon))
{
cmd.Parameters.Add(new MySqlParameter("@uid",this.TextBox1.Text.Trim()));
cmd.Parameters.Add(new MySqlParameter("@remark",this.TextBox2.Text.Trim()));
myCon.Open();
if(cmd.ExecuteNonQuery()==1)
{
Response.Write("<mce:script type="text/javascript"><!--
alert('³É¹¦Ìí¼ÓÁËÒ»Ìõ¼Ç¼')
// --></mce:script>");
}
else
{
Response.Write("<mce:script type="text/javascript"><!--
alert('Ìí¼Óʧ°Ü£¡£¡£¡')
// --></mce:script>");
}
}
}
}
}


Ïà¹ØÎĵµ£º

mysqlÖÐIN×Ó²éѯÅÅÐò

Õ⼸Ìì×öÒ»¸ö²éѯ£¬ÐèÒªÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖнøÐвéѯ£¬ÀýÈ磺
select * from table_name where doc_id IN ('1dba', 'c20a', '907b')
ÆäÖÐIN×Ó¾äÖеÄdoc_idÁбíÊÇͨ¹ýµ÷ÓÃÒ»¸öÍⲿ½Ó¿Ú»ñµÃÒ»×édoc_id³£Á¿ÁÐ±í£¬È»ºóÔÚ±¾µØ¿âÖÐËÑË÷·ûºÏÕâ¸öÁбíµÄÊý¾Ý
¼Ç¼¡£ºóÀ´·¢ÏÖmysql·µ»ØµÄ½á¹û¼¯µÄÅÅÐòÊǰ´ÕÕÈë¿â˳Ðò¸ø³öµÄ£¬µ«ÊÇÎÒ ......

C# µ¥ÊµÀýÉè¼ÆÄ£Ê½

SingletonģʽµÄʵÏÖ
SingletonģʽµÄʵÏÖ»ùÓÚÁ½¸öÒªµã£º
1£©²»Ö±½ÓÓÃÀàµÄ¹¹Ô캯Êý£¬¶øÁíÍâÌṩһ¸öPublicµÄ¾²Ì¬·½·¨À´¹¹ÔìÀàµÄʵÀý¡£Í¨³£Õâ¸ö·½·¨È¡ÃûΪInstance¡£Public±£Ö¤ÁËËüµÄÈ«¾Ö¿É¼ûÐÔ£¬¾²Ì¬·½·¨±£Ö¤Á˲»»á´´½¨³ö¶àÓàµÄʵÀý¡£
2£©½«ÀàµÄ¹¹Ô캯ÊýÉèΪPrivate£¬¼´½«¹¹Ô캯Êý"Òþ²Ø"ÆðÀ´£¬ÈÎºÎÆóͼʹÓù¹Ô캯Êý´´½¨Ê ......

phpѧϰ±Ê¼Ç£¨10£©:MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä

MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT  ²éѯ×ֶΠfrom ±íÃû WHERE Ìõ¼þ 
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ