cannot append values from database when writing to a text file

[khamhielle gabriel]

hi everyone

can somebody help me with this,
i've been trying to write some database value to a text file.
by which the valus are selected using checkbox from the
first page.


ex:
[ ]-serves as checkbox

[ ] 1
[ ] 2
[ ] 3
[ ] 4


if i selected or check 1 and 2.
i should be able to print both in the text file. but what happened is i am only printing the last selection w/c is 2.

for added info i was incorporating the checked value in my select.
and i guess i am not closing the streams inside the loop.
because it works fine in my other pages which requires writing text file.


here is my sample code:

	
			if ( tsek == null )
			{
			out.print("<font color='red'font size='4' align='center'>No Records Selected");
			}
			else
			{
				int iLength = 0;
				iLength = request.getParameterValues("checkbox").length;
				String[] sclaimno = new String[iLength];
				sclaimno = request.getParameterValues("checkbox");
				
				for (int i = 0; i < iLength; i++){
					
					String count="";
					 count+=sclaimno[i];
		 	
		   try {
			    String url= "jdbc:jtds:sqlserver:";
			    String id= "";
			     String pass = ""; 
			   con=null;
     		   s=null;
     		   pst=null;
     		   rs=null;
     		  
   		   	  
              Class.forName("net.sourceforge.jtds.jdbc.Driver");
              con = java.sql.DriverManager.getConnection(url, id, pass);
    
              //spliting
	      		String str = count;
	      		String[] temp;
	      			 
	      		/* delimiter */
	      		String delimiter = ",";
	      		/* given string will be split by the argument delimiter provided. */
	      		temp = str.split(delimiter);
	      		/* print substrings */
	      		for(int d =0; d < temp.length ; d++)
	      		System.out.println(temp[d]+"ITO");
	                		
              		
			  String sql =("SELECT * FROM SWMWTYM   where  WTCLNO = '"+temp[0]+"' " ); 
		            		 
              s = con.createStatement();
              rs = s.executeQuery(sql);
             
       
          	//File creation
          	String strPath = "D:\\BAGO.txt";
          	File strFile = new File(strPath);
          	boolean fileCreated = strFile.createNewFile();
          	//File appendingl
              Writer objWriter = new BufferedWriter(new FileWriter(strFile));
          
      
		   while(rs.next()){
			String str1 = "";
			str1= rs.getString("WTCLNO");
			objWriter.write(str1);
			out .print(str1);
			
			
			
		}
		    
		  objWriter.flush();
		  objWriter.close();
		}
				   
		catch(Exception e){
		e.printStackTrace();
		}}}

thank you for your kind help.
God Bless you ^^