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;