jsp处理客户端请求

来源：百度知道 编辑：UC知道 时间：2024/06/17 19:52:17
这是插入语句的方法：
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, 2);
pStatement.setString(1,"?" );
pStatement.setString(2, "?");
pStatement.executeUpdate();

}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
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()+":"+req

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;
}