-1
import java.sql.*;


public class Voucher {

    public static void main(String[] args) {

        try {
                 Class.forName("oracle.jdbc.driver.OracleDriver");
                 String dbURL = "jdbc:oracle:thin:user/pwd@IP:PORT:DB";

                 Connection conn = DriverManager.getConnection(dbURL);

                String query = "SELECT CIRCLENAME,CALLINGVALUE,GRACEPERIOD,MINOFUSAGE,MRP,PROCESSINGFEE,SERVICETAX,VALIDITY from AM_PREPAID_VOUCHER_COUPONS A, AM_CIRCLE B WHERE A.CIRCLEID=B.CIRCLEID order by b.CIRCLENAME asc";






                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery(query);
                                System.out.println("CIRCLENAME,CALLINGVALUE,GRACEPERIOD,MINOFUSAGE,MRP,PROCESSINGFEE,SERVICETAX,VALIDITY");
                while (rs.next())
                {   

                 String CIRCLENAME = rs.getString("CIRCLENAME");
                 String CALLINGVALUE = rs.getString("CALLINGVALUE");
                 String GRACEPERIOD = rs.getString("GRACEPERIOD");
                 String MINOFUSAGE = rs.getString("MINOFUSAGE");
                 String MRP = rs.getString("MRP");
                 String PROCESSINGFEE = rs.getString("PROCESSINGFEE");
                 String SERVICETAX = rs.getString("SERVICETAX");
                 String VALIDITY = rs.getString("VALIDITY");


                    System.out.println(CIRCLENAME+ "," +CALLINGVALUE+ "," +
                    GRACEPERIOD+ "," +MINOFUSAGE+ "," +MRP+ "," +PROCESSINGFEE+ "," +
                    SERVICETAX+ "," +VALIDITY);

             }

                conn.close();
        }
                catch (Exception e) {
                    System.err.println("Got an exception! ");
                    System.err.println(e.getMessage());
                }

            }

}

Value in column - CALLINGVALUE is "49 TT, 5 days" due to which column values are printed correctly in a csv format. How to handle this comma within a column?

tushar modgil
  • 29
  • 2
  • 1
    What are you trying to do? –  Jan 02 '18 at 08:34
  • I am trying to export data in a comma separated format but one column in database table ( column name - CALLINGVALUE), has a comma in it ( eg: 49 TT, 5 days) due to which a single column value is getting split into two columns. How to export the values as such into a csv format? – tushar modgil Jan 02 '18 at 09:37

1 Answers1

0

You can enclose each field between quotes, but you would have a problem if the data contains quote character, in which case, you should double them.

Otherwise, You can use a CSV library. That's what I would do.

Maurice Perry
  • 9,261
  • 2
  • 12
  • 24