ストアドプロシージャでデータベースアクセスを効率化する：JavaTips 〜JSP／サーブレット編

package to.msn.wings;
 
import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class CallableSql extends HttpServlet {
  public void doGet(HttpServletRequest request,HttpServletResponse
 response)
    throws ServletException,IOException {
    Connection db=null;
    CallableStatement objSql=null;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      db = DriverManager.getConnection("jdbc:odbc:sample", "usr", "pass");
      objSql = db.prepareCall("{call InsertBook (?,?,?)}");
      objSql.setString(1,"ISBN 4-7981-0439-6");
      objSql.setString(2,"10日でおぼえるJakarta入門教室");
      objSql.setString(3,"2800");
      objSql.executeUpdate();
    } catch (ClassNotFoundException e) {
      throw new ServletException(e);
    } catch (SQLException e) {
      throw new ServletException(e);
    } finally{
      try {
        if(objSql!=null){objSql.close();}
        if(db!=null){db.close();}
      } catch (SQLException se) {
        throw new ServletException(se);
      }
    }
  }
}

{call ストアドプロシージャ名 (?,...)}

{?=call ストアドプロシージャ名 (?,...)}