File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How do we dispaly only particular row using jackcess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How do we dispaly only particular row using jackcess" Watch "How do we dispaly only particular row using jackcess" New topic
Author

How do we dispaly only particular row using jackcess

charu java
Greenhorn

Joined: Dec 05, 2012
Posts: 11
Hi this is the sample piece used jackcess to access the .mdb file and display the table data
public class Test {
public static void main(String args[]){
try {
System.out.println(Database.open(new File("\\\\aa.bb.com\\root\\Java\\access.mdb"))
.getTable("MASTER").display());
} catch (IOException e) {
e.printStackTrace();
}

}
}

Is there any code is available to display only one particular row based on condition like how do we display using sql where condition using jackcess.
I am using jackcess1.2.8 jar

Thanks in Advance
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41800
    
  62
The Jackcess home page on SourceForge has an example that does exactly that. My advice is the same as yesterday: start by reading the FAQ and the Cookbook.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How do we dispaly only particular row using jackcess