jaccesst.java

java存取access的方法的列子

package jaccesst1;
import com.jacob.com.*;

public class jaccesst {
    public jaccesst() {
    }
  public static void printRS(Recordset rs)
  {
    Fields fs = rs.getFields();
    //Variant i=new Variant("xpurl");
    Variant i=new Variant("name");
      System.out.print(fs.getIte(i).getName() + " ");
    System.out.println("yyq");
    rs.MoveFirst();
        Field f = fs.getIte(i);
        Variant v = f.getValue();
        System.out.print(v + " ");
      System.out.println("yyq");
      rs.MoveNext();
    }
 public static void getRS(String con, String query)
	{
	  System.out.println("Recordset Open");
		Recordset rs = new Recordset();
		rs.Open(new Variant(query), new Variant(con));
                Connection conn=rs.getActiveConnection();
	  printRS(rs);
          rs.Close();
          conn.Close();
	}
    public static void main(String[] args) {
        //String connectStr = "DRIVER=SQL Server;SERVER=DANADLER;UID=sa;PWD=;WSID=DANADLER;DATABASE=pubs";
        String connectStr = "DBQ=F:\\jaccess\\nb41\\t1\\news30000.mdb;DRIVER={Microsoft Access Driver (*.mdb)};";
        String queryStr = "select * from system";
        //getCommand(connectStr, queryStr);
        getRS(connectStr, queryStr);
    }
    
}