2006061220191111667.java

通过java写的调用snmp4j包实现snmp网管功能的程序

package jdbc;
import java.sql.*;
public class T1
{
    Connection con = null;
    Statement st = null;
    ResultSet rs = null;
    PreparedStatement pre = null;
    CallableStatement call = null;
    public T1()
    {
        //驱动程序
      String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
      //要连接的数据源
      String dsn="jdbc:microsoft:sqlserver://a309:1433;DatabaseName=EMP";
      //用户名称
      String user="qq";
      //口令
      String passd="qq";
      try
      {
          //加载并注册驱动程序
          Class.forName(driver);
          //生成连接
          con=DriverManager.getConnection(dsn,user,passd);
          //判断连接是否成功
          if(con!=null)
          {
           System.out.println("ok");
          }
      }catch(Exception e)
      {
      e.printStackTrace();
      }
    }
    public void staAdd(String sql)
    {
        try{
            st = con.createStatement();
            int i=st.executeUpdate(sql);
            System.out.println(i);
        }catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    public void select(String sql)
    {
        try{
            st = con.createStatement();
            rs = st.executeQuery(sql);
            while(rs.next())
            {
                System.out.print("姓名:"+rs.getString("name")+"        ");
                System.out.println("电话:"+rs.getString("tel"));
            }
        }catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    public void preAdd(String name)
    {
        String s="insert into employ values('22',?,'ee')";
        try
        {
            pre= con.prepareStatement(s);
            pre.setString(1,name);
            int x=pre.executeUpdate();
            System.out.println(x);
        }catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    public void preSelect(String name)
    {
        String s ="select * from employ where name=?";
        try
        {
            pre=con.prepareStatement(s);
            pre.setString(1,name);
            rs=pre.executeQuery();
            while(rs.next())
            {
                System.out.println("姓名:"+rs.getString("name") );
            }
        }catch(Exception e){}
    }
    public void procAdd(String name,String tel)
    {
        try
        {
            call =con.prepareCall("{call insertOne(?,?)}");
            call.setString(1,name);
            call.setString(2,tel);
            call.executeUpdate();


        }catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    //批处理
    public void PCL(String sql[])
    {
        try{
            st = con.createStatement();
            for(String s : sql)
            {
                st.addBatch(s);

            }
            st.executeBatch();
        }catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    public static void main(String[] args)
    {
        T1 t1 = new T1();
        String s = "insert into employ(name,tel) values('aa','bb')";
        String s1 ="update employ set tel='aa' where name='aa'";
        String s2 = "delete from employ where tel='aa'";
        //t1.staAdd(s);
        //t1.staAdd(s1);
        //t1.staAdd(s2);
        String s3 = "select * from employ";
        //t1.select(s3);
        String s4 = "wh";
        //t1.preAdd(s4);
        //t1.preSelect(s4);
        String name ="wh";
        String tel = "888";
        //t1.procAdd(name,tel);
        String s5="update employ set name='wh' where name='yhl'";
        String s6 = "update employ set tel = '888' where name='wh'";
        String s7[]={s5,s6};
        t1.PCL(s7);
    }
}