°Ñ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; }
 
Ïà¹ØÎĵµ£º
¹«Ë¾×éÖ¯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 ......
Ò»¡¢×Ö·ûת»»º¯Êý
1¡¢ASCII()
·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ¡£ÔÚASCII£¨£©º¯ÊýÖУ¬´¿Êý×ÖµÄ×Ö·û´®¿É²»ÓÑ’À¨ÆðÀ´£¬µ«º¬ÆäËü×Ö·ûµÄ×Ö·û´®±ØÐëÓÑ’À¨ÆðÀ´Ê¹Ó㬷ñÔò»á³ö´í¡£
2¡¢CHAR()
½«ASCII Âëת»»Îª×Ö·û¡£Èç¹ûûÓÐÊäÈë0 ~ 255 Ö®¼äµÄASCII ÂëÖµ£¬CHAR£¨£© ·µ»ØNULL ¡£
3¡¢LOWE ......
ÔÎĵØÖ·£ºhttp://www.dingos.cn/index.php?topic=1688.0
OracleÓÐrownumÓÃÓÚ·ÃÎʱíÖÐÐкš£ÄÇôÔÚSQL ServerÖÐÊÇ·ñÓеÈЧµÄÄØ£¿»òÕßÔÚSQL ServerÖÐÈçºÎÊä³öÐкţ¿
-----------------------------------
ÔÚSQL ServerÖÐûÓÐÖ±½ÓµÈЧÓÚOracleµÄrownum
-----------------------------------
Ñϸñ˵À´£¬ÔÚ¹ØÏµÊý¾Ý¿âÖУ¬± ......
ÎÒÃÇÖªµÀ£¬SQL ServerÊÂÎñÈÕÖ¾Ö÷ÒªÊÇÓÃÀ´¼Ç¼ËùÓÐÊÂÎñ¶ÔÊý¾Ý¿âËù×öµÄÐ޸ģ¬Èç¹ûϵͳ³öÏÖ¹ÊÕÏ£¬Ëü½«³ÉΪ×îÐÂÊý¾ÝµÄΨһÀ´Ô´¡£ÈÕÖ¾µÄ²Ù×÷³£ÓÐÒÔϼ¸¸öÓ¦Óãº
Ò»¡¢ÊÂÎñÈÕÖ¾ÎļþLDFµÄ¶ªÊ§
µ±ÎÒÃDz»Ð¡É¾³ý»òÕßLDFÎļþ¶ªÊ§µÄʱºò£¬Êý¾Ý¿âֻʣÏÂMDFÎļþ£¬´Ëʱֱ½Óͨ¹ý¸½¼ÓMDFÊÇÎÞ·¨»Ö¸´Êý¾Ý¿âµÄ£¬ÄÇÎÒÃÇÔõôÑù²ÅÄָܻ´Êý¾Ý¿âÄØ?Î ......