这是添加的方法:
public int select(int id)
{
int num = 0;
try
{
conn=userdao.getConn();
String sql = "insert into book values(?,?,?)";
pStatement = conn.prepareStatement(sql);
pStatement .setInt(1,id);
pStatement.setString(1,"?" );
pStatement.setString(2, "?");
pStatement.executeUpdate();
num =1;
}catch(ClassNotFoundException e)
{
e.printStackTrace();
num=0;
}
catch(SQLException e)
{
e.printStackTrace();
num=0;
}
finally
{
userdao.closeAll(conn, pStatement, rs);
}
return num;
}
这是处理页面的代码<%@ page language="java" import="java.util.*,s2jsp.shiti.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
Bookselect bookdao = new Bookselect();
int id =Integer.parseInt(request.getParameter("id"));
int num = bookdao.select(id);
if(num>0)
{
out.print("添加成功");
}
else
{
out.print("添加失败");
}
%><html>
<head>
</head>
<body>
<br>
<div class="STYLE1" id="Layer1">
<p></p>
<p> </p>
</div>
<div class="STYLE2" id="Layer2"><a href="book.jsp">返回添加其他书籍</a></div>
</body>
</html>
求高手看下是哪里出错了 急急急
public int select(int id)
{
int num = 0;
try
{
conn=userdao.getConn();
String sql = "insert into book values(?,?,?)";
pStatement = conn.prepareStatement(sql);
pStatement .setInt(1,id);
pStatement.setString(1,"?" );
pStatement.setString(2, "?");
pStatement.executeUpdate();
num =1;
}catch(ClassNotFoundException e)
{
e.printStackTrace();
num=0;
}
catch(SQLException e)
{
e.printStackTrace();
num=0;
}
finally
{
userdao.closeAll(conn, pStatement, rs);
}
return num;
}
这是处理页面的代码<%@ page language="java" import="java.util.*,s2jsp.shiti.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
Bookselect bookdao = new Bookselect();
int id =Integer.parseInt(request.getParameter("id"));
int num = bookdao.select(id);
if(num>0)
{
out.print("添加成功");
}
else
{
out.print("添加失败");
}
%><html>
<head>
</head>
<body>
<br>
<div class="STYLE1" id="Layer1">
<p></p>
<p> </p>
</div>
<div class="STYLE2" id="Layer2"><a href="book.jsp">返回添加其他书籍</a></div>
</body>
</html>
求高手看下是哪里出错了 急急急
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NumberFormatException: null
java.lang.Integer.parseInt(Integer.java:415)
java.lang.Integer.parseInt(Integer.java:497)
org.apache.jsp.zhuche_jsp._jspService(zhuche_jsp.java:54)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)