C#与MySQL直接连接

来源：互联网发布：中企动力源码编辑：程序博客网时间：2024/06/03 21:23

C#与MySQL直接连接

需要引入references，参考项目名上右键 properties中的框架版本，从C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.5
引入

static void Main(string[] args)        {            string connStr = "server=localhost;port=3306;database=mygame;user=root;password=mooy1996com;";            MySqlConnection conn = new MySqlConnection(connStr);            try            {                conn.Open();                //string sql = "Insert into users(user_name,password) values('guaa','memeta')";   //删除修改同样                //MySqlCommand cmd = new MySqlCommand(sql, conn);                                 //相当于ExcuteQuery(),返回的是影响的行数                //int r = cmd.ExecuteNonQuery();                string sql2 = "Select * from users";                //string sql3 = "Select * from users where user_name = "+user_name+", user_password = "+user_password;                //string sql4 = "Select * from users where user_id = @user_name , user_password = @password;                //cmd.Parameters.AddWithValue("username");                MySqlCommand cmm = new MySqlCommand(sql2, conn);                MySqlDataReader reader = cmm.ExecuteReader();                                   //相当于ExcuteQuery(sql)?并且返回结果集                //int read = (int)cmm.ExecuteScalar();                                            //只返回第一行的结果（结果唯一的时候比较好）                //Console.WriteLine(read);                while (reader.Read())                {                    Console.WriteLine(reader[0].ToString() + "  " + reader[1].ToString());           //reader[0]是第一列，相当于java里GetString(0);                    //reader.getInt32(0);reader.getInt("user_id");//秒打脸                }                 Console.WriteLine("连接成功！");            }            catch (Exception ex)            {                Console.WriteLine(ex.ToString());            }            finally            {                conn.Close();                Console.WriteLine("关闭成功！");            }            Console.ReadKey();        }

阅读全文

0 0