行 308: public static object GetSingle(string SQLString, params MySqlParameter[] cmdParms)
行 309: {
行 310: using (MySqlConnection connection = new MySqlConnection(connectionString))
行 311: {
行 312: using (MySqlCommand cmd = new MySqlCommand())数据库访问层如下 public SQLHelper()
{
//
//TODO: 在此处添加构造函数逻辑
//
} //数据库连接字符串(web.config来配置),可以动态更改connectionString支持多数据库.
//todo:数据库连接字符串
public static string connectionString = GetConnString(); public static string GetConnString()
{
string DatabaseName = ConfigurationManager.AppSettings["conn"];
string DBName = ConfigurationManager.AppSettings["redminelog"];
return DatabaseName + System.Web.HttpContext.Current.Server.MapPath(DBName);
} #region 执行简单SQL语句 /// <summary>
/// 执行SQL语句,返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySql.Data.MySqlClient.MySqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
-----------------------------------------------------PS我连接的是MYSQL 数据库
行 309: {
行 310: using (MySqlConnection connection = new MySqlConnection(connectionString))
行 311: {
行 312: using (MySqlCommand cmd = new MySqlCommand())数据库访问层如下 public SQLHelper()
{
//
//TODO: 在此处添加构造函数逻辑
//
} //数据库连接字符串(web.config来配置),可以动态更改connectionString支持多数据库.
//todo:数据库连接字符串
public static string connectionString = GetConnString(); public static string GetConnString()
{
string DatabaseName = ConfigurationManager.AppSettings["conn"];
string DBName = ConfigurationManager.AppSettings["redminelog"];
return DatabaseName + System.Web.HttpContext.Current.Server.MapPath(DBName);
} #region 执行简单SQL语句 /// <summary>
/// 执行SQL语句,返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString)
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (MySql.Data.MySqlClient.MySqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}
-----------------------------------------------------PS我连接的是MYSQL 数据库
没用过MySql、谷歌一下
public static string GetConnString()
{
string DatabaseName = ConfigurationManager.AppSettings["conn"];
string DBName = ConfigurationManager.AppSettings["redminelog"];
return "server=127.0.0.1;database=codematic2;uid=sa;pwd=password"
}