java 调用存储过程 怎么用?
发布网友
共2个回答
热心网友
给你个我以前做的例子吧
public void proselect(){
PreparedStatement pstmt=null;
Connection conn=null;
ResultSet rs=null;
conn=com.opendb.OpenDB.conn();//这个只是建立个连接
try {
pstmt = conn.prepareCall("call sel");//调用存储过程sel ,sel代码为select * from test
rs=pstmt.executeQuery();
System.out.println(rs);
while(rs.next()){
System.out.print(rs.getInt(2));
System.out.println(rs.getString(1));
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
热心网友
pstmt = conn.prepareCall("call yourProcereName");//调用存储过程yourProcereName
rs=pstmt.executeQuery();
之后就不用多说了
