很明显:
sql的驱动有问题,版本升级一下就OK了,很简单
sql的驱动有问题,版本升级一下就OK了,很简单
解决方案 »
- 我要哭了啊,求大神啊,帮助啊,jsp连接SQL server 2008的问题
- 浏览器打开页面老是正在从xxx传送数据,其实页面早显示完成了的
- DWR入门的一个问题
- 工作好累啊
- jsp中怎么实现三级联动?
- ************ 日期天数相加 ***************
- 如何在jsp中调用activex控件?
- tomcat路径问题
- jsp 页面 DOCTYPE 改变,导致页面样式改变,请问大神如何解决
- 一个action调整到jsp遍历 实体类的错误
- 在TOMCAT下,我一个Servlet程序修改之后,tomcat运行的还是老的程序!TOMCAT是不是不能自动更新???
- linux惹的祸???参与有分
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String errString="";
boolean flag=false; Statement statement = xa_conn.createStatement();
sql = "select * from type";
if(statement!=null){
rs = statement.executeQuery(sql);
}
你说升级,是指sql server2000吗?
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
现在好象只有这个方法解决
rs.next();
i++;
}为什么?org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 7 is out of range.
ResultSet.CONCUR_UPDATABLE);
sql = "select * from type";
if(statement!=null){
rs = statement.executeQuery(sql);
while(i<pageSize&&!rs.isAfterLast()){
rs.next();
i++;
}为什么还是出错呢?org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 7 is out of range.
while(i<pageSize&&!rs.isLast()){也还是不行啊。郁闷啊!!
sql="select count(*) from account ";
rs=statement.executeQuery(sql);
while(rs.next())
{ intRowCount=rs.getInt(1); }
rs.close();//取得记录集
sql = "select a.*,year(dateandtime) as year, month(dateandtime) as month, day(dateandtime) as day, b.typename as typename from account a,type b where a.typeid=b.typeid "; if(statement!=null){
rs = statement.executeQuery(sql);
%>
<%
//分页
if(curPage==null){intPage=1;}else{intPage=Integer.parseInt(curPage);}
if(intPage<1){intPage=1;}
intPageCount=(intRowCount+pageSize-1)/pageSize;
if(intPage>intPageCount){intPage=intPageCount;}if(test){
out.print("<br>当前页="+intPage);
out.print("<br>记录数="+intRowCount);
out.print("<br>页大小="+pageSize);
out.print("<br>页总数="+intPageCount);
}//分页显示if(intPageCount>0){
while(i<((intPage-1)*pageSize+1)){rs.next();i++;}
i=0;
while(i<pageSize&&!rs.isLast()){
sColor=(i%2==0)?"#E3EFF9":"#ffffff";
String memo=rs.getString("memo");
%>
<tr bgcolor="<%=sColor%>">
<td width="100"><%= rs.getString("name")%></td>
<td width="60"><%= rs.getString("year")%>-<%= rs.getString("month")%>-<%= rs.getString("day")%></td>
<td width="30"><input type="checkbox" name="del" value="<%= rs.getInt("id")%>"></td>
</tr>
<%
rs.next();
i++;
}
}
}
xa_man.releaseConnection(xa_conn);
%>