java调用存储过程CallableStatement问题
数据库中的
Sno int,
Sname varchar(20),
Scourse varchar(30),
Sscore int
)
insert into score values(1,'张三','语文',90);
insert into score values(1,'张三','数学',95);
insert into score values(1,'张三','英语',85);
insert into score values(2,'李四','语文',91);
insert into score values(2,'李四','数学',92);
insert into score values(2,'李四','英语',82);
create proc score1(@no int)
as
select avg(Sscore) from score where Sno=@no
JAVA中
Connection conn;
try {
conn = DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(strsql);
while(rs.next()) {
aa=rs.getString("Sno");//可以读取数据
bb=rs.getString("Sname");
cc=rs.getString("Sscore");
rs.next();
dd=rs.getString("Sscore");
rs.next();
ee=rs.getString("Sscore");
CallableStatement cstmt=conn.prepareCall(
"{call score1(?)}");
int aaa = Integer.parseInt(aa);
cstmt.setInt(1, aaa);
cstmt.registerOutParameter(1, Types.INTEGER);
cstmt.executeUpdate();//这里无法执行,不知道为什么?
int fff=cstmt.getInt(1);
ff=Integer.toString(fff);
break;
}
} catch (SQLException e) {
label.setText("连接不成功");
}