建站
咨詢
售后
建站咨詢
新聞中心
在用JDBC調(diào)用存儲(chǔ)過(guò)程來(lái)實(shí)現(xiàn)分頁(yè)的時(shí)候，因?yàn)橐y(tǒng)計(jì)分頁(yè)數(shù)據(jù)的總數(shù)，在存儲(chǔ)過(guò)程中想到了使用一個(gè)輸出參數(shù)來(lái)完成這樣的功能，于是就用JDBC調(diào)用帶輸出參數(shù)的存儲(chǔ)過(guò)程來(lái)實(shí)現(xiàn)這一功能。剛開(kāi)始還出了點(diǎn)問(wèn)題，如下：
創(chuàng)新互聯(lián)建站是一家網(wǎng)站設(shè)計(jì)公司，集創(chuàng)意、互聯(lián)網(wǎng)應(yīng)用、軟件技術(shù)為一體的創(chuàng)意網(wǎng)站建設(shè)服務(wù)商，主營(yíng)產(chǎn)品：響應(yīng)式網(wǎng)站、品牌網(wǎng)站制作、成都全網(wǎng)營(yíng)銷。我們專注企業(yè)品牌在網(wǎng)站中的整體樹(shù)立，網(wǎng)絡(luò)互動(dòng)的體驗(yàn)，以及在手機(jī)等移動(dòng)端的優(yōu)質(zhì)呈現(xiàn)。成都網(wǎng)站制作、網(wǎng)站設(shè)計(jì)、移動(dòng)互聯(lián)產(chǎn)品、網(wǎng)絡(luò)運(yùn)營(yíng)、VI設(shè)計(jì)、云產(chǎn)品.運(yùn)維為核心業(yè)務(wù)。為用戶提供一站式解決方案，我們深知市場(chǎng)的競(jìng)爭(zhēng)激烈，認(rèn)真對(duì)待每位客戶，為客戶提供賞析悅目的作品，網(wǎng)站的價(jià)值服務(wù)。
- callableStatement.setString(1, "w");
- callableStatement.registerOutParameter(2, java.sql.Types.INTEGER);
- ResultSet rs = callableStatement.executeQuery();
- int out = callableStatement.getInt(2);
- while (rs.next()) {
- System.out.println(rs.getObject("PERSON_NAME"));
- }
如果先調(diào)用 int out = callableStatement.getInt(2);的話，結(jié)果集就會(huì)被關(guān)閉，并拋出
- Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: 結(jié)果集已關(guān)閉。
- at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
- at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
- at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
- at xx.qq.app.AppTest.main(AppTest.java:24)
就出現(xiàn)了上面的異?，F(xiàn)象。
解決方法是將其改為：
- ResultSet rs = callableStatement.executeQuery();
- while (rs.next()) {
- System.out.println(rs.getObject("PERSON_NAME"));
- }
- int out = callableStatement.getInt(2);
這樣就OK了。
附上簡(jiǎn)單的存儲(chǔ)過(guò)程及源碼：
- package xx.qq.app;
- import java.sql.CallableStatement;
- import java.sql.Connection;
- import java.sql.ResultSet;
- import org.springframework.beans.factory.BeanFactory;
- import org.springframework.context.ApplicationContext;
- import org.springframework.context.support.ClassPathXmlApplicationContext;
- import com.mchange.v2.c3p0.ComboPooledDataSource;
- /**
- * @author Jack Zhang
- * Email:fish2-2@163.com
- * @date 2011-08-22
- */
- public class AppTest {
- public static void main(String[] args) throws Exception {
- ApplicationContext context = new ClassPathXmlApplicationContext(
- new String[] { "applicationContext.xml" });
- BeanFactory factory = (BeanFactory) context;
- ComboPooledDataSource dataSource = (ComboPooledDataSource) factory
- .getBean("dataSource");
- Connection con = dataSource.getConnection();
- CallableStatement callableStatement = con
- .prepareCall("{call GetBasics(?,?)}");
- callableStatement.setString(1, "w");
- callableStatement.registerOutParameter(2, java.sql.Types.INTEGER);
- ResultSet rs = callableStatement.executeQuery();
- while (rs.next()) {
- System.out.println(rs.getObject("PERSON_NAME"));
- }
- int out = callableStatement.getInt(2);
- //int out = callableStatement.getInt(2);
- System.out.println(out);
- if (rs != null)
- rs.close();
- if (callableStatement != null)
- callableStatement.close();
- if (con != null)
- con.close();
- }
- }
- /**
- *
- * QueryTemplate queryTemplate =(QueryTemplate)factory.getBean("queryTemplate"); //
- * queryTemplate.query(new Query(){ // public void executeQuery(Connection con,
- * Statement st, ResultSet rs) throws Exception { // String sql ="SELECT * FROM
- * P_BASIC"; // rs = st.executeQuery(sql); // while(rs.next()) // { //
- * System.out.println(rs.getObject(5)); // } // } // });
- *
- */
存儲(chǔ)過(guò)程
- ALTER PROCEDURE GetBasics(
- @PERSON_NAME VARCHAR(32),
- @COUNT INT OUT
- )
- AS
- BEGIN
- SELECT @COUNTCOUNT = COUNT(*) FROM P_BASIC;
- SELECT * FROM P_BASIC
- END
- GO
以上就是JDBC調(diào)用帶輸出參數(shù)的存儲(chǔ)過(guò)程來(lái)完成分頁(yè)并統(tǒng)計(jì)分頁(yè)總數(shù)的全部過(guò)程，本文就介紹到這里了，希望本次的介紹能夠?qū)δ兴斋@！
網(wǎng)站題目：JDBC調(diào)用帶輸出參數(shù)的存儲(chǔ)過(guò)程的實(shí)例解析
本文地址：http://www.5511xx.com/article/cdseggi.html
