
my program will ping upto 192.168.100.59. and i want to insert that particular inforamtion into my oracle db.and i want to update it in my network. here my question is:my prog inserting only one ipadress into my db but i want every ip info into my db.so can u pls help me out. code: import java.io.*; import java.sql.*; import java.util.*; public class nmap { public static void main(String[] args) { new nmap_thread("192.168.100").start(); /*new nmap_thread("192.168.110").start(); new nmap_thread("192.168.120").start(); new nmap_thread("192.168.130").start(); new nmap_thread("192.168.140").start(); new nmap_thread("192.168.150").start(); new nmap_thread("192.168.160").start(); new nmap_thread("192.168.180").start();*/ } } class nmap_thread extends Thread { Connection con=null; PreparedStatement st=null; public nmap_thread(String s) { super(s); } public void run() { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:oradsn","system","1212"); //st=con.createStatement(); }catch(Exception e){} String s1=getName(); String ip_mac = ""; lp1:for(int i=50;i<60;i++) { ip_mac = s1+"."+i;
try
{
Process p = Runtime.getRuntime().exec("ping "+ip_mac,null);
BufferedReader br = new BufferedReader (new InputStreamReader(p.getInputStream()));
String line = null;
int flag =0;
while((line = br.readLine()) != null )
{
//output.write(line);
// System.out.println(line);
if((line.indexOf("Reply from")> -1) && (flag == 0))
{
/*st=con.prepareStatement("insert into sun1 values(?,'on')");
int k=st.executeUpdate();
st.setString(1,ip_mac);*/
//st.setString(2,'on');
System.out.println("System "+ip_mac+" up");
flag ++;
}
}
if(flag == 0)
{
System.out.println("System"+ip_mac+" down");
}
//output.close();
int exitVal = p.waitFor();
StringTokenizer str=new StringTokenizer(ip_mac);
String o1;
while(str.hasMoreTokens())
{
Object o=str.nextToken();
o1=o.toString();
}
st=con.prepareStatement("insert into sun1 values(?,'off')"); st.setString(1,o1); //for (int i1 = 0; i1 < 10; i1++) { //st.setInt(2, i1); int rowCount = st.executeUpdate();
//i=0;
con.close();
}
catch(Exception e){}
}
} }
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.