- C#后端在web.config中进行配置,如果端口号默认为3306,不用指明端口号,以下为两种写法
<configuration>
<appSettings>
<add key="MySqlConnection" value="server=服务器地址;port=端口号;database=数据库;uid=账号;pwd=密码;"/>
</appSettings>
</configuration>
<connectionStrings>
<add name="MySqlConnection" connectionString="server=服务器地址;port=端口号;database=数据库;uid=账号;pwd=密码;"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
- 配置好之后进行获取,查询结果为DataSet后可通过Tables[0]获取,更新等操作为更新行数
var connectionString= ConfigurationManager.AppSettings["MySqlConnection"];
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
using (MySqlDataAdapter adapter = new MySqlDataAdapter(SQLString, connection))
{
adapter.Fill(ds);
}
using (MySqlCommand cmd = new MySqlCommand(SQLString, connection))
{
if (parameters != null)
{
foreach (var parameter in parameters)
{
command.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
}
int numRowsAffected = cmd.ExecuteNonQuery();
}
connection.Close();
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
- 上面两种操作可以分别封装成相应的查询和更新方法进行调用