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;
企业网站.net管理系统,采用三层结构开发，网页编辑器用的是FCKeditor，数据库操作采用的是存储过程学习作品，参照N-Layered Web Applications with ASP.NET 3.5文章及源码码发
0
IF states = NULL THEN
立即学习“Java免费学习笔记（深入）”；
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();
}
java怎么学习？java怎么入门？java在哪学？java怎么学才快？不用担心，这里为大家提供了java速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
332
收藏
