MyBatis.Net使用入门(三)

最新推荐文章于 2024-04-30 17:11:54 发布
最新推荐文章于 2024-04-30 17:11:54 发布
阅读量1.1w 收藏 4
点赞数
分类专栏： MyBatis.Net | MyBatis框架 文章标签： mybatis 持久层框架 ORM C# NET
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wulex/article/details/52232153
版权

项目结构如下:

这里写图片描述

Book.cs模型:

 public class Book
    {
        private string _Isbn;
        private string _Title;
        private DateTime _SaleDate;
        private int _Price;
        public string Isbn
        {
            get { return _Isbn; }
            set
            {
                if (value.Length != 10)
                {
                    throw new DomainException("ISBN是无效的。");
                }
                _Isbn = value;
            }
        }

        public string IsbnWithHyphen
        {
            get
            {
                return
                    _Isbn.Substring(0, 1) + "-" + _Isbn.Substring(1, 4) + "-" + _Isbn.Substring(5, 4) + "-" +
                    _Isbn.Substring(9, 1);
            }
        }

        public string Title
        {
            get { return _Title; }
            set
            {
                if (value == "")
                {
                    throw new DomainException("标题是无效的。");
                }

                _Title = value;
            }
        }

        public DateTime SaleDate
        {
            get { return _SaleDate; }
            set
            {
                if (DateTime.Compare(value.Date, DateTime.Now) > 0)
                {
                    throw new DomainException("发布日期是无效的。");
                }
                _SaleDate = value;
            }
        }

        public int Price
        {
            get { return _Price; }
            set
            {
                if (value <= 0)
                {
                    throw new DomainException("价格是无效的。");
                }
                _Price = value;
            }
        }
    }

Book.xml映射配置文件:

<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="Book" xmlns="http://ibatis.apache.org/mapping"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">


  <!--alias节点用于为类指定一个别名，通常用于为一些很长的类名指定一个别名，这样可以减少一些代码。-->
  <!--别名缩短配置类的作用，还有其他作用,它还指明了IBatis.net应该到哪个程序集去找实体类。-->
  <alias>
        <typeAlias alias="Book" type="MybatisDemo.Domain.Books.Book,MybatisDemo" />
    </alias>

    <resultMaps>
        <resultMap id="BookResult" class="Book">
            <result property="Isbn" column="ISBN" />
            <result property="Title" column="TITLE" />
            <result property="SaleDate" column="SALE_DATE" />
            <result property="Price" column="PRICE" />
        </resultMap>
    </resultMaps>

    <statements>
        <!-- INSERT  -->
        <insert id="InsertBook" parameterClass="Book">
            insert into BOOK
                (ISBN,TITLE,SALE_DATE,PRICE)
            values 
                (#Isbn#, #Title#, #SaleDate#,#Price#)
        </insert>


        <!-- UPDATE -->
        <update id="UpdateBook" parameterClass="Book">
            update BOOK 
            set TITLE = #Title#,
            SALE_DATE = #SaleDate#, 
            PRICE = #Price#
            where ISBN = #Isbn#
        </update>

        <!-- DELETE语句：参数是基本类型（INT）-->
        <delete id="DeleteBook" parameterClass="System.Int32">
            delete from BOOK
            where ISBN = #value#
        </delete>


        <!--<delete id="DeleteBook" parameterClass="Book">
            delete from BOOK
            where ISBN = #Isbn#
        </delete>-->


        <!-- SELECT-->
        <select id="GetBookByIsbn" resultClass="Book" parameterClass="System.String">
            select
                ISBN as Isbn,
                TITLE as Title,
                SALE_DATE as SaleDate,
                PRICE as Price
            from BOOK
            where ISBN = #Isbn#
        </select>       

     <!--<select id="GetBookByIsbn" resultMap="BookResult" parameterClass="Book"> 
            select
                ISBN,
                TITLE,
                SALE_DATE,
                PRICE
            from BOOK
            where ISBN = #Isbn#
        </select>-->        


        <select id="GetBookList" resultMap="BookResult">
            select
                ISBN,
                TITLE,
                SALE_DATE,
                PRICE
            from BOOK
        </select>   

        <select id="GetBookListByTitle" extends="GetBookList" resultMap="BookResult" parameterClass="System.String">
            where TITLE LIKE '%$VALUE$%'
            order by ISBN
        </select>

        <select id="GetBookListByPrice" extends="GetBookList" resultMap="BookResult" parameterClass="System.Collections.Hashtable">
            <dynamic prepend="where">
                <isEqual property="priceCompare" compareValue="以上">
                <![CDATA[
                    PRICE >= #price#
                ]]>
                </isEqual>
                <isEqual property="priceCompare" compareValue="以下">
                <![CDATA[
                    PRICE <= #price#
                ]]>
                </isEqual>
            </dynamic>
            order by PRICE
        </select>
    </statements>
</sqlMap>

日志配置文件log4net.xml

<?xml version="1.0" encoding="utf-8" ?> 

<configuration>
    <configSections>
        <section name="log4net" type="System.Configuration.IgnoreSectionHandler" />
    </configSections>
    <appSettings>
        <add key="log4net.Internal.Debug" value="true"/>
    </appSettings>


    <log4net>
        <appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c %M [%x] - %m%n" />
            </layout>
        </appender>

        <appender name="FileAppender" type="log4net.Appender.FileAppender">
            <param name="File" value="Fileサンプル.log" />
            <param name="AppendToFile" value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>

        <appender name="RollingFileAppender_DateTime" type="log4net.Appender.RollingFileAppender">

            <param name="File" value="MybatisDemo.log" />

            <param name="AppendToFile" value="true" />

            <param name="RollingStyle" value="Date" />
            <!-- <param name="DatePattern" value="yyyy-MM" /> -->
            <!-- <param name="DatePattern" value="yyyy-ww" /> -->
            <!-- <param name="DatePattern" value="yyyy-MM-dd" /> -->
            <!-- <param name="DatePattern" value="yyyy-MM-dd-a" /> -->
            <!-- <param name="DatePattern" value="yyyy-MM-dd-HH" /> -->
            <!-- <param name="DatePattern" value="yyyy-MM-dd-HH-mm" /> -->
            <param name="StaticLogFileName" value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>     


        <appender name="RollingFileAppender_Size" type="log4net.Appender.RollingFileAppender">

            <param name="File" value="iBatisSampleサイズ.log" />

            <param name="AppendToFile" value="true" />

            <param name="RollingStyle" value="Size" />

            <param name="MaximumFileSize" value="20KB" />
            <!-- <param name="MaximumFileSize" value="1MB" /> -->
            <!-- <param name="MaximumFileSize" value="1GB" /> -->
            <param name="MaxSizeRollBackups" value="5" />       
            <param name="StaticLogFileName" value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>



        <appender name="RollingFileAppender_Composite" type="log4net.Appender.RollingFileAppender">

            <param name="File" value="iBatis大小及日期.log" />

            <param name="AppendToFile" value="true" />
            <param name="RollingStyle" value="Composite" />
            <param name="DatePattern" value="yyyy-MM-dd-HH-mm" />
            <param name="MaximumFileSize" value="5KB" />
            <param name="MaxSizeRollBackups" value="5" />           
            <param name="StaticLogFileName" value="true" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>


        <appender name="EventLogAppender" type="log4net.Appender.EventLogAppender" >
            <applicationName value="MyApp" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>

        <appender name="SmtpAppender" type="log4net.Appender.SMTPAppender">
            <param name="To" value="to_user@msn.wings.to" />
            <param name="From" value="from_user@msn.wings.to" />
            <param name="Subject" value="[${COMPUTERNAME}] log4net的系统错误通知" /> 
            <param name="SMTPHost" value="smtp.xxx.msn.wings.to" />
            <param name="LocationInfo" value="false" />
            <param name="BufferSize" value="1024" />
            <param name="Lossy" value="true" />
            <evaluator type="log4net.spi.LevelEvaluator">
                <param name="Threshold" value="FATAL"/>
            </evaluator>
            <layout type="log4net.Layout.PatternLayout">
                <param name="Header" value="此邮件是由log4net的自动发送。\r\n\r\n" />
                <param name="Footer" value="\r\n并尽快请证实。\r\n" />             
                <param name="ConversionPattern" value="%-5p %d{yyyy/MM/dd HH:mm} [%c] %m%n" />
            </layout>
        </appender>

        <appender name="NetSendAppender" type="log4net.Appender.NetSendAppender">
            <threshold value="FATAL" />
            <server value="FROM_PC" />
            <recipient value="TO_PC" />
            <layout type="log4net.Layout.PatternLayout">
                <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
            </layout>
        </appender>

        <appender name="UdpAppender" type="log4net.Appender.UdpAppender">
            <remoteAddress value="127.0.0.1" />
            <remotePort value="8080" />
            <layout type="log4net.Layout.XmlLayoutSchemaLog4j">
                <locationInfo value="true" />
            </layout>
        </appender>


        <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
            <connectionString value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=LogDb.mdb;User Id=;Password=;" />
            <commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message]) VALUES (@log_date, @thread, @log_level, @logger, @message)" />
            <parameter>
                <parameterName value="@log_date" />
                <dbType value="String" />
                <size value="25" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%d" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@thread" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%t" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@log_level" />
                <dbType value="String" />
                <size value="5" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%p" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@logger" />
                <dbType value="String" />
                <size value="255" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%c" />
                </layout>
            </parameter>
            <parameter>
                <parameterName value="@message" />
                <dbType value="String" />
                <size value="1024" />
                <layout type="log4net.Layout.PatternLayout">
                    <conversionPattern value="%m" />
                </layout>
            </parameter>
        </appender>

        <root>
            <level value="ERROR" />
            <appender-ref ref="ConsoleAppender" />
            <appender-ref ref="RollingFileAppender_DateTime" />
        </root>


        <logger name="MybatisDemo">
            <level value="DEBUG" />
        </logger>

        <logger name="IBatisNet.DataMapper.Commands.DefaultPreparedCommand">
            <level value="DEBUG" />
        </logger>
        <logger name="IBatisNet.DataMapper.Configuration.Cache.CacheModel">
            <level value="DEBUG" />
        </logger>
        <logger name="IBatisNet.DataMapper.LazyLoadList">
            <level value="DEBUG" />
        </logger>
        <logger name="IBatisNet.DataMapper.SqlMapSession">
            <level value="DEBUG" />
        </logger>
        <logger name="IBatisNet.Common.Transaction.TransactionScope">
            <level value="DEBUG" />
        </logger>
        <logger name="IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory">
            <level value="OFF" />
        </logger>
        <logger name="IBatisNet.DataMapper.Commands.IPreparedCommand">
            <level value="OFF" />
        </logger>  

    </log4net>
