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 + -
显示快捷键?