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ºó£¬ÔÚʹÓÃmysqʱ£¬³öÏÖÁËÈçÏÂÎÊÌâ.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:327)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2 ......
ƽʱÎÒÃÇÔÚʹÓÃMySQLÊý¾Ý¿âµÄʱºò¾³£»áÒòΪ²Ù×÷ʧÎóÔì³ÉÊý¾Ý¶ªÊ§£¬MySQLÊý¾Ý¿â±¸·Ý¿ÉÒÔ°ïÖúÎÒÃDZÜÃâÓÉÓÚ¸÷ÖÖÔÒòÔì³ÉµÄÊý¾Ý¶ªÊ§»ò×ÅÊý¾Ý¿âµÄÆäËûÎÊÌâ¡£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆÎªÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸öMySQLÊý¾Ý¿â±¸·ÝTestA£¬²¢»Ö¸´µ½µ½hostB»úÖÐ ......
C#:
´´½¨£º
¡¡¡¡¡¡¡¡HttpCookie cookie = new HttpCookie("regID");
cookie .Value = username;
cookie .Expires = DateTime.Now.AddDays(1);
& ......
SingletonģʽµÄʵÏÖ
SingletonģʽµÄʵÏÖ»ùÓÚÁ½¸öÒªµã£º
1£©²»Ö±½ÓÓÃÀàµÄ¹¹Ô캯Êý£¬¶øÁíÍâÌṩһ¸öPublicµÄ¾²Ì¬·½·¨À´¹¹ÔìÀàµÄʵÀý¡£Í¨³£Õâ¸ö·½·¨È¡ÃûΪInstance¡£Public±£Ö¤ÁËËüµÄÈ«¾Ö¿É¼ûÐÔ£¬¾²Ì¬·½·¨±£Ö¤Á˲»»á´´½¨³ö¶àÓàµÄʵÀý¡£
2£©½«ÀàµÄ¹¹Ô캯ÊýÉèΪPrivate£¬¼´½«¹¹Ô캯Êý"Òþ²Ø"ÆðÀ´£¬ÈÎºÎÆóͼʹÓù¹Ô캯Êý´´½¨Ê ......