</configuration>

数据库提供程序配置providers.config

<?xml version="1.0" encoding="utf-8"?>

<providers xmlns="http://ibatis.apache.org/providers" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <clear />
  <provider
    name="sqlServer1.1"
    description="Microsoft SQL Server 7.0/2000, provider V1.0.5000.0 in framework .NET V1.1"
    default="true"
    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    connectionClass="System.Data.SqlClient.SqlConnection"
    commandClass="System.Data.SqlClient.SqlCommand"
    parameterClass="System.Data.SqlClient.SqlParameter"
    parameterDbTypeClass="System.Data.SqlDbType"
    parameterDbTypeProperty="SqlDbType"
    dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
    commandBuilderClass="System.Data.SqlClient.SqlCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix="@" />
  <provider
    name="sqlServer2.0"
    enabled="true"
    description="Microsoft SQL Server, provider V2.0.0.0 in framework .NET V2.0"
    assemblyName="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    connectionClass="System.Data.SqlClient.SqlConnection"
    commandClass="System.Data.SqlClient.SqlCommand"
    parameterClass="System.Data.SqlClient.SqlParameter"
    parameterDbTypeClass="System.Data.SqlDbType"
    parameterDbTypeProperty="SqlDbType"
    dataAdapterClass="System.Data.SqlClient.SqlDataAdapter"
    commandBuilderClass=" System.Data.SqlClient.SqlCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix="@"
    allowMARS="false" />
  <provider
    name="OleDb1.1"
    description="OleDb, provider V1.0.5000.0 in framework .NET V1.1"
    enabled="true"
    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    connectionClass="System.Data.OleDb.OleDbConnection"
    commandClass="System.Data.OleDb.OleDbCommand"
    parameterClass="System.Data.OleDb.OleDbParameter"
    parameterDbTypeClass="System.Data.OleDb.OleDbType"
    parameterDbTypeProperty="OleDbType"
    dataAdapterClass="System.Data.OleDb.OleDbDataAdapter"
    commandBuilderClass="System.Data.OleDb.OleDbCommandBuilder"
    usePositionalParameters="true"
    useParameterPrefixInSql="false"
    useParameterPrefixInParameter="false"
    parameterPrefix="" />
  <provider
    name="Odbc1.1"
    description="Odbc, provider V1.0.5000.0 in framework .NET V1.1"
    enabled="true"
    assemblyName="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
    connectionClass="System.Data.Odbc.OdbcConnection"
    commandClass="System.Data.Odbc.OdbcCommand"
    parameterClass="System.Data.Odbc.OdbcParameter"
    parameterDbTypeClass="System.Data.Odbc.OdbcType"
    parameterDbTypeProperty="OdbcType"
    dataAdapterClass="System.Data.Odbc.OdbcDataAdapter"
    commandBuilderClass="System.Data.Odbc.OdbcCommandBuilder"
    usePositionalParameters="true"
    useParameterPrefixInSql="false"
    useParameterPrefixInParameter="false"
    parameterPrefix="@" />
  <provider
    name="oracle9.2"
    description="Oracle, Oracle provider V9.2.0.401"
    enabled="false"
    assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342"
    connectionClass="Oracle.DataAccess.Client.OracleConnection"
    commandClass="Oracle.DataAccess.Client.OracleCommand"
    parameterClass="Oracle.DataAccess.Client.OracleParameter"
    parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"
    parameterDbTypeProperty="OracleDbType"
    dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
    commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="false"
    parameterPrefix=":"
    useDeriveParameters="false" />
  <provider
    name="oracle10.1"
    description="Oracle, oracle provider V10.1.0.301"
    enabled="false"
    assemblyName="Oracle.DataAccess, Version=10.1.0.301, Culture=neutral, PublicKeyToken=89b483f429c47342"
    connectionClass="Oracle.DataAccess.Client.OracleConnection"
    commandClass="Oracle.DataAccess.Client.OracleCommand"
    parameterClass="Oracle.DataAccess.Client.OracleParameter"
    parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"
    parameterDbTypeProperty="OracleDbType"
    dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"
    commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"
    usePositionalParameters="true"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix=":"
    useDeriveParameters="false" />
  <provider
    name="MySql"
    description="MySQL, MySQL provider V1.0.4.20163"
    enabled="false"
    assemblyName="MySql.Data, Version=1.0.4.20163, Culture=neutral, PublicKeyToken=c5687fc88969c44d"
    connectionClass="MySql.Data.MySqlClient.MySqlConnection"
    commandClass="MySql.Data.MySqlClient.MySqlCommand"
    parameterClass="MySql.Data.MySqlClient.MySqlParameter"
    parameterDbTypeClass="MySql.Data.MySqlClient.MySqlDbType"
    parameterDbTypeProperty="MySqlDbType"
    dataAdapterClass="MySql.Data.MySqlClient.MySqlDataAdapter"
    commandBuilderClass="MySql.Data.MySqlClient.MySqlCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix="@" />
  <provider
    name="SQLite3"
    description="SQLite, SQLite.NET provider V0.21.1869.3794"
    enabled="false"
    assemblyName="SQLite.NET, Version=0.21.1869.3794, Culture=neutral, PublicKeyToken=c273bd375e695f9c"
    connectionClass="Finisar.SQLite.SQLiteConnection"
    commandClass="Finisar.SQLite.SQLiteCommand"
    parameterClass="Finisar.SQLite.SQLiteParameter"
    parameterDbTypeClass="System.Data.DbType, System.Data"
    parameterDbTypeProperty="DbType"
    dataAdapterClass="Finisar.SQLite.SQLiteDataAdapter"
    commandBuilderClass="Finisar.SQLite.SQLiteCommandBuilder"
    usePositionalParameters="true"
    useParameterPrefixInSql="false"
    useParameterPrefixInParameter="false"
    parameterPrefix=""
    setDbParameterPrecision="false"
    setDbParameterScale="false"
    setDbParameterSize="false" />
  <provider
    name="PostgreSql0.7"
    description="PostgreSql, Npgsql provider V0.7.0.0"
    enabled="false"
    assemblyName="Npgsql, Version=0.7.0.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"
    connectionClass="Npgsql.NpgsqlConnection"
    commandClass="Npgsql.NpgsqlCommand"
    parameterClass="Npgsql.NpgsqlParameter"
    parameterDbTypeClass="NpgsqlTypes.NpgsqlDbType"
    parameterDbTypeProperty="NpgsqlDbType"
    dataAdapterClass="Npgsql.NpgsqlDataAdapter"
    commandBuilderClass="Npgsql.NpgsqlCommandBuilder"
    usePositionalParameters="false"
    useParameterPrefixInSql="true"
    useParameterPrefixInParameter="true"
    parameterPrefix=":" />
