mysql存储过程 带参数java
create procedure t_weather_pro (in tmdn varchar(12),out tmsg varchar(12))
begin
declare states,begintime,endtime varchar(2) ;
select t_states,t_begintime,t_endtime into states,begintime,endtime from t_user_weather where t_user = tmdn limit 1;
if states = null then
insert into t_user_weather values(null,tmdn,1,7,10);
select t_states,t_begintime,t_endtime into states,begintime,endtime from t_user_weather where t_user = tmdn limit 1;
set tmsg = states;
else
set tmsg = states;
end if;
end;
java调用
connection conn = mydatasource.getconnection();
try {
callablestatement cstmt=conn.preparecall(sql);
cstmt.setstring(1, 0985023223);
cstmt.registeroutparameter(2, java.sql.types.varchar);
cstmt.executeupdate();
string result=cstmt.getstring(2);
system.out.println(result);
} catch (sqlexception e) {
// todo auto-generated catch blockxq
e.printstacktrace();
}