Question

jeecg框架连接数据库后sql语句放在哪

Answer 1

jeecg框架连接数据库可以在在controller中执行sql
先引入
@Autowired
JdbcDao jdbcDao;
下面是代码
String sqlForLive = "select * from live where user_id='"+id+"' and id !='"+liveId+"'";
List<ApiLiveEntity> liveList = jdbcDao.find(sqlForLive,ApiLiveEntity.class,null);
String updateSql = "UPDATE live SET live_state=0 where user_id='"+id+"' and id !='"+liveId+"'";
jdbcDao.executeSql(updateSql);