Error While Assigning Value in Array from ms Access

[JAVA0282]

dear

I have Created connection with ms access,but there is problem,while assigning value to array,& also getting error "RND.JAVA:59: CANNOT RESOLVE SYMBOL"

please kindly help me on this regard.

--Furqan

[RamyaSivakanth]

Post the code with code tag.

[JAVA0282]

I have mentioned code below, there is connection for ms access to get date & need to assign in array for insertion in oracle, but after its successful compilation then i will make connection to insert data in oracle database by the array.

I have added parameter for EMPNO but i need to add date parameter, actually I have to get data on the base of date parameter.

So kindly please if it possible to add data parameter in query as well.

Tanks for helping me


------------start
/**
* OdbcAccessConnection.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
import java.sql.Connection;
public class Rnd {

static {
char[] v_name = new char[30];
int[] v_empno = new int[30];
int b =1;

}




//Static String[] v_name = new String[30];
//Static int[] v_empno = new int[30];

// static int i =1;

public static void main(String [] args) {
Connection con = null;



try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;

// Connect with a url string


con = DriverManager.getConnection("jdbc:odbc:DB1");

Statement s = con.createStatement();

s.execute("select empno,NAME from EMP WHERE empno = " + b ); // select the data from the table
ResultSet rs = s.getResultSet(); // get any ResultSet that came from our query

System.out.println("Connection ok.");
//String sql = "CREATE TABLE books3 (id NUMBER(11), title VARCHAR2(64))";
//Statement statement = con.createStatement();
//statement.execute(sql);

if (rs != null) // if rs == null, then there is no ResultSet to view
while ( rs.next() ) // this will step through our data row-by-row


//v_empno[a] = rs.getString(1);
//v_name[a] = rs.getString(2);

{
/* the next line will get the first column in our current row's ResultSet
as a String ( getString( columnNumber) ) and output it to the screen */
System.out.println("Data from column_name: " + rs.getString(1) + " " + rs.getString(2) );

// System.out.println(a);
// a= a+1;
System.out.println("select " + b);
}


s.close(); // close the Statement to let the database know we're done with it
con.close();





} catch (Exception e) {
System.err.println("Exception: "+e.getMessage());
}
}
}

---end