function UpdateStudentInfo(StudentInfo $studentInfo) { $studentInfo_zkzh = $studentInfo->getZkzh(); $studentInfo_name = $studentInfo->getName(); $studentInfo_sex = $studentInfo->getSex(); $studentInfo_kslb = $studentInfo->getKslb(); $studentInfo_zzmm = $studentInfo->getZzmm(); $studentInfo_nation = $studentInfo->getNation(); $studentInfo_byxx = $studentInfo->getByxx(); $studentInfo_hkszd = $studentInfo->getHkszd(); $studentInfo_address = $studentInfo->getAddress(); $studentInfo_telephone = $studentInfo->getTelephone(); $studentInfo_zcxx = $studentInfo->getZcxx(); $studentInfo_cardNumber = $studentInfo->getCardNumber(); $studentInfo_xjh = $studentInfo->getXjh(); $studentInfo_gysznj = $studentInfo->getGysznj(); $studentInfo_gesznj = $studentInfo->getGesznj(); $studentInfo_gssznj = $studentInfo->getGssznj(); $studentInfo_memo = $studentInfo->getMemo(); $studentInfo_photo = $studentInfo->getPhoto(); $sql = "update t_StudentInfo set "; $sql = $sql . "name='{$studentInfo_name}'"; $sql = $sql . ",sex='{$studentInfo_sex}'"; $sql = $sql . ",kslb='{$studentInfo_kslb}'"; $sql = $sql . ",zzmm='{$studentInfo_zzmm}'"; $sql = $sql . ",nation={$studentInfo_nation}"; $sql = $sql . ",byxx='{$studentInfo_byxx}'"; $sql = $sql . ",hkszd='{$studentInfo_hkszd}'"; $sql = $sql . ",address='{$studentInfo_address}'"; $sql = $sql . ",telephone='{$studentInfo_telephone}'"; $sql = $sql . ",zcxx='{$studentInfo_zcxx}'"; $sql = $sql . ",cardNumber='{$studentInfo_cardNumber}'"; $sql = $sql . ",xjh='{$studentInfo_xjh}'"; $sql = $sql . ",gysznj='{$studentInfo_gysznj}'"; $sql = $sql . ",gesznj='{$studentInfo_gesznj}'"; $sql = $sql . ",gssznj='{$studentInfo_gssznj}'"; $sql = $sql . ",memo='{$studentInfo_memo}'"; $sql = $sql . ",photo='{$studentInfo_photo}'"; $sql = $sql . " where zkzh='{$studentInfo_zkzh}'"; //调用数据层执行更新操作 $sqlHelper = new SqlHelper(); $res = $sqlHelper->execute_dml($sql); $sqlHelper->close_connect(); return $res; }