我有一个网站 需要分页 里面有2个表 存储过程如下
alter proc [dbo].[selecttop12]
@hangshu int,
@page int,
@id int
as
declare @i varchar(300)
set @i ='select top '+convert(varchar(3) ,@hangshu)+ ' dbo.Revertmatter.matter, dbo.Revertmatter.title, dbo.Revertmatter.reverttime, dbo.Revertmatter.revername from revertmatter where MID= '+convert(varchar(2),@id)+' and MID not in (select top '+convert(varchar(3),(@page-1)*@hangshu)+' MID from revertmatter) '
exec (@i)
当点看页面的时候 有2个查询 分别是查询2个表的内容 传值是有<a>标签 请看下面代码
request.setCharacterEncoding("utf-8");
int num =0;
int l=0;
if(request.getParameter("k")==null)
{
num=1;
}else{
num = Integer.parseInt(request.getParameter("k"));
}
l = num;
Manager mm = new Manager();
String n = new String(request.getParameter("titl").getBytes("ISO-8859-1"), "utf-8");
session.setAttribute("ll",request.getParameter("titl"));
if(n==null)
{n=session.getAttribute("ll").toString();}
int c = Integer.parseInt(request.getParameter("id"));
List<Message> list = mm.selectmessager(n);
List<RevertMessage> list2 = mm.selectRever(l,c);
报错的时候是500 指的是String n = new String(request.getParameter("titl").getBytes("ISO-8859-1"), "utf-8");
这句代码有错~~!请高手指点一下,如果不清楚 可以加 QQ 402365105~~~!谢谢!!!
alter proc [dbo].[selecttop12]
@hangshu int,
@page int,
@id int
as
declare @i varchar(300)
set @i ='select top '+convert(varchar(3) ,@hangshu)+ ' dbo.Revertmatter.matter, dbo.Revertmatter.title, dbo.Revertmatter.reverttime, dbo.Revertmatter.revername from revertmatter where MID= '+convert(varchar(2),@id)+' and MID not in (select top '+convert(varchar(3),(@page-1)*@hangshu)+' MID from revertmatter) '
exec (@i)
当点看页面的时候 有2个查询 分别是查询2个表的内容 传值是有<a>标签 请看下面代码
request.setCharacterEncoding("utf-8");
int num =0;
int l=0;
if(request.getParameter("k")==null)
{
num=1;
}else{
num = Integer.parseInt(request.getParameter("k"));
}
l = num;
Manager mm = new Manager();
String n = new String(request.getParameter("titl").getBytes("ISO-8859-1"), "utf-8");
session.setAttribute("ll",request.getParameter("titl"));
if(n==null)
{n=session.getAttribute("ll").toString();}
int c = Integer.parseInt(request.getParameter("id"));
List<Message> list = mm.selectmessager(n);
List<RevertMessage> list2 = mm.selectRever(l,c);
报错的时候是500 指的是String n = new String(request.getParameter("titl").getBytes("ISO-8859-1"), "utf-8");
这句代码有错~~!请高手指点一下,如果不清楚 可以加 QQ 402365105~~~!谢谢!!!
解决方案 »
- solr 请教排序问题
- 宿主机和虚拟机数据库连接的问题
- 以前用.NET实现起来很简单的东西,可是用java就是搞不出来,在给100分!真心请教,顶者有分!!
- 求助:项目打包成WAR后, 如果在WEB页面上更改并保存WEB-INF下面的.xml文件?
- MVC模式下的一个问题。我快死了。。。
- 程序员们都来谈谈! 关于薪水问题
- 学JSP要不要需要ASP基础?
- 网上商店
- 帮我解释一下,入门问题,在线等待!window2000server+weblogic7.0+oracle9.02
- jdk1.4是不是和sql server 2000 jdbc不兼容?
- 如何屏蔽tomcat启动信息
- jsp 怎样实现图片上传?
75: l = num;
76: Manager mm = new Manager();
77: String n = new String(request.getParameter("titl").getBytes("ISO-8859-1"), "utf-8");
78: session.setAttribute("ll",request.getParameter("titl"));
79: if(n==null)
80: {n=session.getAttribute("ll").toString();}
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.lang.NullPointerException
org.apache.jsp.revert_jsp._jspService(revert_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
这个就是错误信息,请高手指点~~~~
检查你的request.getParameter("titl")里面的titl是否有写错或者是否有值。