public void TestRegister() { string sid = "123", name = "aaa", password = "******"; StudentEntity student = new StudentEntity() { sid=sid,name=name,password=password}; model.register(student); Assert.AreEqual( model.login(sid, password) ,2); }
public int register(StudentEntity student) { OdbcCommand command = new OdbcCommand("insert into student(sid,name,password) values(?,?,?)",connection); command.Parameters.Add(new OdbcParameter("sid", OdbcType.VarChar)).Value = student.sid ; command.Parameters.Add(new OdbcParameter("name", OdbcType.VarChar)).Value = student.name; command.Parameters.Add(new OdbcParameter("password", OdbcType.VarChar)).Value = student.password; return command.ExecuteNonQuery(); }
public List<StudentEntity> getAllStudents() { List<StudentEntity> list = new List<StudentEntity>(); var cmd = buildCommand("select * from student order by sid"); var reader = cmd.ExecuteReader(); while (reader.Read()) { StudentEntity student = new StudentEntity(); student.id = reader.GetInt32(0); student.sid = reader.GetString(1); student.name = reader.GetString(2); student.password = reader.GetString(3); list.Add(student); } return list; }
public ActionResult Register() { StudentModel studentModel = new StudentModel(); LimitUserModel limituserModel = new LimitUserModel(); try { var name = Request.Form["name"]; var sid = Request.Form["sid"]; var password = Request.Form["password"]; if (name == "" || sid == "" || password == "") { ViewBag.err = "请完整填写信息"; return View("~/Views/Index/Register.cshtml"); } if (!limituserModel.isAllowed(sid)) { ViewBag.err = "学号被禁止注册"; return View("~/Views/Index/Register.cshtml"); } var student = new StudentEntity() {sid=sid,name=name,password=password }; var res = studentModel.register(student); if (res != 1) { ViewBag.err = "注册失败,请检查所填信息"; return View("~/Views/Index/Register.cshtml"); } else { return View("~/Views/Index/Index.cshtml"); } } catch (Exception e) { ViewBag.err = "注册失败,请检查所填信息"; return View("~/Views/Index/Register.cshtml"); } }