Plz help ... retreiving data from an access database table....

[austinsmiles]

i think there is some problem with the execute query statement.......
plz help...




import java.sql.*;
import java.io.*;

public class new2
{
public static void main(String args[])
{
if(args.length!=1)
{
System.out.println("syntax:give filename");
return;
}
java.sql.Connection conn = null;
try
{
conn=AccessJDBCUtil.getAccessDBConnection(args[0]);
Statement stmt = conn.createStatement();
ResultSet rs=null;
//stmt.execute(args[1]);
rs=stmt.executeQuery("select name2 from table1 where name1=derik");
//outputResultSet(rs);
stmt.close();
}
catch(SQLException s)
{
System.out.println(s);
}
finally
{
if(conn != null)
{
try
{
conn.close();
}
catch(SQLException ignore) {}
}
}

}
/*private static void outputResultSet(ResultSet rs) throws SQLException
{
ResultSetMetaData rsMetaData=rs.getMetaData();
int numberofcolumns=rsMetaData.getColumnCount();
while(rs.next())
{
for(int i=1; i<(numberofcolumns+1); i++)
System.out.print(rs.getString(i) + " ");
System.out.println();
}
rs.close();
}*/
}

[jelly]

Assuming name2 is declared as varchar it will require string to be passed in the where clause, try:

Code:

rs=stmt.executeQuery("select name2 from table1 where name1='derik' ");

If that doesn't work then please post what the failure is that you are getting