com.admin.product.Posts.java Source code

Introduction

Here is the source code for com.admin.product.Posts.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.admin.product;

import Hibernate.post;
import HibernateUtil.HibernateUtil;
import java.util.List;
import org.hibernate.Session;

/**
 *
 * @author zxq
 */
public class Posts implements Lists {

    @Override
    public List get() {
        Session s = HibernateUtil.currentSession();
        HibernateUtil.beginTransaction();

        String sql = "select * from post";
        List<post> list = s.createSQLQuery(sql).addEntity(post.class).list();
        //System.out.println(hql);
        HibernateUtil.commitTransaction();//??
        HibernateUtil.closeSession();

        return list;
    }

    @Override
    public boolean changeStatus(String status, String id) {
        Session s = HibernateUtil.currentSession();
        HibernateUtil.beginTransaction();
        //String hql = "insert into user(user_name,password,mail,register_date,pic_id) " + "values('?','?','?',SYSDATE(),?)";
        //List<user> list = s.createQuery(hql).setString(0, name).setString(1, pass).setString(2, mail).setString(3, pic_id).list();

        String sql = "update post set available = ? where post_id = ?";
        int back = s.createSQLQuery(sql).setString(0, status).setString(1, id).executeUpdate();
        HibernateUtil.commitTransaction();//??
        HibernateUtil.closeSession();

        return back > 0;
    }
}