您好,欢迎访问一九零五行业门户网

mysql-java怎么调用MySQL存储过程?

mysqljava存储过程
java调用存储过程报错,存储过程有两个int型参数,在数据库里存储过程可以运行,运行结果如上图:java.sql.sqlexception: parameter index out of range (0 代码如下,不知道怎么改,求网友协助
public arraylist getzhdltj(string time,string dzbm)
{
//定义一些变量
resultset rs=null;
connection ct=null;
preparedstatement csmt=null;
statement ps=null;
arraylist al = new arraylist();
try
{
ct=(new connectdb()).conndb();
int dzbmint=integer.parseint(dzbm);
int timeint=integer.parseint(time);
//ct.setautocommit(false);
csmt=ct.preparecall({pro_综合电力统计(in_year,in_stationid)});
csmt.setint(0, timeint);
csmt.setint(1, dzbmint);
csmt.execute(); ct.commit(); rs=csmt.executequery(); while(rs.next()) { wnbqgl nbqgl=new wnbqgl(); //nbqgl.setmaxdl(rs.getdouble(2)); /*月计划发电量*/ nbqgl.setyjfdl(rs.getdouble(1)); nbqgl.setejfdl(rs.getdouble(2)); nbqgl.setsjfdl(rs.getdouble(3)); nbqgl.setsijfdl(rs.getdouble(4)); nbqgl.setwjfdl(rs.getdouble(5)); nbqgl.setljfdl(rs.getdouble(6)); nbqgl.setqjfdl(rs.getdouble(7)); nbqgl.setbjfdl(rs.getdouble(8)); nbqgl.setjjfdl(rs.getdouble(9)); nbqgl.setshijfdl(rs.getdouble(10)); nbqgl.setsyjfdl(rs.getdouble(11)); nbqgl.setsejfdl(rs.getdouble(12));
其它类似信息

推荐信息