📄 testproc.jsp
字号:
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%
String driver = "com.mysql.jdbc.Driver";
String strUrl = "jdbc:mysql://localhost:3306/JPETSTORE";
Class.forName(driver);
Connection conn = DriverManager.getConnection(strUrl, "root", "123");
if(conn!=null){
out.print("1");
}
try{
CallableStatement cmt= conn.prepareCall("{call testproc2(?)}");
//cmt.registerOutParameter("OutParam", Types.INTEGER);
cmt.registerOutParameter("param1",Types.INTEGER);
cmt.executeQuery();
int outputValue =cmt.getInt("param1");
out.println("记录总数="+outputValue);
}catch(Exception e){out.print(e);}
%>
jjj
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -