コード例 #1
0
 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;
 }