a.gclubID AS "gclubID", a.name AS "name", a.contacts AS "contacts", a.cellphone AS "cellphone", a.telphone AS "telphone", a.post AS "post", a.address AS "address", a.scale AS "scale", a.empnum AS "empnum", a.mainpro AS "mainpro", a.remark AS "remark", a.image AS "image", a.regStatus AS "regStatus", a.addTime AS "addTime", a.loginTime AS "loginTime", a.provinceID AS "provinceID", a.cityID AS "cityID", a.townID AS "townID", a.agreement AS "agreement", a.flag AS "flag", a.userID AS "userID", a.clubstatus AS "clubstatus", a.BUSINESSLICENSEIMAGE AS "BUSINESSLICENSEIMAGE", a.LASTMODIFY AS "LASTMODIFY", a.inviterBindID AS "inviterBindID", a.inviterName AS "inviterName", a.headpic AS "headpic", a.mainServiceProviderID AS "mainServiceProviderID", a.scanTime AS "scanTime", a.checkTime AS "checkTime", a.spID AS "spID" SELECT FROM gclub a WHERE a.gclubID = #{id} SELECT FROM gclub a AND a.gclubID = #{id} AND a.userID = #{userID} ORDER BY ${page.orderBy} SELECT FROM gclub a ORDER BY ${page.orderBy} INSERT INTO gclub( name, contacts, cellphone, telphone, post, address, scale, empnum, mainpro, remark, image, regStatus, addTime, loginTime, provinceID, cityID, townID, agreement, flag, userID, clubstatus, BUSINESSLICENSEIMAGE, LASTMODIFY, inviterBindID, inviterName, headpic, mainServiceProviderID, scanTime, checkTime, spID ) VALUES ( #{name}, #{contacts}, #{cellphone}, #{telphone}, #{post}, #{address}, #{scale}, #{empnum}, #{mainpro}, #{remark}, #{image}, #{regStatus}, #{addTime}, #{loginTime}, #{provinceID}, #{cityID}, #{townID}, #{agreement}, #{flag}, #{userID}, #{clubstatus}, #{BUSINESSLICENSEIMAGE}, #{LASTMODIFY}, #{inviterBindID}, #{inviterName}, #{headpic}, #{mainServiceProviderID}, #{scanTime}, #{checkTime}, #{spID} ) UPDATE gclub SET name = #{name}, contacts = #{contacts}, cellphone = #{cellphone}, telphone = #{telphone}, post = #{post}, address = #{address}, scale = #{scale}, empnum = #{empnum}, mainpro = #{mainpro}, remark = #{remark}, image = #{image}, regStatus = #{regStatus}, addTime = #{addTime}, loginTime = #{loginTime}, provinceID = #{provinceID}, cityID = #{cityID}, townID = #{townID}, agreement = #{agreement}, flag = #{flag}, userID = #{userID}, clubstatus = #{clubstatus}, BUSINESSLICENSEIMAGE = #{BUSINESSLICENSEIMAGE}, LASTMODIFY = #{LASTMODIFY}, inviterBindID = #{inviterBindID}, inviterName = #{inviterName}, headpic = #{headpic}, mainServiceProviderID = #{mainServiceProviderID}, scanTime = #{scanTime}, checkTime = #{checkTime}, spID = #{spID} WHERE gclubID = #{id} DELETE FROM gclub WHERE gclubID = #{id} UPDATE gclub SET regStatus = #{regStatus}, flag = #{flag}, LASTMODIFY = #{LASTMODIFY}, inviterBindID = #{inviterBindID}, inviterName = #{inviterName}, mainServiceProviderID = #{mainServiceProviderID}, spID = #{spID} WHERE userID = #{userID}