C# Class FrameDAL.DbHelper.MySqlHelper

Author: Vincent Lau. MySql数据库访问助手
Inheritance: BaseHelper
显示文件 Open project: vincentlauvlwj/FrameDAL

Public Methods

Method Description
MySqlHelper ( ) : System
MySqlHelper ( string connStr ) : System
NewConnection ( ) : DbConnection

创建一个DbConnection对象
NewDataAdapter ( DbCommand cmd ) : DbDataAdapter

创建一个数据适配器对象
PrepareCommand ( DbConnection conn, DbTransaction trans, string sqlText ) : DbCommand

使用给定参数创建DbCommand对象

Private Methods

Method Description
AddParamsToCmd ( MySqlCommand cmd, object parameters ) : void
AddParamsToList ( List arr, ICollection parameters ) : void

Method Details

MySqlHelper() public method

public MySqlHelper ( ) : System
return System

MySqlHelper() public method

public MySqlHelper ( string connStr ) : System
connStr string
return System

NewConnection() public method

创建一个DbConnection对象
public NewConnection ( ) : DbConnection
return DbConnection

NewDataAdapter() public method

创建一个数据适配器对象
public NewDataAdapter ( DbCommand cmd ) : DbDataAdapter
cmd DbCommand 命令对象
return System.Data.Common.DbDataAdapter

PrepareCommand() public method

使用给定参数创建DbCommand对象
public PrepareCommand ( DbConnection conn, DbTransaction trans, string sqlText ) : DbCommand
conn DbConnection 数据库连接
trans DbTransaction 数据库事务
sqlText string 含有问号占位符的SQL命令
return DbCommand