公司网站制作的教程,福州网站建设制作,石景山网站建设设计公司,第九影院用wordpress版权信息简介#xff1a;ibatis 一词来源于“internet”和“abatis”的组合#xff0c;是一个由Clinton Begin在2001年发起的开放源代码项目#xff0c;到后面发展的版本叫MyBatis但都是指的同一个东西。最初侧重于密码软件的开发#xff0c;现在是一个基于Java的持久层框架#x… 简介ibatis 一词来源于“internet”和“abatis”的组合是一个由Clinton Begin在2001年发起的开放源代码项目到后面发展的版本叫MyBatis但都是指的同一个东西。最初侧重于密码软件的开发现在是一个基于Java的持久层框架渐渐的也把这种模式转移到了net。相对NHibernate等“一站式”ORM解决方案而言ibatis 是一种“半自动化”的ORM实现。 下载地址http://code.google.com/p/mybatisnet/downloads/list?can3 本文开发Demo环境IBatis.DataMapper.1.6.2.bin MsSql 2005 Vs 2010 使用步骤 在使用之前为大家推荐一款代码生成器也是我专为此框架写的一款代码生成器生成iBatis的Map配置文件这样一来用户不用开任何关于框架的说明文档即可使用此框架。代码生成器CodeHelper下载地址与说明 http://www.cnblogs.com/stone_w/archive/2011/09/26/2192010.html 第一步创建数据库与新建网站项目。 创建数据库与表的T-sql /* * iBatisDemo Sql * Stone (QQ:1370569) * Date:2011.09.26 */ create database OrmDB go use OrmDB go create table People ( id int primary key identity, [name] varchar(250), age int ) go 打开vs开发工具新建网站项目。 第二步为网站添加iBatis框架支持。 为网站添加引用或者直接把下载的iBatis框架中的IBatisNet.Common.dll和IBatisNet.DataMapper.dll复制到Bin目录下。 第三步添加iBatis配置文件。 iBatis的配置文件只用三种也必须要有这三种 1.providers.config[文件名不能修改]此文件为数据库开发商提供的驱动配置集合是固定不变的无需修改与配置复制文件到网站的根目录代码如下 providers.config ?xml version1.0 encodingutf-8?providersxmlnshttp://ibatis.apache.org/providersxmlns:xsihttp://www.w3.org/2001/XMLSchema-instance clear/ provider namesqlServer1.0 descriptionMicrosoft SQL Server, provider V1.0.3300.0 in framework .NET V1.0 enabledfalse assemblyNameSystem.Data, Version1.0.3300.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.SqlClient.SqlConnection commandClassSystem.Data.SqlClient.SqlCommand parameterClassSystem.Data.SqlClient.SqlParameter parameterDbTypeClassSystem.Data.SqlDbType parameterDbTypePropertySqlDbType dataAdapterClassSystem.Data.SqlClient.SqlDataAdapter commandBuilderClassSystem.Data.SqlClient.SqlCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix allowMARSfalse / provider namesqlServer1.1 descriptionMicrosoft SQL Server, provider V1.0.5000.0 in framework .NET V1.1 enabledfalse assemblyNameSystem.Data, Version1.0.5000.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.SqlClient.SqlConnection commandClassSystem.Data.SqlClient.SqlCommand parameterClassSystem.Data.SqlClient.SqlParameter parameterDbTypeClassSystem.Data.SqlDbType parameterDbTypePropertySqlDbType dataAdapterClassSystem.Data.SqlClient.SqlDataAdapter commandBuilderClassSystem.Data.SqlClient.SqlCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix allowMARSfalse / provider namesqlServer2.0 enabledtrue descriptionMicrosoft SQL Server, provider V2.0.0.0 in framework .NET V2.0 assemblyNameSystem.Data, Version2.0.0.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.SqlClient.SqlConnection commandClassSystem.Data.SqlClient.SqlCommand parameterClassSystem.Data.SqlClient.SqlParameter parameterDbTypeClassSystem.Data.SqlDbType parameterDbTypePropertySqlDbType dataAdapterClassSystem.Data.SqlClient.SqlDataAdapter commandBuilderClass System.Data.SqlClient.SqlCommandBuilder usePositionalParameters false useParameterPrefixInSql true useParameterPrefixInParameter true parameterPrefix allowMARSfalse / provider namesqlServer2005 enabledfalse descriptionMicrosoft SQL Server, provider V2.0.0.0 in framework .NET V2.0 assemblyNameSystem.Data, Version2.0.0.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.SqlClient.SqlConnection commandClassSystem.Data.SqlClient.SqlCommand parameterClassSystem.Data.SqlClient.SqlParameter parameterDbTypeClassSystem.Data.SqlDbType parameterDbTypePropertySqlDbType dataAdapterClassSystem.Data.SqlClient.SqlDataAdapter commandBuilderClass System.Data.SqlClient.SqlCommandBuilder usePositionalParameters false useParameterPrefixInSql true useParameterPrefixInParameter true parameterPrefix allowMARStrue / provider nameOleDb1.1 descriptionOleDb, provider V1.0.5000.0 in framework .NET V1.1 enabledfalse assemblyNameSystem.Data, Version1.0.5000.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.OleDb.OleDbConnection commandClassSystem.Data.OleDb.OleDbCommand parameterClassSystem.Data.OleDb.OleDbParameter parameterDbTypeClassSystem.Data.OleDb.OleDbType parameterDbTypePropertyOleDbType dataAdapterClassSystem.Data.OleDb.OleDbDataAdapter commandBuilderClassSystem.Data.OleDb.OleDbCommandBuilder usePositionalParameterstrue useParameterPrefixInSqlfalse useParameterPrefixInParameterfalse parameterPrefix allowMARSfalse / provider nameOleDb2.0 descriptionOleDb, provider V2.0.0.0 in framework .NET V2 enabledfalse assemblyNameSystem.Data, Version2.0.0.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.OleDb.OleDbConnection commandClassSystem.Data.OleDb.OleDbCommand parameterClassSystem.Data.OleDb.OleDbParameter parameterDbTypeClassSystem.Data.OleDb.OleDbType parameterDbTypePropertyOleDbType dataAdapterClassSystem.Data.OleDb.OleDbDataAdapter commandBuilderClassSystem.Data.OleDb.OleDbCommandBuilder usePositionalParameterstrue useParameterPrefixInSqlfalse useParameterPrefixInParameterfalse parameterPrefix allowMARSfalse / provider nameOdbc1.1 descriptionOdbc, provider V1.0.5000.0 in framework .NET V1.1 enabledfalse assemblyNameSystem.Data, Version1.0.5000.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.Odbc.OdbcConnection commandClassSystem.Data.Odbc.OdbcCommand parameterClassSystem.Data.Odbc.OdbcParameter parameterDbTypeClassSystem.Data.Odbc.OdbcType parameterDbTypePropertyOdbcType dataAdapterClassSystem.Data.Odbc.OdbcDataAdapter commandBuilderClassSystem.Data.Odbc.OdbcCommandBuilder usePositionalParameterstrue useParameterPrefixInSqlfalse useParameterPrefixInParameterfalse parameterPrefix allowMARSfalse / provider nameOdbc2.0 descriptionOdbc, provider V2.0.0.0 in framework .NET V2 enabledfalse assemblyNameSystem.Data, Version2.0.0.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.Odbc.OdbcConnection commandClassSystem.Data.Odbc.OdbcCommand parameterClassSystem.Data.Odbc.OdbcParameter parameterDbTypeClassSystem.Data.Odbc.OdbcType parameterDbTypePropertyOdbcType dataAdapterClassSystem.Data.Odbc.OdbcDataAdapter commandBuilderClassSystem.Data.Odbc.OdbcCommandBuilder usePositionalParameterstrue useParameterPrefixInSqlfalse useParameterPrefixInParameterfalse parameterPrefix allowMARSfalse / provider nameoracle9.2 descriptionOracle, Oracle provider V9.2.0.401 enabledfalse assemblyNameOracle.DataAccess, Version9.2.0.401, Cultureneutral, PublicKeyToken89b483f429c47342 connectionClassOracle.DataAccess.Client.OracleConnection commandClassOracle.DataAccess.Client.OracleCommand parameterClassOracle.DataAccess.Client.OracleParameter parameterDbTypeClassOracle.DataAccess.Client.OracleDbType parameterDbTypePropertyOracleDbType dataAdapterClassOracle.DataAccess.Client.OracleDataAdapter commandBuilderClassOracle.DataAccess.Client.OracleCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParameterfalse parameterPrefix: useDeriveParametersfalse allowMARSfalse / provider nameoracle10.1 descriptionOracle, oracle provider V10.1.0.301 enabledfalse assemblyNameOracle.DataAccess, Version10.1.0.301, Cultureneutral, PublicKeyToken89b483f429c47342 connectionClassOracle.DataAccess.Client.OracleConnection commandClassOracle.DataAccess.Client.OracleCommand parameterClassOracle.DataAccess.Client.OracleParameter parameterDbTypeClassOracle.DataAccess.Client.OracleDbType parameterDbTypePropertyOracleDbType dataAdapterClassOracle.DataAccess.Client.OracleDataAdapter commandBuilderClassOracle.DataAccess.Client.OracleCommandBuilder usePositionalParameterstrue useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix: useDeriveParametersfalse allowMARSfalse / provider nameoracleClient1.0 descriptionOracle, Microsoft provider V1.0.5000.0 enabledfalse assemblyNameSystem.Data.OracleClient, Version1.0.5000.0, Cultureneutral, PublicKeyTokenb77a5c561934e089 connectionClassSystem.Data.OracleClient.OracleConnection commandClassSystem.Data.OracleClient.OracleCommand parameterClassSystem.Data.OracleClient.OracleParameter parameterDbTypeClassSystem.Data.OracleClient.OracleType parameterDbTypePropertyOracleType dataAdapterClassSystem.Data.OracleClient.OracleDataAdapter commandBuilderClassSystem.Data.OracleClient.OracleCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParameterfalse parameterPrefix: allowMARSfalse / provider nameByteFx descriptionMySQL, ByteFx provider V0.7.6.15073 enabledfalse assemblyNameByteFX.MySqlClient, Version0.7.6.15073, Cultureneutral, PublicKeyTokenf2fef6fed1732fc1 connectionClassByteFX.Data.MySqlClient.MySqlConnection commandClassByteFX.Data.MySqlClient.MySqlCommand parameterClassByteFX.Data.MySqlClient.MySqlParameter parameterDbTypeClassByteFX.Data.MySqlClient.MySqlDbType parameterDbTypePropertyMySqlDbType dataAdapterClassByteFX.Data.MySqlClient.MySqlDataAdapter commandBuilderClassByteFX.Data.MySqlClient.MySqlCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix allowMARSfalse / provider nameMySql descriptionMySQL, MySQL provider 1.0.7.30072 enabledfalse assemblyNameMySql.Data, Version1.0.7.30072, Cultureneutral, PublicKeyTokenc5687fc88969c44d connectionClassMySql.Data.MySqlClient.MySqlConnection commandClassMySql.Data.MySqlClient.MySqlCommand parameterClassMySql.Data.MySqlClient.MySqlParameter parameterDbTypeClassMySql.Data.MySqlClient.MySqlDbType parameterDbTypePropertyMySqlDbType dataAdapterClassMySql.Data.MySqlClient.MySqlDataAdapter commandBuilderClassMySql.Data.MySqlClient.MySqlCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix? allowMARSfalse / provider nameSQLite3 Finisar descriptionSQLite, SQLite.NET provider V0.21.1869.3794 enabledfalse assemblyNameSQLite.NET, Version0.21.1869.3794, Cultureneutral, PublicKeyTokenc273bd375e695f9c connectionClassFinisar.SQLite.SQLiteConnection commandClassFinisar.SQLite.SQLiteCommand parameterClassFinisar.SQLite.SQLiteParameter parameterDbTypeClassSystem.Data.DbType, System.Data parameterDbTypePropertyDbType dataAdapterClassFinisar.SQLite.SQLiteDataAdapter commandBuilderClassFinisar.SQLite.SQLiteCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix setDbParameterPrecisionfalse setDbParameterScalefalse allowMARSfalse / provider nameSQLite3 descriptionSQLite, SQLite.NET provider V1.0.43.0 enabledfalse assemblyNameSystem.Data.SQLite, Version1.0.43.0, Cultureneutral, PublicKeyTokendb937bc2d44ff139 connectionClassSystem.Data.SQLite.SQLiteConnection commandClassSystem.Data.SQLite.SQLiteCommand parameterClassSystem.Data.SQLite.SQLiteParameter parameterDbTypeClassSystem.Data.SQLite.SQLiteType parameterDbTypePropertyDbType dataAdapterClassSystem.Data.SQLite.SQLiteDataAdapter commandBuilderClassSystem.Data.SQLite.SQLiteCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix setDbParameterPrecisionfalse setDbParameterScalefalse allowMARSfalse / provider nameFirebird1.7 descriptionFirebird, Firebird SQL .NET provider V1.7.0.33200 enabledfalse assemblyNameFirebirdSql.Data.Firebird, Version1.7.0.33200, Cultureneutral, PublicKeyTokenfa843d180294369d connectionClassFirebirdSql.Data.Firebird.FbConnection commandClassFirebirdSql.Data.Firebird.FbCommand parameterClassFirebirdSql.Data.Firebird.FbParameter parameterDbTypeClassFirebirdSql.Data.Firebird.FbDbType parameterDbTypePropertyFbDbType dataAdapterClassFirebirdSql.Data.Firebird.FbDataAdapter commandBuilderClassFirebirdSql.Data.Firebird.FbCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix allowMARSfalse / provider namePostgreSql0.99.1.0 descriptionPostgreSql, Npgsql provider V0.99.1.0 enabledfalse assemblyNameNpgsql, Version0.99.1.0, Cultureneutral, PublicKeyToken5d8b90d52f46fda7 connectionClassNpgsql.NpgsqlConnection commandClassNpgsql.NpgsqlCommand parameterClassNpgsql.NpgsqlParameter parameterDbTypeClassNpgsqlTypes.NpgsqlDbType parameterDbTypePropertyNpgsqlDbType dataAdapterClassNpgsql.NpgsqlDataAdapter commandBuilderClassNpgsql.NpgsqlCommandBuilder usePositionalParametersfalse useParameterPrefixInSqltrue useParameterPrefixInParametertrue parameterPrefix: allowMARStrue / provider nameiDb2.10 descriptionIBM DB2 Provider, V 10.0 enabledfalse assemblyNameIBM.Data.DB2.iSeries, Version10.0.0.0,Cultureneutral, PublicKeyToken9cdb2ebfb1f93a26, Customnull connectionClassIBM.Data.DB2.iSeries.iDB2Connection commandClassIBM.Data.DB2.iSeries.iDB2Command parameterClassIBM.Data.DB2.iSeries.iDB2Parameter parameterDbTypeClassIBM.Data.DB2.iSeries.iDB2DbType parameterDbTypePropertyiDB2DbType dataAdapterClassIBM.Data.DB2.iSeries.iDB2DataAdapter commandBuilderClassIBM.Data.DB2.iSeries.iDB2CommandBuilder usePositionalParameterstrue useParameterPrefixInSqlfalse useParameterPrefixInParameterfalse parameterPrefix allowMARSfalse / provider nameInformix descriptionInformix NET Provider, 2.81.0.0 enabledfalse assemblyNameIBM.Data.Informix, Version2.81.0.0, Cultureneutral, PublicKeyToken7c307b91aa13d208 connectionClassIBM.Data.Informix.IfxConnection commandClassIBM.Data.Informix.IfxCommand parameterClassIBM.Data.Informix.IfxParameter parameterDbTypeClassIBM.Data.Informix.IfxType parameterDbTypePropertyIfxType dataAdapterClassIBM.Data.Informix.IfxDataAdapter commandBuilderClassIBM.Data.Informix.IfxCommandBuilder usePositionalParameters true useParameterPrefixInSql false useParameterPrefixInParameter false useDeriveParametersfalse allowMARSfalse //providers 2.SQLMap.config[文件名不可修改]配置连接数据库字符串与每个实体类表的映射文件配置复制文件到网站的根目录代码如下 ?xml version1.0 encodingutf-8? sqlMapConfig xmlnshttp://ibatis.apache.org/dataMapper xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance settings !--/是否使用Satement命名空间这里的命名空间指的是映射文件中sqlMap节点的namespace属性默认是false-- setting useStatementNamespacesfalse/ !--是否启用DataMapper的缓存机制,针对全部的SqlMap默认是true-- setting cacheModelsEnabledtrue/ !--是否启用SqlMapConfig.xsd schema验证映射文件默认是false-- setting validateSqlMapfalse/ /settings !--配置数据驱动提供类配置文件的路径和文件名-- providers resourceproviders.config/ !--如果在providers.config文件中指定了默认的数据库驱动那么provider节点就不需要设置了它的作用是在换数据库驱动时不需要修改providers.config文件。datasource节点用于指定ADO.NET Connection String.-- database provider namesqlServer2.0/ dataSource namemydb connectionStringdata source127.0.0.1;databaseMyBatisDB;user idsa;passwordsa;/ /database !--指定映射的文件的位置-- sqlMaps sqlMap resourceMaps/PeopleMap.xml/ /sqlMaps /sqlMapConfig 3.每个实体类表都有一个单独的配置文件类类型为xml。代码生成器也是生成这个类的这样一来用户就可以几秒钟创建开发一个iBatis项目了实体类的配置文件格式如下在网站的根目录创建一个Map的文件夹新建xxxMap.xml格式的配置类比如PeopleMap.xml文件示例代码如下 ?xml version1.0 encodingutf-8 ? !--namespace必须用否者就报错读取配置文件报未将对象引用设置到对象的实例-- sqlMap namespace xmlnshttp://ibatis.apache.org/mapping xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance statements select idGetPeopleById parameterClassstring resultClassHashTable SELECT * FROM People WHERE Id#Id# /select insert idAdd parameterClasshashtable INSERT dbo.People (name ,age) VALUES (#Name# , #Age#) /insert delete idDelete parameterClassint restultClassint DELETE FROM dbo.People WHERE Id#Id# /delete update idUpdate parameterClasshashtable restltClassint UPDATE People SET name#Name# WHERE Id#Id# /update select idGetAll resultClassHashTable SELECT * FROM People /select /statements /sqlMap 这三类配置文件必须都要有与其他orm框架不同的是web.config什么也不用配置及时练数据库连接字符串也不是在它的文件中配置的也就是web.config是没有被用到的。 第四步iBatis框架语法与使用。 使用之前先来加入一个DB辅助类IBatisHepler.cs代码如下 IBatisHepler.cs using System;using System.Collections.Generic;using System.Text;using IBatisNet.DataMapper.Configuration.Statements;using IBatisNet.DataMapper;using IBatisNet.DataMapper.MappedStatements;using IBatisNet.Common;using IBatisNet.DataMapper.Scope;using System.Data;using IBatisNet.DataMapper.Configuration;using System.Collections;/// summary/// IBatis 使用工具类/// /summarypublic class IBatisHepler{ private static ISqlMapper mapper null; static IBatisHepler() { DomSqlMapBuilder builder new DomSqlMapBuilder();//其作用是根据配置文件创建SqlMap实例。 mapper builder.Configure(SqlMap.config) as SqlMapper;//SqlMapper是iBatisNet的核心组件提供数据库操作的基础平台。SqlMapper可通过DomSqlMapBuilder创建。 } /// summary /// 执行添加操作 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returns添加的主键/returns public static object ExcuteInsert(string tag, Hashtable paramObject) { return mapper.Insert(tag, paramObject); } /// summary /// 执行删除操作 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returns影响行数/returns public static int ExcuteDelete(string tag, object paramObject) { return mapper.Delete(tag, paramObject); } /// summary /// 执行修改操作 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returns影响行数/returns public static int ExcuteUpdate(string tag, Hashtable paramObject) { return mapper.Update(tag, paramObject); } /// summary /// 查询单个实体对象 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returns得到的Object/returns public static object ExcuteSelectObj(string tag, object paramObject) { object obj mapper.QueryForObject(tag, paramObject); return obj; } /// summary /// 分页查询 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// param namepageIndex页索引/param /// param namepageSize每页显示的记录数/param /// returns得到的List集合/returns public static IList ExcuteSelect(string tag, object paramObject, int pageIndex, int pageSize) { return mapper.QueryForList(tag, paramObject, pageIndex, pageSize); } /// summary /// 通用的以DataTable的方式得到Select的结果(xml文件中参数要使用$标记的占位参数) /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returns得到的DataTable/returns public static DataTable ExcuteSelect(string tag, object paramObject) { DataSet ds new DataSet(); bool isSessionLocal false; ISqlMapSession session mapper.LocalSession; if (session null) { session mapper.CreateSqlMapSession(); session.OpenConnection(); isSessionLocal true; } try { IDbCommand cmd session.CreateCommand(CommandType.Text); cmd.Connection session.Connection; cmd.CommandText GetSql(tag, paramObject); IDbDataAdapter adapter session.CreateDataAdapter(cmd); adapter.Fill(ds); } finally { if (isSessionLocal) { session.CloseConnection(); } } return ds.Tables[0]; } /// summary /// 得到参数化后的SQL /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// returnssql语句/returns protected static string GetSql(string tag, object paramObject) { IStatement statement mapper.GetMappedStatement(tag).Statement; IMappedStatement mapStatement mapper.GetMappedStatement(tag); ISqlMapSession session mapper.CreateSqlMapSession(); RequestScope request statement.Sql.GetRequestScope(mapStatement, paramObject, session); return request.PreparedStatement.PreparedSql; } /// summary /// 用于分页控件使用 /// /summary /// param nametag语句ID/param /// param nameparamObject语句所需要的参数/param /// param namePageSize每页显示数目/param /// param namecurPage当前页/param /// param namerecCount记录总数/param /// returns得到的DataTable/returns public static DataTable ExcuteSelect(string tag, object paramObject, int PageSize, int curPage, out int recCount) { IDataReader dr null; bool isSessionLocal false; string sql GetSql(tag, paramObject); string strCount select count(*) sql.Substring(sql.ToLower().IndexOf(from)); IDalSession session mapper.LocalSession; DataTable dt new DataTable(); if (session null) { session mapper.CreateSqlMapSession(); session.OpenConnection(); isSessionLocal true; } try { IDbCommand cmdCount session.CreateCommand(CommandType.Text); cmdCount.Connection session.Connection; cmdCount.CommandText strCount; object count cmdCount.ExecuteScalar(); recCount Convert.ToInt32(count); IDbCommand cmd session.CreateCommand(CommandType.Text); cmd.Connection session.Connection; cmd.CommandText sql; dr cmd.ExecuteReader(); dt Paging(dr, PageSize, curPage); } finally { if (isSessionLocal) { session.CloseConnection(); } } return dt; } /**/ /// summary /// 取回合适数量的数据 /// /summary /// param namedataReader/param /// param namePageSize/param /// param namecurPage/param /// returns/returns protected static DataTable Paging(IDataReader dataReader, int PageSize, int curPage) { DataTable dt; dt new DataTable(); int colCount dataReader.FieldCount; for (int i 0; i colCount; i) { dt.Columns.Add(new DataColumn(dataReader.GetName(i), dataReader.GetFieldType(i))); } // 读取数据。将DataReader中的数据读取到DataTable中 object[] vald new object[colCount]; int iCount 0; // 临时记录变量 while (dataReader.Read()) { // 当前记录在当前页记录范围内 if (iCount PageSize * (curPage - 1) iCount PageSize * curPage) { for (int i 0; i colCount; i) vald[i] dataReader.GetValue(i); dt.Rows.Add(vald); } else if (iCount PageSize * curPage) { break; } iCount; // 临时记录变量递增 } if (!dataReader.IsClosed) { dataReader.Close(); dataReader.Dispose(); } return dt; }} 使用语法如下 // 添加引用 using System.Collections; using IBatisNet.DataMapper; using IBatisNet.DataMapper.Configuration; // 1.添加 Hashtable ht_add new Hashtable(); ht_add[Name] IBatis; // [注意]大小写要和xxxMap.xml里保持一致 ht_add[Age] 2001; IBatisHepler.ExcuteInsert(Add, ht_add); // 2.修改 Hashtable ht_up new Hashtable(); ht_up[Id] 1; ht_up[Name] IBatis; ht_up[Age] 2001; IBatisHepler.ExcuteUpdate(Update, ht_up); // 3.删除 IBatisHepler.ExcuteDelete(Delete, 14); // 4.查询 Repeater1.DataSource IBatisHepler.ExcuteSelectObj(GetPeopleById, 1); Repeater1.DataBind(); 我对此框架的评价配置文件有点多用户需要去写东西比较多调用查询不是很好用尤其是条件查询很不方便。 代码下载【①.本Demo下载】 Orm框架相关文章链接 1.NHibernate使用之详细图解 2.iBatis for net 框架使用 3.iBatis for Net 代码生成器CodeHelper附下载地址 4.NBear简介与使用图解 5.SubSonic框架使用图解 6.GentleNet使用之详细图解
