public TeacherAddResponse Post([FromBody] TeacherAddRequest req) { TeacherAddResponse resp = new TeacherAddResponse(); try { MySqlConnection conn = SQLManager.getConn(); //连接数据库 conn.Open(); //打开数据库连接 MySqlCommand test = null; //创建查询指令 test = new MySqlCommand("select* from teacher where teacher_ID=?id;", conn); test.Parameters.AddWithValue("?id", req.id); MySqlDataReader mdr = test.ExecuteReader(); if (mdr.HasRows) { resp.result = "id existed"; mdr.Close(); } else { mdr.Close(); MySqlCommand cmd = null;//创建查询指令 cmd = new MySqlCommand("insert into Teacher values" + "(@id,@password,@name,@department,@title,@telephone);", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@name", req.name); cmd.Parameters.AddWithValue("@password", req.password); cmd.Parameters.AddWithValue("@department", req.department); cmd.Parameters.AddWithValue("@title", req.title); cmd.Parameters.AddWithValue("@telephone", req.telephone); cmd.Prepare(); cmd.ExecuteNonQuery();//执行insert语句 resp.result = "success"; } conn.Close();//关闭连接 } catch (Exception ex) { Console.WriteLine(ex); resp.result = "fail"; } return(resp); }
public TeacherAddResponse Post([FromBody] TeacherAddRequest req) { TeacherAddResponse resp = new TeacherAddResponse(); try { MySqlConnection conn = SQLManager.getConn(); //连接数据库 conn.Open(); //打开数据库连接 MySqlCommand test = null; //创建查询指令 test = new MySqlCommand("select* from teacher where teacher_ID=?id;", conn); test.Parameters.AddWithValue("?id", req.id); MySqlDataReader mdr = test.ExecuteReader(); if (!mdr.HasRows) //id不存在 { resp.result = "wrong id"; mdr.Close(); } else { mdr.Close(); MySqlCommand cmd = null; //创建指令 if (req.password != null) //修改密码 { cmd = new MySqlCommand("update teacher set password = @password where teacher_ID = @id;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@password", req.password); cmd.Prepare(); cmd.ExecuteNonQuery(); //执行update语句 } if (req.department != null) //修改学院 { cmd = new MySqlCommand("update teacher set department = @department where teacher_ID = @id;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@department", req.department); cmd.Prepare(); cmd.ExecuteNonQuery(); //执行update语句 } if (req.title != null) //修改职称 { cmd = new MySqlCommand("update teacher set title = @title where teacher_ID = @id;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@title", req.title); cmd.Prepare(); cmd.ExecuteNonQuery(); //执行update语句 } if (req.telephone != null) //修改联系方式 { cmd = new MySqlCommand("update teacher set contact_way = @telephone where teacher_ID = @id;", conn); cmd.Parameters.AddWithValue("@id", req.id); cmd.Parameters.AddWithValue("@telephone", req.telephone); cmd.Prepare(); cmd.ExecuteNonQuery();//执行update语句 } resp.result = "success"; } conn.Close();//关闭连接 } catch (Exception ex) { Console.WriteLine(ex); resp.result = "fail"; } return(resp); }