{"id":255,"date":"2022-06-24T14:52:07","date_gmt":"2022-06-24T06:52:07","guid":{"rendered":"https:\/\/www.fengjijiao.cn\/?p=255"},"modified":"2022-06-24T14:52:07","modified_gmt":"2022-06-24T06:52:07","slug":"c%e5%9f%ba%e6%9c%ac%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/www.fengjijiao.cn\/?p=255","title":{"rendered":"C#\u57fa\u672c\u6570\u636e\u5e93\u64cd\u4f5c"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>using System;\r\nusing System.Collections.Generic;\r\nusing System.Linq;\r\nusing System.Text;\r\nusing System.Threading.Tasks;\r\nusing MySql.Data.MySqlClient;\r\n\r\nnamespace ConsoleApp1\r\n{\r\n    class Program\r\n    {\r\n        static void Main(string&#91;] args)\r\n        {\r\n            Console.WriteLine(\"lxh yyds!\");\r\n            String uri = \"server=localhost;port=3308;user=root;password=123456;database=test;\";\r\n            using (MySqlConnection conn = new MySqlConnection(uri))\r\n            {\r\n                conn.Open();\r\n                \/\/\u67e5\r\n                String sql = \"select username, password from user where id = @id;\";\r\n                MySqlCommand cmd = new MySqlCommand(sql, conn);\r\n                cmd.Parameters.Add(new MySqlParameter(\"id\", 1));\r\n                UserEntity user = new UserEntity();\r\n                using (MySqlDataReader reader = cmd.ExecuteReader()) {\r\n                    if(reader.HasRows)\r\n                    {\r\n                        Console.WriteLine(\"\u67e5\u8be2\u6210\u529f\uff01\");\r\n                        while(reader.Read())\r\n                        {\r\n                            user.UserName = reader.GetString(0);\r\n                            user.PassWord = reader.GetString(1);\r\n                            Console.WriteLine(user);\r\n                        }\r\n                    }else\r\n                    {\r\n                        Console.WriteLine(\"\u67e5\u8be2\u5931\u8d25\uff01\");\r\n                    }\r\n                }\r\n                \/\/\u589e\r\n                String createSql = \"insert into user (username, password) value (@username, @password);\";\r\n                MySqlCommand createCmd = new MySqlCommand(createSql, conn);\r\n                MySqlParameter&#91;] createParams = { new MySqlParameter(\"username\", \"b\"), new MySqlParameter(\"password\", \"bpassword\")};\r\n                createCmd.Parameters.AddRange(createParams);\r\n                int createCount = createCmd.ExecuteNonQuery();\r\n                if(createCount > 0)\r\n                {\r\n                    Console.WriteLine(\"\u521b\u5efa\u6210\u529f\uff01\");\r\n                } else\r\n                {\r\n                    Console.WriteLine(\"\u521b\u5efa\u5931\u8d25\uff01\");\r\n                }\r\n                \/\/\u5220\r\n                String deleteSql = \"delete from user where username = @username;\";\r\n                MySqlCommand deleteCmd = new MySqlCommand(deleteSql, conn);\r\n                MySqlParameter&#91;] deleteParams = { new MySqlParameter(\"username\", \"b\")};\r\n                deleteCmd.Parameters.AddRange(deleteParams);\r\n                int deleteCount = deleteCmd.ExecuteNonQuery();\r\n                if (deleteCount > 0)\r\n                {\r\n                    Console.WriteLine(\"\u5220\u9664\u6210\u529f\uff01\");\r\n                } else\r\n                {\r\n                    Console.WriteLine(\"\u5220\u9664\u5931\u8d25\uff01\");\r\n                }\r\n                \/\/\u6539\r\n                String updateSql = \"update user set password = '@newpassword' where username = @username;\";\r\n                MySqlCommand updateCmd = new MySqlCommand(updateSql, conn);\r\n                MySqlParameter&#91;] updateParams = { new MySqlParameter(\"newpassword\", \"999\"), new MySqlParameter(\"username\", \"a\")};\r\n                updateCmd.Parameters.AddRange(updateParams);\r\n                int updateCount = updateCmd.ExecuteNonQuery();\r\n                if(updateCount > 0)\r\n                {\r\n                    Console.WriteLine(\"\u4fee\u6539\u6210\u529f\uff01\");\r\n                } else\r\n                {\r\n                    Console.WriteLine(\"\u4fee\u6539\u5931\u8d25\uff01\");\r\n                }\r\n            }\r\n                \r\n            Console.ReadKey();\r\n        }\r\n    }\r\n\r\n    class UserEntity\r\n    {\r\n        public String UserName { get; set; }\r\n        public String PassWord { get; set; }\r\n\r\n        public override string ToString()\r\n        {\r\n            return $\"UserName={UserName};Password={PassWord}\";\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[20],"_links":{"self":[{"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/posts\/255"}],"collection":[{"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=255"}],"version-history":[{"count":1,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":256,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions\/256"}],"wp:attachment":[{"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fengjijiao.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}