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

ASP.NET ²Ù×÷MySQLÊý¾Ý¿âµÄ·½·¨ËµÃ÷

using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
namespace System
{
 /// <summary>
 /// Description of MySqlDBUtil.
 /// </summary>
 public class MySqlDBUtil
 {
        private static String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString.ToString();
  private MySqlDBUtil()
  {
  }
  
  //Ö´Ðе¥Ìõ²åÈëÓï¾ä£¬²¢·µ»Øid£¬²»ÐèÒª·µ»ØidµÄÓÃExceuteNonQueryÖ´ÐС£
  public static int ExecuteInsert(string sql,MySqlParameter[] parameters)
        {
         //Debug.WriteLine(sql);
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                MySqlCommand cmd = new MySqlCommand(sql, connection);
                try
                {
                    connection.Open();
                    if(parameters!=null)cmd.Parameters.AddRange(parameters);
                    cmd.ExecuteNonQuery();
                    cmd.CommandText = @"select LAST_INSERT_ID()";
&nb


Ïà¹ØÎĵµ£º

ASP.NET 2.0»º´æ¼¼Êõ̽ÌÖ

±¾ÎĽéÉÜͨ¹ý»º´æÀ´Ìá¸ßÍøÒ³µÄÖ´ÐÐЧÂÊ¡£
¡¡¡¡1.¡¡¡¡¡¡¡¡¡¡¡¡ ASP.NET Output Caching
¡¡¡¡µ±Ò»¸öÍøÒ³Æµ·±±»·ÃÎʵÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ý°ÑÕû¸öÍøÒ³»º´æÀ´Ìá¸ßÖ´ÐÐЧÂÊ¡£ÕâÑù×÷µÄÓŵãÊÇ£¬µ±Óû§ÔٴηÃÎÊÕâ¸öÍøÒ³µÄʱºò£¬±»¸ñʽ»¯ºÃµÄHTML»á±»Ö±½ÓËÍÏÔ¡£
¡¡¡¡ÎªÊ²Ã´»á´æÔÚÕâÖÖЧ¹ûÄØ£¿ÎÒÃÇͨ¹ýASP.NETµÄ»ù±¾ÔËÐлúÖÆÀ´½âÊÍÕ ......

PHP²Ù×÷MySQLµÄº¯Êý

(1)mysql_connect(Ö÷»ú,Óû§Ãû,¿ÚÁî);
·µ»ØÒ»¸öÁ¬½ÓºÅ.
×¢Òâ:mysql¸÷Óû§µÄ¿ÚÁî¿ÉÒÔËæ¸ÃÓû§ËùÔÚ»úÆ÷IPµØÖ·²»Í¬¶ø¸Ä±ä. ÁíÍâ,mSQLûÓÐÓû§Ãû»úÖÆ,ËùÒÔmsql_connectÖ»ÐèÒªÒ»¸öÖ÷»ú²ÎÊý.Ö÷»ú¿ÉÒÔÊÇIPµØÖ·»òÓòÃû.
(2)mysql_create_db(Êý¾Ý¿âÃû);
(3)mysql_select_db(Êý¾Ý¿âÃû,Á¬½ÓºÅ);
Á¬½ÓÒ»¸öÊý¾Ý¿â.
(4)mysql_q ......

ORACLE Óë mysql µÄÇø±ð

 1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼­±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ² ......

±à¼­MYSQLʱ³ö´í£ºNo curses/termcap library found

»·¾³£ºCentOS linux 5.2
ϵͳֻ°²×°VI±à¼­Æ÷Ó뿪·¢¹¤¾ß
 
Ôڱ༭MYSQLʱ£º
#./configure --prefix=/usr/local/mysql --with-charset=gb2312  --with-extra-charsets=all 
Ö´Ðкó³öÏÖÈçÏ´íÎó£º
checking for tgetent in -ltermcap… no
checking for termcap functions library… config ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