csv处理数据后存入数据库

我自己测试的数据量在9万行多一点儿，数据库是sqlserver，改成自己的就行

package Test;

import java.io.BufferedReader;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class CsvSingle_Order_Source2 {

       static final String JDBC_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  
       static final String DB_URL = "jdbc:sqlserver://localhost:1433;DatabaseName=ReportCenter";

       //  Database credentials
       static final String USER = "sa";
       static final String PASS = "111";

     public static void main(String[] args) {    
            try {   

                Class.forName(JDBC_DRIVER);
                Connection conn = null;
                Statement stmt = null;
                conn = DriverManager.getConnection(DB_URL, USER, PASS);
                stmt = conn.createStatement();
                PreparedStatement st = null;

                BufferedReader reader = new BufferedReader(new FileReader("C:\\Users\\Administrator\\Desktop\\1月数据\\单品数据.csv"));//换成你的文件名   
                reader.readLine();//第一行信息，为标题信息，不用,如果需要，注释掉   
                String line = null;   
                String content = null;
                while((line=reader.readLine())!=null){
                    String item[] = line.split(",");//CSV格式文件为逗号分隔符文件，这里根据逗号切分   

                    String str0 = item[0];
                    String str1 = item[1];
                    String str2 = item[2];
                    String str3 = item[3];
                    String str4 = item[4];            
                    String str5 = item[5];

                    content="insert into Single_Order_Source (shopname,systemordernumber,ordernumber,category,productname)"
                            + "values ('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"+str5+"')";
                    System.out.println(content);
                    stmt.executeUpdate(content);
                }    
                System.out.println("全部完成");

                stmt.close();
                conn.close();
            } catch (Exception e) {    
                e.printStackTrace();    
            }  
        } 
}