snmpget请求获取服务器参数(snmpv3) 并连接MySQL数据库

完整的项目代码：

1、连接MySQL数据库 

package mysnmp;import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.PreparedStatement;  import java.sql.SQLException;   /**  * 连接MySQL数据库   * @author daopinz  *  */public class ConnectBase {      public static final String url = "jdbc:mysql://数据库地址:端口号/库名";      public static final String name = "com.mysql.jdbc.Driver";      public static final String user = "用户名";      public static final String password = "用户密码";        public Connection conn = null;      public PreparedStatement pst = null;        public ConnectBase(String sql) {          try {              Class.forName(name);//指定连接类型              conn = DriverManager.getConnection(url, user, password);//获取连接              pst = conn.prepareStatement(sql);//准备执行语句          } catch (Exception e) {              e.printStackTrace();          }      }        public void close() {          try {              this.conn.close();              this.pst.close();          } catch (SQLException e) {              e.printStackTrace();          }      }  }  

/2、 本类用于向管理进程发送GET信息

package mysnmp;import java.io.IOException;import java.util.Vector;import org.snmp4j.CommunityTarget;import org.snmp4j.PDU;import org.snmp4j.ScopedPDU;import org.snmp4j.Snmp;import org.snmp4j.Target;import org.snmp4j.TransportMapping;import org.snmp4j.UserTarget;import org.snmp4j.event.ResponseEvent;import org.snmp4j.mp.MPv3;import org.snmp4j.mp.SnmpConstants;import org.snmp4j.security.AuthMD5;import org.snmp4j.security.AuthSHA;import org.snmp4j.security.PrivAES128;import org.snmp4j.security.PrivAES192;import org.snmp4j.security.PrivAES256;import org.snmp4j.security.PrivDES;import org.snmp4j.security.SecurityLevel;import org.snmp4j.security.SecurityModels;import org.snmp4j.security.SecurityProtocols;import org.snmp4j.security.USM;import org.snmp4j.security.UsmUser;import org.snmp4j.smi.Address;import org.snmp4j.smi.GenericAddress;import org.snmp4j.smi.OID;import org.snmp4j.smi.OctetString;import org.snmp4j.smi.TcpAddress;import org.snmp4j.smi.VariableBinding;import org.snmp4j.transport.DefaultTcpTransportMapping;import org.snmp4j.transport.DefaultUdpTransportMapping;/** * 本类用于向管理进程发送GET信息 * * @author * */@SuppressWarnings("rawtypes")public class SnmpUtilSendGet {private Address targetAddress = null;private OID authProtocol;private OID privProtocol;private OctetString privPassphrase;private OctetString authPassphrase;private OctetString securityName = new OctetString();private int version;private String host;private Target target;private OctetString community = new OctetString("public");private TransportMapping transport;/** * 初始化Snmp信息 *  * @param host * @param user * @param authProtocol * @param authPasshrase * @param privProtocol * @param privPassphrase * @param version */public SnmpUtilSendGet(String host, String user, String authProtocol, String authPasshrase                          , String privProtocol,String privPassphrase, int version) {this.authPassphrase = new OctetString(authPasshrase);this.securityName = new OctetString(user);this.privPassphrase = new OctetString(privPassphrase);this.version = version;this.host = host;if (authProtocol.equals("MD5")) {this.authProtocol = AuthMD5.ID;} else if (authProtocol.equals("SHA")) {this.authProtocol = AuthSHA.ID;}if (privProtocol.equals("DES")) {this.privProtocol = PrivDES.ID;} else if ((privProtocol.equals("AES128")) || (privProtocol.equals("AES"))) {this.privProtocol = PrivAES128.ID;} else if (privProtocol.equals("AES192")) {this.privProtocol = PrivAES192.ID;} else if (privProtocol.equals("AES256")) {this.privProtocol = PrivAES256.ID;}}/** * 创建snmp *  * @throws IOException */public Snmp createSnmpSession() throws IOException {// 设置管理进程的IP和端口targetAddress = GenericAddress.parse(host);if (targetAddress instanceof TcpAddress) {transport = new DefaultTcpTransportMapping();} else {transport = new DefaultUdpTransportMapping();}Snmp snmp = new Snmp(transport);if (version == SnmpConstants.version3) {USM usm = new USM(SecurityProtocols.getInstance(), new OctetString(                             MPv3.createLocalEngineID()), 0);SecurityModels.getInstance().addSecurityModel(usm);// Add the configured user to the USMaddUsmUser(snmp);}return snmp;}/** * 加入user信息（snmp3） *  * @param snmp */private void addUsmUser(Snmp snmp) {snmp.getUSM().addUser(securityName,new UsmUser(securityName, authProtocol, authPassphrase                , privProtocol, privPassphrase));}/** * 创建PUD *  * @param target * @return */public PDU createPDU(Target target) {PDU request;if (target.getVersion() == SnmpConstants.version3) {request = new ScopedPDU();} else {request = new PDU();}return request;}/** * 创建Target *  * @return */private Target createTarget() {if (version == SnmpConstants.version3) {UserTarget target = new UserTarget();if (authPassphrase != null) {if (privPassphrase != null) {target.setSecurityLevel(SecurityLevel.AUTH_PRIV);} else {target.setSecurityLevel(SecurityLevel.AUTH_NOPRIV);}} else {target.setSecurityLevel(SecurityLevel.NOAUTH_NOPRIV);}target.setSecurityName(securityName);return target;} else {CommunityTarget target = new CommunityTarget();target.setCommunity(community);return target;}}/** * 向管理进程发送Get报文 * * @throws IOException */@SuppressWarnings({ "unchecked" })public String sendPDU(String oids) throws IOException {String v=null;Snmp snmp = createSnmpSession(); target = createTarget();// 设置 targettarget.setAddress(targetAddress);target.setRetries(2);// 通信不成功时的重试次数target.setTimeout(1500);// 超时时间target.setVersion(version);// snmp版本transport.listen();// 创建 PDUScopedPDU pdu = new createPDU();OID oid = new OID(oids);pdu.add(new VariableBinding(oid));pdu.setType(PDU.GET);ResponseEvent respEvnt = snmp.send(pdu, target);if (respEvnt != null && respEvnt.getResponse() != null) {Vector<VariableBinding> recVBs = (Vector<VariableBinding>) respEvnt.getResponse().getVariableBindings();//for (int i = 0; i < recVBs.size(); i++) {VariableBinding recVB = recVBs.elementAt(0);//System.out.println(recVB.getVariable().toString());//System.out.println("------------------------------------------");v=recVB.getVariable().toString();snmp.close();}return v;//}}}

3、获取的结果存入到JSON数组中

package mysnmp;import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;import org.snmp4j.mp.SnmpConstants;import net.sf.json.JSONArray;import net.sf.json.JSONObject;public class DataBaseDemo {static String sql = null;static ConnectBase db = null;static ResultSet rs = null;static String label = null;static String oid_command = null;static String b=null;static String jo = null;public String GetMessage(String Address) throws SQLException, IOException { SnmpUtilSendGet util = new SnmpUtilSendGet("udp:" + Address + "/161", "managerv3", "MD5", "authpassword", "DES","pripassword", SnmpConstants.version3);JSONObject Json = new JSONObject();JSONArray JsonArray = new JSONArray();sql = "select * from 表名 where model='列名' AND method='列名'";// SQL语句db = new ConnectBase(sql);rs = db.pst.executeQuery();// 执行语句，得到结果集while (rs.next()) {label = rs.getString("label");oid_command = rs.getString("oid_command");b = util.sendPDU(oid_command);Json.put(label, b);// JSONObject对象中添加键值对}JsonArray.add(Json);// 将JSONObject对象添加到Json数组中for (int i1 = 0; i1 < JsonArray.size(); i1++) {jo = JsonArray.toString();// System.out.println(JsonArray);System.out.println(jo);}         rs.close();db.close();return jo;}}

4、测试代码

package mysnmp;import java.io.IOException;import java.sql.SQLException;/** * @author daopinz * */public class Test {public static void main(String[] args) throws SQLException, IOException {String Address="xxx.xxx.xxx.xxx";//服务器IP地址DataBaseDemo DB=new DataBaseDemo();DB.GetMessage(Address);}}

在请求snmp之前，要首先在对应的服务器上设置对应的参数，如securityname，MD5、加密方式。。。，

看你测试的服务器，是否支持snmpv3，此文档是针对snmpv3的操作，v1和v2c相对简单一点。