IBatis调用MySQL存储过程出错,谁先解决分就是谁的

2025-04-09 10:48:53
推荐回答(1个)
回答(1):

ibatis.xml:






{CALL mytest (?,?)}


java里面调用:
Integer operateResult = null;
HashMap paramMap = new HashMap();
paramMap.put("username", userVO.getUsername());
paramMap.put("operateResult", operateResult);
Object obj = testDao.queryForObject("test.testProc", paramMap);

存储过程: (存储过程在MYSQL 调用成功了)

DELIMITER $$
DROP PROCEDURE IF EXISTS `mytest`$$

USE `aa`$$
CREATE DEFINER=`root`@`192.168.1.46` PROCEDURE `mytest`(inname VARCHAR(20), OUT returnid INTEGER(11))

BEGIN
SELECT u.user_id FROM user u WHERE u.user_name=inname;

END$$

DELIMITER;