callablestatementtest.java

这是一本描述JDBC数据库的书籍

/*
 * CallableStatementTest.java
 *
 * Created on June 10, 2005, 9:56 AM
 *
 * To change this template, choose Tools | Options and locate the template under
 * the Source Creation and Management node. Right-click the template and choose
 * Open. You can then make changes to the template in the Source Editor.
 */

package ch01;
import java.sql.*;
import javax.sql.*;
import common.*;

/**
 *
 * @author kevin
 */
public class CallableStatementTest {
    
    /** Creates a new instance of CallableStatementTest */
    public CallableStatementTest() {
    }

    public static void main(String[] args){
        Connection conn = null;
        CallableStatement cstmt = null;
        try{
            ConnectionFactory factory = ConnectionFactory.getConnectionFactory();
            conn = factory.getConnection();
            cstmt = conn.prepareCall("{call ? := update_worker_salary_func(?, ?)}");
            cstmt.setLong(2, 100);
            cstmt.setDouble(3, 0.8);
            cstmt.registerOutParameter(1, java.sql.Types.INTEGER);
            cstmt.execute();
            int number = cstmt.getInt(1);
            System.out.println("number : " + number);
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}