°ÑSqlÊý¾Ýת»»ÎªÒµÎñÊý¾ÝµÄ¼¸ÖÖ·½·¨
ORMϵͳ±ØÐë°ÑÊý¾Ý¿âÖеÄÊý¾Ýת»»ÎªÒµÎñÊý¾Ý£¬×ª»»µÄ·½·¨´óÖÂÓÐ3ÖÖ£¬±¾ÎľÍÊÔͼ¶ÔËüÃÇ×öһЩ¼òµ¥·ÖÎö¡£
1¡¢ÊôÐÔ·´Éä¡£¾ÍÊÇͨ¹ý·´É䣬»ñȡҵÎñʵÌåÀàµÄ¸÷¸öÊôÐÔ£¬È»ºóÔÙÉèÖÃÕâЩÊôÐÔµÄÖµ¡£Õâ¸ö·½·¨×î¼òµ¥¡¢×îÎȶ¨¡¢Í¨ÓÃÐÔ×îÇ¿¡¢¿Éά»¤ÐÔ×îÇ¿¡¢ÐÔÄÜ×î²î¡£ÀýÈçNHibernate¾ÍÊÇÓÃÕâÖÖ·½·¨ÊµÏֵģ¬Ëüͨ¹ýIGetterºÍISetter½Ó¿ÚʵÏÖ¶Ôij¸öÒµÎñʵÌåÀàÊôÐԵĶÁÈ¡ºÍдÈë¡£DongLiORMµÄÔçÆÚ°æ±¾Ò²ÊÇÓõÄÕâÖÖ·½·¨£¬Ëûͨ¹ýBusinessObjectµÄÊôÐÔË÷ÒýÆ÷ʵÏÖ¡£ÆäÔÀí¾ÍÊÇÊ×ÏÈͨ¹ý»ñȡij¸öÒµÎñʵÌåÀàij¸öÊôÐÔµÄPropertyInfo£¬È»ºóµ÷ÓøÃPropertyInfoµÄGetValue»òÕßSetValue·½·¨¡£ÀàËÆµÄ´úÂëÈçÏ£º
PropertyInfo info = BusinessType.GetProperty(PropertyName);
info.SetValue(this, value, null);
±ÈÈ磬ÏÖÔÚÓÐÒ»¸öÒµÎñʵÌåÀàUserItem£¬Æä¶¨ÒåÈçÏ£º
public class UserItem
{
public UserItem() { }
private string _userid;
private string _username;
private string _pwd;
private string _email;
public string UserID
{
set { _userid = value; }
get { return _userid; }
}
public string UserName
{
set { _username = value; }
get { return _username; }
}
public string Pwd
{
set { _pwd = value; }
 
Ïà¹ØÎĵµ£º
MYSQL¿ÉÒÔÔÚ¿ØÖÆÌ¨Ï½øÐвÙ×÷£¬ÀûÓÃÃüÁî
SQL´úÂë
mysql -h localhost -u root -p123456
¾Í¿ÉÒԵǽMYSQLµÄ¿ØÖÆÌ¨¡£
sql serverÒ²ÌṩÁË¿ØÖÆÌ¨ÏµIJÙ×÷¹¦ÄÜ¡£
ÔÚSQL SERVERµÄ binnĿ¼Ï£¬ÌṩÁËosql.exeÓëisql.exeÕâÁ½¸öÎļþ¡£
ÕâÁ½¸ö³ÌÐò¶¼ÌṩÁË·ÃÎÊSQL SERVERµÄ¹¦ÄÜ£¬ÕâÁ ......
¹«Ë¾×éÖ¯SQLˮƽ¿¼ÊÔ£¬¿´ÁËд½Ì²Ä£¬Ð´Á˵ã×ܽᷢÉÏÀ´¸ú´ó¼Ò·ÖÏí¡£
ÎÒ¹«Ë¾Ê¹ÓõÄÊÇSybase ASE12.5£¬ËùÒÔÏÂÃæµÄÒ»Ð©ÌØÐÔÊÇÕë¶ÔSybase ASEµÄ¡£
Ò»£ºSQL Bisic
1£ºSQL(Structured Quary Language)ÌØÐÔ£º
a£º±ê×¼»¯
b£º·Ç¹ý³Ì»¯µÄ
c£º¿ÉÓÅ»¯µÄ
d£ºÃæÏò¼¯ºÏ²Ù×÷µÄ
2£ºASEÖеÄÊý¾ÝÀàÐÍ
a£ºNumberic
b£ºCharacter
c£ºDat ......
sql serverϵͳ±íÏêϸ˵Ã÷
sysaltfiles
Ö÷Êý¾Ý¿â ±£´æÊý¾Ý¿âµÄÎļþ
syscharsets
Ö÷Êý¾Ý¿â×Ö·û¼¯ÓëÅÅÐò˳Ðò
sysconfigures
Ö÷Êý¾Ý¿â ÅäÖÃÑ¡Ïî
syscurconfigs
Ö÷Êý¾Ý¿âµ±Ç°ÅäÖÃÑ¡Ïî
sysdatabases
Ö÷Êý¾Ý¿â·þÎñÆ÷ÖеÄÊý¾Ý¿â
syslanguages
Ö÷Êý¾Ý¿âÓïÑÔ
&n ......
Ò»¸öʾÀýËÀËø
ÈÃÎÒÃÇ´ÓÕâÑùÒ»¸öʾÀý¿ªÊ¼ËµÆð£¬ËüÔÚ SQL Server 2000 ºÍ 2005 Öж¼ÄÜÒýÆðËÀËø¡£ÔÚ±¾ÎÄÖУ¬ÎÒʹÓà SQL Server 2005 µÄ×îРCTP£¨ÉçÇø¼¼ÊõÔ¤ÀÀ£¬Community Technology Preview£©°æ±¾£¬SQL Server 2005 Beta 2£¨7 Ô·¢²¼£©Ò²Í¬ÑùÊÊÓá£Èç¹ûÄúûÓÐ Beta 2 »ò×îÐ嵀 CTP °æ±¾£¬ÇëÏÂÔØ SQL Server 2005 Express µÄ ......