111,130
社区成员
发帖
与我相关
我的任务
分享
/// <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----------");
}
}