数组下标越界
packageimport_csv;
importjava.io.BufferedReader;
importjava.io.FileInputStream;
importjava.io.FileNotFoundException;
importjava.io.IOException;
importjava.io.InputStreamReader;
importjava.io.UnsupportedEncodingException;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.SQLException;
importjava.sql.Statement;
publicclasscsv_sqlite{
publicstaticvoidmain(String[]args)throwsClassNotFoundException,IOException{
Stringb[]={"060101","060201","060202","060203",
"060204","060205","060206","060207",
"060208","010101","010102","010103",
"010104","010105","010106","010107",
"010108","010201","010202","010203",
"010204","010301","010302","01",
"02","03","04","01",
"02","03","04","020301",
"020302","030101","030102","030103",
"030104","030105","030106","030107",
"030108","030109","030110","030111",
"030112","030113","030114","030115",
"030116","030117","030118","030119",
"030120","030121","030122","030123",
"030124","030125","030126","030127",
"030128","030129","030130","040101",
"040102","040103","050101","050102",
"050201","050202","050203","050301",
"050302","060101","060102","060103",
"060104","060105","060106","060201",
"060202","060203","060204","060205",
"060206","060207","060208","060209",
"060210"};
intn=b.length;
System.out.println("数组长度:"+n);
Class.forName("org.sqlite.JDBC");
/*Connectionconn=DriverManager
.getConnection("jdbc:sqlite:d:/classtable.db");*/
for(intj=0;j
Stringfile="D:\\编程\\"+b[j]+".csv";
BufferedReaderbr=newBufferedReader(newInputStreamReader(
newFileInputStream(file),"GBK"));
Stringline;
while((line=br.readLine())!=null){
String[]value=line.split(",");
Stringsql="INSERTINTO["+b[j]+"]VALUES('"+value[0]
+"','"+value[1]+"','"+value[2]+"','"
+value[3]+"','"+value[4]+"')";
System.out.println(sql);
}
br.close();
}
}
}
我想先看看运行出的SQL语句,然后一直提示数组下标越界
以下是运行结果:
数组长度:89
INSERTINTO[060101]VALUES('国际贸易实务','实2-205','MON1','8','11')
INSERTINTO[060101]VALUES('财政学','教1-315','MON2','8','19')
INSERTINTO[060101]VALUES('国际贸易实务','教1-313','MON3','1','11')
INSERTINTO[060101]VALUES('中国对外贸易概论','教1-105','MON4','1','9')
INSERTINTO[060101]VALUES('广告学概论','教2-106','TUE2','1','15')
INSERTINTO[060101]VALUES('国际经济学','教1-206','TUE3','1','15')
INSERTINTO[060101]VALUES('外贸英文函电','教1-113','TUE4','1','11')
INSERTINTO[060101]VALUES('财政学','教1-315','WED1','8','19')
INSERTINTO[060101]VALUES('国际贸易','教1-113','WED3','12','19')
INSERTINTO[060101]VALUES('大学英语听说','教1-403','WED4','12','19')
INSERTINTO[060101]VALUES('中国对外贸易概论','教1-105','WED4','1','9')
INSERTINTO[060101]VALUES('国际贸易实务','教1-313','THU1','1','11')
INSERTINTO[060101]VALUES('外贸英文函电','实1-211','THU2','8','11')
INSERTINTO[060101]VALUES('外贸英文函电','教1-113','THU3','1','11')
INSERTINTO[060101]VALUES('广告学概论','教2-106','THU4','1','15')
INSERTINTO[060101]VALUES('国际贸易','教1-113','FRI1','12','19')
INSERTINTO[060101]VALUES('大学英语听说','教1-403','FRI2','12','19')
INSERTINTO[060101]VALUES('国际经济学','教1-206','FRI3','1','15')
INSERTINTO[060201]VALUES('财政学','教2-203','MON2','8','19')
INSERTINTO[060201]VALUES('保险学','教2-109','MON3','8','19')
INSERTINTO[060201]VALUES('广告学概论','教2-106','TUE1','1','15')
INSERTINTO[060201]VALUES('经济法','教1-206','TUE2','8','19')
INSERTINTO[060201]VALUES('国际经济学','教1-206','TUE3','1','15')
INSERTINTO[060201]VALUES('保险学','教2-109','WED2','8','19')
INSERTINTO[060201]VALUES('财政学','教2-203','THU1','8','19')
INSERTINTO[060201]VALUES('经济法','教1-206','THU2','8','19')
INSERTINTO[060201]VALUES('广告学概论','教2-106','THU3','1','15')
如果觉得《java下标越界的三种处理方式 数组下标越界 该怎么解决》对你有帮助,请点赞、收藏,并留下你的观点哦!