</providers>

Mybatis全局配置文件SqlMap.config:

<?xml version="1.0" encoding="utf-8"?>
<sqlMapConfig xmlns="http://ibatis.apache.org/dataMapper"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <!--properties节点通常用于引入在外部定义一些键值对配置文件，以方便在后面统一调用，这样修改的时候，只修改就可以了。
  　　它的引入方式有3种：
  　　resource: 通过相对路径来确定文件的位置。
  　　url：　　 通过绝对路径来确定文件位置。
  　　embedded: 通过嵌入资源方式来确定文件位置。-->
  <!--<properties resource="../../../Files/properties.config"/>-->
  <!--Settings节点里，可以配置以下5个信息：
  useStatementNamespaces：默认flase,是否使用全局完整命名空间。
  cacheModelsEnabled :默认true,是否启用缓存。
  validateSqlMap:默认false,使用启用SqlMapConfig.xsd来验证映射XML文件。
  useReflectionOptimizer:默认true,是否使用反射机制访问C#中对象的属性。
  useEmbedStatementParams 是否使用嵌入的方式声明可变参数-->
  <settings>
    <setting useStatementNamespaces="false" />
    <setting cacheModelsEnabled="true" />
  </settings>

  <providers resource="../../Resources/providers.config" />
  <database>
    <!--<provider name="OleDb1.1"/>-->
    <!--<dataSource name="Access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=iBatisSample.mdb"/>-->
    <provider name="sqlServer2.0" />
    <dataSource name="SQLServer"
                connectionString="Data Source=.\SQLINSTANCE;Initial Catalog=MyBatisDemo;Persist Security Info=True;User ID=sa;Password=123456;connection lifetime=5; min pool size=1; max pool size=50" />
  </database>

  <!--SqlMaps节点，用于配置映射信息。通常在映射信息写在外部，在这个节点引入。-->
  <sqlMaps>
    <sqlMap resource="../../Resources/Maps/Book.xml" />
    <!-- <sqlMap resource="./Maps/Hoge.xml"/>
        <sqlMap resource="./Maps/Moge.xml"/>
        -->
  </sqlMaps>
</sqlMapConfig>

