sqlhelper mysql_谁有Mysql数据库的 SQLHelper类 我手里只有SQLServer2005的和Access的，现要用Mysql的，谁有啊？...

展开全部

这是我自己封装了一个e5a48de588b662616964757a686964616f31333264626535,写的不好,但凑合能用,你看一下

using System;

using System.Data;

using MySql.Data.MySqlClient;

namespace Common.Mysql

{

public class MysqlHelper

{

///

/// 执行一条插入SQL语句,返回插入记录的主键id

///

/// MysqlConnection对象

/// Sql语句

/// Sql语句中的参数

/// 返回插入记录的主键id

public static long Insert(MySqlConnection connection, String sql, MySqlParameter[] ps)

{

if (connection.State.ToString() != "Open")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = sql;

cmd.Parameters.AddRange(ps);

cmd.ExecuteNonQuery();

long result = cmd.LastInsertedId;

connection.Close();

return result;

}

///

/// 执行一条插入SQL语句,返回插入记录的主键id

///

/// 连接字符串

/// Sql语句

/// Sql语句中的参数

/// 返回插入记录的主键id

public static long Insert(String connectionString, String sql, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return Insert(connection, sql, ps);

}

///

/// 执行一条删除SQL语句,返回受影响的行数

///

/// MysqlConnection对象

/// SQL语句,如delete from tablename where ...

/// 参数列表

/// 执行SQL语句后,受影响的行数

public static int Delete(MySqlConnection connection, String sql, MySqlParameter[] ps)

{

if (connection.State.ToString() != "Open")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = sql;

cmd.Parameters.AddRange(ps);

int result = cmd.ExecuteNonQuery();

connection.Close();

return result;

}

///

/// 执行一条删除SQL语句,返回受影响的行数

///

/// 连接字符串

/// SQL语句,如delete from tablename where ...

/// 参数列表

/// 执行SQL语句后,受影响的行数

public static int Delete(String connectionString, String sql, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return Delete(connection, sql, ps);

}

///

/// 执行一条更新SQL语句,返回受影响的行数

///

/// MysqlConnection对象

/// 更新SQL语句,如Update tablename set ....

/// 参数列表

///

public static int Update(MySqlConnection connection, String sql, MySqlParameter[] ps)

{

if (connection.State.ToString() == "Closed")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = sql;

cmd.Parameters.AddRange(ps);

int result = cmd.ExecuteNonQuery();

connection.Close();

return result;

}

///

/// 执行一条更新SQL语句,返回受影响的行数

///

/// 连接字符串

/// 更新SQL语句,如Update tablename set ....

/// 参数列表

///

public static int Update(String connectionString, String sql, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return Update(connection, sql, ps);

}

///

///执行一条查询SQL语句,返回结果集

///

/// MysqlConnection对象

/// 查询SQL语句,如Select * from tablename where ....

/// 参数列表

/// 返回一个DataSet 对象

public static DataSet Query(MySqlConnection connection, String sql, MySqlParameter[] ps)

{

if (connection.State.ToString() == "Closed")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = sql;

if (ps != null && ps.Length > 0)

{

cmd.Parameters.AddRange(ps);

}

MySqlDataAdapter mda = new MySqlDataAdapter(cmd);

DataSet ds = new DataSet();

mda.Fill(ds);

connection.Close();

return ds;

}

///

///执行一条查询SQL语句,返回结果集

///

/// 连接字符串

/// 查询SQL语句,如Select * from tablename where ....

/// 参数列表

/// 返回一个DataSet 对象

public static DataSet Query(String connectionString, String sql, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return Query(connection, sql, ps);

}

///

/// 执行一条查询SQL语句

///

/// MysqlConnection对象

/// 查询SQL语句,如select * from tablename where ...

/// 返回一个DataSet 对象

public static DataSet Query(MySqlConnection connection, String sql)

{

return Query(connection, sql, null);

}

///

/// 执行一条查询SQL语句

///

/// 连接字符串

/// 查询SQL语句,如select * from tablename where ...

/// 返回一个DataSet 对象

public static DataSet Query(String connectionString, String sql)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return Query(connection, sql);

}

///

/// 运行一个存储过程

///

/// MysqlConnection对象

/// 存储过程名

/// 参数列表

/// 返回查询结果集,以及我们自定义的输出参数

public static DataSet RunProcedure(MySqlConnection connection, String procedureName, MySqlParameter[] ps)

{

if (connection.State.ToString() == "Closed")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = procedureName;

cmd.Parameters.AddRange(ps);

if (!cmd.IsPrepared)

cmd.Prepare();

MySqlDataAdapter mda = new MySqlDataAdapter(cmd);

DataSet ds = new DataSet();

mda.Fill(ds);

mda.Dispose();

connection.Close();

return ds;

}

///

/// 运行一个存储过程

///

/// 连接字符串

/// 存储过程名

/// 参数列表

/// 返回查询结果集,以及我们自定义的输出参数

public static DataSet RunProcedure(String connectionString, String procedureName, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return RunProcedure(connection, procedureName, ps);

}

///

/// 开始一个事务

///

/// 数据库连接字符串

/// 返回一个MysqlTransaction对象

public static MySqlTransaction BeginTransaction(String connectionString)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return connection.BeginTransaction();

}

///

/// 开始执行一个事务

///

/// 数据库连接字符串

/// 隔离级别

/// 返回一个MySqlTransaction对象

public static MySqlTransaction BeginTransaction(String connectionString, IsolationLevel iso)

{

MySqlConnection connection = new MySqlConnection(connectionString);

MySqlTransaction transacation = connection.BeginTransaction(iso);

return transacation;

}

///

/// 执行一条Sql语句,返回执行结果第一行第一列的值

///

/// MySqlConnection对象

/// sql语句

/// 参数

/// 返回执行结果的第一行第一列

public static Object ExecuteScalar(MySqlConnection connection, String sql, MySqlParameter[] ps)

{

if (connection.State.ToString() == "Closed")

{

connection.Open();

}

MySqlCommand cmd = connection.CreateCommand();

cmd.CommandText = sql;

if (ps != null && ps.Length > 0)

{

cmd.Parameters.AddRange(ps);

}

object obj = cmd.ExecuteScalar();

connection.Close();

return obj;

}

///

/// 执行一条Sql语句,返回执行结果的第一行第一列

///

/// 数据库连接字符串

/// sql语句

/// 参数列表

/// Sql语句执行结果的第一行第一列

public static Object ExecuteScalar(String connectionString, String sql, MySqlParameter[] ps)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return ExecuteScalar(connection, sql, ps);

}

///

/// 执行一条Sql语句,返回执行结果的第一行第一列

///

/// 数据库连接字符串

/// sql语句

/// Sql语句执行结果的第一行第一列

public static Object ExecuteScalar(String connectionString, String sql)

{

MySqlConnection connection = new MySqlConnection(connectionString);

return ExecuteScalar(connection, sql, null);

}

}

}

本回答由提问者推荐

已赞过

已踩过<

你对这个回答的评价是？

评论

收起