用户管理系统 - 用户列表

假设User类的属性与表格中的列一一对应，可以使用Hibernate进行数据库操作，示例代码如下：

// 获取所有用户 public List getAllUsers() { Session session = HibernateUtil.getSessionFactory().openSession(); List users = session.createQuery("FROM User").list(); session.close(); return users; }

// 删除用户 public void deleteUser(int id) { Session session = HibernateUtil.getSessionFactory().openSession(); Transaction tx = null; try { tx = session.beginTransaction(); User user = (User) session.load(User.class, id); session.delete(user); tx.commit(); } catch (HibernateException e) { if (tx != null) tx.rollback(); e.printStackTrace(); } finally { session.close(); } }

// 编辑用户 public void editUser(User user) { Session session = HibernateUtil.getSessionFactory().openSession(); Transaction tx = null; try { tx = session.beginTransaction(); session.update(user); tx.commit(); } catch (HibernateException e) { if (tx != null) tx.rollback(); e.printStackTrace(); } finally { session.close(); } }

其中，HibernateUtil是一个工具类，用于获取SessionFactory，示例代码如下：

public class HibernateUtil { private static final SessionFactory sessionFactory; static { try { Configuration configuration = new Configuration().configure(); StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder() .applySettings(configuration.getProperties()); sessionFactory = configuration.buildSessionFactory(builder.build()); } catch (Throwable ex) { System.err.println("Initial SessionFactory creation failed." + ex); throw new ExceptionInInitializerError(ex); } } public static SessionFactory getSessionFactory() { return sessionFactory; } }