3.7

fxl

2023-03-07 52cffc4ab8e9787a6f233295502c7c9788dddae1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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();
    }
}