Retrieve Data from CSV file in JSP

Core Java| JSP| Servlets| XML| EJB| JEE5| Web Services| J2ME| Glossary| Questions?

Software Solutions and Services

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet

Questions

INNERCLASSS
What Is The Use Of InnerClasses?
convert to java plss
hi i am using microsoft VB6.0 and my friend ask me to make java program to convert number to words but i only use visual
java program
if c = 2 find d = ++c++++4 answer shows 3+2+4+1 9+1 10 I think d = operator mistake, pls clarify what operator
java program
if int a = 48 find a = a+++++a answer shows 48+49+1 97+1 98 pls clarify find a equation, as I think there some
java
program concept behind inheritance in java
Java File
Hi Friend, Thank you for the support I got previously... Anyone please send me the Java Code for scanning a direct
password protected zip file creation exmpale coded neaded
am able to create a zip file and able to read the file but password protection need please help
java
any programs on combination generation pls...
deteminant
wap to find the determinant of any order matrix
java
i want to know the program for transversal sort. thanks
All Questions...

Comments

Retrieve Data from CSV file in JSP
CSV file : A CSV file is commonly known as a Comma Delimited File or a Character Separated File.

Retrieve Data from CSV file in JSP

CSV file : A CSV file is commonly known as a Comma Delimited File or a Character Separated File. It is a text file that has a specific format which allows saving of text in organized manner. This format known as a flat table, is very simple. Each row contains one record of information. The character used to distinguish each piece of data within each record is most commonly used a comma ",".

"myfile.csv" in the c:\csv folder

Create a Page ("ReadCsvFile.jsp") to retrieve the data from CSV file "myfile.csv".

<%@ page import="java.io.*"%>
<html>
<body>
<%
     String fName = "c:\\csv\\myfile.csv";
     String thisLine;
      int count=0;
      FileInputStream fis = new FileInputStream(fName);
      DataInputStream myInput = new DataInputStream(fis);
      int i=0;
%>
<table>
<%
while ((thisLine = myInput.readLine()) != null)
{
String strar[] = thisLine.split(",");
for(int j=0;j<strar.length;j++)
{
if(i!=0)
{
out.print(" " +strar[j]+ " ");
}
else
{
out.print(" <b>" +strar[j]+ "</b> ");
}
}
out.println("<br>");
i++;
}
%>
</table>
</body>
</html>

Output

Download full source code

ť View all related tutorials

Related Tags: java c string jsp ide class strings script object io objects method get char ip using sequence id declaration length

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.

Add This Tutorial To:
Del.icio.us	Digg	Google	Spurl	Blink	Furl	Simpy	Y! MyWeb

Current Comments

1 comments so far (post your own) View All Comments Latest 10 Comments:

hi, i need to read the fields in csv file and assign to var array in html for use . example a field in the csv name file ,need to <a href="file"> click to view</a> .how to assign ?

Posted by tan on Tuesday, 12.9.08 @ 03:41am | #82547

View This Comment Separately

Training Courses

Website Designing Services

Web Designing Packages From $150!

Website Designing Company Web Hosting

Website Designing Quotation

About Us | Advertising On RoseIndia.net | Site Map

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.