summaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources')
-rw-r--r--src/main/resources/confagent.properties9
-rw-r--r--src/main/resources/log4j.properties8
-rw-r--r--src/main/resources/mapper/AlertRuleDao.xml19
-rw-r--r--src/main/resources/mapper/ConfEventDao.xml9
-rw-r--r--src/main/resources/mapper/EndpointDao.xml39
-rw-r--r--src/main/resources/mapper/PromserverDao.xml27
-rw-r--r--src/main/resources/mapper/SysConfigDao.xml16
-rw-r--r--src/main/resources/spring.xml142
8 files changed, 269 insertions, 0 deletions
diff --git a/src/main/resources/confagent.properties b/src/main/resources/confagent.properties
new file mode 100644
index 0000000..ea5af50
--- /dev/null
+++ b/src/main/resources/confagent.properties
@@ -0,0 +1,9 @@
+jdbc.driver=com.mysql.jdbc.Driver
+jdbc.url=jdbc:mysql://192.168.40.247:3306/nz?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false
+jdbc.username=root
+jdbc.password=111111
+
+ipaddr=192.168.10.15
+ymlPath=F:/prometheus.yml
+prometheusPort=9090
+job.cron=0/30 * * * * ? \ No newline at end of file
diff --git a/src/main/resources/log4j.properties b/src/main/resources/log4j.properties
new file mode 100644
index 0000000..f076a1b
--- /dev/null
+++ b/src/main/resources/log4j.properties
@@ -0,0 +1,8 @@
+### #\u914d\u7f6e\u6839Logger ###
+log4j.rootLogger=debug,stdout
+
+### \u8f93\u51fa\u5230\u63a7\u5236\u53f0 ###
+log4j.appender.stdout=org.apache.log4j.ConsoleAppender
+log4j.appender.stdout.Target=System.out
+log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
+log4j.appender.stdout.layout.ConversionPattern=%d{yyy-MM-dd HH\:mm\:ss} %5p %c{1}\:%L - %m%n
diff --git a/src/main/resources/mapper/AlertRuleDao.xml b/src/main/resources/mapper/AlertRuleDao.xml
new file mode 100644
index 0000000..8f1e028
--- /dev/null
+++ b/src/main/resources/mapper/AlertRuleDao.xml
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.nis.dao.AlertRuleDao">
+ <resultMap type="com.nis.entity.AlertRule" id="alertRule">
+ <result property="id" column="id"/>
+ <result property="alertName" column="alert_name"/>
+ <result property="expr" column="expr"/>
+ <result property="last" column="last"/>
+ <result property="severity" column="severity"/>
+ <result property="summary" column="summary"/>
+ <result property="description" column="description"/>
+ <result property="receiver" column="receiver"/>
+ </resultMap>
+
+ <select id="selectList" resultMap="alertRule">
+ select * from alert_rule
+ </select>
+
+</mapper> \ No newline at end of file
diff --git a/src/main/resources/mapper/ConfEventDao.xml b/src/main/resources/mapper/ConfEventDao.xml
new file mode 100644
index 0000000..c36a444
--- /dev/null
+++ b/src/main/resources/mapper/ConfEventDao.xml
@@ -0,0 +1,9 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.nis.dao.ConfEventDao">
+
+ <select id="selectList" resultType="com.nis.entity.ConfEvent">
+ select * from conf_event
+ </select>
+
+</mapper> \ No newline at end of file
diff --git a/src/main/resources/mapper/EndpointDao.xml b/src/main/resources/mapper/EndpointDao.xml
new file mode 100644
index 0000000..fcd868f
--- /dev/null
+++ b/src/main/resources/mapper/EndpointDao.xml
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.nis.dao.EndpointDao">
+ <resultMap type="com.nis.entity.Endpoint" id="endpoint">
+ <result property="id" column="id"/>
+ <result property="moduleId" column="module_id"/>
+ <result property="assetId" column="asset_id"/>
+ <result property="host" column="host"/>
+ <result property="port" column="port"/>
+ <result property="param" column="param"/>
+ <result property="path" column="path"/>
+
+ <association columnPrefix="m_" property="module" javaType="com.nis.entity.Module">
+ <id column="module_id" property="id"/>
+ <result column="name" property="name"/>
+ <result column="remark" property="remark"/>
+ <result column="project_id" property="projectId"/>
+ <result column="port" property="port"/>
+ <result column="param" property="param"/>
+ <result column="path" property="path"/>
+ </association>
+ </resultMap>
+
+ <select id="selectExporterInfos" resultMap="endpoint">
+ select e.*,
+ m.id AS m_module_id,
+ m.project_id AS m_project_id,
+ m.name AS m_name,
+ m.port AS m_port,
+ m.param AS m_param,
+ m.path AS m_path,
+ m.remark AS m_remark
+ from
+ endpoint e left join asset a on e.asset_id=a.id
+ left join module m on e.module_id = m.id
+ where a.idc_id=#{idcId}
+ </select>
+
+</mapper> \ No newline at end of file
diff --git a/src/main/resources/mapper/PromserverDao.xml b/src/main/resources/mapper/PromserverDao.xml
new file mode 100644
index 0000000..3fcb02a
--- /dev/null
+++ b/src/main/resources/mapper/PromserverDao.xml
@@ -0,0 +1,27 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.nis.dao.PromserverDao">
+ <resultMap type="com.nis.entity.Promserver" id="promserver">
+ <result property="id" column="id"/>
+ <result property="idcId" column="idc_id"/>
+ <result property="host" column="host"/>
+ <result property="relabel" column="relabel"/>
+ <result property="type" column="type"/>
+ </resultMap>
+
+ <select id="selectList" resultMap="promserver">
+ select * from prom_server
+ </select>
+
+ <select id="selectRoleByIp" resultMap="promserver">
+ select * from prom_server where host=#{ip}
+ </select>
+
+ <select id="selectSubInfo" resultMap="promserver">
+ select * from prom_server where idc_id=#{promserver.idcId} and type=#{promserver.type} order by id asc
+ </select>
+
+ <select id="selectSubInfosByType" resultMap="promserver">
+ select * from prom_server where type=#{type}
+ </select>
+</mapper> \ No newline at end of file
diff --git a/src/main/resources/mapper/SysConfigDao.xml b/src/main/resources/mapper/SysConfigDao.xml
new file mode 100644
index 0000000..4b92e6b
--- /dev/null
+++ b/src/main/resources/mapper/SysConfigDao.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.nis.dao.SysConfigDao">
+ <resultMap type="com.nis.entity.SysConfig" id="sysConfig">
+ <result property="id" column="id"/>
+ <result property="paramKey" column="param_key"/>
+ <result property="paramValue" column="param_value"/>
+ <result property="status" column="status"/>
+ <result property="remark" column="remark"/>
+ </resultMap>
+
+ <select id="selectList" resultMap="sysConfig">
+ select * from sys_config where status=1
+ </select>
+
+</mapper> \ No newline at end of file
diff --git a/src/main/resources/spring.xml b/src/main/resources/spring.xml
new file mode 100644
index 0000000..6fe2c2d
--- /dev/null
+++ b/src/main/resources/spring.xml
@@ -0,0 +1,142 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
+ xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
+ xmlns:util="http://www.springframework.org/schema/util" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="
+ http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
+ http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
+ http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd
+ http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.1.xsd
+ http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
+ http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.1.xsd
+ http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.1.xsd"
+ default-lazy-init="true">
+
+ <description>Spring Configuration</description>
+
+ <!-- 加载配置属性文件 -->
+ <context:property-placeholder location="classpath*:confagent.properties" />
+
+ <bean id="propertyConfigurer" class="com.nis.util.PropertyPlaceholder">
+ <property name="location">
+ <value>classpath:confagent.properties</value>
+ </property>
+ </bean>
+
+
+ <!-- 使用Annotation自动注册Bean，解决事物失效问题：在主容器中不扫描@Controller注解，在SpringMvc中只扫描@Controller注解。 -->
+ <context:component-scan base-package="com.nis"><!-- base-package 如果多个，用“,”分隔 -->
+ <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
+ </context:component-scan>
+
+ <!-- MyBatis begin -->
+ <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
+ <property name="dataSource" ref="dataSource"/>
+ <property name="typeAliasesPackage" value="com.nis.entity"/>
+ <property name="mapperLocations" value="classpath:/mapper/*.xml"/>
+ <!-- <property name="configLocation" value="classpath:/mybatis-config.xml"></property> -->
+ </bean>
+
+ <!-- 扫描basePackage下所有以@MyBatisDao注解的接口 -->
+ <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
+ <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
+ <property name="basePackage" value="com.nis.dao"/>
+ <!-- <property name="annotationClass" value="com.nis.common.persistence.annotation.MyBatisDao"/> -->
+ </bean>
+
+ <!-- 定义事务 -->
+ <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+ <property name="dataSource" ref="dataSource" />
+ </bean>
+
+ <!-- 配置 Annotation 驱动，扫描@Transactional注解的类定义事务 -->
+ <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
+ <!-- MyBatis end -->
+
+ <!-- 配置 JSR303 Bean Validator 定义 -->
+ <bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />
+
+ <!-- 计划任务配置，用 @Service @Lazy(false)标注类，用@Scheduled(cron = "0 0 2 * * ?")标注方法 -->
+ <task:executor id="executor" pool-size="10"/>
+ <task:scheduler id="scheduler" pool-size="10"/>
+ <task:annotation-driven scheduler="scheduler" executor="executor" proxy-target-class="true"/>
+
+ <!-- 数据源配置, 使用 BoneCP 数据库连接池 -->
+ <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
+ <!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass -->
+ <property name="driverClassName" value="${jdbc.driver}" />
+
+ <!-- 基本属性 url、user、password -->
+ <property name="url" value="${jdbc.url}" />
+ <property name="username" value="${jdbc.username}" />
+ <property name="password" value="${jdbc.password}" />
+
+ <!-- 配置初始化大小、最小、最大-->
+ <property name="initialSize" value="5" />
+ <property name="minIdle" value="5" />
+ <property name="maxActive" value="10" />
+
+ <!-- 配置获取连接等待超时的时间 -->
+ <property name="maxWait" value="15000" />
+
+ <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
+ <property name="timeBetweenEvictionRunsMillis" value="60000" />
+
+ <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
+ <property name="minEvictableIdleTimeMillis" value="300000" />
+
+ <!-- <property name="validationQuery" value="${jdbc.testSql}" /> -->
+ <property name="testWhileIdle" value="true" />
+ <property name="testOnBorrow" value="false" />
+ <property name="testOnReturn" value="false" />
+
+ <!-- 打开PSCache，并且指定每个连接上PSCache的大小（Oracle使用）
+ <property name="poolPreparedStatements" value="true" />
+ <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> -->
+
+ <!-- 配置监控统计拦截的filters -->
+ <property name="filters" value="stat" />
+ </bean>
+
+ <!-- <bean id="jobFactory" class="com.nis.job.ConfagentJobFactory"/>
+
+ <bean id="scheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
+ <property name="jobFactory" ref="jobFactory"/>
+ </bean> -->
+
+ <bean id="jobFactory" class="com.nis.job.ConfagentJobFactory"/>
+
+
+ <!-- 配置Job类 -->
+ <bean id="myJob" class="com.nis.job.ConfagentJob"></bean>
+
+ <!-- 配置JobDetail -->
+ <bean id="jobDetail" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
+ <!-- 执行目标job -->
+ <property name="targetObject" ref="myJob"></property>
+ <property name="concurrent" value="false" />
+ <!-- 要执行的方法 -->
+ <property name="targetMethod" value="execute"></property>
+ </bean>
+
+ <!-- 配置tirgger触发器 -->
+ <bean id="cronTriggerFactoryBean" class="org.springframework.scheduling.quartz.CronTriggerFactoryBean">
+ <!-- jobDetail -->
+ <property name="jobDetail" ref="jobDetail"></property>
+ <!-- cron表达式，执行时间 每5秒执行一次 -->
+ <property name="cronExpression" value="${job.cron}"></property>
+ </bean>
+
+ <!-- 配置调度工厂 -->
+ <bean id="springJobSchedulerFactoryBean" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
+ <property name="jobFactory" ref="jobFactory"/>
+ <property name="triggers">
+ <list>
+ <ref bean="cronTriggerFactoryBean"></ref>
+ </list>
+ </property>
+
+ </bean>
+
+
+</beans> \ No newline at end of file
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-30 15:14:21 +0000