少量时候是可以的,但是较多的时候会报错public void refreshList(String m)
{int x=0;
File myFile=new File(ad+"/"+m);
File[] objFiles=myFile.listFiles();
for(int i=0;i<objFiles.length;i++)
{ con=ConMysql.gainConnection(); try {
sql=con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
a=objFiles[i].getName();
b=objFiles[i].getPath();
c=objFiles[i].length();
d=b.replaceAll("\\\\","/");
try {
rs=sql.executeQuery("SELECT*FROM download where parent='"+ m +"'");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
while(rs.next())
{try {
if(rs.getString(1).equals(a)==true)
{x=1;
break;
}
else{};} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}if(x==1)
{}
else
{
try {sql.execute("insert into download(filename,fileroot,filevolum,fileid,parent) values('"+ a +"','"+ d +"','"+ c +"','"+ i +"','"+ m +"')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
ConMysql.releaseConnection(rs,null,sql,con);
}
报错是:The server encountered an internal error () that prevented it from fulfilling this request.少量文件时候没有问题,就扫一个文件名较多的文件夹时候报错。
{int x=0;
File myFile=new File(ad+"/"+m);
File[] objFiles=myFile.listFiles();
for(int i=0;i<objFiles.length;i++)
{ con=ConMysql.gainConnection(); try {
sql=con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
a=objFiles[i].getName();
b=objFiles[i].getPath();
c=objFiles[i].length();
d=b.replaceAll("\\\\","/");
try {
rs=sql.executeQuery("SELECT*FROM download where parent='"+ m +"'");
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
while(rs.next())
{try {
if(rs.getString(1).equals(a)==true)
{x=1;
break;
}
else{};} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}if(x==1)
{}
else
{
try {sql.execute("insert into download(filename,fileroot,filevolum,fileid,parent) values('"+ a +"','"+ d +"','"+ c +"','"+ i +"','"+ m +"')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
ConMysql.releaseConnection(rs,null,sql,con);
}
报错是:The server encountered an internal error () that prevented it from fulfilling this request.少量文件时候没有问题,就扫一个文件名较多的文件夹时候报错。
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:500)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:428)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root causejava.lang.NullPointerException
com.DownloadFile.refreshList(DownloadFile.java:26)
org.apache.jsp.LOG.DOWNLOAD.xia_jsp._jspService(xia_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.32 logs.