MySQLÊý¾Ý¿âÁ¬½ÓÀà - .NET¼¼Êõ / C#
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.Common;
using System.Collections;
using System.Collections.Specialized;
/// <summary>
/// db µÄժҪ˵Ã÷
/// </summary>
///
namespace yuqing
{
public class db
{
public db()
{
//conn = new SqlConnection(connectionString);
//conn.Open();
}
public db(string configString)
{
ConfigString = configString;
}
private string _confirString = "ConnectionString";
/**/
/// <summary>
/// ÊôÐÔ,ÉèÖÃÊý¾Ý¿âÁ¬½Ó×Ö·û´®
/// </summary>
public string ConfigString
{
get
{
return _confirString;
}
set
{
_confirString = value;
}
}
#region »ñµÃÊý¾Ý¿âµÄÀàÐÍpublic string GetProviderName(string ConfigString)
/**/
/// <summary>
/// ·µ»ØÊý¾ÝÌṩÕß<
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......
ÓÃlistviewÏÔʾ³ö´ÓÊý¾Ý¿âÖвéѯ³öµÄ¼Ç¼£¬ÏëÔÚ×îºó¼Ç¼ºóÃæÌí¼ÓÒ»ÌõºÏ¼ÆÐУ¬ÈçºÎʵÏÖ£¡Ð»Ð»´ó¼Ò£¡
°ó¶¨Êý¾ÝÄãÓ¦¸ÃûÎÊÌâ°É£¬°ó¶¨ÍêÒÔºóÓÃÒ»¸öÑ»·°ÑÄãҪͳ¼ÆÊý¾ÝµÄÁÐÖеÄÊý¾Ý×ܺÍÓÃÒ»¸ö±äÁ¿½ÓÊÜ£¬È»ºóÔÚÑ»·ÍâÃæne ......