Program.cs的入口程序:

 internal static class Program
    {
        private static readonly log4net.ILog _logger =
            log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        private static void Main()
        {
            try
            {
                _logger.Info("●启动iBATIS.NET");
                Application.EnableVisualStyles();
                Application.SetCompatibleTextRenderingDefault(false);
                Application.Run(new frmBookView());
            }
            catch (Exception ex)
            {
                _logger.Error("★iBATIS.NET示例应用程序错误★", ex);
                MessageBox.Show("一个意外的错误，并退出应用程序。\r了解更多信息，查看“log4net的”的日志。",
                    "iBatisSample", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            _logger.Info("●退出iBATIS.NET");
        }
    }

frmBookDetail窗体后台代码:

 public class frmBookDetail : System.Windows.Forms.Form
    {
        //获取log4net的实例
        private static readonly log4net.ILog _logger =
            log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        private static string baseDir = Path.GetFullPath(@"../../");
        private static DomSqlMapBuilder builder = new DomSqlMapBuilder();
        private static ISqlMapper mapper = builder.Configure(baseDir + @"Resources\SqlMap.config");


        private string _userIsbn = null;
        private String _crudStatus = null;
        private System.Windows.Forms.Label lblIsbn;
        private System.Windows.Forms.Label lblTitle;
        private System.Windows.Forms.Label lblSaleDate;
        private System.Windows.Forms.Label lblPrice;
        private System.Windows.Forms.TextBox txtPrice;
        private System.Windows.Forms.Button btnCancel;
        private System.Windows.Forms.TextBox txtIsbn;
        private System.Windows.Forms.TextBox txtTitle;
        private System.Windows.Forms.DateTimePicker dtpBirthday;
        private System.Windows.Forms.Button btnOk;

        private System.ComponentModel.Container components = null;

        public frmBookDetail()
        {
            InitializeComponent();
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                if (components != null)
                {
                    components.Dispose();
                }
            }
            base.Dispose(disposing);
        }

        private void InitializeComponent()
        {
            this.txtIsbn = new System.Windows.Forms.TextBox();
            this.txtTitle = new System.Windows.Forms.TextBox();
            this.dtpBirthday = new System.Windows.Forms.DateTimePicker();
            this.txtPrice = new System.Windows.Forms.TextBox();
            this.btnOk = new System.Windows.Forms.Button();
            this.btnCancel = new System.Windows.Forms.Button();
            this.lblIsbn = new System.Windows.Forms.Label();
            this.lblTitle = new System.Windows.Forms.Label();
            this.lblSaleDate = new System.Windows.Forms.Label();
            this.lblPrice = new System.Windows.Forms.Label();
            this.SuspendLayout();
            // 
            // txtIsbn
            // 
            this.txtIsbn.Location = new System.Drawing.Point(147, 24);
            this.txtIsbn.MaxLength = 10;
            this.txtIsbn.Name = "txtIsbn";
            this.txtIsbn.Size = new System.Drawing.Size(115, 25);
            this.txtIsbn.TabIndex = 1;
            // 
            // txtTitle
            // 
            this.txtTitle.Location = new System.Drawing.Point(147, 68);
            this.txtTitle.MaxLength = 50;
            this.txtTitle.Name = "txtTitle";
            this.txtTitle.Size = new System.Drawing.Size(224, 25);
            this.txtTitle.TabIndex = 3;
            // 
            // dtpBirthday
            // 
            this.dtpBirthday.Location = new System.Drawing.Point(147, 149);
            this.dtpBirthday.Name = "dtpBirthday";
            this.dtpBirthday.Size = new System.Drawing.Size(173, 25);
            this.dtpBirthday.TabIndex = 9;
            // 
            // txtPrice
            // 
            this.txtPrice.Location = new System.Drawing.Point(147, 111);
            this.txtPrice.MaxLength = 8;
            this.txtPrice.Name = "txtPrice";
            this.txtPrice.Size = new System.Drawing.Size(103, 25);
            this.txtPrice.TabIndex = 5;
            this.txtPrice.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
            // 
            // btnOk
            // 
            this.btnOk.Location = new System.Drawing.Point(61, 216);
            this.btnOk.Name = "btnOk";
            this.btnOk.Size = new System.Drawing.Size(120, 34);
            this.btnOk.TabIndex = 10;
            this.btnOk.Text = "OK";
            this.btnOk.Click += new System.EventHandler(this.btnOk_Click);
            // 
            // btnCancel
            // 
            this.btnCancel.Location = new System.Drawing.Point(251, 216);
            this.btnCancel.Name = "btnCancel";
            this.btnCancel.Size = new System.Drawing.Size(120, 34);
            this.btnCancel.TabIndex = 11;
            this.btnCancel.Text = "返回";
            this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
            // 
            // lblIsbn
            // 
            this.lblIsbn.Location = new System.Drawing.Point(58, 30);
            this.lblIsbn.Name = "lblIsbn";
            this.lblIsbn.Size = new System.Drawing.Size(83, 30);
            this.lblIsbn.TabIndex = 0;
            this.lblIsbn.Text = "ISBN";
            // 
            // lblTitle
            // 
            this.lblTitle.Location = new System.Drawing.Point(58, 72);
            this.lblTitle.Name = "lblTitle";
            this.lblTitle.Size = new System.Drawing.Size(83, 21);
            this.lblTitle.TabIndex = 2;
            this.lblTitle.Text = "标题";
            // 
            // lblSaleDate
            // 
            this.lblSaleDate.Location = new System.Drawing.Point(58, 156);
            this.lblSaleDate.Name = "lblSaleDate";
            this.lblSaleDate.Size = new System.Drawing.Size(83, 30);
            this.lblSaleDate.TabIndex = 8;
            this.lblSaleDate.Text = "发布日期";
            // 
            // lblPrice
            // 
            this.lblPrice.Location = new System.Drawing.Point(58, 114);
            this.lblPrice.Name = "lblPrice";
            this.lblPrice.Size = new System.Drawing.Size(83, 30);
            this.lblPrice.TabIndex = 4;
            this.lblPrice.Text = "价格";
            // 
            // frmBookDetail
            // 
            this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);
            this.ClientSize = new System.Drawing.Size(608, 349);
            this.Controls.Add(this.lblPrice);
            this.Controls.Add(this.lblSaleDate);
            this.Controls.Add(this.lblTitle);
            this.Controls.Add(this.lblIsbn);
            this.Controls.Add(this.btnCancel);
            this.Controls.Add(this.btnOk);
            this.Controls.Add(this.txtPrice);
            this.Controls.Add(this.txtTitle);
            this.Controls.Add(this.txtIsbn);
            this.Controls.Add(this.dtpBirthday);
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
            this.Name = "frmBookDetail";
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
            this.Text = "图书信息";
            this.Load += new System.EventHandler(this.frmBookDetail_Load);
            this.ResumeLayout(false);
            this.PerformLayout();
        }

        public String CrudStatus
        {
            get { return _crudStatus; }
            set { _crudStatus = value; }
        }

        public string BookIsbn
        {
            get { return _userIsbn; }
            set { _userIsbn = value; }
        }

        private void frmBookDetail_Load(object sender, System.EventArgs e)
        {
            System.Diagnostics.Debug.Assert(_crudStatus != null, "状态未设置");

            SetUpInputLock();

            SetUpOkButtunTitle();

            LoadBookInfo();
        }

        private void LoadBookInfo()
        {
            try
            {
                if (_crudStatus.Equals("READ") || _crudStatus.Equals("DELETE") || _crudStatus.Equals("UPDATE"))
                {
                    Book book = (Book) mapper.QueryForObject("GetBookByIsbn", _userIsbn);
                    this.txtIsbn.Text = book.Isbn;
                    this.txtTitle.Text = book.Title;
                    this.txtPrice.Text = book.Price.ToString();
                    this.dtpBirthday.Value = book.SaleDate;
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }

        private void SetUpInputLock()
        {
            if (_crudStatus.Equals("READ") || _crudStatus.Equals("DELETE"))
            {
                this.txtTitle.Enabled = false;
                this.txtPrice.Enabled = false;
                this.dtpBirthday.Enabled = false;
            }

            if (_crudStatus.Equals("READ") || _crudStatus.Equals("DELETE") || _crudStatus.Equals("UPDATE"))
            {
                this.txtIsbn.Enabled = false;
            }
        }

        private void SetUpOkButtunTitle()
        {
            if (_crudStatus.Equals("CREATE"))
            {
                this.btnOk.Text = "添加新数据";
            }
            else if (_crudStatus.Equals("UPDATE"))
            {
                this.btnOk.Text = "更新";
            }
            else if (_crudStatus.Equals("READ"))
            {
                this.btnOk.Text = "OK";
            }
            else if (_crudStatus.Equals("DELETE"))
            {
                this.btnOk.Text = "删除";
            }
        }

        private void btnOk_Click(object sender, System.EventArgs e)
        {
            try
            {
                Book book = new Book();
                if (_crudStatus.Equals("CREATE") || (_crudStatus.Equals("UPDATE")))
                {
                    book.Isbn = this.txtIsbn.Text;
                    book.Title = this.txtTitle.Text;
                    book.Price = int.Parse(this.txtPrice.Text);
                    book.SaleDate = new DateTime(this.dtpBirthday.Value.Year, this.dtpBirthday.Value.Month,
                        this.dtpBirthday.Value.Day);
                }

                if (_crudStatus.Equals("CREATE"))
                {
                    mapper.Insert("InsertBook", book);
                }
                if (_crudStatus.Equals("UPDATE"))
                {
                    mapper.Update("UpdateBook", book);
                }
                if (_crudStatus.Equals("DELETE"))
                {
                    mapper.Delete("DeleteBook", this.txtIsbn.Text);
                }

                this.DialogResult = DialogResult.OK;
                this.Close();
            }
            catch (DomainException ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString(),
                    MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            catch (FormatException ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString(),
                    MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            catch (Exception ex)
            {
                _logger.Error("在数据库更新时发生意外的错误!", ex);


                MessageBox.Show("发生意外的错误!" + "\r\r" + ex.Message,
                    ex.GetType().ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        private void btnCancel_Click(object sender, System.EventArgs e)
        {
            this.DialogResult = DialogResult.Cancel;
            this.Close();
        }
    }

frmBookView窗体后台代码:

 public class frmBookView : System.Windows.Forms.Form
    {
        private static readonly log4net.ILog _logger =
            log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        //DomSqlMapBuilder，其作用是根据配置文件创建SqlMap实例。可以通过这个组件从Stream, Uri, FileInfo, or XmlDocument instance 来读取sqlMap.config文件。
        // SqlMap是线程安全的，也就是说，在一个应用中，可以共享一个SqlMap实例。
        private static string baseDir = Path.GetFullPath(@"../../");
        private static DomSqlMapBuilder builder = new DomSqlMapBuilder();
        private static ISqlMapper mapper = builder.Configure(baseDir + @"Resources\SqlMap.config");

        private DataSet _dataSet = null;
        private DataTable _dataTable = null;
        private System.Windows.Forms.DataGrid grdMain;
        private System.Windows.Forms.Button btnUpdate;
        private System.Windows.Forms.Button btnDelete;
        private System.Windows.Forms.Button btnCreate;
        private System.Windows.Forms.Button btnRead;
        private System.Windows.Forms.TextBox txtTitle;
        private System.Windows.Forms.Label lblTitle;
        private System.Windows.Forms.Button btnSearchTitle;
        private System.Windows.Forms.ComboBox cmbPrice;
        private System.Windows.Forms.ComboBox cmbPrice2;
        private System.Windows.Forms.Label lblPrice;
        private System.Windows.Forms.Button btnSearchPriceWeight;

        private System.ComponentModel.Container components = null;

        public frmBookView()
        {
            InitializeComponent();
        }

        /// <summary>
        /// 运行后释放正在使用的资源
        /// </summary>
        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                if (components != null)
                {
                    components.Dispose();
                }
            }
            base.Dispose(disposing);
        }

        #region 由Windows窗体设计器生成的代码

        private void InitializeComponent()
        {
            this.grdMain = new System.Windows.Forms.DataGrid();
            this.txtTitle = new System.Windows.Forms.TextBox();
            this.btnSearchTitle = new System.Windows.Forms.Button();
            this.btnRead = new System.Windows.Forms.Button();
            this.btnUpdate = new System.Windows.Forms.Button();
            this.btnCreate = new System.Windows.Forms.Button();
            this.btnDelete = new System.Windows.Forms.Button();
            this.lblTitle = new System.Windows.Forms.Label();
            this.cmbPrice = new System.Windows.Forms.ComboBox();
            this.cmbPrice2 = new System.Windows.Forms.ComboBox();
            this.lblPrice = new System.Windows.Forms.Label();
            this.btnSearchPriceWeight = new System.Windows.Forms.Button();
            ((System.ComponentModel.ISupportInitialize) (this.grdMain)).BeginInit();
            this.SuspendLayout();
            // 
            // grdMain
            // 
            this.grdMain.AlternatingBackColor = System.Drawing.Color.White;
            this.grdMain.BackColor = System.Drawing.Color.White;
            this.grdMain.BackgroundColor = System.Drawing.Color.Gainsboro;
            this.grdMain.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
            this.grdMain.CaptionBackColor = System.Drawing.Color.Silver;
            this.grdMain.CaptionFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
            this.grdMain.CaptionForeColor = System.Drawing.Color.Black;
            this.grdMain.CaptionVisible = false;
            this.grdMain.DataMember = "";
            this.grdMain.FlatMode = true;
            this.grdMain.Font = new System.Drawing.Font("Courier New", 9F);
            this.grdMain.ForeColor = System.Drawing.Color.DarkSlateGray;
            this.grdMain.GridLineColor = System.Drawing.Color.DarkGray;
            this.grdMain.HeaderBackColor = System.Drawing.Color.DarkGreen;
            this.grdMain.HeaderFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);
            this.grdMain.HeaderForeColor = System.Drawing.Color.White;
            this.grdMain.LinkColor = System.Drawing.Color.DarkGreen;
            this.grdMain.Location = new System.Drawing.Point(26, 120);
            this.grdMain.Name = "grdMain";
            this.grdMain.ParentRowsBackColor = System.Drawing.Color.Gainsboro;
            this.grdMain.ParentRowsForeColor = System.Drawing.Color.Black;
            this.grdMain.ReadOnly = true;
            this.grdMain.SelectionBackColor = System.Drawing.Color.DarkSeaGreen;
            this.grdMain.SelectionForeColor = System.Drawing.Color.Black;
            this.grdMain.Size = new System.Drawing.Size(729, 348);
            this.grdMain.TabIndex = 10;
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            // 
            // txtTitle
            // 
            this.txtTitle.Font = new System.Drawing.Font("MS UI Gothic", 11F, System.Drawing.FontStyle.Regular,
                System.Drawing.GraphicsUnit.Point, ((byte) (128)));
            this.txtTitle.Location = new System.Drawing.Point(115, 12);
            this.txtTitle.Name = "txtTitle";
            this.txtTitle.Size = new System.Drawing.Size(218, 26);
            this.txtTitle.TabIndex = 1;
            // 
            // btnSearchTitle
            // 
            this.btnSearchTitle.Location = new System.Drawing.Point(346, 12);
            this.btnSearchTitle.Name = "btnSearchTitle";
            this.btnSearchTitle.Size = new System.Drawing.Size(204, 36);
            this.btnSearchTitle.TabIndex = 2;
            this.btnSearchTitle.Text = "标题搜索(&T)";
            this.btnSearchTitle.Click += new System.EventHandler(this.btnSearchTitle_Click);
            // 
            // btnRead
            // 
            this.btnRead.Location = new System.Drawing.Point(26, 480);
            this.btnRead.Name = "btnRead";
            this.btnRead.Size = new System.Drawing.Size(179, 36);
            this.btnRead.TabIndex = 11;
            this.btnRead.Text = "查看(&R)";
            this.btnRead.Click += new System.EventHandler(this.btnRead_Click);
            // 
            // btnUpdate
            // 
            this.btnUpdate.Location = new System.Drawing.Point(384, 480);
            this.btnUpdate.Name = "btnUpdate";
            this.btnUpdate.Size = new System.Drawing.Size(179, 36);
            this.btnUpdate.TabIndex = 13;
            this.btnUpdate.Text = "更新(&U)";
            this.btnUpdate.Click += new System.EventHandler(this.btnUpdate_Click);
            // 
            // btnCreate
            // 
            this.btnCreate.Location = new System.Drawing.Point(205, 480);
            this.btnCreate.Name = "btnCreate";
            this.btnCreate.Size = new System.Drawing.Size(179, 36);
            this.btnCreate.TabIndex = 12;
            this.btnCreate.Text = "追加(&C)";
            this.btnCreate.Click += new System.EventHandler(this.btnCreate_Click);
            // 
            // btnDelete
            // 
            this.btnDelete.Location = new System.Drawing.Point(563, 480);
            this.btnDelete.Name = "btnDelete";
            this.btnDelete.Size = new System.Drawing.Size(179, 36);
            this.btnDelete.TabIndex = 14;
            this.btnDelete.Text = "删除(&D)";
            this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
            // 
            // lblTitle
            // 
            this.lblTitle.Location = new System.Drawing.Point(51, 23);
            this.lblTitle.Name = "lblTitle";
            this.lblTitle.Size = new System.Drawing.Size(47, 25);
            this.lblTitle.TabIndex = 0;
            this.lblTitle.Text = "标题:";
            // 
            // cmbPrice
            // 
            this.cmbPrice.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.cmbPrice.Font = new System.Drawing.Font("MS UI Gothic", 11.25F, System.Drawing.FontStyle.Regular,
                System.Drawing.GraphicsUnit.Point, ((byte) (128)));
            this.cmbPrice.Items.AddRange(new object[]
            {
                "1000",
                "2000",
                "3000",
                "4000",
                "5000"
            });
            this.cmbPrice.Location = new System.Drawing.Point(115, 75);
            this.cmbPrice.Name = "cmbPrice";
            this.cmbPrice.Size = new System.Drawing.Size(128, 27);
            this.cmbPrice.TabIndex = 4;
            // 
            // cmbPrice2
            // 
            this.cmbPrice2.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.cmbPrice2.Font = new System.Drawing.Font("MS UI Gothic", 11.25F, System.Drawing.FontStyle.Regular,
                System.Drawing.GraphicsUnit.Point, ((byte) (128)));
            this.cmbPrice2.Items.AddRange(new object[]
            {
                "",
                "以上",
                "以下"
            });
            this.cmbPrice2.Location = new System.Drawing.Point(243, 75);
            this.cmbPrice2.Name = "cmbPrice2";
            this.cmbPrice2.Size = new System.Drawing.Size(90, 27);
            this.cmbPrice2.TabIndex = 5;
            // 
            // lblPrice
            // 
            this.lblPrice.Location = new System.Drawing.Point(51, 82);
            this.lblPrice.Name = "lblPrice";
            this.lblPrice.Size = new System.Drawing.Size(47, 26);
            this.lblPrice.TabIndex = 3;
            this.lblPrice.Text = "价格:";
            // 
            // btnSearchPriceWeight
            // 
            this.btnSearchPriceWeight.Location = new System.Drawing.Point(346, 66);
            this.btnSearchPriceWeight.Name = "btnSearchPriceWeight";
            this.btnSearchPriceWeight.Size = new System.Drawing.Size(204, 36);
            this.btnSearchPriceWeight.TabIndex = 9;
            this.btnSearchPriceWeight.Text = "价格查询(&S)";
            this.btnSearchPriceWeight.Click += new System.EventHandler(this.btnSearchPriceWeight_Click);
            // 
            // frmBookView
            // 
            this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);
            this.ClientSize = new System.Drawing.Size(790, 549);
            this.Controls.Add(this.btnSearchPriceWeight);
            this.Controls.Add(this.txtTitle);
            this.Controls.Add(this.cmbPrice);
            this.Controls.Add(this.cmbPrice2);
            this.Controls.Add(this.lblPrice);
            this.Controls.Add(this.lblTitle);
            this.Controls.Add(this.btnDelete);
            this.Controls.Add(this.btnCreate);
            this.Controls.Add(this.btnUpdate);
            this.Controls.Add(this.btnRead);
            this.Controls.Add(this.btnSearchTitle);
            this.Controls.Add(this.grdMain);
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
            this.Name = "frmBookView";
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
            this.Text = "书籍一览";
            this.Load += new System.EventHandler(this.frmBookView_Load);
            ((System.ComponentModel.ISupportInitialize) (this.grdMain)).EndInit();
            this.ResumeLayout(false);
            this.PerformLayout();
        }

        #endregion

        /// <summary>
        /// 当窗体加载的处理
        /// </summary>
        private void frmBookView_Load(object sender, System.EventArgs e)
        {
            //设置列名
            _dataSet = new DataSet();
            _dataTable = _dataSet.Tables.Add("");
            DataColumn dc1 = _dataTable.Columns.Add("ISBN-KEY(隐藏)");
            DataColumn dc2 = _dataTable.Columns.Add("ISBN");
            DataColumn dc3 = _dataTable.Columns.Add("标题");
            DataColumn dc4 = _dataTable.Columns.Add("价格", typeof (int));
            DataColumn dc5 = _dataTable.Columns.Add("发布日期", typeof (DateTime));
            //创建数据样式
            DataGridTableStyle tableStyle = new DataGridTableStyle();
            tableStyle.MappingName = _dataTable.TableName;
            this.grdMain.TableStyles.Add(tableStyle);
            //风格
            DataGridTextBoxColumn tbc1 = new DataGridTextBoxColumn();
            DataGridTextBoxColumn tbc2 = new DataGridTextBoxColumn();
            DataGridTextBoxColumn tbc3 = new DataGridTextBoxColumn();
            DataGridTextBoxColumn tbc4 = new DataGridTextBoxColumn();
            DataGridTextBoxColumn tbc5 = new DataGridTextBoxColumn();
            tbc1.MappingName = dc1.ColumnName;
            tbc2.MappingName = dc2.ColumnName;
            tbc3.MappingName = dc3.ColumnName;
            tbc4.MappingName = dc4.ColumnName;
            tbc5.MappingName = dc5.ColumnName;
            //列的标题设置
            tbc1.HeaderText = dc1.ColumnName;
            tbc2.HeaderText = dc2.ColumnName;
            tbc3.HeaderText = dc3.ColumnName;
            tbc4.HeaderText = dc4.ColumnName;
            tbc5.HeaderText = dc5.ColumnName;
            // 设置右对齐和居中左对齐
            tbc1.Alignment = HorizontalAlignment.Left;
            tbc2.Alignment = HorizontalAlignment.Left;
            tbc3.Alignment = HorizontalAlignment.Left;
            tbc4.Alignment = HorizontalAlignment.Right;
            tbc5.Alignment = HorizontalAlignment.Left;
            // 设置列宽
            tbc1.Width = 0;
            tbc2.Width = 100;
            tbc3.Width = 140;
            tbc4.Width = 80;
            tbc5.Width = 80;
            //风格样式
            tableStyle.GridColumnStyles.Add(tbc1);
            tableStyle.GridColumnStyles.Add(tbc2);
            tableStyle.GridColumnStyles.Add(tbc3);
            tableStyle.GridColumnStyles.Add(tbc4);
            tableStyle.GridColumnStyles.Add(tbc5);
            //禁止设置行添加，删除，编辑数据
            _dataTable.DefaultView.AllowNew = false;
            _dataTable.DefaultView.AllowDelete = false;
            _dataTable.DefaultView.AllowEdit = false;
            this.grdMain.SetDataBinding(_dataTable.DefaultView, "");

            //价格的初始设定
            this.cmbPrice.SelectedIndex = 0;
            //名字搜索的执行
            showBooksByTitle();
        }


        /// <summary>
        /// 名字搜索的执行
        /// </summary>
        private void btnSearchTitle_Click(object sender, System.EventArgs e)
        {
            showBooksByTitle();
        }

        /// <summary>
        /// 价格搜索的执行
        /// </summary>
        private void btnSearchPriceWeight_Click(object sender, System.EventArgs e)
        {
            showBooksByPrice();
        }

        /// <summary>
        /// 处理“浏览按钮”的时候
        /// </summary>
        private void btnRead_Click(object sender, System.EventArgs e)
        {
            //如果这本书书号是有效的，“查看”对话框显示
            if (getBookIsbnBySelcectedRow() != "")
            {
                frmBookDetail frmdetail = new frmBookDetail();
                frmdetail.BookIsbn = getBookIsbnBySelcectedRow();
                frmdetail.CrudStatus = "READ";
                frmdetail.ShowDialog();
            }
        }

        /// <summary>
        /// “添加”按钮被按下的时候处理
        /// </summary>
        private void btnCreate_Click(object sender, System.EventArgs e)
        {
            //"添加"的书籍对话框显示
            frmBookDetail frmdetail = new frmBookDetail();
            frmdetail.CrudStatus = "CREATE";
            frmdetail.ShowDialog();
            //如果有变化,重新显示，
            if (frmdetail.DialogResult == DialogResult.OK)
            {
                showBooksByTitle();
            }
        }

        /// <summary>
        /// 按“删除按钮”的时候处理
        /// </summary>
        private void btnDelete_Click(object sender, System.EventArgs e)
        {
            //如果这本书书号是有效的“删除”对话框中显示
            if (getBookIsbnBySelcectedRow() != "")
            {
                frmBookDetail frmdetail = new frmBookDetail();
                frmdetail.BookIsbn = getBookIsbnBySelcectedRow();
                frmdetail.CrudStatus = "DELETE";
                frmdetail.ShowDialog();
                //刷新
                if (frmdetail.DialogResult == DialogResult.OK)
                {
                    showBooksByTitle();
                }
            }
        }

        /// <summary>
        /// 更新
        /// </summary>
        private void btnUpdate_Click(object sender, System.EventArgs e)
        {
            if (getBookIsbnBySelcectedRow() != "")
            {
                frmBookDetail frmdetail = new frmBookDetail();
                frmdetail.BookIsbn = getBookIsbnBySelcectedRow();
                frmdetail.CrudStatus = "UPDATE";
                frmdetail.ShowDialog();
                //刷新
                if (frmdetail.DialogResult == DialogResult.OK)
                {
                    showBooksByTitle();
                }
            }
        }

        /// <summary>
        /// 名字搜索的执行
        /// </summary>
        private void showBooksByTitle()
        {
            try
            {
                //LIKE搜索运行
                //IList books = Mapper.Instance().QueryForList("GetBookListByTitle", this.txtTitle.Text);
                IList books = mapper.QueryForList("GetBookListByTitle", this.txtTitle.Text);
                //清除数据
                _dataTable.Clear();
                //设置搜索结果的数据
                foreach (Book book in books)
                {
                    _dataTable.Rows.Add(new Object[]
                    {book.Isbn, book.IsbnWithHyphen, book.Title, book.Price, book.SaleDate});
                }
            }
            catch (Exception ex)
            {
                throw;
            }
        }

        /// <summary>
        /// 价格搜索的执行
        /// </summary>
        private void showBooksByPrice()
        {
            //价格搜索运行
            Hashtable param = new Hashtable();
            param.Add("price", this.cmbPrice.Text); //价格
            param.Add("priceCompare", this.cmbPrice2.Text); //「以上」or「以下」
            IList books = mapper.QueryForList("GetBookListByPrice", param);
            //清除数据
            _dataTable.Clear();
            //将搜索结果的数据
            foreach (Book book in books)
            {
                _dataTable.Rows.Add(new Object[] {book.Isbn, book.IsbnWithHyphen, book.Title, book.Price, book.SaleDate});
            }
        }

        /// <summary>
        /// 获得所选择的行的书籍ISBN在数据
        /// </summary>
        private string getBookIsbnBySelcectedRow()
        {
            string result = "";
            try
            {
                result = (string) grdMain[grdMain.CurrentCell.RowNumber, 0];
            }
            catch (Exception e)
            {
                //如果图书列表一个按钮被点击一个空白的状态（可能）
                _logger.Debug(e.Message);
            }
            return result;
        }

        private void grdMain_Paint(object sender, System.Windows.Forms.PaintEventArgs e)
        {
            //点击的时候选择一整行
            if (_dataTable.Rows.Count != 0)
            {
                this.grdMain.Select(this.grdMain.CurrentCell.RowNumber);
            }
        }
    }

运行结果如图:

这里写图片描述

搜索结果:

这里写图片描述

查看详细:

这里写图片描述

更新数据:

这里写图片描述

删除数据:

这里写图片描述

其他相关文章

MyBatis.Net使用入门(二)
MyBatis.Net使用入门(一)

.NET跨平台
关注
专栏目录
MyBatis.Net入门之基础配置（一）
博客
05-27 1029
1，安装IBatis.Net包 2，建立测试模型 namespace Demo.Demo8 { public class ceshi1 { public string a { get; set; } public string b { get; set; } } } 3，配置文件 3.1，SqlMap.config <?xml ver...
MyBatis.Net入门之指定配置文件位置及多类型数据库支持（二）
博客
05-27 306
1，将配置文件统一修改至Configs文件夹 2，在App_Start文件夹中，新增配置类 namespace MyBatisNetTest.App_Start { public class IBatisConfig { public static ISqlMapper GetInstance { get; private set; } ...
mybatis.net mysql_Mybatis.net
weixin_26849971的博客
02-01 341
第一次学习Mybatis.net，在博客园也找到好多资料，但是在配置成功之后也遇到了一些问题，尤其是在动态SQl拼接时候，这里把遇到的问题还有自己写的一个Demo贴出来，希望能帮到新手，有不适合的地方也希望大家指出，大家互相学习，共同进步。首先我们需要下载IBatisNet程序包，这里就不多说了一、创建一个MVC4的Web应用程序，并引用我们下载的IBatisNet程序包中的IBatisNet.D...
MyBatis.NET
qq_18932003的博客
10-15 164
iBATIS.NET - DataMapper Application Framework https://ibatis.apache.org/docs/dotnet/datamapper/ ibatis帮你拼接的组合查询sql，也是可以直接print出来的。 https://www.cnblogs.com/13590/archive/2013/02/27/2934580.html MyBatis.NET https://www.codeproject.com/articles/894127/mybat
MyBatis.Net 资料整理
weixin_33912638的博客
01-05 94
现在ORM框架实在很多, Java就不说了, 单.Net这边, NHibernate如雷贯耳, 微软的EF也来势汹汹, 好像castle project也有一个activerecord. 说实在的, 这些框架我都仅仅是知道有这么个东西, 没有做深入的研究和实践. IBatis也是很早就知道了, 对这个框架的定位映象很深.  空闲时候, 研究研究看看能不能在下一个项目中用得上.    夏昕的IB...
mybatis mysql net教程_c# mybatis net +mysql
weixin_30407555的博客
01-27 205
http://www.codeproject.com/Articles/894127/WebControls/#_comments 在这里。。。这是一个mybatisnet 连接sqlserver的例子 只要改到连接 mysql就可以了。2、修改连接 mysql首先要下载 mysql-conector-net ，安装，引入mysql.data.dll修改provider.confi...
第一个mybatis程序 mybatis入门
03-14
【标题】"第一个mybatis程序 mybatis入门" 涉及到的是MyBatis框架的基础使用，这是一个轻量级的Java持久层框架，它简化了与数据库交互的过程，提供了强大的映射功能。以下是对MyBatis入门的详细解析： 1. **MyBatis...
MyBatis从入门到精通
Sunblogy的博客
05-18 985
MyBatis 1.MyBatis介绍 1.1 MyBatis基本介绍 结合MyBatis官网一起阅读，效果更加哟~~~ 1.2 JDBC缺点 1.3 MyBatis 简化JDBC 2.MyBatis快速入门 要求： 2.1 创建数据库表 创建一个自己的表，属性自己去确定，也可以用我的： 输入以下数据库信息： 语句： create database mybatis; use mybatis; drop table if exists tb_user; create table tb_use
MyBatis框架的入门学习
AtlantisChina
10-27 381
包含了Mybatis框架的概述、环境搭建、以及简单的入门案例和注解开发。
mybatisnet源代码
05-28
myBatisnet源代码，SVN地址:http://mybatisnet.googlecode.com/svn 此源码为VS2008开发
asp.net搭建mybatis开发环境
05-19
经过认真的探索终于把asp.net上的mybatis搞清楚了，虽然自己运气很差看了几篇类似的误人子弟的文章。最终还是写出了像样的程序。
MyBatis.NET两个代码生成工具源码+demo+学习资料.zip
04-10
“MesnacCoding_MyBatis.NET”和“ibatis生成工具和使用文档以及样例”两个文件夹是网上两位大佬开发的开源生成工具源码和学习资料 “MyBatisSample”是另外一大佬开发的一个使用例子 都是非常好的资料，分享一下
MyBatis.Net使用入门(二)
极客神殿
08-17 3979
MyBatis使用入门(二)EntityModel模型层的类Customer.cs和Product.cs代码如下: public class Customer { public int CustomerID { get; set; } public string CustomerName { get; set; } public bool
Mybatis.NET入门学习
极客神殿
12-05 3150
MyBatis是一个数据映射工具。 它将包括存储过程的数据库查询的列映射到业务对象的属性。 映射器的一个定义是“在两个独立对象之间建立通信的对象。 数据映射器是“映射器层，用于在对象和数据库之间移动数据，同时使它们彼此之间以及映射器本身保持独立。 为什么？ .NET platform already provides a capable library for accessing databases, whether through SQL statements or stored procedures b
初学MyBatis.net
weixin_30542079的博客
05-07 212
1、MyBatis.net介绍 MyBatis..net是一个简单，但是完整的ORM框架，它使你的实体对象与sql语句或者存储过程之间的映射变得很简单，并提供数据访问。包括两个主要框架 DataAccess FrameWork和DataMapper FrameWork DataAccessObject Framework and DataMapper Framework are ...
c# mybatis net +mysql 的一个初步摸索
zzzxxbird的专栏
10-24 5155
最近 用到  c#+  mysql  + mybatis.net 这个组合的资料不是很好找 ，先总结一下。 1找到  mybatis.net最好有个例子 http://www.codeproject.com/Articles/894127/WebControls/#_comments  在这里。。。 这是一个mybatisnet  连接sqlserver的例子 只要改到连接
Mybatis.net + Mysql
最新发布
Sucker的小笔记
04-30 610
安装时，尽量不要选择太高的版本，否则有可能跟已有的.NET Framework 版本不匹配。安装完成后，在管理器中的引用列表中，会多出来一个引用文件：Mysql.Data文件。安装完成后，会显示在，在已安装页面。同时，在管理器中的引用列表中，会多出来两个引用文件。设置完成后，邮件Providers.config文件，选择属性，进行设置。与Providers.config相同的创建步骤。Controller层（应用层）注意，此处我使用的是Mysql，Mapper层（也叫DAO层）映射层Mapper.xml。
学习MyBatis.Net 之路(一)
qq_34057374的博客
09-02 1808
MyBatis.NET的前身为IBatis，是JAVA版MyBatis在.NET平台上的翻版，相对NHibernate、EntityFramework等重量级ORM框架而言，MyBatis.NET必须由开发人员手动写SQL，相对灵活性更大，更容易保证DB访问的性能，适用开发团队里有SQL熟手的场景。下面是使用步骤： 1.到官网http://code.google.com/p/mybatisnet/
iBatis.Net入门与实践指南
"《myBatis.net详细手册》是一本全面介绍iBatis.NET的实用指南，作者作为一名初级学习者，旨在分享自己的...《myBatis.net详细手册》是一份实用且富有实践价值的学习资料，无论是为了入门还是深化理解，都值得一读。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值