ssh增删改查+用户登录+用户权限管理

package user; import java.util.List; import org.hibernate.Query; import org.hibernate.SQLQuery; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import user.domain.Group; import user.domain.Menu; import user.domain.Table; import user.domain.User; public class UserDaoImpl extends HibernateDaoSupport implements UserDao{ private SessionFactory sessionFactory; public void doCreateUser(User user) { this.getHibernateTemplate().save(user); } @SuppressWarnings("unchecked") public List<User> findAllUsers() { String hql = "from User u order by u.id asc"; List<User> list = this.getHibernateTemplate().find(hql); return list; } public void removeUser(User user) { this.getHibernateTemplate().delete(user); } public void updateUser(User user) { this.getHibernateTemplate().update(user); } public User findUserById(int id) { User user = null; user = (User) this.getHibernateTemplate().get(User.class, id); return user; } public void removeGroup(Group group) { this.getHibernateTemplate().delete(group); } @SuppressWarnings("unchecked") public List<Group> findAllGroup() { String hql = "from Group u order by u.id asc"; List<Group> list = this.getHibernateTemplate().find(hql); return list; } public void doCreateGroup(Group group) { this.getHibernateTemplate().save(group); } public Group findGroupById(int id) { Group group = null; group = (Group) this.getHibernateTemplate().get(Group.class, id); return group; } public void updateGroup(Group group) { this.getHibernateTemplate().update(group); } @Override public List<User> Login(String username, String password) { // TODO Auto-generated method stub List<User> list = super.getHibernateTemplate().find("from User u where u.userName = ? and u.password = ?" , new Object[]{username, password}); return list; } @Override public List<Table> findAllTable() { String hql = "from Table"; List<Table> list = this.getHibernateTemplate().find(hql); return list; } @Override public void removeMenu(Menu menu) { // TODO Auto-generated method stub this.getHibernateTemplate().delete(menu); } @Override public List<Menu> findAllMenu() { // TODO Auto-generated method stub String hql = "from Menu"; List<Menu> list = this.getHibernateTemplate().find(hql); return list; } @Override public void doCreateMenu(Menu menu) { // TODO Auto-generated method stub this.getHibernateTemplate().save(menu); } @Override public Menu findMenuById(int id) { // TODO Auto-generated method stub Menu menu = null; menu = (Menu) this.getHibernateTemplate().get(Menu.class, id); return menu; } @Override public void updateMenu(Menu menu) { // TODO Auto-generated method stub this.getHibernateTemplate().update(menu); } @Override public Menu findMenu(int groupId) { // TODO Auto-generated method stub Menu menu = null; menu = (Menu) this.getHibernateTemplate().get(Menu.class, groupId); return menu; } @Override public Table findTable(int menuId) { // TODO Auto-generated method stub Table table = null; table = (Table) this.getHibernateTemplate().get(Table.class, menuId); return table; } @Override public void delUser(int id) { // TODO Auto-generated method stub String hql = "delete from User where groupId =" + id; Query query = getSession().createQuery( hql ); query.executeUpdate(); } @Override public void delMenu(int id) { // TODO Auto-generated method stub String hql = "delete from Menu where groupId =" + id; Query query = getSession().createQuery( hql ); query.executeUpdate(); } @SuppressWarnings("unchecked") @Override public List<Menu> findMenuList(int groupId) { // TODO Auto-generated method stub String hql = "from Menu where groupId =" + groupId; Query query = getSession().createQuery( hql ); return query.list(); } }