用MYSQL中的加密函数来加密:PASSWORD()

加密:<sql:update var="user" dataSource="${bookdev}">
  insert into user values("","${param.userName}",password("${param.userPwd}"),"${param.userLevel}")
</sql:update>
解密:<sql:query var="query" dataSource="${bookdev}">
  select * from user where userName='${param.userName}' and
  userPwd=password('${param.userPwd}')
</sql:query>
posted on 2005-03-16 10:16  似水流年  阅读(621)  评论(0编辑  收藏  举报