java - Reading from a CSV file -

- 

try {     bufferedreader br = new bufferedreader(new inputstreamreader(item.getinputstream()));     string strline = "";     stringtokenizer st = null;     while ((strline = br.readline()) != null) {         st = new stringtokenizer(strline, "\t");         while (st.hasmoretokens()) {             urlcnt = st.nexttoken();             srccnt = st.nexttoken();             contenttype = st.nexttoken();             verticle = st.nexttoken();             timeframe = st.nexttoken();         }         if (con == null) {             sqlconnection.seturl("jdbc:sqlserver://192.168.2.53\\sql2005;user=sa;password=365media;databasename=ln_adweek");             con = sqlconnection.getnewconnection();             stmt = con.createstatement();         }         try {             resultset rs;             boolean hasrows = false;             rs = stmt.executequery("select url urls_temp url='"+urlcnt+"'");             while (rs.next()) {                 hasrows=true;                 i++;             }             if (!hasrows) {                 j++;                 preparedstatement inserturlstatement = con.preparestatement("insert urls_temp(url, source_name, is_active, is_periodic, link_type, new_entry, verticle, periodic_timeframe) values(?, ?, ?, ?, ?, ?, ?, ?)");                 if (timeframe.equalsignorecase("daily")) {                     inserturlstatement.setstring(1, urlcnt);                     inserturlstatement.setstring(2, srccnt);                     inserturlstatement.setint(3, 1);                     inserturlstatement.setint(4, 0);                     inserturlstatement.setstring(5, contenttype);                     inserturlstatement.setint(6, 1);                     inserturlstatement.setstring(7, verticle);                     inserturlstatement.setstring(8, timeframe);                     inserturlstatement.executeupdate();                     inserturlstatement.close();                 } else {                     inserturlstatement.setstring(1, urlcnt);                     inserturlstatement.setstring(2, srccnt);                     inserturlstatement.setint(3, 1);                     inserturlstatement.setint(4, 1);                     inserturlstatement.setstring(5, contenttype);                     inserturlstatement.setint(6, 1);                     inserturlstatement.setstring(7, verticle);                     inserturlstatement.setstring(8, timeframe);                     inserturlstatement.executeupdate();                 }             }         }     } }

the above code used uploading details database given tab separated in csv file.

sample format of csv file follows , works fine:

http://avb.com(tab space)asdf(tab space)asdf(tab space)asdd(tab space)asdf

http://anything.com(tab space)asdf(tab space)asdf(tab space)asdfasd(tab space)asdfsadf

sometimes may need null values inserted database csv file follows:

http://asdf.com(tab space)(tab space)aasddf(tab space)(tab space)asdfsad

but not working, nothing getting inserted database.

what modification has done above program inserting null values in second , fourth (srccnt & verticle) columns of table?

stringtokenizer treats consecutive delimiters single delimiter. input contains [tab space] delimiters, rest of code doesn't seem expecting spaces so, without more information, i'm going guess input delimited tabs (not [tab space]), , adjacent delimiters being ignored, last nexttoken() throws exception ignoring.

the answer here rewrite using split(), recommended in javadoc

stringtokenizer legacy class retained compatibility reasons although use discouraged in new code. recommended seeking functionality use split method of string or java.util.regex package instead.

that said, should @ of existing csv libraries out there (google java csv).


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more