public class GenerateSampleData {
    public void select() {
        
        String sql="";
        Connection con = null;
        CallableStatement callAble=null;
        
        try{
        Class.forName("com.mysql.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/test";
        con = DriverManager.getConnection(url, "abc", "abc");
        sql="{call test2(?)}";
                callAble=con.prepareCall(sql);
                callAble.registerOutParameter(1, Types.VARCHAR);
                callAble.execute();
                System.out.println(callAble.getString(1));
        }catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }finally{
            try {
                callAble.close();
                con.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            
        }

    }