testcallablestatement.java

来自「JDBC连数据库,这是一门很基初的技术,一定要好好研究」· Java 代码 · 共 21 行

package com.allanlxf.jdbc.core;

import java.sql.*;
import com.allanlxf.jdbc.util.ConnectionFactory;

public class TestCallableStatement
{
    public static void main(String[] args) throws Exception
    {
        Connection con = ConnectionFactory.getConnection();
        CallableStatement cs = con.prepareCall("{call getAccountOwner(?,?)}");
        cs.setInt(1, 2172);
        cs.registerOutParameter(2, Types.VARCHAR);
        
        cs.execute();
        String accountOwner = cs.getString(2);
        System.out.println(accountOwner);
        cs.close();
        con.close();
    }
}