加密:模板:insert into user(userpass) values(encode('useerpass','str'))

insert into user(userid,username,password,person,department_name,zhicheng_name,email) values"

+ "("+userid+",'"+user+"',encode('"+password+"','hanhan'),'"+person+"','"+department+"','"+zhicheng+"','"+email+"')"

解密:select username,decode(password,'hanhan')from user";