quan.java

该程序采用web平台的方案实现了灵活的车辆监控。

/*
 * quan.java
 *
 * Created on 2005年5月18日, 上午9:53
 */

package bean;

/**
 *
 * @author  端木
 */
import java.sql.*;
import java.io.*;
public class quan {
    static Connection con;
    static Statement sql;
    int id;
    String gpass;
    String pass;
    int xian;
    ResultSet rs;
    public quan() {
         try{
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          //建立jdbc-odbc桥连接器
      }
      catch(ClassNotFoundException e){System.out.println(e);}
          try
      {
           con=DriverManager.getConnection("jdbc:odbc:bishe","sa","726");
      }
      catch(SQLException e)
      {System.out.print(e);}
          try
    {sql=con.createStatement();
       rs=sql.executeQuery("SELECT * FROM quanxian WHERE yonghu="+id+"");
      gpass=rs.getString(2);   
       if(pass==gpass){
       xian=rs.getInt(3); }  
       else{xian=4;}
        }
       catch(SQLException e){xian=4;}
         
}
      public void setId(int i)
   {
       id=i;
   }
   public int getId()
   {
       return id;
   }
     public void setXian(int i)
   {
      xian=i;
   }
   public int getXian()
   {
       return xian;
   }
    public void setPass(String s)
   {
      pass=s;
   }
   public String getPass()
   {
       return pass;
   }
}