תÌû£º¾²Ì¬ÀàºÍ¾²Ì¬Àà³ÉÔ±£¨C# ±à³ÌÖ¸ÄÏ£©
ÔÎĵØÖ·£ºhttp://msdn.microsoft.com/zh-cn/library/79b3xss3(VS.80).aspx
¾²Ì¬ÀàºÍÀà³ÉÔ±ÓÃÓÚ´´½¨ÎÞÐè´´½¨ÀàµÄʵÀý¾ÍÄܹ»·ÃÎʵÄÊý¾ÝºÍº¯Êý¡£¾²Ì¬Àà³ÉÔ±¿ÉÓÃÓÚ·ÖÀë¶ÀÁ¢ÓÚÈκζÔÏó±êʶµÄÊý¾ÝºÍÐÐΪ£ºÎÞÂÛ¶ÔÏó·¢Éúʲô¸ü¸Ä£¬ÕâЩÊý¾ÝºÍº¯Êý¶¼²»»áËæÖ®±ä»¯¡£µ±ÀàÖÐûÓÐÒÀÀµ¶ÔÏó±êʶµÄÊý¾Ý»òÐÐΪʱ£¬¾Í¿ÉÒÔʹÓþ²Ì¬Àà¡£
¾²Ì¬Àà
Àà¿ÉÒÔÉùÃ÷Ϊ static µÄ£¬ÒÔָʾËü½ö°üº¬¾²Ì¬³ÉÔ±¡£²»ÄÜʹÓà new ¹Ø¼ü×Ö´´½¨¾²Ì¬ÀàµÄʵÀý¡£¾²Ì¬ÀàÔÚ¼ÓÔØ°üº¬¸ÃÀàµÄ³ÌÐò»òÃüÃû¿Õ¼äʱÓÉ .NET Framework ¹«¹²ÓïÑÔÔËÐпâ (CLR) ×Ô¶¯¼ÓÔØ¡£
ʹÓþ²Ì¬ÀàÀ´°üº¬²»ÓëÌØ¶¨¶ÔÏó¹ØÁªµÄ·½·¨¡£ÀýÈ磬´´½¨Ò»×é²»²Ù×÷ʵÀýÊý¾Ý²¢ÇÒ²»Óë´úÂëÖеÄÌØ¶¨¶ÔÏó¹ØÁªµÄ·½·¨ÊǺܳ£¼ûµÄÒªÇó¡£ÄúÓ¦¸ÃʹÓþ²Ì¬ÀàÀ´°üº¬ÄÇЩ·½·¨¡£
¾²Ì¬ÀàµÄÖ÷Òª¹¦ÄÜÈçÏ£º
ËüÃǽö°üº¬¾²Ì¬³ÉÔ±¡£
ËüÃDz»Äܱ»ÊµÀý»¯¡£
ËüÃÇÊÇÃÜ·âµÄ¡£
ËüÃDz»Äܰüº¬ÊµÀý¹¹Ô캯Êý£¨C# ±à³ÌÖ¸ÄÏ£©¡£
Òò´Ë´´½¨¾²Ì¬ÀàÓë´´½¨½ö°üº¬¾²Ì¬³ÉÔ±ºÍ˽Óй¹Ô캯ÊýµÄÀà´óÖÂÒ»Ñù¡£Ë½Óй¹Ô캯Êý×èÖ¹À౻ʵÀý»¯¡£
ʹÓþ²Ì¬ÀàµÄÓŵãÔÚÓÚ£¬±àÒëÆ÷Äܹ»Ö´Ðмì²éÒÔÈ·±£²»ÖÂżȻµØÌí¼ÓʵÀý³ÉÔ±¡£±àÒëÆ÷½«±£Ö¤²»»á´´½¨´ËÀàµÄʵÀû¡£
¾²Ì¬ÀàÊÇÃÜ·âµÄ£¬Òò´Ë²»¿É±»¼Ì³Ð¡£¾²Ì¬À಻Äܰüº¬¹¹Ô캯Êý£¬µ«ÈÔ¿ÉÉùÃ÷¾²Ì¬¹¹Ô캯ÊýÒÔ·ÖÅä³õʼֵ»òÉèÖÃij¸ö¾²Ì¬×´Ì¬¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û¾²Ì¬¹¹Ô캯Êý£¨C# ±à³ÌÖ¸ÄÏ£©¡£
ºÎʱʹÓþ²Ì¬Àà
¼ÙÉèÓÐÒ»¸öÀà CompanyInfo£¬Ëü°üº¬ÓÃÓÚ»ñÈ¡Óйع«Ë¾Ãû³ÆºÍµØÖ·ÐÅÏ¢µÄÏÂÁз½·¨¡£
class CompanyInfo
{
public string GetCompanyName() { return "CompanyName"; }
public string GetCompanyAddress() { return "CompanyAddress"; }
//...
}
²»ÐèÒª½«ÕâЩ·½·¨¸½¼Óµ½¸ÃÀàµÄ¾ßÌåʵÀý¡£Òò´Ë£¬Äú¿ÉÒÔ½«ËüÉùÃ÷Ϊ¾²Ì¬À࣬¶ø²»ÊÇ´´½¨´ËÀàµÄ²»±ØÒªÊµÀý£¬ÈçÏÂËùʾ£º
static class CompanyInfo
{
public static string GetCompanyName() { return "CompanyName"; }
public static string GetCompanyAddress() { return "CompanyAddress"; }
//...
}
ʹÓþ²Ì¬Àà×÷Ϊ²»ÓëÌØ¶¨¶ÔÏó¹ØÁªµÄ·½·¨µÄ×éÖ¯µ¥Ôª¡£´ËÍ⣬¾²Ì¬ÀàÄܹ»Ê¹ÄúµÄʵÏÖ¸ü¼òµ¥¡¢Ñ¸ËÙ£¬ÒòΪÄú²»±Ø´´½¨¶ÔÏó¾ÍÄܵ÷ÓÃÆä·½·¨¡£ÒÔÒ»ÖÖÓÐÒâÒåµÄ·½Ê½×éÖ¯ÀàÄÚ²¿µÄ·½·¨£¨ÀýÈç System ÃüÃû¿Õ¼äÖÐµÄ Math ÀàµÄ·½·¨£©ÊǺÜ
Ïà¹ØÎĵµ£º
ÔÚrootÕ˺ÅÖÐ,¿ÉÒÔÕý³£µ÷Óô洢¹ý³Ì.
»»µ½common_userÕ˺Åʱ,ͬһ´æ´¢¹ý³ÌÃûµ÷ÓóöÏÖÎÊÌâ.
×·×Ùµ÷ÊÔʱ³öÏÖ:
SELECT command denied to user 'common_user'@'localhost' for table 'proc'
ËÑË÷½â¾ö·½°¸:
MySqlConnection myconnection = new MySqlConnection("server=localhost;user id=common_user; password=***;dat ......
public partial class shujuku_huanyuan : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(@"server=HUAZD-33\XXD33;uid=sa;pwd=111111;database=master;");
protected void Page_Load(object sender, EventArgs e)
&nbs ......
ÔÚASP.NetÒ»°ãµÄ³ÌÐò±àдÖУ¬ËùʹÓõÄÊý¾ÝÀïÃæ£¬ÈÕÆÚʱ¼äÊÇÒ»ÖÖÌØÊâµÄÊý¾ÝÀàÐÍ£¬Ò²ÊǾ³£±»Ê¹Óõġ£---µçÄԽ̳̼¼ÊõÑ§Ï°Íø
ÔÚVisual Basic.NETÖеÄÈÕÆÚʱ¼äÊý¾ÝÓÃÊýÖµµÄÊý¾ÝÀàÐͱ£´æ£¬¶øÇÒÓз¶Î§¡£
ÈÕÆÚµÄ·¶Î§Êǹ«Ôª1Äê1ÔÂ1ÈÕ¡«¹«Ôª9999Äê1 2ÔÂ3 1ÈÕ£¬Ê±¼äµÄ·¶Î§ÊÇ00£º00£º00¡«23£º59£º59¡£ÉùÃ÷¸ñÊ½È ......
Ìí¼ÓÒýÓÃ
using System.Data.OracleClient;
Ö÷ÒªÓõ½ÁËÁ½¸öÀà
System.Data.OracleClient.OracleConnection ±íʾһ¸öµ½Êý¾Ý¿âµÄÁ¬½Ó¡£´ËÀàÎÞ·¨¼Ì³Ð¡£
System.Data.OracleClient.OracleCommand ±íʾÕë¶ÔÊý¾Ý¿âÖ´ÐÐµÄ SQL Óï¾ä»ò´æ ......
´ÓContainerControlÀà¼Ì³ÐµÄ×ÓÀà×÷ΪÈÝÆ÷´°Ì壬¿ÉÒÔÈÝÄɳýFormÀà¶ÔÏóÍâµÄÆäÓà´°Ìå¶ÔÏó¡£
ÔÚËùÓÐÈÝÆ÷´°ÌåÄÚ£¬×î»ù±¾µÄ¾ÍÊǶ¥¼¶ÈÝÆ÷FormÀàÒÔ¼°Ãæ°åÈÝÆ÷PanelÀà¡£ÕâÁ½ÕßµÄÖ÷񻂿±ðΪ£ºÇ°Õß¾ßÓÐWindows±ê×¼¿ò¼Ü£¨±êÌâÀ¸£¬×î´ó»¯¡¢×îС»¯ºÍ¹Ø±Õ°´Å¥£¬´°Ìå±ß¿ò£¬¿Éµ÷Õû³ß´ç£©£¬²¢ÇÒ¿ÉÒÔ¶ÀÁ¢´æÔÚ£»ºóÕßÖ»ÊÇÒ»¿éÇøÓò£¬²¢ÇÒ±ØÐëÒÀ¸½ ......