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>");
}
}
}
}
}
Ïà¹ØÎĵµ£º
À©Õ¹±ê¼ÇÓïÑÔXML£¨eXtensible Markup Language£©£¬ÊÇÓÉW3C×éÖ¯ÖÆ¶¨µÄ¡£×öΪÓÃÓÚÌæ´úHTMLÓïÑÔµÄÒ»ÖÖÐÂÐ͵ıê¼ÇÓïÑÔ£¬XMLÄÚ²¿ÓÐןܶà»ù±¾±ê×¼£¬XML¾ÍÊÇͨ¹ýÓëÕâЩÏà¹Ø±ê×¼µØ½áºÏ£¬Ó¦ÓÃÓÚ¿ÆÑ§¼ÆËã¡¢µç×Ó³ö°æ¡¢¶àýÌåÖÆ×÷ºÍµç×ÓÉÌÎñµÄ¡£C££×÷ΪһÖÖÐÂÐ͵ijÌÐòÓïÑÔ£¬ÊÇ.Net¿ò¼ÜµÄÒ»¸öÖØÒª×é³É²¿·Ö£¬ËûºÍXMLµÄ¹ØÏµÆÄÉî¡£±¾ÎÄ¾Í´Ó ......
SingletonģʽµÄʵÏÖ
SingletonģʽµÄʵÏÖ»ùÓÚÁ½¸öÒªµã£º
1£©²»Ö±½ÓÓÃÀàµÄ¹¹Ô캯Êý£¬¶øÁíÍâÌṩһ¸öPublicµÄ¾²Ì¬·½·¨À´¹¹ÔìÀàµÄʵÀý¡£Í¨³£Õâ¸ö·½·¨È¡ÃûΪInstance¡£Public±£Ö¤ÁËËüµÄÈ«¾Ö¿É¼ûÐÔ£¬¾²Ì¬·½·¨±£Ö¤Á˲»»á´´½¨³ö¶àÓàµÄʵÀý¡£
2£©½«ÀàµÄ¹¹Ô캯ÊýÉèΪPrivate£¬¼´½«¹¹Ô캯Êý"Òþ²Ø"ÆðÀ´£¬ÈÎºÎÆóͼʹÓù¹Ô캯Êý´´½¨Ê ......
תÌûÇë×¢Ã÷³ö´¦£¬²¢±£³ÖÎÄÕµÄÍêÕûÐÔ¡£
¶ÔMySQLÊý¾Ý¿âÀ´Ëµ£¬Í¬Ò»Ê±¿Ì£¬ÔÚͬһ¸öÁ¬½Ó£¨connection£©ÉÏ£¬Ö»ÔÊÐí½øÐÐÒ»¸ö²Ù×÷£¨query£¬etc.£©£¬Èç¹ûÄãµÄ³ÌÐòÊǶàÏ̵߳쬲¢ÇÒÄãÔÚ¶à¸öÏß³ÌÖж¼»áÀûÓÃͬһ¸öconnection¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÄÇô£¬¾ÍÓпÉÄÜ·¢ÉúÎÊÌâ¡£
ÀýÈ磬Äã¿ÉÄÜ»áÊÕµ½“Commands out of sync”µÄ´íÎó ......
1¡¢phpÓëmysql½¨Á¢Á¬½Ó
php.ini ¼ÓÔØmysql×é¼þ
extension=php_mysql.dllǰµÄ;È¥µô
exetension_dir=""·¾¶ÊÇ·ñÕýÈ·
PhpÁ¬½Ómysqlº¯Êý
mysql_connect:¿ªÆôMYSQLÁ¬½Ó
mysql_select_dir:´ò¿ªÒ»¸öÊý¾Ý¿â
@ºÍor die Òþ²Ø´íÎóºÍÌõ¼þÏÔʾ
mysql_connect("Ö÷»ú","Óû§Ãû","ÃÜÂë");
mysql_sele ......