title: Write data from Database to File in Java
body: <p>I am trying to write data from a database into a text file. </p>
  
  <p>The text file remains empty. I tried to deg. Here is the code:</p>
  
  <pre><code>public void writeText()
  {
       try
      {
          Class.forName("com.mysql.jdbc.Driver");
      }
      catch(Exception e)
      {
          e.printStackTrace();
      }
      final String DB_URL ="jdbc:mysql://mis-sql.uhcl.edu/gattupalliv3940";
      Connection conn = null;
      Statement stat  = null;
      ResultSet rs = null;
      try
      {
          conn = DriverManager.getConnection(DB_URL,"gattupalliv3940","1552688");
          stat = conn.createStatement();
          rs = stat.executeQuery("select * from student_2");
          FileWriter fw = new FileWriter("data.txt");
          BufferedWriter bw = new BufferedWriter(fw);
          String line ="";
          while(rs.next())
          {
              line = rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getDouble(3);
              bw.write(line);
              bw.newLine();
          }
          bw.close();
      }
      catch(Exception e)
      {
          e.printStackTrace();
      }
      finally
      {
          try
          {
              conn.close();
              rs.close();
              stat.close();
          }
          catch(Exception e)
          {
              e.printStackTrace();
          }
      }
  }
  </code></pre>