package com.hxzkoa.services;
|
|
import javax.persistence.EntityManager;
|
import javax.persistence.PersistenceContext;
|
import javax.persistence.Query;
|
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.hxzkoa.util.IsInStartAndEndTime;
|
|
@Service
|
public class CaozuoService {
|
@PersistenceContext
|
private EntityManager em;
|
|
@Transactional
|
public void tb_caozuo(String tablename,int state) {
|
String sql = null;
|
Query query = null;
|
String addtime = IsInStartAndEndTime.DataTostr();
|
sql = "UPDATE tb_caozuo SET state=:state,addtime=:addtime WHERE tablename=:tablename";
|
query = this.em.createNativeQuery(sql);
|
query.setParameter("state",state);
|
query.setParameter("addtime",addtime);
|
query.setParameter("tablename",tablename);
|
query.executeUpdate();
|
}
|
}
|
