procedure.jsp
来自「J2EE独立开发制作」· JSP 代码 · 共 23 行
JSP
23 行
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver" );
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=Northwind", "sa", "");
CallableStatement cStmt =con.prepareCall("{call test(?,?)}");
cStmt.setString(1,request.getParameter("Customer"));
cStmt.registerOutParameter(2,java.sql.Types.INTEGER);
cStmt.execute();
out.println("对应的订货单ID是 "+cStmt.getInt(2));
}
catch(Exception e)
{
out.println("Error"+ e);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?