You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
publicstaticfinalStringINSERT_USER = "INSERT INTO user (uid,password,name,regqu,reganswer,iid,sex,age,tel,email,qq,regtime,address,http,status,state,resume) VALUES(?,?,?,?,?,?,?,?,?,?,?,now(),?,?,?,?,?)";
publicstaticfinalStringUPDATE_USER = "UPDATE (user) SET password=?,name=?,iid=?,sex=?,age=?,tel=?,email=?,qq=?,address=?,http=?,status=?,state=?,resume=? where uid=?";
publicstaticfinalStringUPDATE_USER_M = "UPDATE (user) SET status=?,state=? where uid=?";
publicstaticfinalStringSELECT_USER = "SELECT * FROM (user) ";
//head
publicstaticfinalStringINSERT_HEAD =
"INSERT INTO ico (iid,path,atime,state) VALUES(?,?,now(),?)";
publicstaticfinalStringSELECT_HEAD = "SELECT * FROM (ico) ";
publicstaticfinalStringDELETE_HEAD = "DELETE FROM ico ";
//affiche
publicstaticfinalStringINSERT_AFFICHE =
"INSERT INTO affiche (uid,title,atime,content) VALUES(?,?,now(),?)";
publicstaticfinalStringUPDATE_AFFICHE =
"UPDATE (affiche) SET title=?,content=? where aid=?";
publicstaticfinalStringSELECT_AFFICHE = "SELECT * FROM (affiche) ";
publicstaticfinalStringDELETE_AFFICHE = "DELETE FROM affiche ";
//new
publicstaticfinalStringINSERT_NEW =
"INSERT INTO new (uid,title,ntime,fromto,content) VALUES(?,?,now(),?,?)";
publicstaticfinalStringSELECT_NEW = "SELECT * FROM (new) ";
publicstaticfinalStringDELETE_NEW = "DELETE FROM new ";
//link
publicstaticfinalStringINSERT_LINK =
"INSERT INTO link (name,ltime,url) VALUES(?,now(),?)";
publicstaticfinalStringUPDATE_LINK = "UPDATE (link) SET name=?,url=? where lid=?";
publicstaticfinalStringSELECT_LINK = "SELECT * FROM (link) ";
publicstaticfinalStringDELETE_LINK = "DELETE FROM link ";
//ssort
publicstaticfinalStringINSERT_SSORT =
"INSERT INTO ssort (name,resume) VALUES(?,?)";
publicstaticfinalStringUPDATE_SSORT =
"UPDATE (ssort) SET name=?,resume=? where sid=?";
publicstaticfinalStringSELECT_SSORT = "SELECT * FROM (ssort) ";
publicstaticfinalStringDELETE_SSORT = "DELETE FROM ssort ";
//soft
publicstaticfinalStringINSERT_SOFT = "INSERT INTO soft (name,edition,price,uptime,uid,iid,sid,environment,filesize,commend,loadnum,regular,introduce,path,resume) VALUES(?,?,?,now(),?,?,?,?,?,?,?,?,?,?,?)";
publicstaticfinalStringUPDATE_SOFT = "UPDATE (soft) SET name=?,edition=?,price=?,iid=?,sid=?,environment=?,filesize=?,commend=?,loadnum=?,regular=?,introduce=?,path=?,resume=? where sfid=?";
publicstaticfinalStringUPDATE_SOFT_LOAD = "UPDATE (soft) SET loadnum=? where sfid=?";
publicstaticfinalStringSELECT_SOFT = "SELECT * FROM (soft) ";
publicstaticfinalStringDELETE_SOFT = "DELETE FROM soft ";
//resolvent
publicstaticfinalStringINSERT_RESOLVENT =
"INSERT INTO resolvent (sid,uid,sfid,name,uptime,iid,content) VALUES(?,?,?,?,now(),?,?)";
publicstaticfinalStringUPDATE_RESOLVENT =
"UPDATE (resolvent) SET sid=?,sfid=?,name=?,content=? where rid=?";
publicstaticfinalStringSELECT_RESOLVENT = "SELECT * FROM (resolvent) ";
publicstaticfinalStringDELETE_RESOLVENT = "DELETE FROM resolvent ";
//question
publicstaticfinalStringINSERT_QUESTION =
"INSERT INTO question (question,answer) VALUES(?,?)";
publicstaticfinalStringUPDATE_QUESTION =
"UPDATE (question) SET answer=?,question=? where qid=?";
publicstaticfinalStringSELECT_QUESTION = "SELECT * FROM (question) ";
publicstaticfinalStringDELETE_QUESTION = "DELETE FROM question ";
//guestboard
publicstaticfinalStringINSERT_GUESTBOARD =
"INSERT INTO guestboard (title,guest,gtime,content) VALUES(?,?,now(),?)";
publicstaticfinalStringUPDATE_GUESTBOARD =
"UPDATE (guestboard) SET gflag=1,recontent=?,rtime=now() where gid=?";
publicstaticfinalStringSELECT_GUESTBOARD = "SELECT * FROM (guestboard) ";
publicstaticfinalStringDELETE_GUESTBOARD = "DELETE FROM guestboard ";
//mend
publicstaticfinalStringINSERT_MEND = "INSERT INTO mend (sid,name,path,state,uptime,commend,loadnum,filesize,resume) VALUES(?,?,?,?,now(),?,?,?,?)";
publicstaticfinalStringUPDATE_MEND = "UPDATE (mend) SET sid=?,name=?,state=?,commend=?,loadnum=?,filesize=?,resume=? where mid=?";
publicstaticfinalStringUPDATE_MEND_LOAD = "UPDATE (mend) SET loadnum=? where mid=?";
publicstaticfinalStringSELECT_MEND = "SELECT * FROM (mend) ";
publicstaticfinalStringDELETE_MEND = "DELETE FROM mend ";
