📄 ipnettomediatable.java
字号:
package com.sitech.net.topo.table;
import java.io.IOException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Set;
import java.util.Vector;
import org.snmp4j.smi.VariableBinding;
import sitech.www.frame.jdbc.SqlInsert;
import com.sitech.net.topo.CommSnmpGet;
public class IpNetToMediaTable {
public static final String ROOT_OID = "1.3.6.1.2.1.4.22.1.1";
public static final int ATTRIBCOUNT = 4;
private String ID;
private String IP;
Vector rowVector = new Vector();
private void addRow(IpNetToMediaTableRow row) {
rowVector.add(row);
}
public void FillTable(String ip, int port, String community, String id) {
this.ID = id;
this.IP = ip;
CommSnmpGet snmpGet = new CommSnmpGet(ip, port, community);
snmpGet.init();
snmpGet.setRootOid(ROOT_OID);
try {
snmpGet.workTable(ROOT_OID);
} catch (IOException e) {
// TODO Auto-generated catch block
System.out.println("[IP: " + IP + " 采集IpNetToMediaTable失败]");
}
HashMap hm = snmpGet.getWalkHashMap();
Set set = hm.keySet();
Iterator it = set.iterator();
while (it.hasNext()) {
String key = (String) it.next();
String value = (String) hm.get(key);
// 填充IP地址
IpNetToMediaTableRow row = new IpNetToMediaTableRow();
row.setRowIndex(key);
row.setSubNetID(value);
this.addRow(row);
}
try {
for (int i = 0; i < rowVector.size(); i++) {
IpNetToMediaTableRow row = (IpNetToMediaTableRow) rowVector
.elementAt(i);
String rowIndex = row.getRowIndex();
Vector oidsVector = getOtherOids(rowIndex, ATTRIBCOUNT);
Vector resultVector = snmpGet.getPDU(oidsVector);
for (int j = 0; j < resultVector.size(); j++) {
VariableBinding vb = (VariableBinding) resultVector.get(j);
String oid = vb.getOid().toString();
String var = vb.getVariable().toString();
if (oid.startsWith("1.3.6.1.2.1.4.22.1.2.")) {
row.setMacAddr(var);
} else if (oid.startsWith("1.3.6.1.2.1.4.22.1.3.")) {
row.setIpAddr(var);
} else if (oid.startsWith("1.3.6.1.2.1.4.22.1.4.")) {
row.setType(var);
}
}
}
} catch (Exception e) {
// TODO Auto-generated catch block
System.out.println("[IP: " + IP + " 采集IpNetToMediaTable失败]");
}
snmpGet.release();
System.out.println("[IP: " + IP + " IpNetToMediaTable采集完毕]");
}
private Vector getOtherOids(String rowIndex, int attribCount) {
Vector vector = new Vector();
for (int i = 2; i <= attribCount; i++) {
String oid = releaseRootOidLast(ROOT_OID, rowIndex, i);
vector.add(oid);
}
return vector;
}
private String releaseRootOidLast(String rootOid, String rowIndex, int int_i) {
String result = "";
String rowIndexLast = rowIndex.substring(rootOid.length(), rowIndex
.length());
String rootOidStart = rootOid.substring(0, rootOid.length() - 1);
result = rootOidStart + int_i + rowIndexLast;
return result;
}
public Vector getRrows() {
return rowVector;
}
public void saveToDB() {
// 填充IpNetToMediaTable部分
System.out.println("[NodeID: " + ID + " IpAddress: " + IP
+ " IpNetToMediaTable信息记录" + rowVector.size() + "条]");
for (int i = 0; i < rowVector.size(); i++) {
IpNetToMediaTableRow row = (IpNetToMediaTableRow) rowVector.get(i);
String subNetID = row.getSubNetID();
String macAddr = row.getMacAddr();
String ipAddr = row.getIpAddr();
String type = row.getType();
if ((!subNetID.equalsIgnoreCase("noSuchInstance"))
&& (!macAddr.equalsIgnoreCase("noSuchInstance"))
&& (!ipAddr.equalsIgnoreCase("noSuchInstance"))
&& (!type.equalsIgnoreCase("noSuchInstance"))) {
String insert_sql = "insert into tb_topo_ipnettomediatable (NODEID,SUBNETID,MACADDR,IPADDR,H_TYPE) values ('"
+ ID
+ "','"
+ subNetID
+ "','"
+ macAddr
+ "','"
+ ipAddr + "','" + type + "')";
SqlInsert.insert(insert_sql);
}
}
System.out.println("[NodeID: " + ID + " IpAddress: " + IP
+ " IpNetToMediaTable入库完毕]");
// 填充IpNetToMediaTable结束
}
public static void main(String args[]) {
String ip = "130.30.2.129";
int port = 161;
String community = "ahnms2008";
IpNetToMediaTable ipNetToMediaTable = new IpNetToMediaTable();
ipNetToMediaTable.FillTable(ip, port, community,
"04001FFA-7943-A782-FDE6-769683CF268C");
Vector vector = ipNetToMediaTable.getRrows();
for (int i = 0; i < vector.size(); i++) {
IpNetToMediaTableRow row = (IpNetToMediaTableRow) vector.get(i);
String rowindex = row.getRowIndex();
String ipaddr = row.getIpAddr();
String macaddr = row.getMacAddr();
String subnetid = row.getSubNetID();
String type = row.getType();
System.out.println("[RowIndex: " + rowindex + "] [IpAddress: "
+ ipaddr + "] [MacAddress: " + macaddr + "] [SubNetID: "
+ subnetid + "] [Type: " + type + "]");
}
ipNetToMediaTable.saveToDB();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -