c# mysql insert_C#像Mysql数据库插入数据

publicstaticvoidInsertIntoDataBase(MySqlConnection conn,Theme theme)

{stringsqlcommand="insert into processedpapers(dc_ID,dc_title,dc_titleTokens,dc_descriptionTokens,dc_len,dc_description)values(@mydcid,@dmydctitle,@mydctitletokens,@mydcdescriptiontokens,@mydclen,@mydcdescription)";

MySqlParameter dc_ID=newMySqlParameter("@mydcid", MySqlDbType.Int32);

dc_ID.Value=theme.dc_ID;

MySqlParameter dc_len=newMySqlParameter("@mydclen", MySqlDbType.Int16);

dc_len.Value=theme.dc_len;

MySqlParameter dc_title=newMySqlParameter("@mydctitle", MySqlDbType.VarChar,500);

dc_title.Value=theme.dc_title;

MySqlParameter dc_titleTokens=newMySqlParameter("@mydctitletokens", MySqlDbType.VarChar,500);

dc_titleTokens.Value=theme.dc_titleTokens;

MySqlParameter dc_descriptionTokens=newMySqlParameter("@mydcdescriptiontokens", MySqlDbType.Text);

dc_descriptionTokens=theme.dc_descriptionTokens;

MySqlParameter dc_description=newMySqlParameter("@mydcdescription",MySqlDbType.Text);

dc_description.Value=theme.dc_description;

MySqlCommand cmd=newMySqlCommand(sqlcommand, conn);

cmd.Parameters.Add(dc_ID);

cmd.Parameters.Add(dc_len);

cmd.Parameters.Add(dc_title);

cmd.Parameters.Add(dc_titleTokens);

cmd.Parameters.Add(dc_descriptionTokens);

cmd.Parameters.Add(dc_description);

conn.Open();try{

cmd.ExecuteNonQuery();

}catch(System.Exception e)

{

StreamWriter sw=newStreamWriter("C:\\myerror.txt",true, Encoding.Default);

sw.Write(e.Message);

sw.Close();//一旦发生错误程序就停止运行，等待用户发现Console.Read();

}

conn.Close();

}

}//文章类辅助插入数据库操作///publicclassTheme

{publicintdc_ID;publicintdc_len;publicstringdc_title;publicstringdc_titleTokens;publicstringdc_descriptionTokens;publicstringdc_description;publicTheme()

{

dc_ID=0;

dc_len=0;

dc_title=string.Empty;

dc_titleTokens=string.Empty;

dc_descriptionTokens=string.Empty;

dc_description=string.Empty;

}

}