Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Entity
- @Table(name = "dbuser", schema = "public", catalog = "postgres")
- public class DbuserEntity {
- private int id;
- private String username;
- private String createdBy;
- private Date createdDate;
- private String firstName;
- private String lastName;
- @OrderBy("firstName")
- public List<DbuserEntity> dbusers = new ArrayList<DbuserEntity>();
- //constructors
- @Id
- @SequenceGenerator(name="pk_sequence",sequenceName="entity_id_seq", allocationSize=1)
- @GeneratedValue(strategy=GenerationType.AUTO,generator="pk_sequence")
- @Column(name = "id")
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- @Basic
- @Column(name = "username")
- public String getUsername() {
- return username;
- }
- public void setUsername(String username) {
- this.username = username;
- }
- // other getters and setters, equals etc.
- public List readAll() {
- HibernateUtils hibernateUtils = new HibernateUtils();
- Session session = null;
- List users = new ArrayList<DbuserEntity>();
- try {
- session = hibernateUtils.getSessionFactory().openSession();
- session.beginTransaction();
- users = session.createQuery("FROM DbuserEntity ").list();
- session.beginTransaction().commit();
- } catch (HibernateException e) {
- session.beginTransaction().rollback();
- e.printStackTrace();
- } finally {
- if (session != null) {
- if (session.isOpen()) {
- session.close();
- }
- }
- }
- return users;
- }
- public static void main(String[] args) {
- Service service = new Service();
- DbuserEntity db = new DbuserEntity();
- List users = new ArrayList<DbuserEntity>();
- users = service.readAll();
- db.dbusers = users;
- for (DbuserEntity dbuser : db.dbusers) {
- System.out.println(dbuser.toString());
- }
- }
- }
- DbuserEntity{id=19, username='user2', createdby='admin', createddate=2014-11-19, firstname='john', lastname='johnson'}
- DbuserEntity{id=20, username='user3', createdby='admin', createddate=2014-11-19, firstname='ivan', lastname='ivanov'}
- DbuserEntity{id=26, username='newUSer', createdby='system', createddate=2014-11-21, firstname='AAA', lastname='BBB'}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement