展开全部
java代码copy:
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager
.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=111111");
String sql = "{call sel(?)}";
CallableStatement cs = (CallableStatement)con.prepareCall(sql);
cs.execute();
String name = cs.getString(1);
System.out.println(name);
创建bai存储过程代du码:
drop procedure if exists sel;
create procedure sel(out name1 varchar(225))
begin
select name into name1 from a limit 1;
end
输出zhi结果dao: