C#写入数据到mysql数据库,这段代码哪里有问题?请教各位!在线等待达人!
代码如下:/// <summary>
/// 写入到数据库
/// </summary>
static private void WriteToDb(List<Player> players)
{
string source = "DSN=MySqlOperation";
OdbcConnection conn = null;
OdbcCommand cmd = null;
try
{
conn = new OdbcConnection(source);
conn.Open();
cmd = conn.CreateCommand(); foreach (Player p in players)
{
string sqlStr = @"INSERT
INTO nbaPlayers
VALUES(?EnglishName,?ChineseName,?Team,?Birthday,?Height,?Weight,?ComeFrom,?Career)"; OdbcParameter para_0 = new OdbcParameter("?EnglishName", OdbcType.VarChar, 50);
para_0.Value = p.EnglishName;
cmd.Parameters.Add(para_0); OdbcParameter para_1 = new OdbcParameter("?ChineseName", OdbcType.VarChar, 50);
para_1.Value = p.ChineseName;
cmd.Parameters.Add(para_1); OdbcParameter para_2 = new OdbcParameter("?Team", OdbcType.VarChar, 50);
para_2.Value = p.Team;
cmd.Parameters.Add(para_2); OdbcParameter para_3 = new OdbcParameter("?Birthday", OdbcType.VarChar, 50);
para_3.Value = p.Birthday;
cmd.Parameters.Add(para_3); OdbcParameter para_4 = new OdbcParameter("?Height", OdbcType.VarChar, 50);
para_4.Value = p.Height;
cmd.Parameters.Add(para_4); OdbcParameter para_5 = new OdbcParameter("?Weight", OdbcType.VarChar, 50);
para_5.Value = p.Weight;
cmd.Parameters.Add(para_5); OdbcParameter para_6 = new OdbcParameter("?ComeFrom", OdbcType.VarChar, 50);
para_6.Value = p.ComeFrom;
cmd.Parameters.Add(para_6); OdbcParameter para_7 = new OdbcParameter("?Career", OdbcType.Int);
para_7.Value = p.Career;
cmd.Parameters.Add(para_7); cmd.CommandText = sqlStr;
cmd.ExecuteNonQuery(); }
}
catch(Exception excpt)
{
//MessageBox.Show(excpt.Message);
Console.WriteLine(excpt.Message);
}
finally
{
conn.Close();
Console.WriteLine("------------over----------");
}
}谢谢大家!
代码如下:/// <summary>
/// 写入到数据库
/// </summary>
static private void WriteToDb(List<Player> players)
{
string source = "DSN=MySqlOperation";
OdbcConnection conn = null;
OdbcCommand cmd = null;
try
{
conn = new OdbcConnection(source);
conn.Open();
cmd = conn.CreateCommand(); foreach (Player p in players)
{
string sqlStr = @"INSERT
INTO nbaPlayers
VALUES(?EnglishName,?ChineseName,?Team,?Birthday,?Height,?Weight,?ComeFrom,?Career)"; OdbcParameter para_0 = new OdbcParameter("?EnglishName", OdbcType.VarChar, 50);
para_0.Value = p.EnglishName;
cmd.Parameters.Add(para_0); OdbcParameter para_1 = new OdbcParameter("?ChineseName", OdbcType.VarChar, 50);
para_1.Value = p.ChineseName;
cmd.Parameters.Add(para_1); OdbcParameter para_2 = new OdbcParameter("?Team", OdbcType.VarChar, 50);
para_2.Value = p.Team;
cmd.Parameters.Add(para_2); OdbcParameter para_3 = new OdbcParameter("?Birthday", OdbcType.VarChar, 50);
para_3.Value = p.Birthday;
cmd.Parameters.Add(para_3); OdbcParameter para_4 = new OdbcParameter("?Height", OdbcType.VarChar, 50);
para_4.Value = p.Height;
cmd.Parameters.Add(para_4); OdbcParameter para_5 = new OdbcParameter("?Weight", OdbcType.VarChar, 50);
para_5.Value = p.Weight;
cmd.Parameters.Add(para_5); OdbcParameter para_6 = new OdbcParameter("?ComeFrom", OdbcType.VarChar, 50);
para_6.Value = p.ComeFrom;
cmd.Parameters.Add(para_6); OdbcParameter para_7 = new OdbcParameter("?Career", OdbcType.Int);
para_7.Value = p.Career;
cmd.Parameters.Add(para_7); cmd.CommandText = sqlStr;
cmd.ExecuteNonQuery(); }
}
catch(Exception excpt)
{
//MessageBox.Show(excpt.Message);
Console.WriteLine(excpt.Message);
}
finally
{
conn.Close();
Console.WriteLine("------------over----------");
}
}谢谢大家!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货