sql1.properties

来自「一种快速开发的Java Web架构,doc里有详细的设计文档和开发文档。」· PROPERTIES 代码 · 共 33 行

#用户相关sql
user_list=select u.*,r.role_name,c.email as email from t_user u left join t_role r on u.role_id=r.id left join t_contact c on u.id = c.id order by u.id limit ?,?
user_list_count=select count(*) from t_user

#根据用户名查找用户信息
user_checkUser=select * from t_user u where u.username=?