Moon.ORM--最便捷轻盈的ORM 之{数据库操作全面解析(含有DEMO,代码生成器)}

下载代码生成器(库也在代码生成器的根目录中)
/Files/humble/Debug.zip
(顺便说说MOON相对其他ORM的优势:
http://www.cnblogs.com/humble/archive/2012/04/08/2437778.html
)
找到配置文件进行配置(实际项目中也一样).
配置默认的系统数据库类型(
各类数据库的配置)

MYSQL的配置

http://www.mysql.com/downloads/mirror.php?id=406542 mysql 2.0下载地址

Sqlite的配置

PostgreSql的配置

MSSQL的配置
给大家一个全配置,到时候好引用,记住只要其中一种类型
<appSettings>
        
        <add key="Password" value="sqlite的密码,只有sqlite设置了密码时才需要此节点"/>
        <add key="dbType" value="SQLITE" />
        <add key="linkString" value="c:/a.db" />
        
        <add key="dbType" value="MSSQL" />
        <add key="linkString" value="Server=www.eee.com.cn;Database=hd01systemdb_new;uid=db;Password=mingyue1;" />
        
        <add key="dbType" value="MYSQL" />
        <add key="MYSQL_PATH" value="c:\MySql.Data.dll" />
        <add key="linkString" value="Server=localhost;Database=MoonDB;Uid=root;Pwd=root;" />
        
        <add key="dbType" value="PostgreSql" />
        <add key="linkString" value="Server=localhost;Database=MoonDB;User ID=postgres;Password=mingyue;" />
    </appSettings>
运行代码生成器,以MYSQL为例.(注意此架构必须要有主键.且唯一的主键,非符合主键)

给大家看看数据库结构
项目配置文件

        <add key="dbType" value="MYSQL" />
        <add key="MYSQL_PATH" value="c:\MySql.Data.dll" />
        <add key="linkString" value="Server=localhost;Database=MoonDB;Uid=root;Pwd=root;
;Charset=gb2312;
" />
用代码生成器生成实体层. 加入你要做的项目中.(可以把这段代码复制到项目中,也可以编译引用)

