lz使用javacsv.jar
public static void main(String[] args) {
@SuppressWarnings("resource")
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("spring_bean.xml");
JdbcTemplate jdbcTemplate = (JdbcTemplate) applicationContext.getBean("jdbcTemplate");
readeCsv(jdbcTemplate);
}
public static void readeCsv(JdbcTemplate jdbcTemplate){
List<String> segments = new ArrayList<>();
try {
ArrayList<String[]> csvList = new ArrayList<String[]>();
String csvFilePath = "X:\\Users\\xb\\Desktop\\excel\\移动号段0703.csv";
CsvReader reader = new CsvReader(csvFilePath,',',Charset.forName("SJIS")); //编码,一般用这个
reader.readHeaders(); // 跳过表头,需要表头的话,注释掉
while(reader.readRecord()){ //逐行读入数据
csvList.add(reader.getValues());
}
reader.close();
for(int row=0;row<csvList.size();row++){
String cell = csvList.get(row)[0]; //第row行第0列
segments.add(cell);
System.out.println(cell);
}
System.err.println(csvList.size());
System.err.println("segments:"+segments.size());
}catch(Exception ex){
ex.printStackTrace();
}
String sql = "insert into mobile_segment (segment) values(?) ";
for(String segment:segments){
jdbcTemplate.update(sql,segment);
}
}