ssh的集成项目中如何调用mysql中既带输入参数又带输出参数的存储过程
drop procedure if exists pr_add;
DELIMITER $$
create procedure pr_add
(
n varchar(20),
pwd varchar(20),
out cc varchar(20),
out bb varchar(20)
)
begin
select loginName as cc,loginPwd as bb from kcwms.userrole where loginName=n and loginPwd=pwd;
end;
$$call pr_add('admin','admin',@eaec,@bb);
drop procedure if exists pr_add;
DELIMITER $$
create procedure pr_add
(
n varchar(20),
pwd varchar(20),
out cc varchar(20),
out bb varchar(20)
)
begin
select loginName as cc,loginPwd as bb from kcwms.userrole where loginName=n and loginPwd=pwd;
end;
$$call pr_add('admin','admin',@eaec,@bb);
解决方案 »
- $Proxy64 cannot be cast to com.yf.ejb.UserManager
- 当前日期以后的7天以内日期给显示红色,求助大侠
- Weblogic10.3上Cluster环境,MDB同时触发的问题。。
- MyEclipse哪个版本好用啊,请大家指点?谢谢!
- 100分 菜鸟问题,初学JAVA 大家帮忙看下 说下这是什么意思怎么用的越仔细越好 谢谢了 在线等
- 基于j2ee的教育资源的webservice 实现的构想
- struts的<html:radio>标签问题
- 关于hibernate的问题
- struts 问题,设置checkbox 为选中状态怎么做?
- 关于jsf下拉列表问题
- 【第三章】 DI 之 3.2 循环依赖 ——跟我学spring3
- jsp页面的表格,如何处理成excel
SessionFactory factory = new Configuration().configure().buildSessionFactory();
Session session = factory.openSession();
Transaction trans = session.beginTransaction();
Connection con = session.connection();
CallableStatement st = con.prepareCall("{call my_proc(?,?,?)}");
st.setInt(1, 7788);
st.registerOutParameter(2, OracleTypes.NUMBER);
st.registerOutParameter(3, OracleTypes.VARCHAR);
st.execute();
System.out.println(st.getFloat(2));
System.out.println(st.getString(3));
st.close();
con.close();
trans.commit();
throws Exception {
CallableStatement call = null;
int[] result = new int[2];
try {
String cal = "{call USER_CARDCHARGE(?,?,?,?,?,?)}";
Connection conn = DBConnection.getConnection();
call = conn.prepareCall(cal); call.setString(1, cn);
call.setString(2, cardPwd);
call.setString(3, ip);
call.setLong(4, zoneId); call.registerOutParameter(5, 4);
call.registerOutParameter(6, 4);
call.executeUpdate(); result[0] = call.getInt(5);
result[1] = call.getInt(6);
} catch (Exception e) {
e.printStackTrace();
}
return result;
}
为什么报空指针呀?