asp.netÁ¬½ÓmysqlÊý¾Ý¿â
MysqlµÄconnector/net5.0ÏÂÔØµØÖ·:
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.6.zip/from/pick
°²×°ºÃÒÔºó,
µãÊôÐÔ,È»ºóµã²éÕÒÄ¿±ê,µãÏòÉÏÒ»²ãĿ¼,ÕÒµ½Binaries\.NET 2.0,È»ºó½«Õâ¸öÎļþ¸´ÖƵ½ÄãµÄ¹¤³ÌĿ¼ÏÂ,Ò»°ãÕâÑùµÄDLLÎļþ»á±£´æµ½binĿ¼ÏÂ.
ÔÚ´úÂëÒ³ÀïÊäÈëusing Mysql.Data.MysqlClient;È»ºóÔÙÔÚPage_Loadº¯ÊýÀïдMysqlConnection£¬ÔÚµ¥´Êдµ½Ò»°ëʱÌáʾ¾Í³öÀ´ÁË£¬ÏÂÃæµÄ¾Í²»ÓÃдÁ˰É?¶¼ÒѾ³öÏÖ”´úÂëÖÇÄÜÍê³ÉÁË”,Ëæ±ãдһ¶Î´úÂëÊÔÊԾͿÉÒÔÁË,ºÍSqlserverÍêÈ«ÏàËÆ.
ÏÂÃæÌṩÁ½¶Î´úÂ빩²Î¿¼,Ò»¸ö´úÂëÒ³
default2.aspx.csϵĴúÂ룺
C#´úÂë
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string query = "select * from guestbook";
MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=guestbook");
MySqlCommand myCommand=new MySqlCommand(query,myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string bookres="";
while (myDataReader.Read()==true)
{
bookres+=myDataReader["id"];
bookres+=myDataReader["user"];
bookres += myDataReader["pass"];
}
myDataReader.Close();
myConnection.Close();
lb1.Text = bookres;
}
}
1¡¢ÏÂÔØMySQLÊý¾Ý¿â£¬µØÖ·£ºhttp://www.mysql.com/£¬´óСֻÓм¸Ê®¸öÕ×¶øÒÑ£¬°²×°ºÜ·½±ã£¬½ÓÌáʾ¼´¿É¡£
2¡¢MySQL°²×°ºóĬÈÏÊÇûÓпͻ§¶Ë¹¤¾ßµÄ(ÏñSQLServerµÄÆóÒµ¹ÜÀíÆ÷£¬²éѯ·ÖÎöÆ÷µÈ)£¬Ö»ÊÇÒ»¸ö·þÎñÆ÷´æ´¢Êý¾Ý£¬ÎªÁË·½±ãÄãÒªÔÙÏÂÔØÒ»¸ö¿Í»§¶Ë¹¤¾ß£¬ÓÐºÜ¶à£¬ÍÆ¼öʹÓÃSQL Manager for MySQL£¬¼ò½àСÇÉ£¬¹¦ÄÜҲǿ´ó¡£ÏÂÔØ£ºhttp://www.sqlmanager.net/en/products/mysql/manager/download
3¡¢ASP.NETÁ¬½ÓMySQLÐèÒªÒ»¸ö×é¼þ(.net±¾Éí²»Ìṩ·ÃÎÊMySQLµÄÇý
Ïà¹ØÎĵµ£º
½üÀ´¶Ôphp±È½Ï¸ÐÐËȤ£¬¾Í¶Ï¶ÏÐøÐøµÄ»¨ÁËÁ½¸öÐÇÆÚµÄʱ¼ä°ÑÕû¸öphp¿ª·¢ÐèÒªÓõ½µÄ¶«Î÷¶¼×°ºÃÁË£¬´ó¸ÅµÄ°²×°¹ý³ÌÈçÏ¡£
Ò»¡¢°²×°µÄÈí¼þ:
Apache: 2.2.14
PHP:5.2.12
MySQL:5.1.42¡£
SVN:1.5.6
PHPMyAdmin:3.2.5
Zend Studio: 7.1
Zend Debugger: 5.1.14
¶þ¡¢°²×°¹ý³Ì£º
1. °²×°ºÍÅäÖÃapache
°²×°£ºÊ×ÏÈ´Óhttp://apa ......
ÍøÕ¾µÄÖØ¶¨Ïò£¬Í¨³£ÓõÄÓÐ 301 ºÍ 302£¬301ÊÇÓÀ¾ÃÖØ¶¨Ïò£¬ÊǶÔSEOÓѺõģ¬ÓÐÀûÓÚ±£³ÖÔÓòÃûºÍÐÂÓòÃûÖ®¼äµÄPR×ªÒÆ¼°Á÷Á¿Êý¾ÝµÈ¡£
Asp.Net ÖÐʵÏÖ301ÖØ¶¨ÏòµÄ´úÂ룬ҲÊDZȽϼòµ¥µÄ£¬¾Ù¸öÀý×Ó£º
ÔÀ´µÄÓòÃûÊÇ www.abc.com, ÏÖÔÚÒª½«¶ÔÕâ¸öÓòÃûµÄ·ÃÎÊ£¬È«²¿Öض¨Ïòµ½ www.zu14.cn;
Ö»ÐèÔÚ ÐèҪתÏòµÄÒ³ÃæÀ
protected void ......
1. µ±²»ÐèҪʹÓÃSessionµÄʱºòÇë¹Ø±Õ
¹Ø±ÕSessionµ±²»ÐèҪʹÓõÄʱºò
• ÈôÒª½ûÓÃÒ³µÄ»á»°×´Ì¬£¬Ç뽫@ Page Ö¸ÁîÖеÄEnableSessionState ÊôÐÔÉèÖÃΪfalse¡£ÀýÈ磬 <%@ Page EnableSessionState="false" %>¡£
• ×¢ÒâÈç¹ûÒ³ÐèÒª·ÃÎʻỰ±äÁ¿£¬µ«²»´òËã´´½¨»òÐÞ¸ÄËüÃÇ£¬Ôò½« ......
PerlÖÐDBI¡¢DBD::mysqlÄ£¿éµÄ°²×°
ʹÓõÄÈí¼þ°æ±¾
DBI-1.604.tar.gz
DBD-mysql-4.006.tar.gz
½¨ÒéʹÓÃÒÔÉϰ汾´îÅ䣬·ñÔò¿ÉÄÜÁ¬½Ómysql´íÎó
Ò»¡¢DBIµÄ°²×°
wget http://www.cpan.org/modules/by-module/DBD/DBI-1.604.tar.gz
tar -zxvf DBI-1.604.tar.gz
cd DBI-1.604
perl Makefile.PL ......
1.²é¿´MySQL·ÖÇø±íµÄÖ´Ðмƻ®:
×¢Òâ:¶ÔMySQL·ÖÇø±í°´·ÖÇø²éѯ,²»ÓÃÏñOracleÄÇÑù,ÔÚSQLÖÐÌí¼Ó“PARTITION”×Ö·û´®¡£
Ìáʾ£ºÊ¹Ó÷ÖÇø¹¦ÄÜÖ®ºó£¬Ïà¹Ø²éѯ×îºÃ¶¼ÓÃEXPLAIN PARTITIONS¹ýÒ»±é£¬È·ÈÏ·ÖÇøÊÇ·ñÉúЧ¡£ÀýÈç:
EXPLAIN PARTITIONS SELECT * from tab_test WHERE created = '2008-01-02';
2.²é¿´MySQLÆÕͨ± ......