using System;
using Moon.Orm;
using System.Collections.Generic;
namespace MoonDB{
public class recordset:EntityBase{
    public recordset():base(){
    SetEntityName("`recordset`");
    SetFieldsCount(3);
    SetPrimaryField(recordsetTable.RecordID);
    SetIsSystemSetPrimaryKey(true);
    }
    private Int64  _RecordID;
    public Int64 RecordID{
    get{return _RecordID;}
    set{
        _RecordID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`RecordID`")==false)
            {this.FieldsChangedDictionary.Add("`RecordID`",value);}
}
    }
    private Int64  _UserID;
    public Int64 UserID{
    get{return _UserID;}
    set{
        _UserID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`UserID`")==false)
            {this.FieldsChangedDictionary.Add("`UserID`",value);}
}
    }
    private String  _Sumary;
    public String Sumary{
    get{return _Sumary;}
    set{
        _Sumary=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Sumary`")==false)
            {this.FieldsChangedDictionary.Add("`Sumary`",value);}
}
    }
}

public class recordsetTable{
    public static readonly Field RecordID=new Field("`RecordID`",true);
    public static readonly Field UserID=new Field("`UserID`",false);
    public static readonly Field Sumary=new Field("`Sumary`",false);
    static recordsetTable(){
        RecordID.TableName="`recordset`";
        UserID.TableName="`recordset`";
        Sumary.TableName="`recordset`";
    }
}

public class userset:EntityBase{
    public userset():base(){
    SetEntityName("`userset`");
    SetFieldsCount(4);
    SetPrimaryField(usersetTable.ID);
    SetIsSystemSetPrimaryKey(true);
    }
    private String  _UserName;
    public String UserName{
    get{return _UserName;}
    set{
        _UserName=value;
        if (this.FieldsChangedDictionary.ContainsKey("`UserName`")==false)
            {this.FieldsChangedDictionary.Add("`UserName`",value);}
}
    }
    private Int32  _Age;
    public Int32 Age{
    get{return _Age;}
    set{
        _Age=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Age`")==false)
            {this.FieldsChangedDictionary.Add("`Age`",value);}
}
    }
    private Int64  _ID;
    public Int64 ID{
    get{return _ID;}
    set{
        _ID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`ID`")==false)
            {this.FieldsChangedDictionary.Add("`ID`",value);}
}
    }
    private String  _Address;
    public String Address{
    get{return _Address;}
    set{
        _Address=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Address`")==false)
            {this.FieldsChangedDictionary.Add("`Address`",value);}
}
    }
}

public class usersetTable{
    public static readonly Field UserName=new Field("`UserName`",false);
    public static readonly Field Age=new Field("`Age`",false);
    public static readonly Field ID=new Field("`ID`",true);
    public static readonly Field Address=new Field("`Address`",false);
    static usersetTable(){
        UserName.TableName="`userset`";
        Age.TableName="`userset`";
        ID.TableName="`userset`";
        Address.TableName="`userset`";
    }
}

}

实际项目

最后一步进行开发.

using System;
using System.Collections.Generic;
using System.Data;
using MoonDB;
using Moon.Orm;

namespace Test
{
    class Program
    {
        public static void Main(string[] args)
        {
            userset user=new userset();
            user.Age=12;
            user.UserName="qsmy12345"+DateTime.Now.Ticks;
            user.Address=user.UserName;
            object newID=DBFactory.Add(user);
            Console.WriteLine();
            Console.WriteLine(user.GetOnlyMark());
            user.Address=DateTime.Now+"a秦仕川a";
            DBFactory.Update(user);
            string name=DBFactory.GetOneField<string>(usersetTable.Address,usersetTable.ID.Equal(newID));
            List<userset> list=DBFactory.GetEntities<userset>(usersetTable.ID.BiggerThan(0));
            Console.WriteLine(list[0].Address);
            Console.Read();

        }
    }
}

MYSQL.sql文件,自己还原下载

View Code

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `new_view` (
  `id` bigint(20),
  `username` varchar(50)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recordset` (
  `RecordID` bigint(20) NOT NULL AUTO_INCREMENT,
  `UserID` bigint(20) NOT NULL,
  `Sumary` varchar(1000) NOT NULL,
  PRIMARY KEY (`RecordID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userset` (
  `UserName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Age` int(11) DEFAULT NULL,
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `Address` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `userset` VALUES ('qsmy其实',12,1,NULL),('qsmy其实11',12,2,NULL),('qsmy其实11',12,3,NULL),('qsmy其实11',12,4,NULL),('qsmy其实11',12,5,NULL),('qsmy其实11',12,6,NULL),('qsmy其实11',12,7,NULL),('qsmy其实11',12,8,NULL),('qsmy其实11',12,9,NULL),('qsmy其实11',12,10,NULL),('qsmy其实11',12,11,NULL),('qsmy其实11',12,12,NULL),('qsmy其实11',12,13,NULL),('qsmy其实11',12,14,NULL),('qsmy其实11',12,15,NULL),('qsmy其实11',12,16,NULL),('qsmy其实11',12,17,NULL),('qsmy其实11',12,18,NULL),('qsmy其实11',12,19,NULL),('qsmy其实11',12,20,NULL),('qsmy其实11',12,21,NULL),('qsmy其实11',12,22,NULL),('qsmy其实11',12,23,NULL),('dd',123,24,NULL),('dd',123,25,NULL),('dd',123,26,NULL),('dd',123,27,NULL),('dd',123,28,NULL),('dd',123,29,NULL),('dd',123,30,NULL),('dd',123,31,NULL),('dd',123,32,NULL),('dd',123,33,NULL),('dd',123,34,NULL),('dd',123,35,NULL),('dd',123,36,NULL),('dd',123,37,NULL),('dd',123,38,NULL),('dd',123,39,NULL),('dd',123,40,NULL),('dd',123,41,NULL),('dd',123,42,NULL),('dd',123,43,NULL),('dd',123,44,NULL),('dd',123,45,NULL),('dd',123,46,NULL),('aaa',11,47,NULL),('aaa',11,48,NULL),('aaa',11,49,NULL),('aaa',11,50,NULL),('aaa',11,51,NULL),('aaa',11,52,NULL),('aaa',11,53,NULL),('aaa',11,54,NULL),('qsmy12345',12,55,NULL),('qsmy12345634694104416406250',12,56,NULL),('qsmy12345634694105064218750',12,57,NULL),('2012-4-7 15:49:36???',12,58,NULL),('2012-4-7 15:52:45???',12,59,NULL),('2012-4-7 15:54:34???',12,60,NULL),('2012-4-7 15:55:01???',12,61,NULL),('2012-4-7 15:56:44???',12,62,NULL),('2012-4-7 15:57:56a???a',12,63,NULL),('2012-4-7 16:00:46a???a',12,64,'qsmy12345634694112457343750'),('qsmy12345634694113184531250',12,65,'2012-4-7 16:01:59a???a'),('qsmy12345634694114936718750',12,66,'2012-4-7 16:04:54a秦仕川a'),('qsmy12345634694115219687500',12,67,'2012-4-7 16:05:22a秦仕川a'),('qsmy12345634694115920781250',12,68,'2012-4-7 16:06:32a秦仕川a'),('qsmy12345634694116243125000',12,69,'2012-4-7 16:07:05a秦仕川a'),('qsmy12345634694116477187500',12,70,'2012-4-7 16:07:28a秦仕川a'),('qsmy12345634694117010468750',12,71,'2012-4-7 16:08:21a秦仕川a');
/*!50001 DROP TABLE IF EXISTS `new_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `new_view` AS select `userset`.`ID` AS `id`,`userset`.`UserName` AS `username` from `userset` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

复制代码

复制代码

.NET技术研究

MOON.ORM类比其他类型ORM的区别,以及我为什么写此架构
摘要: Moon的特色大道至简 1.高性能(该框架采用纯的ADO.NET进行框架,避免Linq以及反射带来的性能损失); 2.易用性强(配置简单,智能感知,代码生成器的辅助,会sql就可(可以自我性能优化)) ; 3.多数据库支持(如果需要可自我扩增,反应同道加入团队开发中(联系:qsmy_qin@163.com)) 4.强大查询语法糖功能 5.多数据源支持,你可以同时操作多种数据库在同一个项目中. 6..net framework 2.0原生支持 ,实体框架及基于linq的架构需3.5.1.对于实体框架,实体框架的性能问题,我不知道现今如何,但4.0的测试中足以见到htt...阅读全文

posted @ 2012-04-08 17:19 [秦时明月] 阅读(71) | 评论 (1) 编辑

Moon.ORM--最便捷轻盈的ORM 之{数据库操作全面解析(含有DEMO,代码生成器)}
摘要: 下载代码生成器(库也在代码生成器的根目录中) /Files/humble/Debug.zip(顺便说说MOON相对其他ORM的优势:http://www.cnblogs.com/humble/archive/2012/04/08/2437778.html)找到配置文件进行配置(实际项目中也一样).配置默认的系统数据库类型(各类数据库的配置)MYSQL的配置 http://www.mysql.com/downloads/mirror.php?id=406542 mysql 2.0下载地址Sqlite的配置 PostgreSql的配置 MSSQL的配置给大家一个全配置,到时候好引用,记住只要其中一阅读全文

posted @ 2012-04-08 16:48 [秦时明月] 阅读(447) | 评论 (6) 编辑

另类的ASP.NET快速开发架构体系
摘要: 第一部分另类的MVC架构JVPL架构(JVPL模式的系统结构图)1.JVPL模式(JSON+视图+处理器+加载器) 1)定义: JVPL和mvc设计模式类似,一个变种的MVC设计模式. 2)MVC的优弱点: MVC让开发从原来的 webform中解脱出来,解决了层次清晰逻辑与UI的隔离以及服务端控件的一些瑕疵等诸多问题,但是MVC的弱点同时也存在.在MVC中我们的Model时常变动,我们必须手动创建Model类和Model的变动修改.同时对于Model的Action控制操作也需要一定程度上的变动.(由实体框架等生成的实体(Model)是无法满足现行逻辑需求的). 其次因为实际开发中没有...阅读全文

posted @ 2012-02-26 15:01 [秦时明月] 阅读(3590) | 评论 (52) 编辑

(MVC和JVPL模式)Moon.Web架构谈
摘要: 图一 JVPL模式JVPL模式和mvc设计模式类似,一个变种的MVC设计模式.在MVC中我们的Model时常变动我们必须手动创建Model类和Model的变动修改.同时对于Model的Action控制操作也需要一定程度上的变动.(由实体框架等生成的实体(Model)是无法满足现行逻辑需求的).MVC让开发从原来的webform中解脱出来,解决了层次清晰逻辑与UI的隔离以及服务端控件的一些瑕疵等诸多问题,但是MVC的弱点同时也存在.因为实际开发中没有银弹,只有平衡点.V,C之间的逻辑紧密,然而实际的前台实现和效果需求是变化莫测的,更加导致美工决定VC的局面,从而VC的重用性很低很低.如果一个页阅读全文

posted @ 2012-02-08 15:27 [秦时明月] 阅读(204) | 评论 (1) 编辑

破解hash算法.高手请进,求解.
摘要: publicstaticstringMD5(stringstr) { byte[]array = Encoding.UTF8.GetBytes(str); array =newMD5CryptoServiceProvider().ComputeHash(array); stringtext =""; for(inti =0;i<array.Length;i++) { text+= array[i].ToString("x").PadLeft(2,'0'); } returntext; }做一个解密程序.阅读全文

posted @ 2012-01-12 10:14 [秦时明月] 阅读(644) | 评论 (3) 编辑

Moon.NET框架架构及介绍
摘要: 企业开发宗旨在于高效与便捷以及系统升级与维护的稳定.此框架为此而架构设计，目标在于打造一个高效能的.NET开发框架。Moon.NET由两部分组成：Qin.Data(一个高性能的ORM系统,其特色是提供便捷的开发和高效的数据库访问性能以及方便便捷的系统升级,内含代码生成器、代码自动编译);Qin.Web(一个快速的ASP.NET服务端框架,内含一个前端js脚本一引擎[有了它,你只需专注于业务逻辑,几乎绝大部分代码由引擎生成]、以及实现权限认证的AOP方案和一个前端UI库).其中的Qin.Data已被用于合富网络有限公司的数据层取代原有的实体框架. Qin.Data的相关介绍背景公司的...阅读全文

posted @ 2011-12-15 08:59 [秦时明月] 阅读(453) | 评论 (2) 编辑

我的数据库访问框架之1
摘要: 1.背景公司的项目一开始使用实体框架,但对于公司的需求其性能不如意,故此开发一个适合公司需求的数据库框架.虽然市面的有很多类似框架,虽然各有所长但短处尤在.对秋天兄的cyq.data的思想颇有所感,cyq的发布使我茅塞顿开.mysoft的风格看似linq进而触发我使用扩展.在此感谢他们. 2.简介 Qin.Data是一个通用数据库处理框架(包含MSSQL ACCESS SQLITE EXCEL MYSQL DB2 ORACLE...只要你愿意实现接口就可以).很便捷地进行常用数据库操作(增删改查).其性能是几近纯ADO.NET.对于实体的查询采用emit实现,如果您还不满意可用此框...阅读全文

posted @ 2011-10-12 14:36 [秦时明月] 阅读(1142) | 评论 (15) 编辑

一个高性能、易用性强、跨数据库的数据库访问框架之三 (Qin.Data高级功能展示)
摘要: 1)查询.查询实体DBTooldb=newDBTool(Table.EventBaseSet);//指定表 db.Where=EventBaseSet.EventID_.Equals_(3);//锁定记录 vardata=db.GetEntity<EventBaseSet>();//获取实体查询指定字段DBTooldb=newDBTool(Table.EventBaseSet);db.Where=EventBaseSet.EventID_.Equals_(32);varname=db.GetOneField<string>(EventBaseSet.EventID_);阅读全文

posted @ 2011-09-22 11:01 [秦时明月] 阅读(314) | 评论 (2) 编辑

Qin.Data发布及使用说明
摘要: 背景公司的项目开始实体框架,但对于公司的需求其性能不如意.故此开发一个适合公司需求的数据库框架.虽然市面的有很多类似框架,虽然各有所长但短处尤在.对秋天兄的cyq.data的思想颇有所感,cyq的发布使我茅塞顿开.mysoft的风格看似linq进而触发我使用扩展.在此感谢他们. 简介 Qin.Data是一个通用数据库处理框架(包含MSSQL ACCESS SQLITE EXCEL MYSQL DB2 ORACLE...只要你愿意实现接口就可以).很便捷地进行常用数据库操作(增删改查).其性能是几近纯ADO.NET.对于实体的查询采用emit实现,如果您还不满意可用此框架的代码生成器直接...阅读全文

posted @ 2011-09-18 15:20 [秦时明月] 阅读(184) | 评论 (11) 编辑

using System;
using Moon.Orm;
using System.Collections.Generic;
namespace MoonDB{
public class recordset:EntityBase{
    public recordset():base(){
    SetEntityName("`recordset`");
    SetFieldsCount(3);
    SetPrimaryField(recordsetTable.RecordID);
    SetIsSystemSetPrimaryKey(true);
    }
    private Int64  _RecordID;
    public Int64 RecordID{
    get{return _RecordID;}
    set{
        _RecordID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`RecordID`")==false)
            {this.FieldsChangedDictionary.Add("`RecordID`",value);}
}
    }
    private Int64  _UserID;
    public Int64 UserID{
    get{return _UserID;}
    set{
        _UserID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`UserID`")==false)
            {this.FieldsChangedDictionary.Add("`UserID`",value);}
}
    }
    private String  _Sumary;
    public String Sumary{
    get{return _Sumary;}
    set{
        _Sumary=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Sumary`")==false)
            {this.FieldsChangedDictionary.Add("`Sumary`",value);}
}
    }
}

public class recordsetTable{
    public static readonly Field RecordID=new Field("`RecordID`",true);
    public static readonly Field UserID=new Field("`UserID`",false);
    public static readonly Field Sumary=new Field("`Sumary`",false);
    static recordsetTable(){
        RecordID.TableName="`recordset`";
        UserID.TableName="`recordset`";
        Sumary.TableName="`recordset`";
    }
}

public class userset:EntityBase{
    public userset():base(){
    SetEntityName("`userset`");
    SetFieldsCount(4);
    SetPrimaryField(usersetTable.ID);
    SetIsSystemSetPrimaryKey(true);
    }
    private String  _UserName;
    public String UserName{
    get{return _UserName;}
    set{
        _UserName=value;
        if (this.FieldsChangedDictionary.ContainsKey("`UserName`")==false)
            {this.FieldsChangedDictionary.Add("`UserName`",value);}
}
    }
    private Int32  _Age;
    public Int32 Age{
    get{return _Age;}
    set{
        _Age=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Age`")==false)
            {this.FieldsChangedDictionary.Add("`Age`",value);}
}
    }
    private Int64  _ID;
    public Int64 ID{
    get{return _ID;}
    set{
        _ID=value;
        if (this.FieldsChangedDictionary.ContainsKey("`ID`")==false)
            {this.FieldsChangedDictionary.Add("`ID`",value);}
}
    }
    private String  _Address;
    public String Address{
    get{return _Address;}
    set{
        _Address=value;
        if (this.FieldsChangedDictionary.ContainsKey("`Address`")==false)
            {this.FieldsChangedDictionary.Add("`Address`",value);}
}
    }
}

public class usersetTable{
    public static readonly Field UserName=new Field("`UserName`",false);
    public static readonly Field Age=new Field("`Age`",false);
    public static readonly Field ID=new Field("`ID`",true);
    public static readonly Field Address=new Field("`Address`",false);
    static usersetTable(){
        UserName.TableName="`userset`";
        Age.TableName="`userset`";
        ID.TableName="`userset`";
        Address.TableName="`userset`";
    }
}

}

实际项目

最后一步进行开发.

using System;
using System.Collections.Generic;
using System.Data;
using MoonDB;
using Moon.Orm;

namespace Test
{
    class Program
    {
        public static void Main(string[] args)
        {
            userset user=new userset();
            user.Age=12;
            user.UserName="qsmy12345"+DateTime.Now.Ticks;
            user.Address=user.UserName;
            object newID=DBFactory.Add(user);
            Console.WriteLine();
            Console.WriteLine(user.GetOnlyMark());
            user.Address=DateTime.Now+"a秦仕川a";
            DBFactory.Update(user);
            string name=DBFactory.GetOneField<string>(usersetTable.Address,usersetTable.ID.Equal(newID));
            List<userset> list=DBFactory.GetEntities<userset>(usersetTable.ID.BiggerThan(0));
            Console.WriteLine(list[0].Address);
            Console.Read();

        }
    }
}

MYSQL.sql文件,自己还原下载

View Code

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `new_view` (
  `id` bigint(20),
  `username` varchar(50)
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recordset` (
  `RecordID` bigint(20) NOT NULL AUTO_INCREMENT,
  `UserID` bigint(20) NOT NULL,
  `Sumary` varchar(1000) NOT NULL,
  PRIMARY KEY (`RecordID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userset` (
  `UserName` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Age` int(11) DEFAULT NULL,
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `Address` varchar(1000) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `userset` VALUES ('qsmy其实',12,1,NULL),('qsmy其实11',12,2,NULL),('qsmy其实11',12,3,NULL),('qsmy其实11',12,4,NULL),('qsmy其实11',12,5,NULL),('qsmy其实11',12,6,NULL),('qsmy其实11',12,7,NULL),('qsmy其实11',12,8,NULL),('qsmy其实11',12,9,NULL),('qsmy其实11',12,10,NULL),('qsmy其实11',12,11,NULL),('qsmy其实11',12,12,NULL),('qsmy其实11',12,13,NULL),('qsmy其实11',12,14,NULL),('qsmy其实11',12,15,NULL),('qsmy其实11',12,16,NULL),('qsmy其实11',12,17,NULL),('qsmy其实11',12,18,NULL),('qsmy其实11',12,19,NULL),('qsmy其实11',12,20,NULL),('qsmy其实11',12,21,NULL),('qsmy其实11',12,22,NULL),('qsmy其实11',12,23,NULL),('dd',123,24,NULL),('dd',123,25,NULL),('dd',123,26,NULL),('dd',123,27,NULL),('dd',123,28,NULL),('dd',123,29,NULL),('dd',123,30,NULL),('dd',123,31,NULL),('dd',123,32,NULL),('dd',123,33,NULL),('dd',123,34,NULL),('dd',123,35,NULL),('dd',123,36,NULL),('dd',123,37,NULL),('dd',123,38,NULL),('dd',123,39,NULL),('dd',123,40,NULL),('dd',123,41,NULL),('dd',123,42,NULL),('dd',123,43,NULL),('dd',123,44,NULL),('dd',123,45,NULL),('dd',123,46,NULL),('aaa',11,47,NULL),('aaa',11,48,NULL),('aaa',11,49,NULL),('aaa',11,50,NULL),('aaa',11,51,NULL),('aaa',11,52,NULL),('aaa',11,53,NULL),('aaa',11,54,NULL),('qsmy12345',12,55,NULL),('qsmy12345634694104416406250',12,56,NULL),('qsmy12345634694105064218750',12,57,NULL),('2012-4-7 15:49:36???',12,58,NULL),('2012-4-7 15:52:45???',12,59,NULL),('2012-4-7 15:54:34???',12,60,NULL),('2012-4-7 15:55:01???',12,61,NULL),('2012-4-7 15:56:44???',12,62,NULL),('2012-4-7 15:57:56a???a',12,63,NULL),('2012-4-7 16:00:46a???a',12,64,'qsmy12345634694112457343750'),('qsmy12345634694113184531250',12,65,'2012-4-7 16:01:59a???a'),('qsmy12345634694114936718750',12,66,'2012-4-7 16:04:54a秦仕川a'),('qsmy12345634694115219687500',12,67,'2012-4-7 16:05:22a秦仕川a'),('qsmy12345634694115920781250',12,68,'2012-4-7 16:06:32a秦仕川a'),('qsmy12345634694116243125000',12,69,'2012-4-7 16:07:05a秦仕川a'),('qsmy12345634694116477187500',12,70,'2012-4-7 16:07:28a秦仕川a'),('qsmy12345634694117010468750',12,71,'2012-4-7 16:08:21a秦仕川a');
/*!50001 DROP TABLE IF EXISTS `new_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `new_view` AS select `userset`.`ID` AS `id`,`userset`.`UserName` AS `username` from `userset` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

复制代码

复制代码

posted on 2012-04-08 21:53 HackerVirus 阅读(266) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

公告

导航

Moon.ORM--最便捷轻盈的ORM 之{数据库操作全面解析(含有DEMO,代码生成器)}