package com.yeshi.buwan.service.imp;
|
|
import java.io.Serializable;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.springframework.stereotype.Service;
|
|
import com.yeshi.buwan.dao.HolmesDao;
|
import com.yeshi.buwan.domain.Holmes;
|
|
@Service
|
public class HolmesService {
|
|
@Resource
|
private HolmesDao dao;
|
|
public void updateConnetionClient() {
|
List<String> sqlList = dao.sqlList("SELECT SUBSTRING_INDEX(HOST,':',1) AS ip FROM information_schema.processlist WHERE DB='buwan_video' GROUP BY ip ");
|
Holmes holmes;
|
for (String ip : sqlList) {
|
List<Holmes> list = dao.list("from Holmes hs where hs.ip=?", new Serializable[]{ip});
|
if(list.size() == 0){
|
holmes = new Holmes();
|
holmes.setIp(ip);
|
holmes.setCreateTime(System.currentTimeMillis());
|
dao.create(holmes);
|
}
|
}
|
|
}
|
|
}
|
