加密:模板: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";