hi all
here im trying to create .csv file.
my code is
public class CSVFile {
public static void main(String[] args) {
String record=null;
try {
Class.forName("org.sqlite.JDBC");
Connection conn=DriverManager.getConnection("jdbc:sqlite:"+"C :\\Sqlite
retriver.db");
Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from fileSystem");
ResultSetMetaData meta=rs.getMetaData();
int colCount=meta.getColumnCount();
int j=0;
File fileStore = new File(fileStore.csv");
FileOutputStream fos=new FileOutputStream(fileStore);
long i=0;
while(i++<10000)
{
rs.next();
record=rs.getString(1)+","rs.getString(2)","rs.get String(3)","rs.getString(4)","rs.getString(5)","rs .getString(6)","rs.getString(7)","rs.getString(8)" ,"rs.getString(9)"\n";
fos.write(record.getBytes());
System.out.println("counter"+(j++));
}
This is my code
my problem is in my database i have 2,00,000 records
but here i will get upto 65,000 records only
i want to get all records
is there any solution
plz help me