增
string[] textRead = File.ReadAllLines(@"C:\Test\local_doctor.txt");
String sql = "insert into doctor(user,pwd,reg_date) VALUE ('" + textRead[0].Substring(0, 24) + "','" + textRead[0].Substring(25, 24) + "','" + textRead[0].Substring(50, 17) + "');";
删
string sql = "delete from zwttable where name=tony";
查
string sql = "select * from record where judge = 0;";
改
""里句尾没有分号
string sql = "update doctor set judge = 1 where judge = 0";
string sql = "update zwttable set name=tony,age=26";