iBATIS.NET 学习笔记(六)-优快云博客

本文介绍如何使用iBATIS.NET框架在Northwind数据库的Customers表中添加记录。通过一个ASP.NET Web页面实现数据输入及保存操作，并展示了完整的代码实现。

用iBATIS.NET实现简单的添加记录到数据库(向数据库Northwind中的Cutsomers表添加记录)
新建Web页面，Test2.aspx

@ Page language="c#" Codebehind="Test2.aspx.cs" AutoEventWireup="false" Inherits="IbatisNet.Example.Test2" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

</HEAD>

<body>

<h1><P><FONT face="宋体">添加记录到数据库</FONT></P>

<TR>

<TD>CustomerID</TD>

<TD>

<asp:TextBox id="txtID" runat="server" MaxLength="5"></asp:TextBox></TD>

</TR>

<TR>

<TD>CompanyName</TD>

<TD>

<asp:TextBox id="txtComName" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>ContactName</TD>

<TD>

<asp:TextBox id="txtContName" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>ContactTitle</TD>

<TD>

<asp:TextBox id="txtContTitle" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>Address</TD>

<TD>

<asp:TextBox id="txtAddress" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>

<asp:TextBox id="txtCity" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>Region</TD>

<TD>

<asp:TextBox id="txtRegion" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>PostalCode</TD>

<TD>

<asp:TextBox id="txtPostal" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>Country</TD>

<TD>

<asp:TextBox id="txtCountry" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>Phone</TD>

<TD>

<asp:TextBox id="txtPhone" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<TD>

<asp:TextBox id="txtFax" runat="server"></asp:TextBox></TD>

</TR>

<TR>

<asp:Button id="btnSave" runat="server" Text="保存"></asp:Button></TD>

</TR>

</TABLE>

</FONT>

</P>

</h1>

<asp:Label id="lbMessage" runat="server" ForeColor="Red"></asp:Label>

</form>

</body>

</HTML>

Test2.aspx.cs

//***********************************************************

//*公司：浙江航大科技开发有限公司

//*作者：YK

//*模块：Test2

//*功能：

//*创建日期：

//*修改日期：

//***********************************************************

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using IBatisNet.Common;

using IBatisNet.DataMapper;

using IBatisNet.DataAccess;

namespace IbatisNet.Example

{

/**//// <summary>

/// Test2 的摘要说明。

/// </summary>

public class Test2 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox txtID;

protected System.Web.UI.WebControls.TextBox txtComName;

protected System.Web.UI.WebControls.TextBox txtContName;

protected System.Web.UI.WebControls.TextBox txtContTitle;

protected System.Web.UI.WebControls.TextBox txtAddress;

protected System.Web.UI.WebControls.TextBox txtCity;

protected System.Web.UI.WebControls.TextBox txtRegion;

protected System.Web.UI.WebControls.TextBox txtPostal;

protected System.Web.UI.WebControls.TextBox txtCountry;

protected System.Web.UI.WebControls.TextBox txtPhone;

protected System.Web.UI.WebControls.TextBox txtFax;

protected System.Web.UI.WebControls.Label lbMessage;

protected System.Web.UI.WebControls.Button btnSave;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

}

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

override protected void OnInit(EventArgs e)

{

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.btnSave.Click += new System.EventHandler(this.btnSave_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void btnSave_Click(object sender, System.EventArgs e)

{

IbatisNet.Example.Model.Customers customer = new IbatisNet.Example.Model.Customers();

customer.CustomerID = this.txtID.Text;

customer.CompanyName = this.txtComName.Text;

customer.ContactName = this.txtContName.Text;

customer.ContactTitle = this.txtContTitle.Text;

customer.Country = this.txtCountry.Text;

customer.Fax = this.txtFax.Text;

customer.Phone = this.txtPhone.Text;

customer.PostalCode = this.txtPostal.Text;

customer.Region = this.txtRegion.Text;

customer.Address = this.txtAddress.Text;

customer.City = this.txtCity.Text;

try

{

//添加记录到数据库

//"InsertCustomer"添加语句在Maps/Customers.xml中设置

IbatisNet.Example.Mapper.Instance().Insert("InsertCustomer",customer);

this.lbMessage.Text="新增记录成功！";

}

catch(Exception ex)

{

this.lbMessage.Text="新增记录出错！："+ex.Message;

}

转载于:https://www.cnblogs.com/yknb/archive/2006/07/19/454947.html