存储过程调用

1. 存储过程调用

 

-- 存储过程

-- 定义分隔符

DELIMITER $$

CREATE PROCEDURE proc_login()

BEGIN

   SELECT * FROM admin;

END $$

 

-- 调用

CALL proc_login;

public class App_call {// 全局参数private Connection con;private Statement stmt;private PreparedStatement pstmt;private CallableStatement cstmt;  // 存储过程private ResultSet rs; // 程序中调用存储过程@Testpublic void testCall() throws Exception {try {//1 . 创建连接con = JdbcUtil.getConnection();//2.  创建执行存储过程的stmt对象CallableStatement cstmt = con.prepareCall("CALL proc_login");//3.  执行（存储过程）rs = cstmt.executeQuery();// 遍历结果，测试if (rs.next()) {String name = rs.getString("userName");String pwd = rs.getString("pwd");// 测试System.out.println(name + pwd);}} catch (Exception e) {e.printStackTrace();}}}