更新语句: "UPDATE DX_FM_MANAGER SET USERNAME =?,PASSWORD =?,REALNAME =?,SEX =?,PHONE =?,EMAIL =?,IDCARD =?,PCODE =?,FLAG =?,SYSFLAG =? WHERE ID =?"; 插入语句1:"INSERT INTO DX_FM_ATP_MAP(MANAGERID,TYPECODE,POPID,RULEORDER) VALUES(?,?,?,?)"; 插入语句2:"INSERT INTO DX_FM_MANAGER(ID,USERNAME,PASSWORD,REALNAME,SEX,PHONE,EMAIL) VALUES(SEQ_DX_FM_MANAGER.NEXTVAL,?,?,?,?,?,?,?)"; //SEQ_DX_FM_MANAGER为序列 删除语句: "DELETE DX_FM_ATP_MAP WHERE MANAGERID =?"; 查询语句: "SELECT ID,USERNAME,REALNAME,SEX,PHONE,EMAIL,IDCARD,PCODE,SYSFLAG from DX_FM_MANAGER where USERNAME =? and PASSWORD =? and FLAG=1" 序列的创建: -- Create sequence create sequence SEQ_DX_FM_MOPLOG minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 nocache;