Uploading excel sheet to Database

HI ,

I am using IDE netbeans, sql 2008 as data base .

Now i tried to create a java application and written the following code :

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package readtextfile;

import java.io.BufferedReader;
import java.io.DataInputStream;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.StringTokenizer;

/**
 *
 * @author kishore
 */
public class ReadTextFile {

/**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        String credit_wise = "";
        String ge_account_no = "";
        String date = "";
        String line_no = "";
        String flag = "0";
        String day = "";
        StringBuffer content = new StringBuffer();
        String temp_day = "";
        String temp_line = "";
        Connection con = null;
        PreparedStatement pst = null;
        String note_sql = "";
        String username = "sa";
        String password = "Passw0rd";
        String url = "jdbc:sqlserver://localhost:1433;databaseName=TDP";

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                      con = DriverManager.getConnection(url, username, password);

// Open the file that is the first
            // command line parameter
            //FileInputStream fstream = new FileInputStream("C:/MODULAR/TDP/new_data/NZ Final/Notes/new doc.txt");
            FileInputStream fstream = new FileInputStream("C:/Modular/TDP/TDP_Data/NZ Payments/0801.xlsx");
            // Get the object of DataInputStream
            DataInputStream in = new DataInputStream(fstream);
                BufferedReader br = new BufferedReader(new InputStreamReader(in));
            String strLine;
            //Read File Line By Line
            while ((strLine = br.readLine()) != null)   {
              // Print the content on the console
              //System.out.println (strLine);
              StringTokenizer st = new StringTokenizer(strLine, "|");
                  credit_wise = st.nextToken();
                  ge_account_no = st.nextToken();
                  date = st.nextToken();
                  date = date.substring(6, 10)+"-"+date.substring(3, 5)+"-"+date.substring(0, 2);
                  line_no = st.nextToken();
                  day = st.nextToken();
                  content = content.append(st.nextToken()+" ");
                  if(day.equalsIgnoreCase("1"))
                  {
                      note_sql = "insert into note(date, bi_ref, ge_account_no, credit_wise, content)" +
                              //" values (?,?,?,?,?,?,?)";
                              " values " +
                                  "('"+java.sql.Date.valueOf(date)+"'," +
                                  "(select id from account where ge_account_no='"+ge_account_no+"')," +
                                  "'"+ge_account_no+"'," +
                                  "'"+credit_wise+"'," +
                                  "'"+content.toString()+"')";
                      //System.out.println("sql :: "+note_sql);
                      pst = con.prepareStatement(note_sql);
                      pst.executeUpdate();
                      //content = new StringBuffer();
                  }
                  else
                  {
                    //content.append(" "+st.nextToken()) ;
                  }

/*
                  System.out.println("st1:: "+str1);
                  System.out.println("st2:: "+str2);
                  System.out.println("st3:: "+str3);
                  System.out.println("st4:: "+str4);
                  System.out.println("st5:: "+str5);
                  System.out.println("st6:: "+str6);
                   */
            }
            //Close the input stream
            in.close();
        }catch (Exception e){//Catch exception if any
          System.err.println("Error: " + e.toString());
        }

}

I created a datasource dsn as mydsn and cinfigured with Microsoft Excel.

when i tried to run i got the follwoing error:

run:
Error: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
BUILD SUCCESSFUL (total time: 0 seconds)

PLease help me. as i am starter. thank You

1) UseCodeTags. You can edit your post to add them.

2) the message is quite clear - the SQL driver class cannot be found. You need to add sqljdbc.jar to your class path.

Yeah thank i have already added that jar file. Now can you correct my code. I am unable to imoprt excel to sql database.

Well, what's the problem now?

Maybe you should look at the java.sql.Blob datatype...

http://msdn.microsoft.com/en-us/library/ms378813.aspx

I've added code tags to your post and am moving it to our JDBC forum.

content.toString() isn't going to work for a CLOB/BLOB. You need to use a PreparedStatement with "?" binding variables.