📄 procedure.jsp

📁 J2EE独立开发制作

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -