Insert into sqlserver database - Java JDBC

Java examples for JDBC:SQL Server

  1. HOME
  2. Java
  3. JDBC
  4. SQL Server

Description

Insert into sqlserver database

Demo Code

import java.io.*;
import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class CorLongan {
  public static void main(String[] args) throws ParseException{      
    Connection conn = null;// w w  w.j  a v  a2 s  . com
    try{
      String fruit="aaa";
      String connUrl = "jdbc:sqlserver://localhost:1433;databaseName=agriculture";
      conn = DriverManager.getConnection(connUrl, "sa", "passw0rd");
      
      String text="";
      for(int i=2004;i<=2014;i++){
        text += "year"+i+" "+"float"+","+" ";
      }
      text = "create table "+fruit+"("+text+"seq Int"+")"+";";
      String insStmt1 = text;
      PreparedStatement pstmt1 = conn.prepareStatement(insStmt1);
      pstmt1.executeUpdate();      
      
      ///source
      File inputfile1 = new File("C:\\Users\\T100T\\Downloads\\totalfruit\\"+fruit+".csv");  //?i???      
      String str;
      BufferedReader in1 = new BufferedReader(new FileReader(inputfile1));          
      //insert      
      String insStmt2 = "INSERT INTO "+ fruit +" VALUES (?,?,?,?,?,?,?,?,?,?,?,?)";  //?i???
      PreparedStatement pstmt2 = conn.prepareStatement(insStmt2);
      str=in1.readLine();
      
      while((str=in1.readLine())!=null){
        String[] inputdata =str.split(",");    
        for(int i=1;i<=11;i++){
          pstmt2.setFloat(i,Float.parseFloat(inputdata[i]));
        }           
             pstmt2.setInt(12,Integer.parseInt(inputdata[12]));
            pstmt2.addBatch();    
      }pstmt2.executeBatch();          
        
      
      
    }catch(IOException i){i.printStackTrace();}
     catch(SQLException e){e.printStackTrace();} 
     finally { 
     if (conn != null)try {conn.close();}catch(SQLException e){e.printStackTrace();}
  }   
  }
}

Related Tutorials