java.sql.SQLException: 第 1 行: '<' 附近有语法错误。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:933)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:365)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at edu.nwpu.grsadmin.information.News_Edit.FileShow(News_Edit.java:110)
at _news._viewnews__jsp._jspService(/gyy/news/viewnews.jsp:24)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin 2.1.17 (built Tue Jul 11 09:01:03 PDT 2006) 查阅了很多资料,仍然不会解决,希望大家帮帮我。谢谢!!!
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:933)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.cursorCreate(MSCursorResultSet.java:541)
at net.sourceforge.jtds.jdbc.MSCursorResultSet.<init>(MSCursorResultSet.java:154)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:365)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1258)
at edu.nwpu.grsadmin.information.News_Edit.FileShow(News_Edit.java:110)
at _news._viewnews__jsp._jspService(/gyy/news/viewnews.jsp:24)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:346)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:534)
--------------------------------------------------------------------------------
Resin 2.1.17 (built Tue Jul 11 09:01:03 PDT 2006) 查阅了很多资料,仍然不会解决,希望大家帮帮我。谢谢!!!
String neirong =rs.getContent();
StringBuffer sbTemp = new StringBuffer();
char cAT;
int slength = neirong.length();
int charindex = 0;
int flag = 0; while(charindex < slength){
cAT = neirong.charAt(charindex);
if((flag == 0) && (cAT == '<')){
flag = 1;
}
if((flag == 1) && (cAT == '>')){
flag = 0;
}
if((cAT == ' ') && (flag == 0)){
sbTemp.append(" ");
}else if((cAT == '\r') && (flag == 0)){
//sbTemp.append("<br>");
}else{
sbTemp.append(cAT);
}
charindex = charindex + 1;
} neirong = sbTemp.toString();
%> 这个有错误吗?请各位帮帮忙!
for (int i = 0;i<file.getFileCount();i++){
%>
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: '<' 附近有语法错误。
看这里的110行啊,打印一下你的SQL语句