Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

putting values of text file into database

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
i am having a textfile with the values (keyword, value) like follows:

challeng,0.98466665,internet,0.94937503,stock,0.91408336,com,0.63175
where challeng is keyword and 0.984 is value and so on..

I need to take the values of this text file and put it in a a database with two fields keyword and value how to do it?
 
Start by looking at the JDCB commands.

API packages in java.sql.*;

Look at CallableStatement, ResultSet , and Connection.

Get a driver for your database or use ODCB through JDCB.

I wrote code to use MS SQL 7.0 Server and Stored Procedures.

I am not sure what database you want to use?

Good luck,
Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top